R12 APP-OFA-48392 Unable to Get The Concurrent Request Status Using Procedure FND_CONCURRENT.GET_REQUEST_STATUS

Subject:	R12 APP-OFA-48392 Unable to Get The Concurrent Request Status Using Procedure FND_CONCURRENT.GET_REQUEST_STATUS
	Doc ID:	742830.1	Type:	PROBLEM
	Modified Date :	20-FEB-2009	Status:	PUBLISHED

 

In this Document
  Symptoms
  Cause
  Solution
  References

---

 

 

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