Interlock Manager Not Spawning Worker Jobs After 12.2.10 Upgrade (Doc ID 2738833.1)

Last updated on DECEMBER 22, 2020

Applies to:

Symptoms

12.2.10 After upgrade from 12.2.9

PROBLEM
-------------
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.

FND_LOG_MESSAGES shows
errors in module
JMF_SUBCONTRACT_ORDERS_PVT.Stamp_Null_Shikyu_Comp_Prices
JMF_SHIKYU_ONT_PVT.get_price_quote

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"
User-Defined Exception

THEN EXITS.
-- 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

NOTE:
-- 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

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.