ORA-01400

Autoconfig errors on adgentns.pl ORA-01400: cannot insert NULL into
FND_APPS_SYSTEM.CSI_NUMBER (Doc ID 1209823.1)


CAUSE

A null value for parameter s_systemcsi in APPS Context XML File This makes autoconfig script
to insert NULL value to ("APPLSYS"."FND_APPS_SYSTEM"."CSI_NUMBER") generating the error message : ORA-01400: cannot insert NULL into ("APPLSYS"."FND_APPS_SYSTEM"."CSI_NUMBER")


SOLUTION

To implement the solution, please execute the following steps:

1. Source the APPS Tier environment file $APPL_TOP/APPS_.env.
2. Backup the APPS Tier Context File
3. Edit APPS Tier tier context XML file,

Replace:
<AFSYSCSI oa_var="s_systemcsi"/>

With:
<AFSYSCSI oa_var="s_systemcsi">0</AFSYSCSI>

4. Save the changes.
5. Run autoconfig to re-test the issue.

No comments:

java.sql.SQLSyntaxErrorException: Access was denied to the user in MySQL 8.4.

 java.sql.SQLSyntaxErrorException: Access denied for user 'SIT'@'%' to database 'SIT' means the MySQL user SIT does ...