Customer Form Error: Clicking on Party Name After Running a Search Raises Error: JBO-27122: SQL error during statement preparation (Doc ID 1504933.1)

Last updated on APRIL 06, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In Release 12.1.3, when navigating to customer form:

Responsibility: Receivables Manager
Navigation: Customers > Customers

  1. Query a Customer
  2. Click on the Customer(Party Name) and the following error occurs:

 

Exception Details.

 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.

Error Page  
Exception Details.  
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error

during statement preparation.  Statement: SELECT * FROM (select * from (
select cc.class_category, l.meaning
from   hz_class_categories cc,
      fnd_lookup_types_vl l
where  cc.class_category = l.lookup_type
and    l.view_application_id = 222
and    exists (
        select null
        from   hz_code_assignments ca
        where  ca.owner_table_name = 'HZ_CLASS_CATEGORIES'
        and    ca.owner_table_id is null
        and    ca.owner_table_key_1 = cc.class_category
        and    ca.class_category = 'CLASS_CATEGORY_GROUP'
        and    ca.class_code = :1
        and    nvl(ca.status, 'A') = 'A'
        and    sysdate between ca.start_date_active and nvl(ca.end_date_active, sysdate+1))
union all
select cc.class_category, l.meaning
from   hz_class_categories cc,
      fnd_lookup_types_vl l
where  cc.class_category = l.lookup_type
and    l.view_application_id = 222
and    'INDUSTRIAL_GROUP' <> :2
and    not exists (
        select null
        from   hz_code_assignments ca
        where  ca.owner_table_name = 'HZ_CLASS_CATEGORIES'
        and    ca.owner_table_id is null
        and    ca.OWNER_TABLE_KEY_1 = cc.class_category
        and    ca.class_category = 'CLASS_CATEGORY_GROUP'
        and    nvl(ca.status, 'A') = 'A'
        and    sysdate between ca.start_date_active and nvl(ca.end_date_active, sysdate+1))  
and    hz_classification_v2pub.is_valid_category('HZ_PARTIES', cc.class_category, :3) = 'T' ) a
where exists (select null
from hz_class_code_denorm
where class_category = a.class_category
and trunc(sysdate) between nvl(start_date_active,trunc(sysdate)) and
nvl(end_date_active,trunc(sysdate))
and enabled_flag = 'Y'
and LANGUAGE = userenv('LANG'))) QRSLT  ORDER BY meaning
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException

..

...

## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms