Inconsistent Row Fetch For Cursor C_system_variables In LIKESTORE.pc (Doc ID 1960409.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

In RMS 13.2.5, incorrect coding in likestore.pc while fetching the system variables is picking wrong values.

Details:

The cursor c_system_variables in likestore.pc program looks like this:

The fetch is fetching less number of rows. i.e. VAT_IND is missing in the fetch, will this result VAT_IND being fetched into ps_std_av_ind and STD_AV_IND could get fetched into ps_rpm_ind.

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