My Oracle Support Banner

CREATE_ORD_TSF_SQL Create Incorrect Message When Cost Can Not Find For An Item. (Doc ID 2240950.1)

Last updated on MARCH 10, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.1.9 and later
Information in this document applies to any platform.

Symptoms

CREATE_ORD_TSF_SQL Package create incorrect error message when cost can not find for an item.

when processing an "inv_req" message when the supplier cost is not found for an item is reversed.
The message displayed has the item and the supplier reversed.


Steps to reproduce:

  1. Create item request in Oracle Retail Store Inventory Management(SIM) for item that does not have a supplier cost assigned
  2. Submit request
  3. RIB message failing with below error:
    No Item/Supplier/Origin Country/Location records exist for Item %s1, Supplier %s2.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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