OraNA :: Oracle News Aggregator

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.

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.