ORA-01722 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL Error During Statement Preparation (Doc ID 1453152.1)

Last updated on DECEMBER 24, 2015

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 29-Sep-2013***

Symptoms

With the Sysadmin user navigate:

Integrated SOA Gateway -> Administration -> SOA Monitor

The following Error is reflected:

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (SELECT REQUEST_TIMESTAMP AS REQDATETIME,
      REQUEST_COMPLETED AS RESDATETIME,
      WRQ.IREP_NAME AS WEB_SERVICE_NAME,
      FIC.CLASS_ID as CLASS_ID,
      METHOD AS METHOD_NAME,
      USER_NAME,
      WRQ.USER_ID,
      IP_ADDRESS,
      REQUEST_STATUS as REQUEST_STATUS,
      RESPONSE_STATUS as RESPONSE_STATUS,
      MESSAGE_ID,
      REQUEST_PATTERN,
      (select meaning from fnd_lookup_values_vl
where lookup_type = 'FND_SOA_RESPONSE_STATUS'
and lookup_code=WRQ.RESPONSE_STATUS) as res_status,
(select meaning from fnd_lookup_values_vl
where lookup_type = 'FND_SOA_REQUEST_STATUS'
and lookup_code=WRQ.REQUEST_STATUS) as req_status,
(select meaning from fnd_lookup_values_vl
where lookup_type = 'FND_SOA_MESSAGE_PATTERN'
and lookup_code=WRQ.REQUEST_PATTERN) as interaction_architecture,
(select decode(count(*), 0, 'LOG_ABSENT', 'LOG_PRESENT') from fnd_log_messages
where transaction_context_id in
(select transaction_context_id from fnd_log_transaction_context
where transaction_type='SOA_INSTANCE' and
transaction_id =  WRQ.MESSAGE_ID)) as ENABLE_LOG
FROM FND_SOA_REQUEST WRQ,
     FND_USER FU,
     FND_IREP_CLASSES FIC
WHERE WRQ.USER_ID = FU.USER_ID(+)
AND FIC.IREP_NAME = WRQ.IREP_NAME
AND FIC.CLASS_TYPE NOT IN ('SOAPSERVICEDOC', 'WEBSERVICEDOC')) QRSLT  WHERE (( ( TO_DATE(TO_CHAR(REQDATETIME,'dd-mm-yyyy'),'dd-mm-yyyy')) >=trunc(SYSDATE-7))) ORDER BY REQDATETIME DESC

Changes

 Apply R12.1.3

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