When Uploading Item From File, SVC_ITEM_SUPPLIER Records Are Not Processed In The Right Order
(Doc ID 2494737.1)
Last updated on MARCH 03, 2019
Applies to:Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.
When an user wants to update the primary supplier to a new one and delete the old supplier (item without any transactions) the induction should work, however induction is returning an error on the DEL record stating that supplier is primary while the MOD message to change that supplier to not primary should already have been processed.
Process_IS function of package CORESVC_ITEM should order the records also by row_seq, not only by item.
The issue can be reproduced at will with the following steps:
- Having an Item with two Suppliers
Supplier A (Primary = Y)
Supplier B (Primary = N)
- Upload induction with first record as a Mod (to make of Supplier B primary) and second record as a DEL of Supplier A
- Upload fails assuming you are deleting Supplier A while its primary
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