Query to validate migration of XML/BI Publisher Template and Data Definition

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: Upload your own post and refer it anywhere anytime:

Leave a Reply