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 laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |