Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Requisition Order Round Up if less than item quantity

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
Comments
-
This request is a priority request which allows for better inventory controls with the client's business model;
Rule logic:
- 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
- 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)
- Quantity: 47 → Nearest multiple of 5 is 45 or 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.
0 - Divisibility Check:
-
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.
0