XLAAARPT Account Analysis Report Shows Wrong Ledger SUM (Doc ID 1619472.1)

Last updated on JULY 17, 2014

Applies to:

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

Goal

Oracle XML template for XLAAARPT Account Analysis report has ledger SUM DR/CR  <?LEDGER_SUM_PR_DR?> and <?LEDGER_SUM_PR_CR?>:

</LIST_PERIOD_S>
<ACCT_SUM_PR_DR>0</ACCT_SUM_PR_DR>
<ACCT_SUM_PR_CR>0</ACCT_SUM_PR_CR>
<ACCT_SUM_BAL_DR>0</ACCT_SUM_BAL_DR>
<ACCT_SUM_BAL_CR>0</ACCT_SUM_BAL_CR>
</CCID_S>
</LIST_CCID_S>
<LEDGER_SUM_PR_DR>0</LEDGER_SUM_PR_DR>
<LEDGER_SUM_PR_CR>0</LEDGER_SUM_PR_CR>
<LEDGER_SUM_BAL_DR>0</LEDGER_SUM_BAL_DR>
<LEDGER_SUM_BAL_CR>0</LEDGER_SUM_BAL_CR>


These seem to be NULL in Oracle's output which is wrong. Since its a sum function it should add up all the DR and CR and have that value against this tag.
 

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