Enforce Integer Quantities for Materials in Work Orders and Production Transactions

Manufacturers often handle indivisible materials, such as labels, in whole units instead of fractional or decimal quantities. With this feature, you can now specify the materials in work definition operations that need to be issued or returned in integer quantities with round up or round down rules. The enforce integer rules for materials are applied in the context of their unit of measure. These rounding rules are automatically applied to the work order required quantities and shown as adjusted quantities to facilitate material reservations and picking. You can also report these adjusted quantities for materials manually, through backflush, or through REST API and File-Based Data Import.

The screenshot shows details of a sample item structure in Product Information Management. The Enforce Integer Requirement is set to Round up for the item, Label.

Enforce Integer Requirement Setup for an Item Structure Component in Product Information Management

Enforce Integer Requirement Setup for an Item Structure Component in Product Information Management

The Manufacturing work definition for a standard material inherits the Enforce Integer Requirement from the item structure in Product Information Management.

Enforce Integer Requirement for the material in the Work Definiton

Enforce Integer Requirement for the Component in the Work Definition

The Enforce Integer and Adjusted Quantity fields are added to the material in the work order. The Enforce Integer value for the material is inherited from the corresponding work definition material. The Adjusted Quantity for the material is the round up or round down quantity, as per the Enforce Integer requirement.

Enforce Integer Requirement for the material in the Work Order

Enforce Integer Requirement for the Component in the Work Order

The transaction quantity is rounded to an integer to honor the Enforce Integer Requirement policy setup for the work order material.

Enforce Integer Requirement for the material in the Material Transaction

Enforce Integer Requirement for the Component in the Material Transaction

Enforcing integer quantities eliminates inventory discrepancies in material consumption, improving alignment between the physical and the system inventory.

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Manufacturing and Supply Chain Materials Management  No Longer Optional From: Update 26B

Tips And Considerations

  • Enforcing integer quantities is applicable to input materials only, not to products and outputs.
  • Enforcing integer quantities is not applicable to contract manufacturing, outside processing flows, and maintenance flows.
  • In the current update, enforcing integer quantities is not supported for:
    • Work definitions, work orders, and material transactions in the Classic user interface
    • Work definitions, work orders, and material transactions using ADFdi spreadsheet upload
    • Work definition and work order reports
    • Orderless transactions
    • Flow Schedules
    • Scaling in process work orders
    • Material Availability Workbench
    • Manufacturing OTBI subject areas
    • Work Definition Read-Only Data Store objects
  • For Manufacturing work order components, the current logic for open quantity remains the same, and is calculated as:
    • Open quantity = Required quantity – Issued quantity.
    • In addition, the open quantity is set to zero if it becomes negative.
  • It must be noted that existing customers who have already setup round up or round down policy for item structure components, will automatically see enforce integer changes in new work definitions, work orders and material transactions, when their work definitions are synchronized with item structures.
  • Partial material completions will inflate or deflate the transacted quantities when enforce integer is enabled. Hence, as a best practice full quantity completion is recommended for material transactions.
  • When completing an operation, users should not enforce the validation for 'Completions with Under Issues' when the difference is due to round down
  • Considerations for Picks and Reservations:
    • Inventory picking and reservations will honor the adjusted quantity of the work order component and UOM to honor the enforce integer requirement.
    • The Reserve Automatically action rounds up or rounds down the work order component quantity based on the enforce integer setup at the work order component to reserve an integer quantity.
    • To manually create reservations, enter an integer reservation quantity for a component in work order UOM. This reserves the work order component to supplies such as purchase order, transfer order, work order, or requisition supplies. The reservation for the incoming supply is transferred to on-hand document type only when the integer quantity of the incoming supply is received for a demand.
    • The picks are created in the integer quantity for the work order components which are enabled for enforce integer.An error message is displayed when the user enters a non-integer pick quantity for pick confirmation.
    • If the item is serial controlled and Inventory organization parameter "Allocate Serials" is enabled, then the enforce integer requirement will be honored only at Pick Confirm.
    • When Fusion Inventory is integrated with Oracle Cloud WMS with Enforce Integer Functionality enabled note that due to the nature of Inventory Stored in the warehouse, pick confirmation could send inventory which is not an integral multiple of the required quantity of the movement request. This could potentially create pick confirmation errors. We recommend not to enable WMS until the enforce integer flag is being honored on movement request in a future update.

Key Resources

  • Watch the Enforce Integer Quantities for Materials in Work Orders and Production Transactions demo.
  • Oracle Fusion Cloud SCM: Refer to the Using Manufacturing guide, available on the Oracle Help Center.
  • Oracle Fusion Cloud SCM: Refer to the Implementing Manufacturing and Supply Chain Materials Management guide, available on the Oracle Help Center.

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

These privileges were available prior to this update.

Work Definition Privileges:

  • Manage Work Definitions (WIS_MANAGE_WORK_DEFINITIONS_PRIV)
  • View Work Definitions (WIS_VIEW_WORK_DEFINITIONS_PRIV)
  • Get Work Definitions by Service (WIS_GET_WORK_DEFINITIONS_SERVICE_PRIV)
  • Manage Work Definitions by Service (WIS_MANAGE_WORK_DEFINITIONS_SERVICE_PRIV)
  • Get Manufacturing Plant Set Up Data by Service (WIS_GET_MFG_PLANT_SETUP_SERVICE_PRIV)

Work Order Privileges:

  • Manage Work Order Headers (WIP_MANAGE_WORK_ORDER_HEADERS_PRIV)
  • Manage Work Order Operations (WIP_MANAGE_WORK_ORDER_OPERATIONS_PRIV)
  • Manage Work Execution Work Area (WIP_MANAGE_WORK_EXECUTION_WORK_AREA_PRIV)
  • View Work Orders (WIP_VIEW_WORK_ORDERS_PRIV)

Material Transaction Privileges:

  • Report Material Transactions (WIP_REPORT_MATERIAL_TRANSACTIONS_PRIV)

Item Structure Privileges and Duty Roles:

  • Create Item Structure (EGP_CREATE_ITEM_STRUCTURE_PRIV)
  • View Item (EGP_VIEW_ITEM_PRIV)
  • Manage Item (EGP_MANAGE_ITEM_PRIV)
  • Access Item Structure Data Using a REST Service (EGP_GET_ITEM_STRUCTURE_REST_PRIV)
  • Access Product Management Landing Page (EGP_ACCESS_LANDING_PAGE_PRIV)
  • Item Management (ORA_EGP_ITEM_MANAGEMENT_DUTY)