FNDLOAD for Multilingual/Territory
FNDLOAD usually downloads LDT file based on the application specific default language (most of the cases default language would be ‘US’). Some time we end… Read More »FNDLOAD for Multilingual/Territory
AOL and SYSADMIN
How to use Oracle Message Dictionary – FND MESSAGES
Oracle Message Dictionary provides flexibility to store pre-formatted text as part of its catalog to display them as error/warning/note messages in Forms, Log Files, OAF… Read More »How to use Oracle Message Dictionary – FND MESSAGES
Making a DFF read only through custom.pll
We can make a DFF read only through Custom.pll by using a seeded procedure ‘FND_DESCR_FLEX.UPDATE_DEFINITION’. Here is the syntax of the procedure: FND_DESCR_FLEX.UPDATE_DEFINITION( /* Arguments… Read More »Making a DFF read only through custom.pll
Making a DFF Segment read only through ‘Special’ type of Value Set
We can make a DFF segment read only by restricting the segment with a valuset of ‘Special’ type. Steps to create ‘Special’ type of value… Read More »Making a DFF Segment read only through ‘Special’ type of Value Set
SQL Query to findout Profile Option Values
/********************************************************* *PURPOSE: To find out profile option Values * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT DISTINCT POT.PROFILE_OPTION_NAME "PROFILE_CODE" , POT.USER_PROFILE_OPTION_NAME "PROFILE_NAME" , DECODE (a.profile_option_value ,… Read More »SQL Query to findout Profile Option Values
How to Create a Dependent Parameters using Dependent Value set
Definition: A dependent value set is similar to an independent value set, except that the available values in the list and the meaning of a… Read More »How to Create a Dependent Parameters using Dependent Value set
How to get Concurrent Request ID of a parent program in a child program of a Request Set?
Upon a requirement I have created a request set with multiple programs in it. I was in a need to pull request ID of the… Read More »How to get Concurrent Request ID of a parent program in a child program of a Request Set?
PL/SQL script to find and Kill Blocking Sessions/Objects
/********************************************************* *PURPOSE: To findout blocking sessions and kill them * *AUTHOR: Shailender Thallam * **********************************************************/ — DECLARE CURSOR c IS SELECT c.owner, c.object_name, c.object_type, b.SID… Read More »PL/SQL script to find and Kill Blocking Sessions/Objects
How to submitt XMLP Report using a PL/SQL Script
Generally we use FND_REQUEST.SUBMIT_REQUEST to submit a concurrent program using a PL/SQL script. But we can not attach a layout to the concurrent request using… Read More »How to submitt XMLP Report using a PL/SQL Script
PL/SQL Script to Submit a Concurrent Request from backend
We can submit a concurrent request from backend using fnd_request.submit_request API. Before submitting the API we need to set the environment context using fnd_global.apps_initialize 1… Read More »PL/SQL Script to Submit a Concurrent Request from backend