Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
Autoconfig errors on adgentns.pl ORA-01400 cannot insert NULL into FND_APPS_SYSTEM.CSI_NUMBER
Recently, we encountered an issue while running AutoConfig on the Applications Tier in Oracle E-Business Suite Release 12. The following error was observed:
ERROR
ERROR: [CVM Error Report]
The following report lists errors encountered during CVM Phase
/…/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl 2
No of scripts failed in CVM phase: 1 AutoConfig is exiting with status 1
The following report lists errors encountered during CVM Phase
/…/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl 2
No of scripts failed in CVM phase: 1 AutoConfig is exiting with status 1
ERROR in NetServiceHandler.log:
Registering Middle Tier Node
[ Input Information ]
……
Tools Local : null
Web Local : null
StackTrace:
java.sql.SQLException:
ORA-01400: cannot insert NULL into (“APPLSYS”.”FND_APPS_SYSTEM”.”CSI_NUMBER”)
ORA-06512: at “APPS.FND_APP_SYSTEM”, line 39
ORA-06512: at “APPS.FND_NET_SERVICES”, line 1720
ORA-06512: at line 1
[ Input Information ]
……
Tools Local : null
Web Local : null
StackTrace:
java.sql.SQLException:
ORA-01400: cannot insert NULL into (“APPLSYS”.”FND_APPS_SYSTEM”.”CSI_NUMBER”)
ORA-06512: at “APPS.FND_APP_SYSTEM”, line 39
ORA-06512: at “APPS.FND_NET_SERVICES”, line 1720
ORA-06512: at line 1
“The issue occurred due to a null value for the parameter
s_systemcsiin the APPS Context XML file. This caused the AutoConfig script to attempt inserting a NULL value into theCSI_NUMBERcolumn of theAPPLSYS.FND_APPS_SYSTEMtable, resulting in the error:ORA-01400: cannot insert NULL into ("APPLSYS"."FND_APPS_SYSTEM"."CSI_NUMBER").”
SOLUTION
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.
