"ORA-00907: Missing Right Parenthesis Returned By Program Unit PCHISTMGN_SQL.GET_INFO" Error On RMS Price and Margin History Screen (Doc ID 2152479.1)

Last updated on APRIL 03, 2017

Applies to:

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

Symptoms

Price and Margin History [pchistmgn] screen throws the following error after search criteria is entered:

 
Steps to Reproduce:

  1. Define search criteria such as from date and to date, group type and item on the Price and Margin History screen and hit search.
  2. Note that screen throws this error and no data is returned.

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