Easy to Create or Customize Interactive Reports
Introduction This Post is About to Steps for Create or Customize Interactive Reports in Oracle EBS-R12. Steps Navigate to the Welcome to dashboard. Click your name in the global area…
Read MoreDynamic Approvel List for AME
Introduction This Post illustrates steps required to Oracle has provided an API to get the dynamic list of approvers for AME. We need to pass the transaction type id and…
Read MoreCustomer Credit Snapshot Report
Introduction This Post illustrates steps required to Report will fetch and display all customer credit card snapshot details in excel format in Oracle EBS R12. Data Defination <?xml version=”1.0″ encoding=”UTF-8″?>…
Read MoreAPI To Create Bulk GL Code Combinations Using API in Oracle EBS-R12
Introduction This Post illustrate the steps required to Create Bulk GL Code Combinations Using API in Oracle EBS R12. Script to Create Bulk GL Code Combinations Using API DECLARE CURSOR…
Read MoreBasics for Custom Form Development
Introduction The below are the steps to follow to develop a basic Custom form in EBS. Download the Resource folder from the server and place it in the local directory.…
Read MoreAuto 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 More