Posts by Venkatesh Balasubramanian

Customer 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 More

API 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 More

Call Oracle package in Oracle BI Publisher 10g

Introduction This Post is about Oracle BI Publisher is just a reporting tool. From which we can download excel, CSV, XML, RTF, PDF reports. In which we can use only…

Read More

Basics 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 More

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 More

Asset 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 More

AR 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 More

API 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 More

API 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

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 More