Set completion status of Concurrent Request (Host)

If you have a concurrent request executable of type host (shell script. on unix) and you want to set the status of the request to Warning or Error upon completion you need to use a small SQL-script. to accomplish this.

Warning

DECLARE
  l_result     BOOLEAN;
  l_session_id NUMBER;
  l_reqid      NUMBER;
BEGIN
  l_reqid := '&&1';
  dbms_output.put_line('l_reqid '||l_reqid);
  fnd_global.INITIALIZE(l_session_id, null, null, null,null, -1, null, null, null, 
                        null, l_reqid, null,null,null,null,null,null,-1);
  l_result := fnd_concurrent.set_completion_status('WARNING','Review log file for details.');
  COMMIT;
END;
/
exit 0;

Error

DECLARE
  l_result     BOOLEAN;
  l_session_id NUMBER;
  l_reqid      NUMBER;
BEGIN
  l_reqid := '&&1';
  dbms_output.put_line('l_reqid '||l_reqid);
  fnd_global.INITIALIZE(l_session_id, null, null, null,null, -1, null, null, null, 
                        null, l_reqid, null,null,null,null,null,null,-1);
  l_result := fnd_concurrent.set_completion_status('ERROR','Review log file for details.');
  COMMIT;
END;
/
exit 0;

Call the script. from your shell script.

sqlplus $unpw @$XX_TOP/sql/your file name.sql "$conc_request_id"

You can of course handle both Warning and Error in the same SQL-file.

ITPub博客

Set completion status of Concurrent Request (Host)

Set completion status of Concurrent Request (Host)

最新文章