Discrete Manufacturing - EBS (MOSC)

MOSC Banner

WIPDJMDF Scheduling job and creating material requirements

edited Nov 7, 2019 5:22PM in Discrete Manufacturing - EBS (MOSC) 2 commentsAnswered

Every time that I try to create a new discrete job, no matter what item, the forms get stuck with the message.

If I run

select count(*)
from bom_operation_sequences bos1, bom_operation_sequences bos2
where bos1.routing_sequence_id = bos2.routing_sequence_id
and bos1.operation_seq_num = bos2.operation_seq_num
and bos1.operation_sequence_id <> bos2.operation_sequence_id

and (bos1.disable_date is null and bos2.disable_date is null);

The result is 0

SELECT count(*)
FROM bom_operation_resources A
WHERE a.rowid        > ANY
(SELECT B.rowid
FROM bom_operation_resources B
WHERE A.operation_sequence_id = B.operation_sequence_id

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center