My Oracle Support Banner

R12: Invoice Validation: ORA-01400 cannot insert NULL into ZX.ZX_ERRORS_GT.TRX_ID Error Message (Doc ID 1299317.1)

Last updated on SEPTEMBER 09, 2019

Applies to:

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

Symptoms

When attempting to validate invoice, the following error occurs.

ERROR
-----------------------
APP-SQLAP-10000: ORA-01400 cannot insert NULL into ZX.ZX_ERRORS_GT.TRX_ID
IRA096510 PL/SQL unhandled user-defined exception occurred in
AP_ETAX_SERVICES_PKG.Calculate < AP_ETAX_PKG.Calling_eTax <
AP_APPROVAL_PKG.Approval < APXINWKB with parameters P_Invoice_Id = XXXXXX

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
 1. Fixed Files
 2. Recommended Patches
 3. Solution Steps
References

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