When Supplier of an Invoice Was Not Configured in ReIM Supplier Options ,Then Automatch Batch Terminates With Error: "Cannot Insert NULL" (Doc ID 987693.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

If the supplier of an invoice is not configured in Retail Invoice Matching (ReIM), then the Automatch batch terminates with the following error:

 

Steps to Recreate:

1. Create a Purchase Order (PO) for a supplier which is not configured in ReIM Supplier Options.
2. Run Data generator file to create a EDI file.
3. Run EDI upload batch, to load the Invoice to ReIM.
4. Run Automatch Batch and notice the  error:   cannot insert NULL into "RMS13" ."IM_QTY_DISCREPANCY". "AP_REVIEWER").

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