Difficulty Setting Up Environment to Submit a Concurrent Request from a Trigger
Hello All,
I am developing a 'before insert' trigger to submit concurrent requests. Given the following declarations:
l_boolean_work BOOLEAN;
l_resp_id NUMBER;
l_appl_id NUMBER;
l_user_id NUMBER;
and with the three numeric values populated with valid values, I was initially using this call to set up the environment for a call to FND_REQUEST_SUBMIT_REQUEST:
FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_a ppl_id);
which is what I have used successfully when submitting concurrent requests from other PL/SQL-based concurrent requests.
This worked, but only exactly half of the time - on every other call I would get an "ORA-04092: cannot SET NLS in a trigger" error returned from the call to FND_GLOBAL.APPS_INITIALIZE, a/k/a "cannot commit in a trigger".
I am developing a 'before insert' trigger to submit concurrent requests. Given the following declarations:
l_boolean_work BOOLEAN;
l_resp_id NUMBER;
l_appl_id NUMBER;
l_user_id NUMBER;
and with the three numeric values populated with valid values, I was initially using this call to set up the environment for a call to FND_REQUEST_SUBMIT_REQUEST:
FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_a ppl_id);
which is what I have used successfully when submitting concurrent requests from other PL/SQL-based concurrent requests.
This worked, but only exactly half of the time - on every other call I would get an "ORA-04092: cannot SET NLS in a trigger" error returned from the call to FND_GLOBAL.APPS_INITIALIZE, a/k/a "cannot commit in a trigger".
0