My Oracle Support Banner

Duplicate Records In Posting Tables Causes Duplicate Receipt Posting (Doc ID 2767979.1)

Last updated on APRIL 11, 2022

Applies to:

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


When posting an Invoice getting duplicate records in staging tables which results to duplicate receipt posting.

Steps To Recreate :

  1. Create an invoice with 10 items, 15 units each.
  2. All items have a cost variance of $1.00 with the invoice have a variance of $150.00. The tolerance level is set at $25.00 for summary.
  3. Resolving line items until invoice is within summary tolerance. Once the invoice is within summary tolerance the users will then do an online match.

            Noticed that the items that were line item resolved are getting an additional receipt at receipt posting table (IM_RECEIPT_ITEM_POSTING).
            Hence, receipt posting table quantity is out of sync and causing getting duplicate records in Staging tables.




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

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