My Oracle Support Banner

SALESPROCESS.KSH Rejects Sales File Stating NO_RETAIL_ITEM Even Though ITEM_LOC has Retail. (Doc ID 2443788.1)

Last updated on SEPTEMBER 11, 2018

Applies to:

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


SALESPROCESS.KSH(Main Processing of Staged Sale/Return Transactions) job rejects the sales with with NO_RETAIL_ITEM error. When the same files are processed again the batch completes successfully without any issues.

Steps to reproduce:

1. Upload sales files. Note that the files are rejected with "NO_RETAIL_ITEM error. ITEM_LOC table has retail populated.
2.  Re-upload the files. Note that the files get uploaded successfully.


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.