Hi All,
How can I get SQL code behind this order report. (Please find screenshot below)
Thanks in advance.
IFS apps 10.
Best Regards,
Hari
Best answer by ludovic.rougean
View original
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,
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…
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'
What proposed Thomas is clearly better and I also realized you can see it from the permission set, in component part.
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'
Hi Thomas, got it “XLR_TEMPLATE_UTIL_API.Execute_Report”
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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.