Handling Mixed UPC Pallet in item creation and inventory
We have a business scenario where our vendor supplies a single pallet containing a mix of three different UPCs. Specifically, each pallet includes:
104 cases of Item A88 cases of Item B192 cases of Item C
Our customer orders in OM are based on individual item cases, not pallets. However, the vendor only accepts "Pallet" as the PO ordering UOM, not individual items.
We understand one approach could be to order Items A, B, and C in fixed ratios on PO and receiving them accordingly. But since the supplier insists on Pallet as the only orderable unit, we’re exploring how best to model this in Oracle Cloud.