Update Limitations

Update and Create in the same Upload

Oracle’s web service has a bug where if more than one item is being uploaded in a single upload it will error when the first item in the upload is an update transaction and any subsequent items in the upload are a create transaction. In this situation, we have configured the Integrator to display the following message:

No upload has been performed for the selected range/sheet due to validation errors or missing Upload Action(s). Please provide a valid value or section upload Action(s)

Possible workarounds:

  • It is possible to use the Excel Sort function on the Header section ‘Upload Action’ field to sort the create transaction above the update transactions.

  • Consider separate worksheets for the create transactions and update transactions.

Update Item EFFs

The fields ‘Item EFF Context Status’ and ‘Item EFF Attribute Status’ will remain in a validated state even after a successful upload.

Only item-level EFFs are supported. The solution does not support EFFs at the item revision or item supplier levels.

The Integrator does not indicate which fields are non-updatable; if values are provided for these fields, the upload will succeed but the changes will not be applied.