Interlock Manager Not Processing Purchase Orders Created For Outsourced Assemblies (Doc ID 2175558.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Outsourced Mfg for Discrete Industries - Version 12.2.5 and later
Information in this document applies to any platform.

Goal

FND_LOG_MESSAGES shows the following:

In log messages we see
JMF_SHIKYU_WIP_PVT 2 >> Compute_Start_Date: p_oem_organization = 1104, p_tp_organization = 1124, p_item_id = 104129
JMF_SHIKYU_WIP_PVT 2 >> Compute_Start_Date: l_start_date (before considering off days) =
JMF_SHIKYU_WIP_PVT 2 >> Compute_Start_Date: l_off_days = 0
JMF_SHIKYU_WIP_PVT 2 >> Compute_Start_Date: l_start_date =

THEN
JMF_SUBCONTRACT_ORDERS_PVT 6 JMF_SUBCONTRACT_ORDERS_PVTLoad_Shikyu_Components: ORA-01403: no data found
JMF_SUBCONTRACT_ORDERS_PVT 6 JMF_SUBCONTRACT_ORDERS_PVTSubcontract_Orders_Manager: User-Defined Exception

And column call stack /error stack has
PL/SQL Call Stack object line object
  handle number name
0xde28ab20 73 package body APPS.FND_LOG
0xde28ab20 216 package body APPS.FND_LOG
0xcf4add38 3360 package body APPS.JMF_SUBCONTRACT_ORDERS_PVT 0xcf
/
ORA-01403: no data found

What is causing this error?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms