11i_FA_提交折旧报错_APP-OFA-48393

作者 amwlq 20:59

APP-OFA-48393: Program exited with errors :
Unable to get the concurrent request status using procedure FND_CONCURRENT.GET_REQUEST_STATUS.
Module CHECK_BOOK_STATUS ended with error

APP-OFA-48393: 程序因错误而退出：
无法使用 FND_CONCURRENT.GET_REQUEST_STATUS 程序取得并发请求状态。
模块 CHECK_BOOK_STATUS 因错误而终止。

Metalink Note:

Depreciation Ends with Error in FND_CONCURRENT.GET_REQUEST_STATUS [ID 199678.1]

cause: The DEPRN_STATUS in the FA_BOOK_CONTROLS table was incorrectly set
to 'S' after a failed depreciation run.

fix:

Verify the book status -

SQL> select book_type_code, deprn_request_id, mass_request_id, deprn_status
SQL> from fa_book_controls
SQL> where book_type_code = '&book_type_code';

If the deprn_status is anything other that 'S', DO NOT PROCEED with resetting
the status.

Check to make sure there are no records in FA_DEPRN_DETAIL and FA_DEPRN_SUMMARY
tables.

1. get the period_counter.

SQL> select period_counter
SQL> from fa_deprn_periods
SQL> where book_type_code = '&book_type_code'
SQL> and period_close_date is null;

The period_counter is the current period counter number associated with the
period you are trying to run depreciation for, and the book_type_code is the
name of your Asset Book.

2. Check the FA_DEPRN_DETAIL and FA_DEPRN_SUMMARY tables for records :

SQL> select count(*)
SQL> from fa_deprn_summary
SQL> where book_type_code = '&book_type_code'
SQL> and period_counter = &period_counter
SQL> and deprn_amount is not null;

SQL> select count(*)
SQL> from fa_deprn_detail
SQL> where book_type_code = '&book_type_code'
SQL> and period_counter = &period_counter
SQL> and deprn_amount is not null;

These scripts should return 0 rows selected.
If any rows are returned, you may need to call Oracle Support to create a
datafix.

To re-run depreciation, you need to update the book status to 'E' for 'Error'

SQL> update fa_book_controls
SQL> set deprn_request_id = NULL,
SQL> deprn_status = 'E'
SQL> where deprn_status = 'S'
SQL> and book_type_code = '&book_type_code';

NOTE: Never under any circumstances update the deprn_status to 'C' for
'Complete'.

Amwlq: follow that script. ,we can submit the Depreciation as normal.

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

转载于:http://blog.itpub.net/24908207/viewspace-683593/