OE_ORDER_PUB.PROCESS_ORDER Does not update ship_to_ord_id on order.
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;