Cannot Perform Insert When Resolving Discrepancy Using RUA on a Child Shipment (Doc ID 1643798.1)

Last updated on JANUARY 08, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.1.4.4 and later
Information in this document applies to any platform.

Symptoms

In ReIM 13.1.4.4

Create and receive a PO (Purchase Order). Create an invoice and match it to the PO. Now adjust the receipt. Since the original receipt is matched, it creates a new shipment record. Create an invoice with a quantity discrepancy. Attempt to resolve discrepancy using RUA (Receiver Unit Cost Adjustment).  'Cannot Perform Insert' error message is thrown.

Steps to Reproduce:

  1. Create and receive a PO.
  2. Create an invoice and match it to the PO.
  3. Now adjust the receipt. Since the original receipt is matched, it creates a new shipment record.
  4. Create an invoice with a quantity discrepancy.
  5. Attempt to resolve discrepancy using RUA.
  6. See 'Cannot Perform Insert' error message.



ReIM Error Log shows:

 

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