in earlier versions of IFS cloud, when printing a report; for instance Customer Ledger Open Items. The data was stored in cust_open_item_rep, which could be accessed via Quick Report and hence be exported to excel.
These views are empty when printing reports in 25R2, are the information stored elsewhere now?
Question
Where are %_REP reports stored in 25R2?
They are still used the same way.
Just tried: select * from ifsapp.CUST_OPEN_ITEM_REP order by result_key desc and all looks fine.
I am taking that back, it is only reports created before upgrade to 25R2 that is visible in ifsapp.CUST_OPEN_ITEM_REP. any report created after upgrade is not visible in this view.
Maybe the results do not exist anymore. Please bear in mind that every report has a number of days defined for the report results to exist in the archive.
Edit: I tested in on report created in 25R2 when I sent my first reply.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.