Category Archives: AOL and SYSADMIN

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 »

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 »

What is TKPROF? How to run TKPROF?

Trace file is not in a understandable format, but to make it easier to understand and readable Oracle has provided a utility TKPROF. Syntaxt to run TKPROF TKPROF <trace-file> <output-file> [options]TKPROF <trace-file> <output-file> [options] Note: Its mandatory to set environment before running TKPROF. TKPROF Example TKPROF PerfIssue.trc PerfIssue.prf — –Another way with options — TKPROF… Read More »

PL/SQL Script to Reset User Password from Backend

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 /************************************************************ *PURPOSE: To change/reset password of a user from backend * *AUTHOR: Shailender Thallam * *************************************************************/ SET serveroutput ON; DECLARE v_user_name VARCHAR2(30):= UPPER(’SYSADMIN’); v_new_password VARCHAR2(30):= ‘welcome1’; v_status BOOLEAN; BEGIN v_status := fnd_user_pkg.ChangePassword ( username… Read More »

How to Generate Trace for a Seeded or Custom Concurrent Program/Report?

This article tells you the process of generating trace for a concurrent program which will be helpful for debugging. Step 1: Enable trace for a concurrent program Navigate to System Administrator Responsibility –> Concurrent Programs –> Define and Query the program/report and then enable check box Enable trace Step 2: Enabling Debugging Profile Option Navigate… Read More »

How to set ORG_ID for MOAC Enabled Concurrent Programs while Submitting from Backend

A field “Operating Unit Mode” is present in the Concurrent Program definition when viewed through OA Framework pages. Query to check this option from back-end: SELECT concurrent_program_name, multi_org_category FROM fnd_concurrent_programs WHERE concurrent_program_name = ‘<CP_short_name>’; –Ex: ‘APXINRIR’   S-Single M-Multiple null-EmptySELECT concurrent_program_name, multi_org_category FROM fnd_concurrent_programs WHERE concurrent_program_name = ‘<CP_short_name>’; –Ex: ‘APXINRIR’ S-Single M-Multiple null-Empty To submit… Read More »

A killer “Auto Refresh” option on Concurrent Request Window – New Features to Concurrent Request Form

Oracle is coming up with some exciting features on “Concurrent Request” form in upcoming EBS 12.2.6 release. As per a discussion on MOS, An Oracle user Attiq Ahmed has suggested Oracle to implement some features on “Concurrent Request” form and looks like Oracle has considered these ideas and implemented them in their next release Below… Read More »

Script to Delete Concurrent Program and Executable from backend

/******************************************************************************** *PURPOSE: To delete concurrent program definition and executable from back-end * *AUTHOR: Shailender Thallam * *********************************************************************************/ SET SERVEROUTPUT ON;   DECLARE l_prog_short_name VARCHAR2 (240); l_exec_short_name VARCHAR2 (240); l_appl_full_name VARCHAR2 (240); l_appl_short_name VARCHAR2 (240); l_del_prog_flag VARCHAR2 (1) := ‘Y’; –Set flag whether to delete Concurrent program or not l_del_exec_flag VARCHAR2 (1) := ‘Y’; –Set flag… Read More »

SQL Query to list all DB Links in a database

/********************************************************* *PURPOSE: Query to list all DB Links in a database * *AUTHOR: Shailender Thallam * *********************************************************/ SELECT obj.object_type "Object Type", obj.owner "Object Owner", obj.object_name "Object Name", obj.status "Object Status", dbl.db_link "DB Link", dbl.username "DB User Name", dbl.host "DB Host" FROM dba_objects obj, dba_db_links dbl WHERE obj.object_name = dbl.db_link AND obj.object_type = ‘DATABASE LINK’;/********************************************************* *PURPOSE:… Read More »