Andyblg's Blog

November 9, 2012

CONCSUB and XDOREPPB for r12

Filed under: ebs — andyblg @ 13:33
Tags: ,

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

Advertisements

8 Comments »

  1. If you are using Blogger, simply copy and paste the link in to the add links option of your blog and watch the ad appear on your blog. You’ll have the chance to associate with others who are interested in what you’re interested in and spread the word bout your great site.

    Comment by pyniudqty@gmail.com — February 1, 2014 @ 16:57 | Reply

  2. You have noted very interesting points! ps nice web site.

    Comment by mind and success — March 12, 2013 @ 23:17 | Reply

  3. I simply want to tell you that I’m new to blogs and definitely savored your web site. More than likely I’m likely to bookmark your site . You certainly come with really good well written articles. Thank you for sharing your web-site.

    Comment by Esteban Cueva — February 19, 2013 @ 13:02 | Reply

  4. Way cool! Some extremely valid points! I appreciate you penning this article and the rest of the website is also really good.

    Comment by click here — December 2, 2012 @ 20:59 | Reply

  5. You have mentioned very interesting details! ps nice website.

    Comment by blog — November 23, 2012 @ 04:38 | Reply

  6. Courier…

    […]CONCSUB and XDOREPPB for r12 « Andyblg's Blog[…]…

    Trackback by Courier — November 18, 2012 @ 04:00 | Reply

  7. Excellent info and nicely written. Keep up the fantastic stuff!

    Comment by future garage — November 18, 2012 @ 01:35 | Reply

  8. This is great stuff!! Thanks much for sharing.

    Comment by Anonymous — November 17, 2012 @ 01:26 | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: