My Oracle Support Banner

When a Posting Document Fails With a Balancing Error, the Data is Still Getting Populated to the Financial Stage Tables (Doc ID 1947140.1)

Last updated on FEBRUARY 10, 2021

Applies to:

Oracle Retail Invoice Matching - Version 13.2.8 and later
Information in this document applies to any platform.

Symptoms

When a document fails with a balancing error still the data is getting populated to the financial stage tables.


Steps to Replicate:

  1. Create a Purchase Order (PO) and fully receive the PO.
  2. Create Invoice with quantity greater than PO quantity.
  3. Do the Quantity Resolution online and select the Reason Code the invoice becomes 'MTCH' after resolution.
  4. Run reimrollup batch. Credit Note Request quantity is created.
  5. Run reimposting batch.
  6. The invoice remains 'MTCH'.
  7. In the IM_POSTING_DOC_ERRORS  a balancing error message is seen.
  8. Observe that still the incorrect data is getting posted to the financial stage tables.  Reimposting batch does not cleanup completely failed records.

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
References


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