"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,