Receipts Issue: Distributions for a Cleared Receipt Shows UNAPP Lines In XLA & GL Tables But Not In AR_DISTRIBUTIONS_ALL (Doc ID 753176.1)

Last updated on JUNE 07, 2016

Applies to:

Oracle Receivables - Version 12.0.5 and later
Information in this document applies to any platform.
XLAACCPB - Create Accounting
ARACCPB - Submit Accounting
FORM:ARXRWMAI.FMB - Receipts


Symptoms

Review cleared receipt in GL and the line count is different than what is showing in AR.

Review of ar_distributions_all shows 2 lines for the clear entry:

AR_DISTRIBUTIONS_ALL

SOURCE_TABLESOURCE_TYPECCIDAMOUNT_DRAMOUNT_CR
CRH CASH 2279 3000  
CRH REMITTANCE 2279   3000

Review of XLA_DISTRIBUTION_LINKS and XLA_AE_LINES and GL_JE_LINES shows 4 lines:

XLA_DISTRIBUTION_LINKS

ACCOUNTING_LINE_CODEUNROUNDED_ENTERED_DRUNROUNDED_ENTERED_CR
RCT_CASH 3000  
RCT_REMIT   3000
RCT_UNAPP_DEBIT   3000
RCT_UNAPP_DEBIT 3000  

Last 2 rows above are in question.

XLA_AE_LINES

CCIDACCOUNTING_CLASS_CODEENTERED_DRENTERED_CR
2279 CASH 3000  
2279 REMITTANCE   3000
2448 UNAPP 0  

Last row above is in question.

GL_JE_LINES

CCIDENTERED_DRENTERED_CR
2279 8000  
2279   8000
2448 0  


Granted the last row above is a zero dollar unapp row but why does this zero dollar UNAPP row exist? It isn't in AR_DISTRIBUTIONS_ALL.

Cause

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