Posts by Yammanur Rajeeva Subash Chandra

Oralce Integration Cloud : Integration Styles and Roles in OIC

Introduction:  Oracle Integration Cloud (OIC) Gen 3 comes with several roles that define what users can do in the system. These roles ensure that only the right people have access…

Read More

Script used to fetch important details about blanket purchase order (PO) approvals status

Use-Case: This SQL query is used to fetch important details about blanket purchase order (PO) approvals. It pulls information like approval actions, dates, revision numbers, PO amounts, and checks if…

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

Move concurrent program from One Instance to Another Instance having same name as old instance. Working as same as under old instance same responsibility and request group

Move concurrent program from One Instance to Another Instance having same name as old instance. Working as same as under old instance same responsibility and request group Step 1) we…

Read More

Query to Display the Concurrent Program’s which has are modified at XML Data_Defination_level or LOB’level

Introduction:   This query is used to fetch the list of  concurrent program names which are having the changes at XML Publisher level (Data_Definition or Template Level) which also includes…

Read More

FNDLOAD command to download and upload LDT file for a Concurrent Program

FNDLOAD command to download and upload LDT file for a Concurrent Program Introduction:  It is generally time-consuming process and task to create same setup data on each instance separately. Hence…

Read More

Query to get the executable details for the concurrent program or package And Query to get the Concurrent Program’s and their Request Groups

1-) Query to get the executable details for the concurrent program or package Introduction:  This query is used to fetch the user concurrent program name, concurrent program name, executable id…

Read More

Query to display the customer name and customer address details

Introduction: This query is used to fetch the data of customer name and also the details like the account number, addresses, city, country, postal code and customer account id. In…

Read More