Introduction This Post illustrates the steps required to Create Project party in oracle projects accounting using the API PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY in oracle EBS. Script DECLARE l_project_id_prem pa_project_parties.project_id%TYPE := NULL; l_project_role VARCHAR2…
Read MoreUser Hooks There were many times we need to put some extra logic before or after happening of some business event. In Such cases, we use user hook API. It…
Read MoreeAM – Asset Number Conversion Asset Number: An asset number uniquely identifies each…
Read MoreA responsibility is an important configuration which allows the user to navigate to the various menus and form functions within that responsibility.Oracle API is used to load responsibility from one…
Read MoreThe 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 More