Perform Inventory On-Hand Quantity Consolidation
Use the Perform Inventory On-Hand Quantity Consolidation process to perform consolidation of on-hand quantities for inventory organizations.
Every transaction that increases a good’s on-hand quantity, like a purchase order receipt or miscellaneous receipt, creates a unique entry in the INV_ONHAND_QUANTITIES_DETAIL table. While multiple entries are necessary for many reasons, the existence of multiple records for an item with the same attributes, in the same location, with the same original receipt date can potentially cause performance issues in future transactions that require checking material availability. In certain circumstances, it makes sense for you to consolidate these rows for improved performance in future transactions.
When to Use
Run this process for organizations where receipts are performed more frequently than issues for the same combination of attributes, thereby leading to excessive on-hand records that may impact your transaction processing performance. It's recommended to run or schedule the scheduled process only when you observe that Oracle Fusion Cloud Inventory Management transaction processing (through the user interface, file-based data import (FBDI), REST resource, or SOAP API) is taking longer than expected.
Privileges Required
- Perform Inventory On-Hand Quantity Consolidation (INV_PERFORM_ONHAND_QUANTITY_CONSOLIDATION_PRIV)
Specifications
| Specification | Description |
|---|---|
| Job Type | Ad hoc job Scheduled |
| Frequency | As required, usually after the receipt transactions are performed. We recommend that you run the process once a week. |
| Time of Day | This process should be run at the start of the day before performing the day to day inventory transactions. |
| Duration | The runtime of this process depends on the number of on-hand records available to consolidate. |
| Compatibility | There should only be one instance of the process by organization at any one time. The job is incompatible with itself. Please keep this in mind while creating the schedules. |
Parameters
| Parameter | Optional or Required | Description | Parameter Values | Special Combinations Required | Notes |
|---|---|---|---|---|---|
| Organization | Required | Enter the organization code for this report. | Organization | None | It’s recommended to run the process for specific organizations where the maximum number of receipts are performed. |
Troubleshooting Information
- You can view the status of the process in the Scheduled Processes work area. If the process status is error, select the row and then click the Process Details tab. Click Log and Output, and then click the attachment hyperlink to download the log and output file. Share the files with Oracle Support to log a service request.
- The output and the log file will show the number of records available before consolidation, records eligible for consolidation, records consolidated, records that weren’t consolidated, and records available after consolidation.
- On-hand quantity consolidation happens only when the Item, Organization, Revision, Subinventory, Locator, Lot, Project, Task, Country of Origin, and Original Receipt Date attributes are the same in the on-hand table.
- For additional details, please see Consolidate Inventory On-Hand Quantities in the What’s New section of the Oracle Fusion Cloud Inventory Management Readiness document.