AutoCreate Final Assembly Orders Ends With Warning Due to Lock Issue (Doc ID 2301748.1)

Last updated on AUGUST 28, 2017

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem Statement
WICDOL module: AutoCreate Final Assembly Orders request ends with Warning status.
When running the request with debug mode (OM: Debug Level = 5), the following lock error occur is seen on the concurrent request log file.

Error
----------------------------------------
Processing line_id: 23729687
----------------------------------------
get_order_lines: NOT Setting the Org Context since MO:Operating Unit = OEL.org_id.
get_order_lines: Looking the sourcing information...
get_order_lines: Could not lock line id 23729687 for update. <===
get_order_lines: This line is being processed by another process.
get_order_lines: ****************************************
get_order_lines: Number of Order Lines Selected: 0
get_order_lines: Number of Rows on Hold: 0
get_order_lines: Number of Rows not Departure Planned: 0
get_order_lines: Number of Rows in error: 0
get_order_lines: Number of Order Lines Inserted: 0
get_order_lines: Number of Flow Schedules Created: 0
get_order_lines: WIP Group ID: -1
get_order_lines: ****************************************
get_order_lines: CTOWIPWB.get_order_lines: Line 23729687 is NOT eligible for Autocreate FAS anymore.
get_order_lines: Could not find a WIP job. Records probably stuck in wip job schedule interface.
Return status from CTO_WIP_WRAPPER.get_order_lines:1
Group_Id from CTO_WIP_WRAPPER.get_order_lines: -1
L_orders_loaded=> 0

Steps to Reproduce

  1. On Sales order line form, progress sales order for ATO item.
  2. AutoCreate Final Assembly Orders request launches.

Cause

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 hundreds of Community platforms