Author Archives: Shailender Thallam

FNDLOAD Commands to Migrate WebADI Objects

Below are the different components of WebADI the can be migrated from one instance to another Integrators Contents Layouts Mappings Parameter List Components Integrator Command to Download Integrator FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XX_INTEGRATOR_LDT_FILE.ldt BNE_INTEGRATORS INTEGRATOR_ASN=”XX_CUST” INTEGRATOR_CODE=”XX_INTEGRATOR_CODE” Command to Upload Integrator FNDLOAD apps/apps 0 Y UPLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XX_INTEGRATOR_LDT_FILE.ldt Contents Command to Download Contents FNDLOAD… Read More »

SQL*Loader Concepts

SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. Capabilities of SQL*Loader Can load data from multiple data files during the same load session Can load data into multiple tables during the same load session Can selectively load data (Records can be loaded based on the records’… Read More »

FNDLOAD and XDOLoader to Migrate XMLP reports

To migrate an XMLP report we need below 4 objects LDT file for Concurrent Program LDT file for XMLP Template and Data Definition XML Data Definition RTF or XLS layout LDT file for Concurrent Program To Download LDT: FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_EMP_DETAILS_RPT.ldt PROGRAM APPLICATION_SHORT_NAME=XXCUST CONCURRENT_PROGRAM_NAME=XX_EMP_DETAILS_RPT To Upload LDT: FNDLOAD apps/apps 0 Y… Read More »

PL/SQL Script to Delete Lookup or Lookup Code

/******************************************** *PURPOSE: To Delete Lookup or Lookup Code * *AUTHOR: Shailender Thallam * *********************************************/ SET serveroutput ON; —   DECLARE CURSOR cur_lkp_values IS SELECT lookup_type, lookup_code, security_group_id, view_application_id FROM fnd_lookup_values WHERE lookup_type = ‘XX_LKP_NAME’ AND lookup_code LIKE ‘XX_LKP_CODE’; BEGIN FOR i IN cur_lkp_values LOOP BEGIN fnd_lookup_values_pkg.delete_row (x_lookup_type => i.lookup_type, x_security_group_id => i.security_group_id, x_view_application_id => i.view_application_id,… Read More »

SSH-KEYGEN Password Less Entry Setup to connect from one server to another server without Password

Once I had a requirement to copy some files from APP sever to DB server of same instance on regular intervals. We can achieve this by writing a small host program to connect to DB sever through FTP or SFTP and transfer files but this would require DB server login user name and password. We… Read More »

What is Host Program? How to create Host Program? and What is .Prog file?

To run a unix based shell script as a concurrent program, the executable of the concurrent program should be registered as a ‘Host’ program. The execution file name of the host program should end with .prog extension and a soft link should be created for the .prog file. Here is an example of creation of… Read More »

Frequently used Oracle SQL Developer Short Cut Keys

Short Cut Description Ctrl+Space Invokes code insight on demand Ctrl+Up Replaces worksheet with Previous SQL from SQL History Ctrl+Down Replaces worksheet with Next SQL from SQL History Ctrl+Shift+Up Appends current worksheet with Previous SQL from SQL History Ctrl+Shift+Down Appends current worksheet with Next SQL from SQL History Dhift+F4 opens a Describe window for current object… Read More »