XDOBURSTREP: Passing parameters to Bursting Control file

Last week, some one on forum looking for the solution to add date prefix with output file name. Not sure, if that was specific to EBS, but we can use CP parameters to pass any variables to control file. Not only user defiend parameters, we can access the profile options, standard apps variables as well within control file. We need to prefix these variables with "cp:"

The following sample control file shows the usage of FileNamePrefix parameter, which is added to XDOBURSTRPT cp definition.

requestSet.jpg

If you review any bursting debug log file from EBS, you will find following system parameter, which can be refer in bursting control file with the same notation ie "cp:variable-name".

BurstingProcessor:Property Key=>user-variable:cp:territory : value=>US
BurstingProcessor:Property Key=>user-variable:cp:ReportRequestID : value=>4510775
BurstingProcessor:Property Key=>user-variable:cp:language : value=>en
BurstingProcessor:Property Key=>user-variable:cp:responsibility : value=>50559
BurstingProcessor:Property Key=>user-variable.OA_MEDIA : value=>http://abcd.us.oracle.com:8000/OA_MEDIA
BurstingProcessor:Property Key=>burstng-source : value=>EBS
BurstingProcessor:Property Key=>user-variable:cp:DebugFlag : value=>Y
BurstingProcessor:Property Key=>user-variable:cp:locale : value=>en-US
BurstingProcessor:Property Key=>user-variable:cp:parent_request_id : value=>4510775
BurstingProcessor:Property Key=>user-variable:cp:FileNamePrefix : value=>08262010
BurstingProcessor:Property Key=>user-variable:cp:user : value=>OPERATIONS
BurstingProcessor:Property Key=>user-variable:cp:application_short_name : value=>XDO
BurstingProcessor:Property Key=>user-variable:cp:request_id : value=>4511724
BurstingProcessor:Property Key=>user-variable:cp:org_id : value=>204
BurstingProcessor:Property Key=>user-variable:cp:Dummy for Data Security : value=>Y
BurstingProcessor:Property Key=>user-variable:cp:reportdescription : value=>Invoice Print Batch of Invoices


Thanks and have a nice weekend.

Comments:

Hi, Thanks for the article and new info for use in bursting: i have a doubt can we access custom profiles using the syntax: "${cp:CUST_MAIL_ADDRESS}" Thanks, Mahi

Posted by Mahesh on September 08, 2010 at 05:45 PM PDT #

Unfortunately, custom profiles are not accessable in current implementtaion.

Posted by ashish.shrivastava on September 08, 2010 at 06:13 PM PDT #

but if you pass the profile value in as a parameter to concurrent program then that should work

Posted by Trevor Hepworth on January 25, 2013 at 02:46 AM PST #

Hi,
How can I split lines in the message body(new line).
eg-
<xapi:message id="123" to="${CUST_EMAIL}" cc="" bcc="" attachment="true" content-type="text/html" subject="Invoice ${TRX_NO}">
Dear Sir/Madam,

Please find the attached Invoice ${TRX_NO} for ${CUST_NAME} dated ${TRX_DATE}.

Best Regards
Finance Department
</xapi:message>

Thanks

Posted by guest on April 11, 2013 at 06:29 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

bocadmin_ww

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