Inventory Transactions Integrator Limitations
While the Inventory Transactions Integrator provides robust bulk-management capabilities for Oracle ERP Cloud inventory movements, its functionality is governed by the underlying Oracle REST Web Services. Users should be aware of the following constraints when working with this Integrator.
General Limitations
-
The Organization attribute is a mandatory filter requirement for the Oracle REST Web Service and must be provided for all Create, Update, Delete, and Download operations.
-
Only transactions that have not yet been processed by Oracle ERP Cloud can be updated or deleted. Processed transactions that have updated inventory balances are considered final and cannot be modified or removed through this Integrator.
-
Descriptive Flexfields (DFFs) associated with inventory transactions may have context-sensitive segments. Not all DFF configurations are guaranteed to be supported in all environments.
-
The volume of records returned in a single download is subject to the Oracle REST Web Service pagination limits. Very large datasets may need to be retrieved using multiple downloads with more specific filter criteria.
Known Specific Limitations
The following limitations relate to specific fields and behaviours within the Integrator. These are driven by constraints in the Oracle REST Web Services and will be addressed in future releases.
Use Current Cost Flag
The integrator supports both Yes and No values for the Use Current Cost Flag. When set to No, users must populate the Transaction Cost Identifier, Cost Component Code, and Unit Cost columns to provide manual cost details. See the Unit Cost section for full details. Additionally, the Completed Transactions Oracle REST Web Service does not currently return the Use Current Cost Flag in its response payload, therefore this field will not be populated when downloading from the Completed Transactions source.No value will be introduced in a coming release. Additionally, the Completed Transactions web service does not return the Use Current Cost Flag in its response payload, therefore this field will not be populated when downloading from the Completed Transactions source.
Use Current Cost Flag — Update Limitation
When performing an Update operation on a transaction that includes a manual cost (Use Current Cost Flag set to No), changing the Cost Component Code or the unit cost value will result in the following error:
"Too many objects match the primary key oracle.jbo.Key[FUSION {TransactionCostIdentifier} {CostComponentCode} -2 C]. Error Code: 25013"
This error occurs because the Oracle REST Web Service identifies cost records by a composite primary key consisting of the Transaction Cost Identifier and the Cost Component Code. When an update is attempted using the same Transaction Cost Identifier but with a different Cost Component Code, Oracle interprets this as a duplicate key conflict rather than an update to the existing record.
This is a known Oracle REST Web Service limitation. As a workaround, clear the Transaction Cost Identifier value on the row before performing the update. The integrator will generate a new unique Transaction Cost Identifier for the updated cost record, which allows the update to proceed without conflict.
Inventory Organization Name for Interface Transaction Downloads
The Oracle REST Web Services for the Interface Transactions do not return the Inventory Organization Code in their response payload — they return the Organization Name only. To mitigate this, the Integrator includes an Inventory Organization Name column on the sheet. When a download is performed using this source, the Organization Code will be automatically defaulted from the corresponding Organization Name.
Transaction Descriptive Flexfields (DFFs)
For Descriptive Flexfield (DFF) values to be processed correctly, the DFF segment configuration on the Interface transaction must match the DFF segment configuration on the base transaction table. If the interface DFF settings and the base DFF settings are mismatched, DFF values may not be transferred or may be mapped to the wrong segments during processing. Ensure your Oracle DFF setup is consistent across both layers before using DFF columns in the Integrator.
Transaction Source Code, Source Line ID, and Source Header ID Not Returned by Completed Transactions
The Completed Transactions Oracle REST Web Service does not currently return the Transaction Source Code, Source Line ID, or Source Header ID in its response payload. As a result, these fields will appear blank when downloading data from the Completed Transactions source.
Lot and Serial Controlled Items
The Integrator does not currently support items that are both lot‑controlled and serial‑controlled. This capability will be included in a future release.
Serial Number Cannot Be Updated on a Pending Transaction
Serial numbers assigned to a pending interface transaction cannot be modified after the transaction has been created. This is because the serial number is used as the key identifier to locate the individual serial record in the Oracle interface table
If a serial number was entered incorrectly on a pending transaction, the following steps must be taken:
-
Use the Delete function to remove the incorrect transaction from the interface table.
-
Use the Create function to re-enter the transaction with the correct serial number.
This limitation applies to all serial-controlled transaction types supported by this Integrator, including Miscellaneous Receipt, Miscellaneous Issue, and Project Material Issue where the item is serial-controlled. This is not a More4apps limitation — it is a constraint of the Oracle inventoryStagedTransactions REST Web Service, which does not expose an update operation for serial number values on the serial child resource (/child/serials).
Lot Number Cannot Be Updated on a Pending Transaction
Lot numbers assigned to a pending interface transaction cannot be modified after the transaction has been created. This is because the lot number is used as the key identifier to locate the corresponding lot record in the Oracle interface table, and the Integrator—when using the nested API to perform updates—cannot locate a modified lot number. This limitation will be addressed in a future release.
Download Record Limit — Interface Transactions
The Oracle REST Web Service for Interface Transactions (inventoryStagedTransactions) enforces a maximum page size of 500 records per call. This limit is imposed by Oracle at the endpoint level and cannot be increased by setting the limit parameter above 500. As a result, the download process can retrieve only up to 500 records per request. This is an Oracle‑known limitation and will be resolved once Oracle updates the web service in a future release
Expected Receipt Date Not Available for Download
The Expected Receipt Date field is not currently returned by either the Interface Transactions or Completed Transactions Oracle REST Web Services. As a result, this field will not be populated when downloading from either source. This is a known Oracle Web Service limitation. The integrator will be updated to include this field once Oracle makes it available in a future release.
Intransit Shipment
Transaction Quantity must be entered as a negative value (e.g. -2). The Oracle REST Web Service requires a negative quantity for Intransit Shipment transactions — a positive value will be rejected with an error.
Shipment Number — Manual Entry Only
The Shipment Number field for Intransit Shipment transactions currently supports manual entry only. There is no Oracle REST Web Service available to generate the next shipment number automatically, so users must supply their own unique value.
This limitation will be resolved once Oracle provides a shipment number generation endpoint in a future release. At that point the integrator will be updated to support automatic generation.
Future Enhancements
The limitations listed in this document will be reviewed and addressed over time as Oracle improves the underlying REST Web Services and as More4apps introduces additional features to this Integrator. For the latest information on enhancements and fixes, refer to the More4apps Release Notes.
If you encounter issues not listed here, or have enhancement suggestions, please contact More4apps support at the community portal.