Subcontracting: Interlock Manager Issues - see debug message "No subcontracting relationship exists between the OEM and the MP" AND also solved PO Not Picked Up For Processing
(Doc ID 2184261.1)
Last updated on JULY 20, 2020
Applies to:Oracle Outsourced Mfg for Discrete Industries - Version 12.2.4 and later
Information in this document applies to any platform.
Qn1:Subcontracting: Interlock Manager not kicking off the worker program . We are running the program in production after go-live
The Subcontracting process completely stop as Replenishment PO and Replenishment SO not created , Which impacting $
Uploaded all the screen shot of setup and fnd log , program log , setup Diagnostics, Apps Diagnostics
FND LOG messages in the ZIP file shows it is failing in the initial validation phase
MODULE LOG_LEVEL MESSAGE_TEXT
JMF_SUBCONTRACT_ORDERS_PVT 2 >> Validate_OSA_Item: OSA flag is 1
JMF_SUBCONTRACT_ORDERS_PVT 2 >> Validate_OSA_Item: Component flag is
JMF_SUBCONTRACT_ORDERS_PVT 2 >> Get_OEM_Tp_Org: Start
JMF_SUBCONTRACT_ORDERS_PVT 2 >> Get_OEM_Tp_Org: p_organization_id:<ID>: p_vendor_id:<ID>: p_vendor_site_id:<ID>
JMF_SUBCONTRACT_ORDERS_PVT 2 >> Get_OEM_Tp_OrgTP Org:
JMF_SUBCONTRACT_ORDERS_PVT 2 >> Get_OEM_Tp_Org: Exit
JMF_SUBCONTRACT_ORDERS_PVT 2 >> Validate_OSA_Item mp org id -
jmf.plsql.JMF_SHIKYU_GRP.Get_Subcontracting_Type.invoked 2 Entry
jmf.plsql.JMF_SHIKYU_GRP.Get_Subcontracting_Type.invoked 2 Before the query: subcontracting_type = ""
>>> jmf.plsql.JMF_GRP.Get_Subcontracting_Type.no_data_found 4 No subcontracting relationship exists between the OEM and the MP
Qn2:We have solved several issues in the Post go-live - In the case of PO 2017 we did not see this PO/Item picked up by the Interlock Manager and processed.
Even for a failure in the interlock manager when trying to process a PO, we expect that line will exist in the table JMF_SUBCONTRACT_ORDERS after it attempts to process and the INTERLOCK_STATUS = E or N
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