Lot Based Job Interface - Creating Negative Numbers For Operation_sequence_id

(Doc ID 2251418.1)

Last updated on APRIL 28, 2017

Applies to:

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


On : 12.2.5 version, Lot Based Job

When attempting to move a Lot based job,
the following error occurs.

Invalid Job

The issue can be reproduced at will with the following steps:

1. Insert data into the wsm_lot_job_interface table, then into the wsm_lot_job_dtl_interface table
2. Import the data

3. Responsibility = Shop Floor Management
4. Navigation = Lot Move Transactions -->Query the Job "2706258RL4"
5. Select the Transaction Type as Move-->Save
6. Error comes up

The issue has the following business impact:
Due to this issue, users cannot move and complete the job.


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