急！app-ofa-48392新增资产时报的错

greece1119

在新增资产点击完成时，报了这个错，请版主还有各位高手帮忙看看可能是什么问题呢？

呼和鞑靼

是不是有必输的弹性域没有输入啊？

greece1119

都填了啊，我总觉得是设置上的问题……

呼和鞑靼

那就检查一下账簿控制参数吧！

greece1119

呼和鞑靼 发表于 2011/6/29 16:03
那就检查一下账簿控制参数吧！

能具体点吗？这个问题困惑了我们好几天了……

呼和鞑靼

你们是不是在资产账簿那里做过客户化呀，和什么做过关联？例如组织和账簿关联？

greece1119

呼和鞑靼 发表于 2011/6/29 16:24
你们是不是在资产账簿那里做过客户化呀，和什么做过关联？例如组织和账簿关联？

资产账簿这没有做过客户化呀……

Soman

检查资产账簿定义！

sony0629

Q:在资产工作台做资产当前成本调整时，系统报错“APP-OFA-48392:您不能更改进行扩展折旧的资产的成本”，英文环境下也是这个错误（Unable To Change Depreciation Method Of An Asset Which Is Not In Extended Depreciation）
A:参考metalink文章 Doc ID：756668.1，打补丁7612039

sony0629

Applies to:

Oracle Assets - Version: 12.0.4
This problem can occur on any platform.

Symptoms

On Release 12 Users are unable to change any asset information from the Asset Workbench form FAXASSET for a specific Book.
The following error occurs :
APP-OFA-48392 Unable to get the concurrent request status using procedure
FND_CONCURRENT.GET_REQUEST_STATUS


.

Cause

The cause of the issue is invalid  value in FA_BOOK_CONTROLS.CREATE_ACCOUNTING_REQUEST_ID for the related Book

CREATE_ACCOUNTING_REQUEST_ID is populated with Concurrent request ID of a Create Accounting program currently locking this book.
Therefore , after Create Accounting program completes , this column  should be nulled out .

In case Create Accounting program is not running anymore for this Book and  FA_BOOK_CONTROLS.CREATE_ACCOUNTING_REQUEST_ID wasn't set to Null  and FND_CONCURRENT_REQUESTS table was purged , then the application cannot check the status of this request_id and raises the error :Unable to get the concurrent request status using procedure
FND_CONCURRENT.GET_REQUEST_STATUS

For issues with DEPRN_REQUEST_ID ,DEPRN_STATUS or MASS_REQUEST_ID please read Note 412599.1 or Note 199678.1

Solution

-- To implement the solution, please execute the following steps first  in a TEST instance :
1) Please run :
select book_type_code,
deprn_request_id,
deprn_status,
mass_request_id,
create_accounting_request_id  from fa_book_controls ;

2)If the query returns a value for CREATE_ACCOUNTING_REQUEST_ID  and related Book_type_code ,then run following query:

SELECT R.PHASE_CODE, R.STATUS_CODE, R.COMPLETION_TEXT,
PHASE.LOOKUP_CODE, STATUS.LOOKUP_CODE,
PHASE.MEANING, STATUS.MEANING
FROM FND_CONCURRENT_REQUESTS R,
FND_CONCURRENT_PROGRAMS P,
FND_LOOKUPS PHASE,
FND_LOOKUPS STATUS
WHERE PHASE.LOOKUP_TYPE = 'CP_PHASE_CODE'
AND PHASE.LOOKUP_CODE =
DECODE(STATUS.LOOKUP_CODE, 'H', 'I', 'S', 'I', 'U', 'I', 'M', 'I', R.PHASE_CODE)
AND STATUS.LOOKUP_TYPE = 'CP_STATUS_CODE'
AND STATUS.LOOKUP_CODE =
DECODE(R.PHASE_CODE, 'P',
DECODE(R.HOLD_FLAG, 'Y', 'H', DECODE(P.ENABLED_FLAG, 'N', 'U', DECODE(SIGN(R.REQUESTED_START_DATE - SYSDATE),1,'P', R.STATUS_CODE))), 'R', DECODE(R.HOLD_FLAG, 'Y', 'S', DECODE(R.STATUS_CODE, 'Q', 'B', 'I', 'B', R.STATUS_CODE)), R.STATUS_CODE)
AND (R.CONCURRENT_PROGRAM_ID =  P.CONCURRENT_PROGRAM_ID
AND R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID )
AND R.REQUEST_ID = &create_accounting_request_id;

If this query returns no row , it means the request has been purged from FND_CONCURRENT_REQUESTS table , then perform next step

3)Run following update to unlock the book :
update fa_book_controls
set CREATE_ACCOUNTING_REQUEST_ID = null
where book_type_code='your_book';

commit;

3)Navigate to the Asset workbench and test if assets can be updated for this Book.

References

Note 199678.1 - Depreciation Ends with Error in FND_CONCURRENT.GET_REQUEST_STATUS
Note 412599.1 - APP-OFA-48392 : Unable to get the concurrent request status using procedure fnd_concurrent.get_request_status when attempting to update any asset in Asset Workbench


本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/yy5512/archive/2009/07/17/4357640.aspx

greece1119

我出现的这个问题好像和楼上的问题不一样吧……

呼和鞑靼

FA_AM_CORP
fa_books  都是你们的资产账簿吧，这两个资产账簿有什么关联？

呼和鞑靼

一个组织下有多个资产账簿？

greece1119

呼和鞑靼 发表于 2011/6/30 10:55
FA_AM_CORP
fa_books  都是你们的资产账簿吧，这两个资产账簿有什么关联？

FA_AM_CORP是账簿
fa_books是表

呼和鞑靼

那就是有客户化开发或者是个性化吧！怎么会这样呢？

greece1119

呼和鞑靼 发表于 2011/6/30 13:29
那就是有客户化开发或者是个性化吧！怎么会这样呢？

这个画面确实有一些客户化的东西，但是我们把标准的画面提交上去也报这个错，所以我觉得应该还是设置上的问题……

davis7527

应该是你们的客制吧。

呼和鞑靼

你把个性化都去掉先看看！

greece1119

呼和鞑靼 发表于 2011/6/30 13:57
你把个性化都去掉先看看！

我们试了，标准画面也是报这个错，所以肯定是设置上的问题……

greece1119

待解决……