G-Invoicing Error When Entering Unit of Measure (UOM) For a New Line After the First Line or Schedule in SFO (Seller Facilitated Order): 'java.sql.SQLException: Invalid column type'
(Doc ID 2987981.1)
Last updated on NOVEMBER 21, 2023
Applies to:
Oracle Project Billing - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
When entering UOM and adding a new line to a SFO with lines and schedule, an error occurs:
Error- You have encountered an unexpected error. Please contact your system administrato
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select meaning,lookup_code code
from pa_lookups
where lookup_type= :1
AND enabled_flag='Y'
AND sysdate between start_date_active and nvl(end_date_active,sysdate)) QRSLT WHERE (length(code) <= 3 AND ( UPPER(MEANING) like UPPER(:2) AND (MEANING like :3 OR MEANING like :4 OR MEANING like :5 OR MEANING like :6)))
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:836)
.
.
.
## Detail 0 ##
java.sql.SQLException: Invalid column type
Reproduce By Steps
Using G-Invoicing responsibility:
1. Create SFO
2. Add header details
3. Add 1st Line with UOM: EA
4. Add 1st Schedule to Line 1
5. Add 2nd Line with UOM and receive error
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 |