The custom lookup parameters can be passed to the below API’s to insert data into Oracle standard tables fnd_lookup_values and fnd_lookup_types *fnd_lookup_types_pkg.insert_row *fnd_lookup_values_pkg.insert_row Sample script with description to…
Read MoreAccounts Payable 11i R12 PO_VENDORS AP_SUPPLIERS PO_VENDOR_SITES_ALL AP_SUPPLIER_SITES_ALL PO_VENDOR_CONTACTS AP_SUPPLIER_CONTACTS AP_SUPPLIER_INT_REJECTIONS AP_INVOICE_LINES_ALL IBY Payment 11i R12 IBY_PAY_SERVICE_REQUESTS IBY_PAY_INSTRUCTIONS_ALL IBY_DOCS_PAYABLE_ALL IBY_PAYMENTS_ALL IBY_EXTERNAL_PAYEES_ALL IBY_EXT_BANK_ACCOUNTS IBY_EXT_PARTY_PMT_MTHDS IBY_ACCOUNT_OWNERS IBY_PMT_INSTR_USES_ALL Accounting 11i R12 AP_ACOCUNTING_EVENTS_ALL XLA_EVENTS…
Read MoreThis blog describes the process and technical information required for creating new employee using API. In any business organization employee should there to do the work, so Oracle provide hr_employee_api.create_employee…
Read MoreThis blog describes the technical information required for creating Inventory organization and their classification using API.In order to create Inventory organization we can use three API which are Apps.hr_organization_api.create_organization Apps.hr_organization_api.update_organization …
Read MoreSELECT glimp.je_header_id je_header_id, glimp.je_line_num je_line_num, xal.accounted_cr accounted_cr, xal.accounted_dr accounted_dr, xal.entered_cr entered_cr, xal.entered_dr entered_dr, xah.accounting_date accounting_date, xal.accounting_class_code acct_line_type, xal.code_combination_id code_combination_id, gcc.segment1 || ‘.’…
Read MoreSELECT r.je_header_id je_header_id, r.je_line_num je_line_num, 200 application_id, aeh.ledger_id set_of_books_id, ‘INV’ trx_class, l8.displayed_field trx_class_name, l1.displayed_field trx_type_name, i.invoice_type_lookup_code trx_type_c, i.invoice_num invoice_number, i.invoice_num trx_number_displayed, ael.description comments, fd.NAME doc_sequence_name,…
Read MoreAssignment Set: Once sourcing rules has been defined, you must assign them to particular items and/or organizations. These assignments are grouped together in assignment sets. In an assignment set you…
Read MoreSourcing Rule: Sourcing Rule Provides list of approved suppliers where we can rank the suppliers on a percentage basis. This is useful for the buyers/requestors at the time of making…
Read MoreStandard functionality in the SO Form, provides the On-Hand visibility of an Item at the Specific Inventory Org (Ship From Org) level. In case the Visibility is required as per…
Read MoreWhen performing Master Data Migration for Supplier or Customer business also needs the migration of Associated Banks and Bank Branches.In order to perform this we need to migrate Banks, Bank…
Read More