Designing Inventory Organizations for a Two-Legal-Entity Distribution Network
Northwind Components is implementing Oracle Cloud Inventory for two legal entities: a U.S. manufacturing and distribution entity and a Netherlands sales entity that uses a third-party logistics provider. The U.S. operation has one manufacturing plant and two distribution centers; the Netherlands operation has one 3PL warehouse. Finance wants a single item master owned by the U.S. organization, separate standard costs for the Netherlands entity, and replenishment from the U.S. DC to the 3PL through inter-organization transfers. Operations wants quarantine and reject subinventories in every warehouse, locator control in the high-density pick areas, and no locator control in bulk storage. There are 8,000 active items, of which 2,500 are stocked in the Netherlands. The security team also requires that Netherlands warehouse users cannot view U.S. standard costs or transact in U.S. organizations. The project team is debating whether to use one inventory organization for all warehouses to simplify reporting.
1. Recommend the inventory organization and item master structure. Justify each separation and explain why a single organization for all warehouses is unsafe.
Read the worked answer
Use one item master organization for item definition and separate child inventory organizations for transaction and costing boundaries. At minimum, create a U.S. inventory organization for the manufacturing plant and U.S. distribution network, and a separate Netherlands inventory organization for the 3PL. If the two U.S. DCs have different costing, ownership, or operational parameters, model them as separate inventory organizations as well; otherwise they can share an organization with separate subinventories. The item master should remain a definition organization, not the organization in which all warehouses transact.
A single organization across legal entities is unsafe because inventory organization is the level at which many parameters, cost profiles, and security assignments operate. It would blur legal ownership and standard-cost separation between the U.S. and Netherlands entities, make 3PL accountability harder, and weaken organization-level access control. Subinventories cannot substitute for organizations when you need inter-organization transfers, separate costing, or distinct organization parameters. Use the organization hierarchy for reporting roll-up, not as a substitute for transaction boundaries.
2. Design the subinventory and locator approach, including where locator control should be enabled and how to prevent Netherlands users from seeing U.S. costs.
Read the worked answer
Within each inventory organization, define subinventories for receiving, inspection or quarantine, reject, bulk storage, and pick faces as needed. Enable locator control at the subinventory level, not uniformly across the organization: turn it on for high-density pick areas and bulk locations where you need precise location tracking, and leave it off for subinventories where locator detail adds no value. Quarantine and reject should be separate subinventories so material is visible but not available to pick.
For the Netherlands 3PL, create a separate inventory organization and assign only the 2,500 Netherlands-stocked items to it. Do not rely on subinventory names or item categories for cost security. Use organization access and role-based data security so Netherlands warehouse users are scoped only to the Netherlands organization and cannot query U.S. organizations or cost fields. Test both transaction access and reporting access, because a user may be blocked from entering a receipt but still see cost in an OTBI report if the report does not enforce the same organization scope.
3. What transaction should replenish the 3PL, and what setup must exist before the first shipment?
Read the worked answer
Use an inter-organization transfer, typically through a transfer order, because the shipment crosses inventory organizations and possibly legal entities. A movement request is for moving material within the same inventory organization, such as bulk to pick face; it will not satisfy the U.S.-to-Netherlands replenishment requirement.
Before the first shipment, confirm that the item is assigned to both the shipping and receiving inventory organizations, that both organizations have active cost profiles and organization parameters, and that the transfer order type and in-transit time are defined. Establish the shipping and receiving relationship, the transfer price or costing rule, and the receipt routing at destination. Decide whether the material is received into a 3PL receiving or quarantine subinventory before put away. Also confirm that organization access allows the U.S. shipper to ship and the Netherlands receiver to receive, without giving either side unnecessary visibility into the other organization's costs.