REIMPOSTING Batch Fails With 'ORA-00001: unique constraint (SCH_RMS13.PK_IM_RECEIPT_ITEM_POSTING_STA) violated' Error

(Doc ID 2118971.1)

Last updated on MARCH 22, 2016

Applies to:

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

Symptoms

In Oracle Retail Invoice Matching (ReIM) 14.1.1, when attempting to run reimposting, the batch fails with the following error:


Steps to Reproduce:

  1. Create a purchase order (PO) in RMS.
  2. Receive the PO in RMS in 2 shipments, and such that items are received in multiple cartons.
  3. Create an invoice in ReIM.
  4. Run automatch batch.  The invoice status changes to MTCH.
  5. Run ReIM rollup batch.
  6. Run ReIM posting batch.
  7. The batch errors with the above error message.

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