My Oracle Support Banner

Unable To Create A Bonus Job Using Import WIP Lot Transactions Program (Doc ID 2319973.1)

Last updated on FEBRUARY 26, 2019

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.


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

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

In this Document

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