My Oracle Support Banner

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 later
Information in this document applies to any platform.


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(


## 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




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.