REL12 AP: Cannot Import AP Invoices Due To These Errors: "VALIDATE DEFAULT IMPORT FAIL" and " APP-SQLAP-10000: ORA-12899: value too large"
Last updated on MAY 10, 2017
Applies to:Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Dec-2015***
When attempting to import invoices, the following error occurs.
ERROR IN THE LOG
VALIDATE DEFAULT IMPORT FAIL
ERROR IN THE FND LOG FILE
An FND Log shows this error.
APP-SQLAP-10000: ORA-12899: value too large for column "ZX"."ZX_TRX_HEADERS_GT"."DEFAULT_TAXATION_COUNTRY" (actual: 3, maximum: 2) occurred in
AP_ETAX_SERVICES_PKG.Populate_Header_Import_GT<-AP_ETAX_SERVICES_PKG.Validate_Default_Import<-Import_invoiceswith parameters ( P_Invoice_Header_Rec = 150761 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
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