Shipping Execution - EBS (MOSC)

MOSC Banner

Data is not inserting in wsh_delivery_details when trying to schedule sales order using API

We are trying to schedule the sales order using OE_ORDER_PUB.process_order but data is not inserting into wsh_delivery_details table with delivery information.

APPL Version : R12.2.9

Below are the parameter passing to the API

   lr_line_tbl (1)           := oe_order_pub.g_miss_line_rec;

   lr_line_tbl (1).operation      := oe_globals.g_opr_update;

   lr_line_tbl (1).header_id      := rec.p_header_id;

   lr_line_tbl (1).line_id       := rec.p_line_id;

   lr_line_tbl (1).ordered_quantity   := ln_qty;

   lr_line_tbl (1).schedule_action_code := 1;

   lr_line_tbl (1).flow_status_code   := 'AWAITING_SHIPPING';

   lr_line_tbl (1).schedule_ship_date  := SYSDATE;

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