Order Management - EBS (MOSC)

MOSC Banner

Not Able to Put Order Line On Hold using OE_ORDER_PUB.process_order

edited Aug 31, 2015 1:17PM in Order Management - EBS (MOSC) 13 commentsAnswered

Hi All,

Using note "How to apply a HOLD at Line Level using an API ? (Doc ID 1396053.1)" created custom code to put order line on hold.

When I am calling the custom procedure from SQL Prompt Order Line Hold is getting Applied.

Begin

APPLY_ORDER_ECCN_HOLD(64501205,16477865,142410, 60240,  660);

end;

But When I am calling same Customer Procedure from GRC(Governance Risk Complinance) Form Rule then OE_ORDER_PUB API is failing.

From GRC we can trigger to custom procedure, but API is failing to apply hold.

Out Parameter of API Returns following values.

l_return_status: E

l_msg_data : NULL

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center