Include Items with Zero On-Hand Inventory in Inventory Balance Snapshot by ERP Buckets
WMS is enhancing the configurable rules to generate inventory balances to include items that do not have inventory. This will aid in inventory on-hand balance reconciliation to ensure Oracle Fusion Cloud SCM has the same on-hand and availability picture as WMS. Smoother and accurate built in inventory snapshot reconciliation enables smoother go-lives and less custom integrations.
The current process includes an optimization where records with zero inventory for a specific SKU/ERP Bucket combination from the previous run are excluded to reduce data volume.
In 25B, we are introducing the following improvements to ensure data accuracy and consistency:
- The Generate Inventory Balance Snapshot scheduled job that generates data into the intermediate table (Inventory Balance Info) will now consider all ERP buckets based on the current inventory balance snapshot.
- For each SKU/Batch/Expiry Date/Inventory Attribute combination, the system will determine the quantity for ERP buckets that had a quantity greater than zero in the previous run, even if the current quantity is zero.
FOR EXAMPLE:
Consider SKU ABC with ERP buckets AVAILABLE and DAMAGED. In the first run, AVAILABLE has 100, and DAMAGED has 20.
Before the second run, the inventory changes, with AVAILABLE at 80 and STAGING at 20. The subsequent run will now include AVAILABLE with 80, DAMAGED with 0, and STAGING with 20, ensuring that the DAMAGED bucket is not overlooked.
SUMMARY TYPE
- Inventory Balance by ERP Bucket: If the summary type is organized by ERP Bucket, the system will search for ERP Buckets in Inventory Balance Info based on the SKU/Batch/Expiry Date/Inventory Attribute combination.
- Inventory Balance by Location: When the summary is by Location, the search for ERP Buckets will include the Location parameter, ensuring accurate data retrieval.
EXTRACT INVENTORY BALANCE TO DELETE ZERO QUANTITY RECORDS
To maintain a clean and relevant dataset, we have introduced an option to flush out or purge records with zero quantities during the extraction process. This feature ensures that your inventory data remains concise and up-to-date.
Scheduled Job Enhancements
We’ve added the following scheduled job enhancements:
| Scheduled Job | Description |
|---|---|
| Extract Inventory Balance Snapshot | This job will now include zero quantity records for the specified SKU/BATCH/EXP_DATE/INVENTORY ATTRIBUTE combinations. You can choose to retain or purge these records based on your preferences. |
| Generate Inventory Balance Snapshot | The extraction rule can be configured to handle zero quantity records. You can select whether to include or exclude these records in the generated snapshot. |
DELETE ZERO QUANTITY RECORDS EXTRACTED PARAMETER
You can manage including ERP buckets with zero quantity from the previous run using the delete_zero_qty_records_extracted parameter in the Extract Inventory Snapshot scheduled job.
- The parameter accepts values "Yes" or "No".
- By default, it is left blank, ensuring zero quantity records are not flushed out.
- If set to "Yes", the system will delete zero quantity records for the specified SKU/Inventory combinations after the extraction process, keeping your data tidy.
- If set to "No", all records, including zero and non-zero quantities, will be extracted without purging.
The new parameter is accessible and configurable in the Item Summary Generation Rule View UI for extraction rule types, ensuring a seamless and controlled inventory management experience.
Steps to Enable
You don't need to do anything to enable this feature.