My Oracle Support Banner

R12: AP: Error When Validating a Purchase Order Matched Invoice: "Cannot Insert NULL Into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."DIST_CODE_COMBINATION_ ID”)" (Doc ID 2974979.1)

Last updated on JANUARY 04, 2024

Applies to:

Oracle Payables - Version 12.1.1 and later
Information in this document applies to any platform.
using the Retroactive Price process
LCM (Landed Cost Management) setup is enable,



Symptoms

When trying to process an PO match invoice getting an error:

APP-SQLAP-10000: ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."DIST_CODE_COMBINATION_ ID”) occurred in lnsert_Tax_Distributions <-
AP_ETAX_UTIUTY_PKG.Retum_Tax_Distributions<-AP_ETAX_SERVICES_P KG. Update_AP <-AP_ETAX_SERVICES_PKG .Distribute <-AP_ETAX_P KG.Calling_eTax<-AP_APPROVAL_PKG.Approval

Step 11: Insert new distributions including variances


Steps:
Go to Payables Responsibility,
Enter/Query an invoice  that is matched to  Purchase Order
Go to Actions  and run validate
The applicaiton returns the error.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.