Technology Stack - EBS (MOSC)

MOSC Banner

Error while updating SQL Statement in OAF View Object Extension

Hello Every One ,

I am trying to extend a VO while adding a column to the SQL statement facing the below error

Illegal name . It is either a reserved word or object of given name already exists.

Due to this the new column is not appearing in Attribute mapping section.

Based on my check i found the error is happening due to constant values in select statement .

There are 5 constant value like below

Select 'ChgQtyType',

     'ChgPriceType',

     'ChgPrmDateType',

      'ChgAmntType',

      'ShipStatusType',

      'DispStatus',

FROM ....

when commented above values in select statement the error is not appearing and the new column is shown in attribute mapping window

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center