Oracle Fusion Data Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Requisition Order Round Up if less than item quantity

Archived
16
Views
2
Comments

Mobile Inventory/Requisitioning Module

Round up if quantity ordered is not divisible by standard order quantity

If an order is placed using a quantity that is not divisible by the standard order quantity then round up to standard order quantity.

Example:

Purchase Orders are set to be ordered in Case quantities each CASE has 6 Eaches. Using self-service requisition a user creates a requisition for 3 EA. Currently the PO will be for .5 CS.  We would like to see the system round it up to 1 CS.

Thank you

2
2 votes

Archived · Last Updated

Needs to be posted in an application-specific Idea Lab

Comments

  • J Holliday-Bass
    J Holliday-Bass Rank 1 - Community Starter

    This request is a priority request which allows for better inventory controls with the client's business model;

    Rule logic:

    1. Divisibility Check:
      • Define a base unit (e.g., case pack size, standard quantity) — let's assume 5 for this example.
      • For each inventory item quantity:
        • If divisible by 5 → no change
        • If not divisible:
          • Round up to the nearest multiple of 5 if rounding up is preferred
          • Or round down if minimizing overstock is preferred
          • Or round to the nearest multiple of 5 if balance is preferred
    2. Example:
      • Quantity: 47 → Nearest multiple of 5 is 45 or 50
        • Round up → 50
        • Round down → 45
        • Nearest → 45 (since 47 is closer to 45 than 50)

    Considerable Options for making this change:

    • ERP Integration: This logic can be embedded in inventory update scripts, batch processing jobs, or API endpoints.
    • Custom Script: generate a Python script or SQL logic that applies this rule across a dataset.
    • Automation: ability to schedule a job to run during inventory reconciliation or order processing.
  • This Idea Lab is for Fusion Data Intelligence, which is an analytics solution for Fusion Applications. Since this idea is an application-specific request, please check Oracle Cloud Customer Connect and post to the relevant Idea Lab there.