My Oracle Support Banner

Abstract Forms Giving Ambiguous Error When Adding New Attribute (Doc ID 2515152.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Sourcing - Version 12.2.7 and later
Information in this document applies to any platform.


On : 12.2.7 version,

When Pre Bid-Proposal Date and Time is checked to Display on the Main Page of the Abstract Form, then navigating to the Active Negotiations,
the following error occurs.

If choose Status All, no errors.


oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM ( select PAHA.auction_header_id AS AUCTION_HEADER_ID
, decode(nvl(PAHA.award_status, 'NO'), 'NO', 'NO', 'AWARDED') AS AWARD_STATUS

ORA-00918: column ambiguously defined
00918. 00000 -  "column ambiguously defined"
Error at Line: 1 Column: 8

The issue can be reproduced at will with the following steps:
1. Configure Abstract and Forms
2. Add new attributes/columns
3. Go to the page
4. Choose status: Active


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.