Hello -
Have been trying to submit a concurrent request from a custom form (version4.5). The form is registered under Oracle Projects Apps. I get an error as follows....
APP-00222: Encountered an error while getting the ORACLE user account for your concurrent request to run from.
The only suggestion I have found on-line (which came from Metalink) is that the problem is most likely due to the custom application not being a member of any Oracle datagroup. But I verified that the custom application IS a member of the data group, specifically the Standard data group.
My code is called from a when-button-pressed trigger and is basically as follows:
:SEARCH_PARAMETERS.REQUEST_ID :=
FND_REQUEST.SUBMIT_REQUEST('WPOPM'
,'PAXPHPCT1','','', v_SUB_REQUEST
,:SEARCH_PARAMETERS.PROJECT
,:SEARCH_PARAMETERS.PROJ_NAME
,:SEARCH_PARAMETERS.TASK_NUM
,to_char(:SEARCH_PARAMETERS.START_DATE,'DD-MON-YY')
,to_char(:SEARCH_PARAMETERS.END_DATE,'DD-MON-YY')
,chr(0),'','','','','','','','','','','','','',''
,'','','','','','','','','','','','','','','','','','','',''
,'','','','','','','','','','','','','','','','','','','',''
,'','','','','','','','','','','','','','','','','','','',''
,'','','','','','','','','','','','','','','','','','','','');
message('Pause: '||to_char(:SEARCH_PARAMETERS.REQUEST_ID), ACKNOWLEDGE);
COMMIT;
IF :SEARCH_PARAMETERS.REQUEST_ID = 0 THEN
user_exit('FND MESSAGE_SERVER');
user_exit('FND MESSAGE_DISPLAY ERROR');
ELSE
message('SUCCESSFUL: '||to_char(:SEARCH_PARAMETERS.REQUEST_ID));
DO_KEY('COMMIT_FORM');
END IF;
Thanks so much for any help you can provide!
Wade
|