API to update the attribute in AR invoice
Introduction This Post is about to update the attribute in AR invoice Through API In Oracle EBS R12. Please find the below script for update the attribute in AR Invoice…
Read MoreAPI to update customer Profile in Oracle Applications
Introduction This Post illustrates the steps required to update customer Profile in Oracle EBS R12. Script to update customer Profile in Oracle Applications DECLARE p_customer_profile_rec_type hz_customer_profile_v2pub.customer_profile_rec_type; p_cust_account_profile_id NUMBER; p_object_version_number NUMBER;…
Read MoreAPI to Update a Customer Account TCA R12
Introduction This Post illustrates the steps required to Update a Customer Account TCA in Oracle EBS R12. Script to Update a Customer Account API TCA R12 DECLARE p_cust_account_rec hz_cust_account_v2pub.cust_account_rec_type; p_object_version_number…
Read MoreAPI to Check Item On-hand Quantity for Specific Inventory Organization
Introduction This Post is about to Check on hand Quantity for Specific Inventory Organization in Oracle EBS R12. Script to check on hand Quantity for specific inventory Organization API DECLARE…
Read MoreAPI for Bank Account Creation in Oracle Apps
Introduction This Post illustrates the steps required to Bank Account Creation API in Oracle EBS R12. Script to Bank Account Creation API DECLARE p_init_msg_list VARCHAR2 (200); p_acct_rec apps.ce_bank_pub.bankacct_rec_type; x_acct_id NUMBER;…
Read MoreAP 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 More