Inquiry Screen System Errors (Doc ID 2887797.1)

Last updated on AUGUST 08, 2022

Applies to:

Symptoms

On : 11.3.1.11 version, General

ACTUAL BEHAVIOR
---------------
Following an upgrade to OIPA V11.3.1.10/V11.3.1.11, users have encountered system errors on a number of Inquiry Screens.


ERROR
-----------
java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.9.WAS-v20211116-c34c592f4a): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=WHERE;sActivity.StatusCode;), DRIVER=4.24.92
Error Code: -104
Call: SELECT COUNT(1) FROM ( AsTransaction JOIN AsActivity ON AsActivity.TransactionGUID = AsTransaction.TransactionGUID JOIN AsPolicy ON AsPolicy.PolicyGUID = AsActivity.PolicyGUID JOIN AsCode ON AsCode.CodeValue = AsActivity.StatusCode WHERE AsTransaction.TransactionGUID = ? AND AsCode.CodeName = 'AsCodeStatus' AND CAST((AsActivity.EffectiveDate) AS DATE) >= CAST(? AS DATE) AND CAST((AsActivity.EffectiveDate) AS DATE) <= CAST(? AS DATE) AND AsActivity.StatusCode in ('01','02','09','13','14') AND AsActivity.TypeCode In ('01','04') ) A
bind => ########, 2022-05-26, 2022-05-26]
Query: DataReadQuery(sql="SELECT COUNT(1) FROM ( AsTransaction JOIN AsActivity ON AsActivity.TransactionGUID = AsTransaction.TransactionGUID JOIN AsPolicy ON AsPolicy.PolicyGUID = AsActivity.PolicyGUID JOIN AsCode ON AsCode.CodeValue = AsActivity.StatusCode WHERE AsTransaction.TransactionGUID = ? AND AsCode.CodeName = 'AsCodeStatus' AND CAST((AsActivity.EffectiveDate) AS DATE) >= CAST(? AS DATE) AND CAST((AsActivity.EffectiveDate) AS DATE) <= CAST(? AS DATE) AND AsActivity.StatusCode in ('01','02','09','13','14') AND AsActivity.TypeCode In ('01','04') ) A")
at com.adminserver.pas.uip.aspects.UipExtensibilityAspect.extendUipMethod(UipExtensibilityAspect.java:65)
at com.adminserver.pas.uip.InquiryScreenUip.processLoadTotalResult(InquiryScreenUip.java:605)
at com.oracle.pas.page.InquiryScreenPage.processLoadTotalResult(InquiryScreenPage.java:125)
at com.oracle.pas.service.delegate.InquiryScreenServiceDelegate.processLoadTotalResult(InquiryScreenServiceDelegate.java:143)
at com.oracle.pas.service.InquiryScreenService.processLoadTotalResult(InquiryScreenService.java:68)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:508)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to OIPA Application.
2. Navigate Company Level Inquiry Screens.
3. Select Inquiry Screen Name = Activity Report
4. Enter any valid Date for Start Date and End Date.
5. Choose any item for Activity To Report On.
6. Click OK
7. OIPA returns a System Error.

Cause

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