REIM Injector Batch Throwing Error When EDI Having two UPC From Same SKU
(Doc ID 2973410.1)
Last updated on SEPTEMBER 11, 2023
Applies to:
Oracle Retail Invoice Matching Cloud Service - Version 19.3 and laterInformation in this document applies to any platform.
Symptoms
REIM Injector batch throwing error when EDI having two UPC from same SKU.
Steps To recreate:
1.Create an EDI file for one doc, with two TDETL lines.
One TDETL with item number and second TDETL line with UPC (pointing to the same item).
Run ReimediInjector batch .
It fails with PV_CRITICAL error.
INJECT_DOC_ID DETAIL_ID NON_MERCH_CODE RULE ERROR_CONTEXT FIXABLE STATUS ACTION_DATE CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE OBJECT_VERSION_ID TRIAL_ID INJECT_ID
-1 PV_CRITICAL @0PACKAGE_ERROR@1ORA-00001: unique constraint (RMS01.PK_IM_INVOICE_DETAIL) violated@2REIM_INJECTOR_SQL.INJECT_VALID_TRANSACTIONS N N 05-05-23 RETAIL.USER RETAIL.USER 05-05-23 1 1015016
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |