Reimediinjector - TDETL.UPC Not Validated Against ITEM_MASTER (Doc ID 2290463.1)

Last updated on JULY 27, 2017

Applies to:

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

Goal

Why is the reiminjector batch not throwing any error into IM_INJECT_DOC_ERROR table even though the UPC’s does not exist in ITEM_MASTER for a ORDER (Order also does not exist in the ORDHEAD table) on the invoice.

Documentation indicates that, UPC for this detail record. Valid item number is retrieved for the UPC. Stored in IM_INVOICE_DETAIL.ITEM or IM_DOC_DETAIL_REASON_CODES.ITEM.

TDETL.UPC: Documentation indicates that UPC should be valid to be imported but

Reject transaction to file if: 1.UPC is null and Item is null.
                                       2.Both UPC and Item are not null.

Reject transaction to tables if:1.Valid item is not found for UPC and UPC supp.
                                          2.Valid item is not associated with the supplier.
                                          3.The item found is identical to another detail item for this transaction (no duplicate items).”
 

Solution

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