My Oracle Support Banner

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 AUGUST 25, 2021

Applies to:

Oracle Sourcing - Version 12.2.5 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.