FA 折旧出错

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
APP-FND-01564: ORACLE error 1403 in fazgtsob

Cause: fazgtsob failed due to ORA-01403: no data found
.

The SQL statement being executed at the time of the error was: and was executed from the file .
GL_INVALID_SOBNAME
Error: function fazcsob returned failure (called from famcgtbt)
Error: function famcgtbt returned failure (called from fazcbcs)
Error: function fazcbcs returned failure (called from fadgbi)
Error: function fadgbi returned failure (called from FADEPR)[@more@]

Solution

This is not an error, merely a warning that the profile option, FA_LARGE_ROLLBACK_SEGMENT (（FA: Large Rollback Segment Name）)has not been set. Make sure that there is a message at the bottom of the logfile that says that the program completed successfully. (NOT SURE!!!
The profile option, FA_LARGE_ROLLBACK_SEGMENT is a system profile that is set by
signing onto Oracle Applications as System Administrator and navigating to Profile > System Profiles.

Query up the FA profile, FA_LARGE_ROLLBACK_SEGMENT（FA: Large Rollback Segment Name）. Set its value to the name of the largest rollback segment on the system.

This can be set at Site, Application, Responsibility or User. It is advisable to set this at Site level.

The large rollback segment has only been implemented for certain concurrent programs. They are:

Mass Additions Post (FAMAPT)
Depreciation (FADEPR)
Purge (FAPURG)


This is intended functionality and just a warning message. An Enhancement Request (ER #4078302) has been logged to remove this warning message

metalink 的solutions 等于白说

)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/226700/viewspace-1058465/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/226700/viewspace-1058465/