Adding Description Field In RFQ Abstract Page Error: ORA-01747: invalid user.table.column, table.column, or column
(Doc ID 2801854.1)
Last updated on MARCH 15, 2022
Applies to:
Oracle Sourcing - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
When attempting to add the Description field to RFQ (Request For Quotation) Abstract page,
the following error occurs.
ERROR
-----------------------
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during
statement preparation. Statement: select PAHA.auction_header_id AS AUCTION_HEADER_ID
, NEGOTIATION_STATUS
.
.
.
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column
specification
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use Sourcing Super User responsibility, under Administration -> Abstract and Forms,
update Abstract.
2. For Description field, check the “Active” and “Display on Main Page” checkboxes.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |