Split Order Quantity based on Pallet Qty on Purchase Requisition

Summary:

Split Order Quantity based on Pallet Qty on Purchase Requisition

Content (required):

My Client is a Distributor and they push the order proposal from planning system to create requisitions. So in upstream systems they will decide the Qty to be purchased and sent to Self service Procurement Cloud and the quantity should get split based on the pallet qty maintained.

Ex: Order Qty is 90 Each and it is coming as one line in the interface . We need to maintain the Pallet Qty somewhere in Oracle Cloud as 30 Each (1 Pallet = 30 Each). So now the expectation is requistion should get splitted into 3 lines based on pallet quantity