Publish Inventory On-Hand Balances to an External System
Use the Publish Inventory On-Hand Balances to an External System scheduled process to generate a file-based export for efficient reconciliation of inventory on-hand balances, including serial numbers, between Oracle Inventory Management and external systems.
This process helps maintain synchronization across systems and supports accurate demand fulfillment and supply planning. The scheduled process generates periodic snapshots of inventory on-hand balances that can be shared with external systems for reconciliation purposes. The process supports reconciliation for both serial-controlled and non-serial-controlled items.
- Uses the input parameters to retrieve inventory on-hand data for the selected organizations and records.
- Generates a CSV (.psv) file containing inventory on-hand balance information.
- Compresses the output file into a ZIP file.
- Uploads the ZIP file to Universal Content Management (UCM) for consumption by external systems.
When to Use
Use this scheduled process when Oracle Fusion Cloud Inventory Management is integrated with an external execution system such as a warehouse management system (WMS) or third-party logistics provider (3PL), and if there’s a need to reconcile on-hand inventory balances between systems. This process is especially useful when discrepancies arise due to transaction timing differences, integration failures, or synchronization issues that can affect planning, fulfillment, and inventory accuracy.
The process enables you to export current on-hand balances, including serial numbers, in a standardized flat file format, making it easier to compare and reconcile inventory data across Oracle Inventory Management and external systems.
Privileges Required
- Publish Inventory On-Hand Balances to External Systems (INV_PUBLISH_ONHAND_TO_EXT_SYSTEMS_PRIV)
Specifications
| Specification | Description |
|---|---|
| Job Type | Ad hoc job Scheduled |
| Frequency | Run the scheduled process as needed based on the frequency of reconciliation required with the external system. This can be on demand depending on business operations and transaction volume. |
| Time of Day | Typically scheduled during nonpeak business hours or after major transaction processing windows to minimize performance impact and ensure the latest inventory transactions are captured. |
| Duration | The process duration depends on the volume of on-hand inventory records, serial-controlled items, and organizations being processed. Larger inventory volumes may require additional processing time. |
| Compatibility | There should be only one instance of the job running at any time, and there’s no current functional need to run multiple instances of this process simultaneously. |
Parameters
| Parameter | Optional or Required | Description | Parameter Values | Special Combinations Required | Notes |
|---|---|---|---|---|---|
| External System | Required | Select the external system to which the on-hand balances will be sent. | External system name | None | Use the ORA_INV_BALANCES_INV_EXTERNAL lookup to define external
system details. Once configured, the external system names will
appear in the External System parameter list within the scheduled
process job. Oracle WMS is provided as a default (seeded) external system. When adding a new external system, use numeric values only (for example, 1, 2) as the lookup code. The value must be greater than zero (0) because zero (0) is reserved for Oracle WMS. |
| Organization | Required | Select the organization for which the on-hand balance snapshot needs to be generated. |
Inventory organization |
None | N/A |
| Publish from Date | Optional | Specifies the date from which on-hand balances will be considered. Use this field to include data from a period prior to the last successful publication date. | Date | None | N/A |
| Items to Publish | Required | Select the type of inventory items to include. |
Not Serial Controlled Items Serial Controlled Items Both |
None |
Not Serial Controlled Items - Includes all items except serial-controlled items. Serial Controlled Items - Includes only serial-controlled items. Both - Includes all items (both serial and not serial controlled). |
| Full Publish | Required | Enter Yes or No to indicate whether to publish all records regardless of the Publish-from Date. | Yes No |
None | Yes: Publishes all records regardless of the Publish from
Date. No: Publishes only the changes in item balances since the last successful publication. |
Troubleshooting Information
- You can monitor the status of the process in the Scheduled Processes work area.
- Any validation errors or warning messages that prevent successful completion of the process are captured and displayed in the error log.
- After submitting the process, you can perform actions such as Resubmit, Put on Hold, Cancel Process, and Release Process using the Scheduled Processes work area.
- If the process performance is slower than expected or the job isn’t completing, review these key factors: inventory data volume, date range selected, and the type of items being processed.