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.
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
Global Blanket PO lines will be excluded in SQL to populate lines for processing
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