Home » Developer & Programmer » Forms » FND_REQUEST.SUBMIT_REQUEST error APP-00222
FND_REQUEST.SUBMIT_REQUEST error APP-00222 [message #140833] Wed, 05 October 2005 17:22 Go to next message
Wade
Messages: 5
Registered: October 2005
Location: Pittsburgh
Junior Member
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



Re: FND_REQUEST.SUBMIT_REQUEST error APP-00222 [message #140864 is a reply to message #140833] Wed, 05 October 2005 23:45 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
If you put a 'pause' statement after your 'message' statements, do you get any change in behaviour?

David
Re: FND_REQUEST.SUBMIT_REQUEST error APP-00222 [message #140966 is a reply to message #140864] Thu, 06 October 2005 07:42 Go to previous messageGo to next message
Wade
Messages: 5
Registered: October 2005
Location: Pittsburgh
Junior Member
Hi David,

Putting a PAUSE; caused the messages to appear on the bottom of the screen (where messages without acknowledge usually appear) instead of appearing in a message popup window. The Pause; caused 'Please Acknowledge' windows to appear.

Is that what you would expect?

Wade
Re: FND_REQUEST.SUBMIT_REQUEST error APP-00222 [message #141084 is a reply to message #140966] Thu, 06 October 2005 20:33 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Yes ... but did the messages that were displayed come out in exactly the same order as when you didn't have the 'pause' statement?

David
Previous Topic: order by problem (merged)
Next Topic: Display the alert (merged)
Goto Forum:
  


Current Time: Fri Sep 20 01:54:31 CDT 2024