Query to validate migration of XML/BI Publisher Template and Data Definition
SQL Query to verify Oracle XML/BI Publisher template and data definition migration
xdo tables in oracle apps r12
Oracle xdo tables
Oracle xml publisher backend query
BI Publisher setup validation
SELECT xt_list.*, xdo_db.* FROM (SELECT XDDV.data_source_code "Data Definition Code", XDDV.data_source_name "Data Definition", XDDV.description "Data Definition Description", XTB.template_code template_code, XTT.template_name "Template Name", XTT.description "Template Description", XTB.template_type_code "Type", XTB.default_output_type "Default Output Type", XLtemp.file_name "Template File Name", xlbur.FILE_NAME "Bursting File Name", xldd.FILE_NAME "Data Template File Name" FROM apps.XDO_DS_DEFINITIONS_VL XDDV, apps.XDO_TEMPLATES_B XTB, apps.XDO_TEMPLATES_TL XTT, apps.XDO_LOBS XLTemp, apps.XDO_LOBS XLDD, apps.XDO_LOBS XLBUR, apps.FND_APPLICATION_TL FAT, APPS.FND_APPLICATION FA WHERE XDDV.application_short_name = FA.application_short_name AND FAT.application_id = FA.application_id AND XTB.application_short_name = XDDV.application_short_name AND XDDV.data_source_code = XTB.data_source_code AND XTT.template_code = XTB.template_code AND XTT.language = 'US' AND fat.language = 'US' AND XLtemp.LOB_CODE(+) = XTB.TEMPLATE_CODE AND XLtemp.XDO_FILE_TYPE(+) = XTB.TEMPLATE_TYPE_CODE AND xldd.LOB_CODE(+) = XDDV.data_source_code AND xldd.LOB_TYPE(+) = 'DATA_TEMPLATE' AND xlbur.LOB_CODE(+) = XDDV.data_source_code AND xlbur.LOB_TYPE(+) = 'BURSTING_FILE') xdo_db, (SELECT 'XXTEMPLATE_CODE1' xt_code FROM DUAL UNION SELECT ' XXTEMPLATE_CODE2' xt_code FROM DUAL) xt_list WHERE xdo_db.TEMPLATE_CODE(+) = xt_list.xt_code ORDER BY 1;
For more reusable queries, click https://tech7.in/category/technologyblog/oracle/
Click https://tech7.in/technologyblog/oracle/query/query-to-get-details-of-xml-bi-publisher-template-and-data-definition/
to view Query to get details of XML/BI Publisher Template and Data Definition
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