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