Account Payable Remittance Advice
Introduction This post is about AP Remittance Advice, a document that describes payments that are being made. The person or company that is causing the payment will include a remittance…
Read MoreAPI to Create Project Party in Oracle Project Accounting
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 in Oracle HRMS
User 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
eAM – Asset Number Conversion Asset Number: An asset number uniquely identifies each…
Read MoreCreate Responsibility API
A 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 MoreCreating Lookup and Lookup Values through API
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 More11i to R12 Table Changes
Accounts 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 MoreOracle HRMS – Create Employee API
This 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 MoreCreate, Update Organization API
This 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 MoreQuery to Link PO, AP, GL, ZX, CE, RCV & XLA
SELECT 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 More