Problem when running initial load
Posted: Wed Nov 23, 2011 6:23 am
Dear All,
When I run the initial load, the Request Set Status completed with error.
In the log file:
+---------------------------------------------------------------------------+
Financial Intelligence: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
FII_GL_CCID_I_C module: Load General Ledger Code Combination Identifier Dimension
+---------------------------------------------------------------------------+
Current system time is 23-NOV-2011 09:08:04
+---------------------------------------------------------------------------+
**Starts**23-NOV-2011 09:08:04
**Ends**23-NOV-2011 09:08:05
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
-----------------------------
Error occured in Procedure: INSERT_INTO_CCID_DIM_INIT
Message: ORA-00001: unique constraint (FII.FII_GL_CCID_DIMENSIONS
_U1) violated
<x FII_GL_CCID_C.INSERT_INTO_CCID_DIM_INIT() 23-NOV-11 09:08:05
-----------------------------
Error occured in Procedure: INSERT_NEW_CCID
Phase: Call INSERT_INTO_CCID_DIM_INIT
Message: ORA-00001: unique constraint
(FII.FII_GL_CCID_DIMENSIONS_U1) violated
<x FII_GL_CCID_C.INSERT_NEW_CCID() 23-NOV-11 09:08:05
-----------------------------
Error occured in Procedure: MAIN
Phase: Call INSERT_INTO_CCID_DIM_INIT
Message: ORA-00001: unique constraint (FII.FII_G
L_CCID_DIMENSIONS_U1) violated
<x FII_GL_CCID_C.Main() 23-NOV-11 09:08:05
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 23-NOV-2011 09:08:05
+---------------------------------------------------------------------------+
When I run the initial load, the Request Set Status completed with error.
In the log file:
+---------------------------------------------------------------------------+
Financial Intelligence: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
FII_GL_CCID_I_C module: Load General Ledger Code Combination Identifier Dimension
+---------------------------------------------------------------------------+
Current system time is 23-NOV-2011 09:08:04
+---------------------------------------------------------------------------+
**Starts**23-NOV-2011 09:08:04
**Ends**23-NOV-2011 09:08:05
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
-----------------------------
Error occured in Procedure: INSERT_INTO_CCID_DIM_INIT
Message: ORA-00001: unique constraint (FII.FII_GL_CCID_DIMENSIONS
_U1) violated
<x FII_GL_CCID_C.INSERT_INTO_CCID_DIM_INIT() 23-NOV-11 09:08:05
-----------------------------
Error occured in Procedure: INSERT_NEW_CCID
Phase: Call INSERT_INTO_CCID_DIM_INIT
Message: ORA-00001: unique constraint
(FII.FII_GL_CCID_DIMENSIONS_U1) violated
<x FII_GL_CCID_C.INSERT_NEW_CCID() 23-NOV-11 09:08:05
-----------------------------
Error occured in Procedure: MAIN
Phase: Call INSERT_INTO_CCID_DIM_INIT
Message: ORA-00001: unique constraint (FII.FII_G
L_CCID_DIMENSIONS_U1) violated
<x FII_GL_CCID_C.Main() 23-NOV-11 09:08:05
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 23-NOV-2011 09:08:05
+---------------------------------------------------------------------------+