How to resolve error ORA-01652 in FA

[admin]

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

[lokeshoracle123]

Hi,

Run the Gather Schema Statistics concurrent program
for FA schema, from the system administrator responsibility.

Also make sure that FA: print debug is set to No as it consumed table space.

Thanks
Lokesh