Interlock Manager Not Spawning Worker Jobs After 12.2.10 Upgrade
(Doc ID 2738833.1)
Last updated on DECEMBER 22, 2020
Applies to:Oracle Outsourced Mfg for Discrete Industries - Version 12.2.10 and later
Information in this document applies to any platform.
12.2.10 After upgrade from 12.2.9
Interlock Manager is not creating replenishment sales order, replenishment purchase order, and work order in the MP org after a subcontracting purchase order is created and approved.
errors in module
in export.xlsx LINE 4354
p_subcontract_po_shipment_id = 123456 p_oem_organization_id = 111 p_tp_organization_id = 222 Count of components = 1
Component = 666777 Quantity = 16
Org ID selected from org_organization_definitions = 102
Org ID from CLIENT_INFO = 102
Ship To customer id = 19000 Ship To org id = 1535301
THEN THROWS ERROR
"ORA-01086: savepoint 'BEFORE_PROCESS_ORDER' never established in this session or is invalid
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-01403: no data found"
-- New lines exist in jmf_subcontract_orders and they are never pulled for processing since the error occurs transacting old business and before new business
-- There were ~ many records that have errors >>>> they can be ignored <<<<
-- items can be sourced from normal supplier and also from MP - so when normal supplier is used, those lines will get error in Interlock FND Log >>> No subcontracting relationship exists between the OEM and the MP
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