My Oracle Support Banner

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

Last updated on MAY 09, 2022

Applies to:

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



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.


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

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