How to get SQL code behind Order report

Hi, 

you should get the ID of the report from the view REPORTS:

Or you can also use the Debug console.

Then with the ID, go to PL/SQL Package Code, and the search for the ID, replace REP by RPI.

ex: PART_CERTIFICATE_REP → PART_CERTIFICATE_RPI

ludovic.rougean wrote:

Hi, 

you should get the ID of the report from the view REPORTS:

Or you can also use the Debug console.

Then with the ID, go to PL/SQL Package Code, and the search for the ID, replace REP by RPI.

ex: PART_CERTIFICATE_REP → PART_CERTIFICATE_RPI

 

Hi Ludovic, thank you.

for report ‘Part provisions by company/site’, the report id is FIN011B_REP,

but I cannot find that in PL/SQL package Code screen. showing no data

best Regards,

Hari

You searched for the package %FIN011B% you got nothing ?

If no, it seems your report is custom, actually I do not have it on my DB. In this case it could be included in another package or they may have used an other name for the package, you try several combinaison including %Part%Provision% until you find an RPI package that seems matching… 

Hi Ludovic,

Still I’m getting no data.

Is there any way, can I get the code using PL/SQL developer?

Best Regards,

Hari

You can do query from view REPORT_DEFINITION view to get the package name + method name used by a report:

SELECT method
FROM ifsapp.report_definition
WHERE report_id = 'FIN011B_REP'

SELECT method
FROM ifsapp.report_definition
WHERE report_id = 'FIN011B_REP'

Hi Thomas, got it “XLR_TEMPLATE_UTIL_API.Execute_Report”

ludovic.rougean wrote:

What proposed Thomas is clearly better and I also realized you can see it from the permission set, in component part.

Thank you Ludoviv, got it from permission set as well.

Best Regards,

Hari