My Oracle Support Banner

RETL Batches Rmse_rpas_store.ksh And Rmse_rpas_stock_on_hand.ksh Have Inconsistent Data Filters (Doc ID 2412862.1)

Last updated on MARCH 17, 2019

Applies to:

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

Symptoms

Oracle Retail Extract, Transform, and Load (RETL) batches have inconsistent data filters  in  rmse_rpas_store.ksh and rmse_rpas_stock_on_hand.ksh.
The closed stores are excluded by loc.csv.DAT(./rmse_rpas_store.ksh), whereas the Stock on hand(SOH) extract doesn’t exclude closed stores(./rmse_rpas_stock_on_hand.ksh).

This leads to failure in Oracle Retail Demand Forecasting(RDF), wherein the rows for closed stores in SOH file is error out.

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.