ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 11i_FA_提交折旧报错_APP-OFA-48393

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

原创 Linux操作系统 作者:月照花 时间:2011-01-11 11:43:10 0 删除 编辑
作者 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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: FORALL 用法小结
请登录后发表评论 登录
全部评论

注册时间:2011-01-11

  • 博文量
    10
  • 访问量
    30478