MOAC At Release 12 & Custom Purchasing Report
I have written an extremely simple report, using Report Builder 10.1.2.0.2, containing only the following query:
SELECT *
FROM po_headers
ORDER BY segment1 ASC
My layout then references only segment1, in a repeating frame. All Report Triggers are empty, and the report contains no other code (e.g. Program Units, Formula Columns, Summary Columns etc.). The report takes no parameters.
The report is registered to my custom application, and set up with Operating Unit Mode set to Single.
However, when I run the report, no data is returned. If I change the table to PO_HEADERS_ALL, data is returned.
When I run the standard
SELECT *
FROM po_headers
ORDER BY segment1 ASC
My layout then references only segment1, in a repeating frame. All Report Triggers are empty, and the report contains no other code (e.g. Program Units, Formula Columns, Summary Columns etc.). The report takes no parameters.
The report is registered to my custom application, and set up with Operating Unit Mode set to Single.
However, when I run the report, no data is returned. If I change the table to PO_HEADERS_ALL, data is returned.
When I run the standard
0