My Oracle Support Banner

Error in Latin Tax Categories Form: ORA-01400: cannot insert NULL into("JL"."JL_ZZ_AR_TX_CATEG_ALL"."TAX_RELE_SET") (Doc ID 2780448.1)

Last updated on JUNE 03, 2021

Applies to:

Oracle Financials for the Americas - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to Setup Latin Tax, the following error occurs in the Latin Tax Categories Form

ERROR
-----------------------
ORA-01400: cannot insert NULL into("JL"."JL_ZZ_AR_TX_CATEG_ALL"."TAX_RELE_SET"))(CALLING_SEQUENCE=JL_ZZ_AR_TX_CATEG_PKG.INSERT_ROW<JLZZTCTG)(PARAMETERS = tax_category_id = ### end_date_active = 'DD-MTH-YY') DEBUG_INFO = Insert JL_ZZ_AR_TX_CATEG)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. From AR Superuser Responsibility
2. Navigate to Brazil Localization>Setup>Latin Tax>Categories
3. Populate Form for new setup
4. Error spawns at save.

Changes

 Setup a new Legal Entity and Operating Unit

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


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