Matched Invoice Validation Error APP-SQLAP-10000: ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."DIST_CODE_COMBINATION_ID")

(Doc ID 2257362.1)

Last updated on MAY 22, 2017

Applies to:

Oracle Landed Cost Management - Version 12.2 and later
Oracle Inventory Management - Version 12.2 and later
Information in this document applies to any platform.


On : 12.2.5 version, Invoices Matching Issues

Invoice Number cannot be validated.

When trying to validate the invoice, following error appears:

APP-SQLAP-10000: ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."DIST_CODE_COMBINATION_ID") occurred in
AP_APPROVAL_MATCHED_PKG.Exec_Matched_Variance_Checks<-AP_APPROVAL_PKG.Generate_Distributions<-AP_APPROVAL_PKG.Approvalwith parameters (Invoice_id 20737335, Sys Xrate Gain Ccid= , Sys Xrate Loss Ccid=)
while performing the following operation:
CALCULATE_VARIANCE - variance exists -erv:0 ipv:-3875.85

The issue can be reproduced at will with the following steps:
1. Responsibility = Payables Manager
2. Navigate to Invoice Workbench and search for the invoice
3. Try to validate the invoice. Error appears


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