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.


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.




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.