My Oracle Support Banner

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

Last updated on JULY 02, 2023

Applies to:

Oracle Applications DBA - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

On application Release 12 When attempting to run autoconfig on APPS Tier, the following error occurs:

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

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

 

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
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.