My Oracle Support Banner

When Uploading Item From File, SVC_ITEM_SUPPLIER Records Are Not Processed In The Right Order (Doc ID 2494737.1)

Last updated on NOVEMBER 23, 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:

  1. Having an Item with two Suppliers
    Supplier A  (Primary = Y)
    Supplier B  (Primary = N)
  2. Upload induction with first record as a Mod (to make of Supplier B primary) and second record as a DEL of Supplier A
  3. 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.