API for UOM Conversion
A unit of measure conversion is a mathematical relationship between two different units of measure. For example, 12 Each = 1 Dozen. If you want… Read More »API for UOM Conversion
AUTHID CURRENT_USER and AUTHID DEFINER
Usually in seeded objects definition we see the key words AUTHID CURRENT_USER or AUTHID DEFINER like shown in the below screen shot AUTHID clause tells… Read More »AUTHID CURRENT_USER and AUTHID DEFINER
INDIA Legislation: New State ‘Telangana’ Added in IN_STATES System Lookup
With effect from June 02, 2014 the new state of Telangana will be operational in the Indian Union. Details of the new state are explained… Read More »INDIA Legislation: New State ‘Telangana’ Added in IN_STATES System Lookup
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
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
How to install and setup JDeveloper for OAF
Find Out the Right version Not all versions of JDeveloper tool is compatible with any version of Oracle E-Business Suite, so we need to find… Read More »How to install and setup JDeveloper for OAF
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
Permanent SOLUTION for “FRM-92095: Oracle JInitiator version too low.” Error in EBS Environments
To resolve “FRM-92095: Oracle JInitiator version too low.” error please follow the below steps: Go to start and search for ‘Configure Java’ Go to the… Read More »Permanent SOLUTION for “FRM-92095: Oracle JInitiator version too low.” Error in EBS Environments
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