R12: 'POSYSTEMPARAMETEREO.GROUP_SHIPMENTS_FLAG: invalid identifier' Error When Trying To Open Purchasing Options Page (Doc ID 1576729.1)

Last updated on SEPTEMBER 06, 2013

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to open Purchasing Options page,the following error occurs.

Error

You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exceptions details

After pressing on the text link to get more information about the error next message can be seen on the details part:

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00904: "POSYSTEMPARAMETEREO"."GROUP_SHIPMENTS_FLAG": invalid identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
  ...

Steps to Reproduce

1. Go to Purchasing Responsibility > Setup > Organizations > Purchasing Options
2. Chose the Operating Unit and press on 'Go' button
3. Error occurs

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