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