Excel

Item Where-Used Analysis Report (Excel – PL/SQL)

Introduction: This blog has the SQL query that can be used for Item where used Report in Oracle Apps R12. Cause of the issue: Business wants a PLSQL excel based report…

Read More

Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time

Script to upload multiple  LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time   Use-Case: In general during the migration process/Go-Live the downtime of the server will be…

Read More

BI Publisher Report with Excel Template

Step1:Concurrent Program Create a Concurrent Program with Exceutable File Name as XDODTEXE Step:2 Data Xml Template Create a Data Xml Template for the Query Step:3 Data Definitions Create a Data…

Read More