Receipts Workbench Issue: Datafix: cash_receipt_history_id is Incorrectly Stamped in ar_misc_cash_distributions Table
(Doc ID 2048732.1)
Last updated on APRIL 02, 2019
Oracle Receivables - Version 12 and later Information in this document applies to any platform.
Issue: ====== User is not able to post the receipt to GL.
There are some Negative Miscellaneous Receipts that show as remitted once as per the ar_cash_receipt_history_all but ar_distributions_all has duplicate Remittance rows. Due to this the accounting is off when they look at view accounting.
ANALYSIS ========= Distributions are imbalanced in ar_distributions (ARD) Table.
cash_receipt_history_id populated in AR_MISC_CASH_DISTRIBUTIONS_ALL is not present in AR_CASH_RECEIPT_HISTORY_ALL.
It looks like the initial record which was created for the CRH_ID has been deleted.
Fix Approach ============ cash_receipt_history_id record needs to be updated in ar_misc_cash_distributiions_all table.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!