EBS在后台取消请求

54 阅读 0 评论 36 点赞

我是靠谱客的博主活泼蚂蚁，最近开发中收集的这篇文章主要介绍EBS在后台取消请求，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

UPDATE FND_CONCURRENT_REQUESTS R
   SET PHASE_CODE      = 'C',
       STATUS_CODE     = 'D',
       completion_text = 'SYSADMIN 已取消请求。'
WHERE R.REQUESTED_BY = '1193'
   AND PHASE_CODE = 'P'
   AND STATUS_CODE IN ('I', 'Q')
   AND (nvl(request_type, 'X') != 'S')

注意要commit

DECLARE

   v_request_id NUMBER;
v_message    VARCHAR2(300);
V_TRUE       BOOLEAN;
BEGIN
fnd_global.apps_initialize(29996, 51714, 555);
v_request_id := 3945574;
DBMS_OUTPUT.PUT_LINE('TEST BEFORE CANCEL');
V_TRUE := fnd_concurrent.cancel_request(Request_Id => v_request_id, Message    => v_message);
DBMS_OUTPUT.PUT_LINE('TEST AFTER CANCEL ' || v_message);

COMMIT;
EXCEPTION
WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('TEST AFTER exception');
END;