How to resolve error ORA-01652 in FA
Posted: Mon Jun 13, 2011 11:28 am
+---------------------------------------------------------------------------+
Assets: Version : 11.5.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
FADEPR module: Depreciation Run
+---------------------------------------------------------------------------+
Current system time is 10-JUN-2011 16:08:10
+---------------------------------------------------------------------------+
APP-FND-01388: Cannot read value for profile option FA_LARGE_ROLLBACK_SEGMENT in routine &ROUTINE.
APP-OFA-48747: You can ignore this error, and the previous related error messages, unless you want to use a dedicated rollback segment for mass programs. These messages do not indicate a failure in this concurrent program. They indicate that FND was unable to retrieve a value from the large rollback profile option, and that no explicit rollback segment will be used.
Depreciation Program Exception Report
Cost Initial Journal Entry program completed
APP-FND-01564: ORACLE error 1652 in faddep
Cause: faddep failed due to ORA-01652: unable to extend temp segment by 16 in tablespace TEMP
.
The SQL statement being executed at the time of the error was: and was executed from the file .
APP-OFA-47693: Error: faddep - SQL error in main select
Cause: You have a database problem.
Action: Contact your system administrator.
Error: FETCHing cursor C1
Error: function faddep returned failure (called from FADEPR)
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Concurrent program returned no reason for failure.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 10-JUN-2011 16:08:33
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
===========Solution=============
Run the Gather Schema Statistics concurrent program
for FA schema, from the system administrator responsibility.
Also make sure that the profile FA: print debug is set to No as it consumed table space.
Assets: Version : 11.5.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
FADEPR module: Depreciation Run
+---------------------------------------------------------------------------+
Current system time is 10-JUN-2011 16:08:10
+---------------------------------------------------------------------------+
APP-FND-01388: Cannot read value for profile option FA_LARGE_ROLLBACK_SEGMENT in routine &ROUTINE.
APP-OFA-48747: You can ignore this error, and the previous related error messages, unless you want to use a dedicated rollback segment for mass programs. These messages do not indicate a failure in this concurrent program. They indicate that FND was unable to retrieve a value from the large rollback profile option, and that no explicit rollback segment will be used.
Depreciation Program Exception Report
Cost Initial Journal Entry program completed
APP-FND-01564: ORACLE error 1652 in faddep
Cause: faddep failed due to ORA-01652: unable to extend temp segment by 16 in tablespace TEMP
.
The SQL statement being executed at the time of the error was: and was executed from the file .
APP-OFA-47693: Error: faddep - SQL error in main select
Cause: You have a database problem.
Action: Contact your system administrator.
Error: FETCHing cursor C1
Error: function faddep returned failure (called from FADEPR)
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Concurrent program returned no reason for failure.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 10-JUN-2011 16:08:33
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
===========Solution=============
Run the Gather Schema Statistics concurrent program
for FA schema, from the system administrator responsibility.
Also make sure that the profile FA: print debug is set to No as it consumed table space.