To find out base table of a DFF, open ‘Application Developer’ responsibility and then navigate to Flexfield –> Descriptive –> Register You can either use… Read More »How to find base table of a DFF from application
Here are the steps to configure Privacy Statement link using Functional Administrator 1. Select Functional Administrator responsibility 2. Click the Personalization tab 3. In Document… Read More »How Do You Change the Privacy Statement From The Default Value Of http://personalize.this.link in Oracle Applications Release 12
Standard Oracle Logo can be changes in two ways one at site level and one at entire application level. 1) You can replace Standard logo… Read More »How to change Standard Oracle Logo
/********************************************************** *PURPOSE: To list all forms personalizations * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT ffv.form_id , ffv.form_name , ffv.user_form_name , ffv.description "Form Description", ffcr.sequence ,… Read More »Oracle SQL Query to list all Form Personalizations
There are two system profile options that can be used to change look and feel. Java Look and Feel & Java Color Scheme Java Look… Read More »How to configure Oracle Forms Color
fnd_user_pkg.addresp is an Oracle Seeded API to add responsibilities to a user account. Added some logic to select responsibilities of one user to another user.… Read More »Oracle Script to Copy Responsibilites of one user account to another user account
Oracle has a seeded API fnd_user_pkg which has a procedure createuser which is used to create a user login account. Below is the sample script… Read More »Oracle Script to Create User Login Account
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25… Read More »SQL Query to findout information about a Concurrent Request
Record History is one of the excellent feature implemented by Oracle to track the data changes made by the users. Today in this article I… Read More »FAQ on Tracking Data Changes with Record History (WHO Columns)
Query to find Oracle Apps Login URL SELECT home_url FROM icx_parameters;SELECT home_url FROM icx_parameters; Query to find Oracle Apps Instance Version SELECT release_name FROM fnd_product_groups;SELECT… Read More »Some Useful Queries to know Information about your Oracle Instance