Extract for Payments – Check and EFT
Introduction This Post illustrates the steps required to Extract for Payments – Check and EFT in Oracle EBS R12. Script to used for Extract for Payments – Check and…
Read MoreSQL to Find Employee – Supervisor Hierarchy details
Introduction The Purchase order or Requisitions are not valid unless it is approved. In any of the procurement process, most of the issues occur in the approval of the purchasing…
Read MoreLoad XML data into Oracle table
Description: The XmlDocument class is an in-memory representation of an XML document. It implements the W3C XML Document Object Model (DOM) Level 1 Core and the Core DOM Level 2. Steps to Load…
Read MoreForm Personalization to modify the LOV of a Field
Introduction To Change the LOV of the “Tax Category” field in the “Enter transaction India Localization” form In oracle EBS R12 Navigation: AR Super User > India Local Receivables > Transactions > Transactions (Localized) Double Click it to…
Read MoreInsert Run Report in Excel for Apps
Introduction This Post illustrates the steps required to Insert Run functionality is used to return the sum, count, max, etc. for the datapoint(columns) in the E4A Report. The value will…
Read MoreDeploying “Create Employee” API as REST Service :
Introduction This Post illustrates steps Deploying “Create Employee” API as REST Service: in Oracle EBS R12. Go to Integrated SOA Gateway –> Integration Repository The below page will open. 2. Click on the Search button.…
Read MoreCreate AR Transaction/Invoice adjustment(API)
Interoduction This Post is about to Create AR Transaction/Invoice adjustment(API) Scope: To apply the adjustment in AR Invoice. (eg. To make AR Invoice amount roundoff). Before RoundOff adjustment API Applying…
Read MorePersonalization at Adjustment/Sales order/Credit Memo application form
Introduction This component can be used for requirements related to personalization where we want to restrict the user to create an RMA/Adjustment/Credit memo if certain(user-defined) conditions are not met. …
Read MoreHow to Update the Web Adi Template
Introduction This post is about How to Update the Web Adi Template in Oracle EBS R12. Purpose As per the business requirement user had requested to add some fields…
Read MoreDaily Exchange Currency Rates Interface
Description: URL will be passed as a parameter where we can identify the currency rate conversion amount. FROM_CURRENCY, TO_CURRENCY, and the date for when it has to be run will…
Read More