Download Inventory Transactions

The Inventory Transactions Integrator provides four distinct download sources, each retrieving a different set of data from Oracle ERP Cloud. Select the appropriate download source based on the information you need to review, analyse, or use as the basis for an update or delete operation.

To perform a download, navigate to the Download icon of the Integrator in the More4apps ribbon, select your desired download source, enter the applicable filter criteria, and click Download. Results are populated directly into the Excel sheet.

How to Download

Navigate to the Download icon of the Inventory Transactions Integrator in the More4apps ribbon.

Download via Form

This method allows you to search for values directly within the form. If you’re uncertain of the entire value, use the wildcard symbol '%' to represent unknown characters in your search. Follow these steps:

Open the Data Form.
Use the search function to input the values you’re looking for. Remember, you can use the wildcard symbol '%' to substitute for unknown parts of the value.
Once you’ve found the desired values, select 'Download'. The Sales Orders will be downloaded based on your search criteria.

Download via Sheet

In this method, the values you input on the sheet serve as search parameters. Remember, only the columns marked with a triangle symbol can be used as search filters. If you’re unsure of the entire value, use the wildcard symbol '%'. Follow these steps:

Open the Sheet and input your desired search parameters into the columns that have a triangle symbol. Use the wildcard '%' to substitute for unknown parts of the value.
Once you’ve filled in the required search parameters, select 'Download'. The assignments will be downloaded based on the data you have input.

Download Sources

Download Source 1: Interface Transactions

This download retrieves transactions that currently exist in the Oracle Inventory Transaction Interface (INV_TRANSACTIONS_INTERFACE). These are transactions that have been created but not yet processed and posted to inventory by Oracle. Use this source to review, modify, or delete pending transactions before they are processed.

Available Filter Criteria:

Filter Field

Required

Description

Inventory Organization

Yes

The name of the Inventory Organization. Note: the Oracle REST Web Service for interface transactions filters by organization name, not organization code.

Interface Transaction ID

The interface transaction ID is returned after a successful upload. You can use this ID to download and retrieve the corresponding record.

Transaction Type

Filter by one of the seven supported transaction types to narrow the results returned.

Item Number

Filter transactions for a specific inventory item.

Subinventory

Filter by a specific source or destination subinventory.

Transaction Date From

Return interface transactions with a transaction date on or after this date.

Transaction Date To

Return interface transactions with a transaction date on or before this date.

Reason

Filter by a specific transaction reason code assigned to the interface transaction.

Note: Interface transactions downloaded from this source are in a pending state and are eligible for Update and Delete operations using this integrator. Large downloads may take additional time depending on the volume of transactions in Oracle ERP Cloud. It is recommended to use date range filters and specific transaction type filters to limit the number of records returned and improve download performance.

Download Source 2: Completed Transactions

This download retrieves transactions that have been fully processed by Oracle and posted to the base inventory transaction history tables (INV_MATERIAL_TRANSACTIONS). These transactions have already updated inventory balances and are considered final. Use this source for reporting, audit, and reconciliation purposes.

Available Filter Criteria:

Filter Field

Required

Description

Inventory Organization

Yes

Filter by the name of the Inventory Organization Name.

Inventory Code

Yes

Filter by the Inventory Organization Code. Note:

Transaction Type

Filter by one of the seven supported transaction types to narrow the results returned.

Item Number

Filter transactions for a specific inventory item.

Subinventory

Filter by a specific source or destination subinventory.

Transaction Date From

Return interface transactions with a transaction date on or after this date.

Transaction Date To

Return interface transactions with a transaction date on or before this date.

Reason

Filter by a specific transaction reason code assigned to the interface transaction.

Note: Completed transactions have already updated inventory balances and cannot be updated or deleted through this integrator. This source is intended for reference and audit purposes only. Large downloads may take additional time depending on the volume of transactions in Oracle ERP Cloud. It is recommended to use date range filters and specific transaction type filters to limit the number of records returned and improve download performance.

Download Source 3: On-Hand Subinventory Level

This download retrieves the current on-hand inventory quantities summarised at the Subinventory level. For each item in the specified Organization, a single consolidated quantity is returned representing the total on-hand stock across all subinventories and locators. Use this source for a high-level inventory position review.

Filter Field

Required

Description

Organization

Yes

The Inventory Organization is mandatory. On-hand quantities are returned for all items within this organization.

Item Number

Yes

Restrict results to a specific item number assigned to the organization.

Subinventory

Limit results to on-hand quantities held within a specific subinventory.

Note: On-hand quantities returned by this source are read-only and are for reference purposes. On-hand balances cannot be directly updated or deleted through the Inventory Transactions Integrator; they are maintained by the processing of transactions.

Read-Only Columns Returned

The following quantity columns are returned by this download source 3. All columns are read-only and cannot be edited in the sheet.

Column

Description

On-Hand Quantity

The total quantity of the item physically in stock within the organization in the primary unit of measure. This is the sum of all on-hand quantity across all subinventories for the item.

Reserved Quantity

The quantity of the item that has been reserved against an existing demand, such as a sales order, account alias, or other reservation source. This quantity is committed and cannot be used for other transactions until the reservation is fulfilled or released.

Available to Reserve (ATR)

The quantity of the item that is available to be reserved for new demand. Calculated as On-Hand Quantity minus Reserved Quantity. Only stock held in reservable subinventories is included in this figure.

Available to Transact (ATT)

The quantity of the item that can be physically issued or transacted right now. This is the most restrictive availability figure — it excludes reserved quantity and any quantity held in non-nettable or non-transactable subinventories.

Total Org-Level On-Hand Quantity

The consolidated on-hand quantity for the item across the entire organization, regardless of subinventory or locator. This represents the grand total of stock held at the organization level and is useful for high-level inventory position reporting. Because it is an aggregated total, the same value may appear repeatedly on multiple rows.

Note: All columns in this section are read-only. The quantity figures are calculated and maintained by Oracle ERP Cloud and reflect the current state of inventory at the time of download. Reserved Quantity and Total Org-Level On-Hand Quantity are available on this source only.