Tuesday 23 July 2019

Cancel Line API Error ORA-01403: No Data Found in Package OE_ORDER_GRP Procedure Automatic_account_creation

Issue: Cancel Line API Error ORA-01403: No Data Found in Package OE_ORDER_GRP Procedure Automatic_account_creation

Steps: Used API oe_order_pub.process_order to Cancel Line with proper init commands but still got the error.

      oe_msg_pub.initialize;
      oe_debug_pub.initialize;
      mo_global.init ('ONT');
      mo_global.set_org_context (g_org_id, NULL, 'ONT');
      fnd_global.set_nls_context ('AMERICAN');
      mo_global.set_policy_context ('S', g_org_id);

In order for the API to work correctly, we need to set the org context and initialize  correctly.

Upon further investigation found that the ORG_ID passed to the script does not match with Order Org :D


No comments:

Post a Comment