Primary Key Error Appears When an Invoice is Searched: 'Too many objects match the primary key oracle.jbo'
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.
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:
- Create a Purchase Order (PO) containing one item.
- Open ReIM and create a merchandise invoice with discrepancy from the PO.
- Resolve the discrepancy.
- Open ReIM and search the invoice.
- 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.
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