Unable To Create A Bonus Job Using Import WIP Lot Transactions Program

(Doc ID 2319973.1)

Last updated on OCTOBER 26, 2017

Applies to:

Oracle Shop Floor Management - Version 12.2.6 and later
Information in this document applies to any platform.


Problem Statement
When attempting to create a bonus Lot through the WIP Lot Transaction Interface, the following error occurs.

The starting operation specified is not in the primary path of the network routing
derive_val_res_job_details failed
Bonus Txn procedure failed

Steps to Reproduce

  1. Routing is defined as below;
    Operation 1: Effective date:11-JUL-2017
    Operation 2: Effective date:11-JUL-2017
    Routing Network is defined as below
    Operation 1 -> Operation 2 - PRIMARY 100%
  2. Set disable date for Seq2 and add new line for Seq 2 with different effective date.
    Operation 1: Effective date:11-JUL-2017
    Operation 2: Effective date:11-JUL-2017 - 31-DEC-2017 23:59:59
    Operation 2: Effective date:01-JAN-2018
  3. Inserted data into wsm_split_merge_txn_interface and wsm_resulting_jobs_interface tables with starting_Operation = 2
  4. After submitting the Program Import WIP Lot Transactions ,the record ends in error and Job is not getting created.


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