OAAM Unable To View Customer Care Cases In Oarm after 10.1.4.5 Upgrade (Doc ID 1310537.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Adaptive Access Manager - Version 10.1.4.5 and later
Information in this document applies to any platform.

Symptoms

After OAAM Upgrade from 3.5.2 to 10.1.4.5 bp8. When attempted to view Customer Care cases, unable to see the actual cases. The counter can be seen on the caseList.jsp page, which indicates cases exists, and the cases exist in the V_CASE table in the database. When attempted to view the cases through the interface result is a blank page.

Changes

Check the following queries in upgraded 10.1.4.5 database

This is query for all number of cases

Select count (*) from v_case;



Specific conditions for case types

Select count (*) from v_case where case_type != 0;
Select count (*) from v_case where case_type = 0;


The exception occurs for all the cases with case_type = 0.
case_type zero is no longer valid, and should have been converted during the upgrade process.

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