Generating Shipping Documents

Those of you that use the Shipping module under 11i and want to use publisher to format them, will maybe know that its not as simple as flipping the Oracle Reports to XML, creating and uploading a layout template for the reports in the set and running them. You'll get a nasty surprise - yes, you'll get XML data rather than shiny new PDF output.


Dont panic, the Shipping team have apatch out for you to solve this - 5688014 - 'Shipping Document Sets does not generate the report in PDF format even if report is defined with the Output Format as 'XML' and has a Template attached' - a long but very descriptive patch header. The patch is not going to let your users select a template for each document at runtime but you will not have to customize any reports or plsql - always a plus.


The problem with the document set submission and its not alone, I can think of a few other 'problematic' reports, is that they are submittedly programatically via plsql using the FND_REQUEST package. When you submit programmatically the concurrent manager will not automatically pick up that you are submitting an XML output report and look for a template to apply - you need to tell it prior to sending that FND_REQUEST.SUBMIT_REQUEST call.


If you have your own code and want the concurrent manager to apply the template you need to add the following command to your code prior to the submit command.


FND_REQUEST.ADD_LAYOUT(
 template_appl_name => 'XXX',
 template_code => 'XXXX',
 template_language => 'XX',
 template_territory => 'XX',
 output_format => 'XXX');
Be sure to pass the Template Application code and ensure you are passing the correct language and territory codes.
Now you can call the SUBMIT_REQUEST call:


FND_REQUEST.SUBMIT_REQUEST(
'XXX',
'YYYY',
'SSSSSS',
NULL,
FALSE,
P_XXXX,
NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL);
and you get the desired output.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today