OAF customizations queries
Query to list all pages under any top/directory
Query to list all customizations on a OAF page
Query to get xml code of an OAF page/module
Query to delete any OAF customization
Query to find all changes done to OAF Pages in the application
Query to list all pages under any top/directory
--Query to list all pages under any top/directory
set serveroutput on;
DECLARE
BEGIN
jdr_utils.listdocuments ('/oracle/apps/per', TRUE);
END;
Query to list all customizations on a OAF page
--Query to list all customizations on a OAF page set serveroutput on; DECLARE BEGIN jdr_utils.listcustomizations (p_document => '/oracle/apps/per/irc/candidateSelfService/webui/RegCreateAccountPG'); END;
Query to get xml code of an OAF page/module
--Query to get xml code of an OAF page/module
set serveroutput on;
DECLARE
BEGIN
jdr_utils.printdocument (
p_document => '/oracle/apps/per/irc/candidateSelfService/webui/RegCreateAccountPG');
END;
Query to delete any OAF customization
--Query to delete any OAF customization
set serveroutput on;
DECLARE
BEGIN
jdr_utils.deletedocument (
p_document => '/oracle/apps/per/irc/candidateSelfService/server/customizations/site/0/VisitorAM');
END;
Query to find all changes done to OAF Pages in the application
--The below query helps to find all changes done to OAF Pages in the application.
SELECT PATH.path_docid perz_doc_id,
jdr_mds_internal.getdocumentname (PATH.path_docid) perz_doc_path
FROM jdr_paths PATH
WHERE PATH.path_docid IN
(SELECT DISTINCT comp_docid
FROM jdr_components
WHERE comp_seq = 0
AND comp_element = 'customization'
AND comp_id IS NULL)
AND UPPER (jdr_mds_internal.getdocumentname (PATH.path_docid)) LIKE
UPPER ('%%')-- document path here
ORDER BY perz_doc_path;
Related posts:
- Register a test concurrent program from backend in Oracle EBS
- Supervisor Hierarchy and Approval Limits in Oracle EBS R12
- Query to find vacation rules in Oracle R12
- View java class source in oracle database
- Load Java source code in oracle database
- Query to find all APIs of Oracle Apps modules
- OAF customizations queries
- Oracle apps list of concurrent programs in a Request Set
- Query to get Organization Hierarchy in Oracle apps
- Oracle apps query to find incompatible programs blocking a concurrent request
- Form function attached to which responsibility and user
- Query to find the responsibility attached to user in oracle apps
- How to enable debug log in Oracle apps EBS
- How to add AME role and responsibility to user
- Oracle form attached to which responsibility
- SQL query to get MIME type for file extension
- Query to get concurrent program and executable details
- Query to get responsibility level profile option values
- Query to validate migration of XML/BI Publisher Template and Data Definition
- Query to get details of XML/BI Publisher Template and Data Definition
- Query to get Site level and Organization level Profile Option Value
- PL-SQL code to reset application user password
- PL-SQL Procedure to send email with attachment
- PL-SQL to delete Concurrent Program and Executable
- Query to get the details of the lock in the database
- PL-SQL code to delete XML/BI Publisher template and Data Definition
- Query to find Form Personalization
- Query to find profile option values
- Query to get details of concurrent program parameters
- PL-SQL Code to find Menu Hierarchy of a responsibility
- Query to find details of Flex value sets
- Query to find concurrent program Responsibility and Request Group
- Concurrent program SQL statement currently running in background
- Query to find scheduled concurrent programs
- Query to kill database session for a concurrent request
- Query to get DFF (Descriptive Flex Field) Details