My Oracle Support Banner

R12: AP:Payables Open Interface Import Error With Validate_default_import Failed (Doc ID 2754799.1)

Last updated on AUGUST 30, 2023

Applies to:

Oracle Payables - Version 12.1.3 to 12.2.12 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

After populating interface tables ap_invoices_interface  and ap_invoice_lines_interface , When attempting to submit  Payables open interface import program
the following error occurs.

APP-SQLAP-10000: ORA-01400: cannot insert NULL into ("ZX"."ZX_TRX_HEADERS_GT"."LEGAL_ENTITY_ID") occurred in
AP_ETAX_SERVICES_PKG.Populate_Header_Import_GT<-AP_ETAX_SERVICES_PKG.Validate_Default_Import<-Import_invoices with parameters ( P_Invoice_Header_Rec = xxxx P_Calling_Mode =VALIDATE IMPORT P_Error_Code = P_Calling_Sequence = AP_ETAX_SERVICES_PKG.Validate_Default_Import<-Import_invoices while performing the following operation:
Step 8: Populate zx_trx_headers_gt

 

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
References


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