R12:AP:EBTax: Receiving An Error Message While Canceling An Invoice- APP-SQLAP-10000: ORA-01400: Cannot insert NULL into ("ZX"."ZX_TRX_HEADERS_GT"."LEGAL_ENTITY_ID") (Doc ID 1633545.1)

Last updated on NOVEMBER 20, 2015

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On R12, 

When attempting to cancel invoice,
the following error occurs.

Issue occurs only for upgraded invoice

ERROR
-----------------------
APP-SQLAP-10000: ORA-01400: Cannot insert NULL into ("ZX"."ZX_TRX_HEADERS_GT"."LEGAL_ENTITY_ID") Occurred in
AP_ETAX_SERVICES_PKG.POPULATE_HEADERS_GT<-AP_ETAX_SERVICES_PKG.POPULATE_HEADERS_GT

P_CALLING _SEQUENCE = AP_ETAX_SERVICES_PKG.CANCEL_INVOICE


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Invoice Workbench -> Cancel Invoice

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to Cancel invoice

Cause

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