When Supplier of an Invoice Was Not Configured in ReIM Supplier Options ,Then Automatch Batch Terminates With Error: "Cannot Insert NULL"
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.
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").
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