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 NOVEMBER 14, 2024
Applies to:
Oracle Payables - Version 12.1.1 and laterInformation 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 |