XML Publisher Concurrent Program explained (with SQL and tables)

 

When we have XML Publisher Type Concurrent Program, below executable will be used

SELECT * FROM apps.fnd_executables WHERE executable_name='XDODTEXE';

Concurrent Program Definition will be like :

--Get Concurrent Program details
select
      a.concurrent_program_id,
      a.concurrent_program_name,
      b.user_concurrent_program_name,
      c.executable_name,
      c.execution_method_code,
      (select meaning FROM apps.fnd_lookups
         WHERE lookup_type like 'CP_EXECUTION_METHOD_CODE' 
         and lookup_code= c.execution_method_code) type,
      c.execution_file_name
from
      apps.fnd_concurrent_programs a,
      apps.fnd_concurrent_programs_tl b,
      apps.fnd_executables c
where
      a.concurrent_program_id=b.concurrent_program_id
      and a.executable_id=c.executable_id
      and a.executable_application_id=c.application_id
      and  b.user_concurrent_program_name like 'ABC Program';

To view XML Publisher Data Definition and Data Template go to XML Publisher Responsibility

Click on Data Definitions

Concurrent Program Short Name is Code in this page

 

select  APPLICATION_SHORT_NAME,	
        DATA_SOURCE_CODE, --Code field on above page
        DATA_SOURCE_NAME, --Name field on above page
        DESCRIPTION
from    apps.XDO_DS_DEFINITIONS_TL 
where   data_source_code = 'ABC'  --Concurrent Program Short Name
;

select  APPLICATION_SHORT_NAME,
        DATA_SOURCE_CODE,	--Code field on above page
        DATA_SOURCE_STATUS,	--Enable Flag
        START_DATE,
        END_DATE
from    apps.XDO_DS_DEFINITIONS_B 

where   data_source_code = 'ABC' --Concurrent Program Short Name
;

SELECT * FROM XDO_LOBS 
WHERE   lob_code='ABC' --Concurrent Program Short Name
;

DATA TEMPLATE is .xml file and TEMPLATE is actually the RTF file used in Templates. You can download both these files from FILE_DATA column (using SQL Developer)

Click on ABC Report :

select  * 
from    XDO_TEMPLATES_B
where   data_source_code = 'ABC' --Concurrent Program Short Name
;

select  * 
from    XDO_TEMPLATES_TL 
where   data_source_code = 'ABC' --Concurrent Program Short Name
;