EBS Customizations (MOSC)

MOSC Banner

APPS.FND_CONCURRENT.get_request_status issue

edited Aug 7, 2013 1:56PM in EBS Customizations (MOSC) Question
We are trying to find the request status from a custom code using the following fnd function
l_call_status := APPS.FND_CONCURRENT.get_request_status(v_request_id, '','', l_phase, l_status, l_dev_phase, l_dev_status, l_message);

Above call return false and status/phase return null. Whereas the same function call return values when called from APPS schema. I have granted SELECT all the APPS tables and granted EXECUTE to FND_CONCURRENT package.Below is the actual code we are using:

DECLARE
l_phase VARCHAR2(100);
l_status VARCHAR2(100);
l_dev_phase VARCHAR2(100);
l_dev_status VARCHAR2(100);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center