When an Item Cost is Updated In Backoffice , the Supplier ID Linked to that Item is Defaulted to 0 (Doc ID 2097918.1)

Last updated on MAY 03, 2016

Applies to:

Oracle Retail Back Office - Version 14.0 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail back Office (ORBO),  cost of an item that has Supplier ID other than 0 (default) gets modified, a new record with Supplier ID = 0 is inserted/updated in CO_BRK_SPR_ITM_BS table.

Steps To Reproduce:

1. Perform an Item Import along with Supplier (Different than default id(0)) information (Ex: ID_ITM = 9696 and ID_SPR = 0003).
2. Once DIMP is completed, verify following tables to confirm the item is inserted correctly.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms