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

Last updated on APRIL 04, 2025

Applies to:

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

Only the lines related to Blanket Release will be picked up - exclude the additional lines related to Price Break data.

Cause

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