Skip to main content

I am looking to create a migration job which reserves available material each morning for open material requisition lines. I have followed steps outlined here but could not make the jump from the Customer Order to the Material Requisition. Here is my current setup. I am not sure on the Source Mapping and for some reason  Part_No is not listed as a column name even though I see it when testing the API using Postman.

 

SELECT MRL.QTY_DUE - MRL.QTY_ASSIGNED, MRL.ORDER_CLASS, MRL.ORDER_NO, MRL.LINE_NO, MRL.RELEASE_NO, MRL.LINE_ITEM_NO, MRL.QTY_DUE - MRL.QTY_ASSIGNED, ROWID FROM MATERIAL_REQUIS_LINE MRL WHERE MRL.STATUS_CODE IN ('Released','Reserved','Partially Delivered') AND (MRL.QTY_DUE-QTY_ASSIGNED) >0

Select statement OK, parsed and executed for 1 row 
Length of statement : 289 characters

 

MATERIAL_REQUIS_LINE_API.MAKE_LINE_RESERVATIONS

 

 

 

 

Hi,

I think you should check in code how the system is retrieving the different part nos to be reserved, but probably not needed for your migration job.

Check how the procedure is finding the parts to be reserved and try it out with one material requisition as an example.

Regards,

Pilar

Reply


Terms & ConditionsCookie settings