Primary Key Error Appears When an Invoice is Searched: 'Too many objects match the primary key oracle.jbo' (Doc ID 2164275.1)

Last updated on JULY 27, 2016

Applies to:

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

Symptoms

When a user searches an invoice, Retail Invoice Matching (ReIM) produces an error referring to a primary key. The products of the invoice are not shown, and every time the user tries to change tabs, the primary key error appears.


Steps to Recreate:

  1. Create a Purchase Order (PO) containing one item.
  2. Open ReIM and create a merchandise invoice with discrepancy from the PO.
  3. Resolve the discrepancy.
  4. Open ReIM and search the invoice.
  5. The error occurs.  This error seems to happen when the values of column DOC_ID in IM_INVOICE_DETAIL table and IM_DOC_DETAIL_REASON_CODES_ID column in IM_DOC_DETAIL_REASON_CODES table are the same.

Changes

 

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