Discrete Manufacturing - EBS (MOSC)

MOSC Banner

"Close Discrete Jobs" failed with error There are transactions pending against these jobs,

as checked, no pending interface.

it's old discrete job, please help suggestion solution , how to close it?

SELECT wip_entity_name, wip_entity_id, organization_id
FROM wip_entities
WHERE wip_entity_name = 'SP04263432';

--79624216

SELECT count(*)
FROM WIP_MOVE_TXN_INTERFACE
WHERE ORGANIZATION_ID = 227
AND WIP_ENTITY_ID =79624216;

 0 rows

SELECT count(*)
FROM MTL_MATERIAL_TRANSACTIONS
WHERE COSTED_FLAG IN ('N','E')
AND TRANSACTION_SOURCE_TYPE_ID = 5
AND ORGANIZATION_ID = 227
AND TRANSACTION_SOURCE_ID =79624216;

 

0 rows

SELECT count(*)
FROM WIP_OPERATION_YIELDS
WHERE ORGANIZATION_ID = 227
AND STATUS IN (1, 3)
AND WIP_ENTITY_ID = 79624216;

 

0 rows

SELECT count(*)
FROM WIP_LPN_COMPLETIONS WLC,

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