Tuesday, November 8, 2016

order is not eligible for booking check workflow status for this order

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;



-->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

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...