Auto Apply given Credit memos to the Invoices
Introduction This Post explain steps required to Apply Credit Memos to the Invoices through API in Oracle EBS R12 Script to Apply Credit Memos to the Invoices through API CREATE…
Read MoreAsset Retirements Report
Introduction Asset Retirements Report is used to review the assets you retired for the Book and accounting Period range you choose. The report is sorted by balancing segment, asset type,…
Read MoreAR Selected Invoices Print
Introduction This script is used Queries to get AR Selected Invoices. Script to using for AR Selected Invoices Print /* Adjustments */ SELECT line_adjusted adj_line, tax_adjusted adj_tax, freight_adjusted adj_freight, adj.amount…
Read MoreAPI to update the supplier
Introduction This Post is About to Update the supplier Through API. Script for API to update the Supplier DECLARE p_api_version NUMBER; p_init_msg_list VARCHAR2 (200); p_commit VARCHAR2 (200); p_validation_level NUMBER; x_return_status…
Read MoreAPI to update the customer locations
Introduction This Post illustrates the steps required to update the customer locations in Oracle EBS R12. Below script for update customer locations DECLARE p_location_rec hz_location_v2pub.location_rec_type; p_object_version_number NUMBER; x_return_status VARCHAR2 (2000);…
Read MoreAPI 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 More