fnd_request.submit_request help

[jcasas23]

Why if I call this pl/sql req_id = 0?

declare
req_id number;
begin
req_id := fnd_request.submit_request('PER','BTOTMEMP',
null,to_char(sysdate, 'DD-MON-YYYY'),
TRUE,'CIA=1',
'YEAR=2004','MONTH=10',chr(0),null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,
null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,
null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,
null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,
null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null);
dbms_output.put_line (req_id);
end;

 

[SantaMufasa]

J,

Again, my crystal ball is very fuzzy today and it cannot tell me what on earth the function "fnd_request.submit_request" does. Whatever it does, the RETURN value is '0'. Perhaps if you post the code for "fnd_request.submit_request", we can explain how you ended up with '0'.

Cheers,

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 00:15 (16Feb05) UTC (aka "GMT" and "Zulu"),
@ 17:15 (15Feb05) Mountain Time

Do you use Oracle and live or work in Utah, USA? Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[carp]

I have found this to occur when one or more of the required arguments is missing or has an invalid value.
Also, be sure to do a commit after running the function - otherwise, your concurrent manager will not see the record in fnd_concurrent_requests. This is one of Oracle's little surprises that will get you every time!