My Oracle Support Banner

ORA-01400 Error on FORMS_LOCALE_MASTER During Profitability Analytics Install (Doc ID 1327741.1)

Last updated on JUNE 16, 2011

Applies to:

Oracle Financial Services Profitability Analytics - Version: 5.1 and later   [Release: 5 and later ]
Oracle Financial Services Profitability Management - Version: 5.2 and later    [Release: 5 and later]
Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2 and later    [Release: 7 and later]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

While installing Oracle Financial Services Profitability Analytics (PFTBI) 5.1 with Profitability Management 5.2.2 or higher, you receive an ORA-01400 error in the installation log PFTBI_DEMOINF_SolutionsLOG_xxxxxxxx.log:

[ 19/04/2011 11:27:10 ] ===>Executing file:/app/install/ofsaa/Oracle/scripts/config/insert/commonapp_fusionlocale_en_us.sql
[ 19/04/2011 11:27:10 ] Query:'Insert into "FORMS_LOCALE_MASTER" ("FORM_CODE","DSN_ID","CONTROL_ID","LOCALE_ID","CONTROL_NAME","CONTEXTHELP","TOOLTIP","CONTROL_TYPE","FORM_VERSION") values ('CommonApp_ProcessTuningDetails','OFSAAINF',21,'en_US','Search',null,null,null,0)'
Error:ORA-01400: cannot insert NULL into ("CONFIG"."FORMS_LOCALE_MASTER"."CONTROL_TYPE")

[ 19/04/2011 11:27:10 ] Query:'Insert into "FORMS_LOCALE_MASTER" ("FORM_CODE","DSN_ID","CONTROL_ID","LOCALE_ID","CONTROL_NAME","CONTEXTHELP","TOOLTIP","CONTROL_TYPE","FORM_VERSION") values ('CommonApp_ProcessTuningDetails','OFSAAINF',22,'en_US','Available Process Tuning Options',null,null,null,0)'
Error:ORA-01400: cannot insert NULL into ("CONFIG"."FORMS_LOCALE_MASTER"."CONTROL_TYPE")

[ 19/04/2011 11:27:10 ] Query:'Insert into "FORMS_LOCALE_MASTER" ("FORM_CODE","DSN_ID","CONTROL_ID","LOCALE_ID","CONTROL_NAME","CONTEXTHELP","TOOLTIP","CONTROL_TYPE","FORM_VERSION") values ('CommonApp_ProcessTuningDetails','OFSAAINF',2,'en_US','Step-1:Assignment Level Details',null,null,null,0)'
Error:ORA-01400: cannot insert NULL into ("CONFIG"."FORMS_LOCALE_MASTER"."CONTROL_TYPE")
.
.
.
etc

You are not sure if the errors above are safe to ignore or require further action.

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.