Category Archives: AOL and SYSADMIN

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 »

FND_GLOBAL and FND_PROFILE: Import List of System Global values

We can find values of System global values using FND_PROFILE and FND_GLOBAL FND_PROFILE To manipulate values stored in client and server user profile caches.Any changes you make to profile option values using these routines affect only the run-time environment. The effect of these settings end when the program ends, because the database session (which holds… Read More »