Order HTS Item Updates Failing On Upload
(Doc ID 2664019.1)
Last updated on APRIL 28, 2020
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.
Order HTS Item updates failing on upload with locking error.
- Prepare a template for Order upload with only the 2 sheets ORDHEAD and ORDSKU_HTS
1- Create Multiple POs 5 items each all items do not have HTS attached.
2- Attach HTS to PO items, and make sure the assessment is calculated correctly in ITEM_HTS_ASSESS table
3- Create an ODS sheet based on the template above to update HTS for the order details (ORDSKU_HTS)
4- Upload the sheet to RMS
Upload fails with error like:
Table ORDSKU with key values of <ORDER_NO>, %s3 is locked by another user.
And upload only updates a few of the orders not all.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document