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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms