My Oracle Support Banner

Subcontracting: Interlock Manager Is Trying To Process Blanket Purchase Agreement (Doc ID 2686696.1)

Last updated on JULY 15, 2020

Applies to:

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

Symptoms

12.2.8

PROBLEM
-------------
Global Blanket PO lines are picked up by the Interlock Manager for processing.
This happens during the insert into INSERT INTO JMF_SUBCONTRACT_ORDERS_TEMP and the cause is the Global Blanket has lines in po_line_locations_all poll table

The lines are inserted when customer chooses Price Break on the Global Blanket PO
Lines show poll.shipment_type = 'PRICE BREAK'

JMF SQL does not filter out these lines.

Subsequently, these lines fail validation with ORA-01403 and this prevents further processing by the Interlock manager.

In customer example:
Global PO has 2 lines -- both lines have lines for poll.shipment_type = 'PRICE BREAK'
Also created standard PO with 2 lines for the same items to be processed.

All 4 lines end up in JMF_SUBCONTRACT_ORDERS with interlock_status = 'N' and no further processing happens

EXPECTED BEHAVIOR
----------------------------
Global Blanket PO lines will be excluded in SQL to populate lines for processing

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
References


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