My Oracle Support Banner

"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 FEBRUARY 27, 2019

Applies to:

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


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.


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.