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.