Receipts Workbench Issue: Datafix: cash_receipt_history_id is Incorrectly Stamped in ar_misc_cash_distributions Table (Doc ID 2048732.1)

Last updated on DECEMBER 06, 2015

Applies to:

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

Symptoms

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.

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