Open Account AP Balances Listing Report Not Producing Output in Summary Mode and Inserting Fewer Rows into GT Table

(Doc ID 1946262.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Goal


When the "Open Account AP Balances Listing" report is run in "Summary" report mode in R12.1.3 it is not showing any output except for the header.  Also the log file summary appears to be showing fewer lines inserted into the global temporary (GT) table.

When the report is run with same details but with the “Report Mode” parameter as "Detail", then it shows data in the output file and the log file showing the correct number of rows inserted into GT table.

Question 1 : Why does the report not show any output in "Summary" mode and why does it insert a different number of rows into the GT table when the report is run in "Summary" mode as opposed to "Detail".

Question 2 :  The "Accounts Payable Trial Balance" report is also showing a different "# of rows inserted into GT table" in "Summary" vs "Detail" mode.  Please clarify.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms