APPS.FND_CONCURRENT.get_request_status issue
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);
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);
0