My Oracle Support Banner

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

Last updated on OCTOBER 18, 2021

Applies to:

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

Symptoms

Submit the Payables Open Interface,
the following error occurs.

REJECT CODE: VALIDATE DEFAULT IMPORT FAIL

From the FND Debug Log messages we can see the error message as

The issue is identified as 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_invoiceswith parameters ( P_Invoice_Header_Rec = 6728146 P_Calling_Mode =VALIDATE IMPORT P_Error_Code = P_Calling_Sequence = AP_ETAX_SERVICES_PKG.Validate_Default_Import<-Import_invoiceswhile 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.