Order Management - EBS (MOSC)

MOSC Banner

OE_ORDER_PUB.PROCESS_ORDER Does not update ship_to_ord_id on order.

edited Apr 21, 2015 10:03AM in Order Management - EBS (MOSC) 6 commentsAnswered

Hi,

I am using below code to update ship_to_org_id on my order though the api returns me status as 'S' but when i check by querying the order then it returns me same old ship_to_org_id.

Note that my application is 12.2.4 and DB version is 11.2.0.4. Any pointer on this would be great help.

   SELECT SHIP_TO_ORG_ID

     FROM oe_order_headers_all

    WHERE header_id = 33946949;

DECLARE

   i_header_id                NUMBER:=33946949;

   i_ship_to_org_id           NUMBER:=9567441;

   i_bill_to_org_id           NUMBER:=2140886;

   o_return_status            VARCHAR2 (4000):=NULL;

   l_header_rec               oe_order_pub.header_rec_type;

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