Message::order is not eligible for booking check workflow
status for this order
Solution::
àrun the scrpit with order
number and then run the “work flow process” then book the order
DECLARE
v_headerid NUMBER;
CURSOR cr
IS
SELECT oeh.header_id
FROM oe_order_headers_all oeh
WHERE oeh.order_number = '791137'; --order in issue
l_org_id NUMBER := 204; --OU ID get org id form above
BEGIN
mo_global.set_policy_context ('S', l_org_id);
FOR rs IN cr
LOOP
v_headerid := rs.header_id;
apps.wf_engine.startprocess ('OEOH', TO_CHAR (v_headerid));
END LOOP;
END;
v_headerid NUMBER;
CURSOR cr
IS
SELECT oeh.header_id
FROM oe_order_headers_all oeh
WHERE oeh.order_number = '791137'; --order in issue
l_org_id NUMBER := 204; --OU ID get org id form above
BEGIN
mo_global.set_policy_context ('S', l_org_id);
FOR rs IN cr
LOOP
v_headerid := rs.header_id;
apps.wf_engine.startprocess ('OEOH', TO_CHAR (v_headerid));
END LOOP;
END;
-->Run the ” wokflow background process “
Goto -àsystem administrator -àview requests-àsubmit new request
Prog name( wokflow background process )
Parameters:
Process Deferred:YES
Process Timeout:YES
No comments:
Post a Comment