My Oracle Support Banner

Misc Receipts Created With Duplicate REMITTANCE Rows In XLA Tables (Doc ID 1112298.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Miscellaneous receipts are created with duplicate REMITTANCE rows in XLA tables.

Miscellaneous receipts are created with duplicate rows in XLA_AE_LINES for remittance that correspond to distribution id 90794 in AR, distributions are correct and balanced:

AR_DISTRIBUTIONS_ALL
line_id src_id src_table src_type             amt_dr   amt_cr
90793  9121  CRH       CASH                56.9        -             
90794  9121  CRM      REMITTANCE  -             56.9 
90795  2037  MCD      MISCCASH      56.9        -      
90796  2038  MCD      MISCCASH       -             56.9

In XLA, duplicate remittance rows are seen:
XLA_AE_LINES
acctg_class         entered_dr   entered_cr
CASH                 56.9             -
MISC_CASH      -                  56.9
MISC_CASH     56.9             -
REMITTANCE   -                 113.8 --> there should only be 1 remittance row for 56.9
REMITTANCE   -                 170.7 --> duplicated

Unable to delete the duplicate rows and process, as create accounting will regenerate the rows in XLA_AE_LINES as it processes the receipts.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.