Wednesday, October 19, 2011

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.

1 comment:

  1. Nice posts with scripts, use full stuff for every one thanks for the post, And you can also check for any issues and tips and trouble shooting related to appsdba 11i and R12 on http://www.appstier.blogspot.in/

    ReplyDelete

javascript:void(0)