AP Web Report Workflow Status
Introduction This Post illustrate steps required to AP Web Report Workflow Status in Oracle EBS R12. Script to AP Web Report Workflow Status SELECT ‘WPAY’ TYPE, gl.segment1 division, gl.segment3 dcc,…
Read MoreAP Supplier Banks Payments Query
Introduction This Post is about to AP Supplier bank payments Query. Query for getting AP Supplier Bank Payments Query SELECT pvs.org_id org_id, iep.default_payment_method_code, alc.lookup_code, hou.NAME org_name, pv.vendor_id supplier_id, pv.segment1 supplier_number,…
Read MoreAP Invoice On Hold Report
Introduction Invoice on Hold Report is used to review detailed information about invoices on hold. You can submit the Approval process before submit this report to obtain the most up-to-date…
Read MoreAccounts Payable Trial Balance Report
Description Account Payable Trial Balance Report meant to verify that total accounts payable liabilities in Payable’s equal those in the general ledger. Before closing a period, you can compare the…
Read MoreAccount 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 More