My Oracle Support Banner

R12: Why is PROCESS_ORDER API not progressing line workflow used to "schedule" line? (Doc ID 1988873.1)

Last updated on MAY 22, 2018

Applies to:

Oracle Order Management - Version 12.0 and later
Information in this document applies to any platform.


On : 12.1.3 version, Trx Changes & Cancellations

When using the Process_Order API to schedule order lines, lines are SCHEDULED as expected but the line workflow
is not progressed and remains at a "Schedule - Eligible" (Notified) status.

Passing the below standard attributes to trigger the API scheduling.

  l_line_tbl (1) := oe_order_pub.g_miss_line_rec;
  l_line_tbl (1).operation := oe_globals.g_opr_update;
  l_line_tbl (1).header_id := 423852;
  l_line_tbl (1).line_id := 10467692;
  l_line_tbl (1).schedule_ship_date := TO_DATE ('17-DEC-2014');

Expect line to be scheduled - SSD (Schedule Ship Date) updated, Schedule Status Code populated etc...but also
expect line workflow to be progressed.

The issue can be reproduced at will with the following steps:
1. Run Process_Order API wrapper script for single example order line.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.