Oracle Analytics and AI

Refer to Oracle Reports parameter in Excel template

Summary

Refer to Oracle Reports parameter in Excel template

Content

Hi All,

I have a concurrent program in R12 with XML type. My template is an Excel Template and i want to display the values of some of the parameters in that concurrent program. But, these parameters are not produced in the XML generated( i.e. there is no formula or SQL query for them into the Oracle Report and it is an Oracle Standard Report ( can't customize it)).

Is it possible to refer somehow to these parameters in Excel template?

I tried to put in XDO_METADATA a reference column like below:

XDO_?P_STAT_DATE_FROM?

<?param@begin:P_STAT_DATE_FROM?>

... and then I just specified XDO_?P_STAT_DATE_FROM? in the column i want to see it but this displays nothing.

Any ideas if this is achievable without modifying the Oracle Report?

Regards,

Alex

Find more posts tagged with

Accepted answers

All comments

User910243567

I don't think it's doable without customizing the report.

Brajesh Shukla-95078

WHat is the oracle seeded report name?

YGUTTIKONDA

Alex,

per my knowledge all the standard reports will have something called a data definition, go to XML Publisher Administrator and verify the data template .. I have checked few standard report which has the parameters ...

Other option is if your report does not include the parameters in the Data Template .. you can just modify the data template to include the parameters .. Hope this helps .

User_U66J8

Hi All,

The Standard Report is 'Bank Statement Detail Report'. Its output is 'TEXT'(that's why it doesn't have data template ) so we created a custom one with type XML so we can create a custom template(Excel).

But we don't want to modify the RDF file for this report and we want to use the current executable.

Issue is solved with a workaround. Currently it generates those parameters in the XML as where clauses e.g. <PARAM>AND date between 01-FEB-2017 and 02-FEB-2017<PARAM>/.

The workaround is to extract the value from the parameter with Excel functions ( FIND, SUBSTITUTE, MID, etc). It's not easy to support going forward but it displays the desired output.

Regards,

Alex