CONCSUB and XDOREPPB for r12

Main discussion in Thread: How to submit BIP report using CONCSUB utility (after upgrade is How to submit BIP report using CONCSUB utility)

Before test:

– create Data Definition XXAND17 with Data Template as

<dataQuery>
<sqlStatement name="Q_1">
<![CDATA[
select ct.customer_trx_id,
ct.trx_number,
ct.trx_date,
ctt.type
from ra_customer_trx_all ct, ra_cust_trx_types_all ctt
where 1 = 1
AND ctt.cust_trx_type_id(+) = ct.cust_trx_type_id
and rownum <= 3
]]>
</sqlStatement></dataQuery>
<dataStructure>
<group name="G_trxs" dataType="varchar2" source="Q_1">
<element name="trx_number" dataType="varchar2" value="trx_number"/>
<element name="trx_date" dataType="date" value="trx_date"/>
<element name="doc_type" dataType="number" value="doc_type"/>
</group>

– create template XXAND17 with RTF layout
– create concurrent program XXAND17 and add to group of FND

Test:

[oracle@oebs out]$ CONCSUB APPS/APPS FND 'Application Developer' SYSADMIN WAIT=N CONCURRENT FND XXAND17
Submitted request 9915625 for CONCURRENT FND XXAND17

Find result:

[oracle@oebs ~]$ find /oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/out/ -iname '*9915625*'
/oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/out/o9915625.out

open it by pwd $APPLCSF/$APPLOUT

<?xml version="1.0" encoding="UTF-8"?>

<XXAND5>

<LIST_G_TRXS>
<G_TRXS>
<TRX_NUMBER>10000000</TRX_NUMBER>
<TRX_DATE>1997-03-11T00:00:00.000+03:00</TRX_DATE>
<DOC_TYPE/>
</G_TRXS>
<G_TRXS>
<TRX_NUMBER>10000000</TRX_NUMBER>
<TRX_DATE>1997-03-11T00:00:00.000+03:00</TRX_DATE>
<DOC_TYPE/>
</G_TRXS>
<G_TRXS>
<TRX_NUMBER>10000000</TRX_NUMBER>
<TRX_DATE>1997-03-11T00:00:00.000+03:00</TRX_DATE>
<DOC_TYPE/>
</G_TRXS>
</LIST_G_TRXS>
</XXAND5>

Next format xml …

<code>[oracle@oebs out]$ CONCSUB apps/apps FND 'Application Developer' SYSADMIN WAIT=N CONCURRENT XDO XDOREPPB Y 9915625 0 XXAND17 en N RTF RTF
Submitted request 9915626 for CONCURRENT XDO XDOREPPB Y 9915625 0 XXAND17 en N RTF RTF

Find result it’s must be RTF output

[oracle@oebs ~]$ find /oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/out/ -iname '*9915626*'
/oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/out/o9915626.out
[oracle@oebs ~]$

Oops “.out”, not “.rtf”

If we find 9915626 by View->Request and “View Output” then you can see RTF output as well.

Open o9915626.out

{\rtf1\ansi\deff0
{\fonttbl
{\f0 Arial;}
{\f1 Times;}
{\f2 Courier New;}
{\f3 Calibri;}
}
{\colortbl
;
\red0\green0\blue0;
\red231\green243\blue253;
\red255\green255\blue255;
}
{\info
{\title RTF Template}
{\doccomm Generated by Oracle XML Publisher 5.6.3}
}
\formshade\viewkind1\viewbksp1\uc1\dntblnsbdb

it’s look like rtf

so

[oracle@oebs ~]$ cd /oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/out
[oracle@oebs out]$ cp o9915626.out o9915626.rtf

Open o9915626.rtf by ms word and it’s Ok.

But accordantly fnd_conc_req_outputs

This table stores output files created by Concurrent Request. Initial
 output file generated by Concurrent Request will be stored in
 FND_CONCURRENT_REQUESTS table and all remaining output files generated
 Concurrent Request including XML Publisher generated output will be
 stored in this table.

hm

SQL> select LOGFILE_NAME, OUTFILE_NAME from fnd_concurrent_requests r
2  where request_id in (9915625, 9915626)
3  /

LOGFILE_NAME                                                                     OUTFILE_NAME
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
/oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/log/l9915625.req                   /oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/out/o9915625.out
/oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/log/l9915626.req                   /oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/out/o9915626.out

SQL> select * from fnd_conc_req_outputs where concurrent_request_id  in (9915625, 9915626)
2  /

CONCURRENT_REQUEST_ID  OUTPUT_ID FILE_TYPE                      FILE_NAME                                                                        FILE_NODE_NAME                                                                    FILE_SIZE ACTION_TYPE FILE_CREATION_DATE
--------------------- ---------- ------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- ----------- ------------------

SQL>

but what about GUI. Submit request for XXAND17 with id = 9916625

SQL> select LOGFILE_NAME, OUTFILE_NAME from fnd_concurrent_requests r
2  where request_id in (9916625)
3  /

LOGFILE_NAME                                                                     OUTFILE_NAME
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
/oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/log/l9916625.req                   /oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/out/o9916625.out

SQL> select * from fnd_conc_req_outputs where concurrent_request_id  in (9916625)
2  /

CONCURRENT_REQUEST_ID  OUTPUT_ID FILE_TYPE                      FILE_NAME                                                                        FILE_NODE_NAME                                                                    FILE_SIZE ACTION_TYPE FILE_CREATION_DATE
--------------------- ---------- ------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- ----------- ------------------
9916625      17265 RTF                            /oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/out/XXAND17_9916625_1.RTF          OEBS                                                                                   4855           6 09.11.2012

SQL>

we have row for 9916625 in fnd_conc_req_outputs. Nice but what about os output

[oracle@oebs out]$ find /oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/out/ -iname '*9916625*'
/oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/out/o9916625.out
/oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/out/XXAND17_9916625_1.RTF
[oracle@oebs out]$

Yes. Rtf output. Nice.

as for PDF

[oracle@oebs out]$ CONCSUB apps/apps FND 'Application Developer' SYSADMIN WAIT=N CONCURRENT XDO XDOREPPB Y 9915625 0 XXAND17 en N RTF PDF
Submitted request 9917625 for CONCURRENT XDO XDOREPPB Y 9915625 0 XXAND17 en N RTF PDF

[oracle@oebs out]$

If we find 9917625 by View->Request and “View Output” then you can see PDF output as well. Ok but what about os output

[oracle@oebs out]$ find /oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/out/ -iname '*9917625*'
/oracle/VIS/inst/apps/VIS_oebs/logs/appl/conc/out/o9917625.out
[oracle@oebs out]$

so try as for rtf

[oracle@oebs out]$ cp o9917625.out o9917625.pdf

and yes it’s pdf output as well.

so conclusion:
XDOREPPB work correctly but not rename output accordantly output format (rtf, pdf in my case)

it’s also not create row in fnd_conc_req_outputs. Strange …

so it’s a bug or some profile must be set

comment any ideas plz