/********************************************************** *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
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
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
To know what is FNDLOAD Utility? and how to use it?, do read this article Here are the FNDLOAD Scripts to Migrate 15 different AOL… Read More »FNDLOAD Scripts to Migrate AOL Entities
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 /************************************************************************** *PURPOSE:… Read More »SQL Query to list Active Responsibilities of a Active User
1 2 3 4 5 6 7 8 9 10 11 12 13 14 /************************************************************************** *PURPOSE: To list out Responsibilities assigned to a Request Group… Read More »SQL Query to list out Responsibilities assigned to a Request Group
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 list all Oracle Reports assigned to a Responsibility