Performance Issue With RMS-AIP Interface Script RMSE_AIP_FUTURE_DELIVERY_TSF.KSH

(Doc ID 2168158.1)

Last updated on APRIL 04, 2017

Applies to:

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

Symptoms

RMS-AIP (Retail Merchandising System - Retail Advanced Inventory Planning) interface script: rmse_aip_future_delivery_tsf.ksh runs longer than expected even with a normal volume of data.


Steps to Reproduce:

  1. Run the rmse_aip_future_delivery_tsf.ksh script.
  2. Note that it is fetching duplicate records by picking up the non primary suppliers due to a missing join.

Changes

 

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