My Oracle Support Banner

Using Fixed Fields With Suspense Screen Search (Doc ID 2732604.1)

Last updated on DECEMBER 02, 2020

Applies to:

Oracle Insurance Policy Administration J2EE - Version 11.2.0.23 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.23 version, General

ACTUAL BEHAVIOR
---------------
Issues with Suspense Screen Search.
When configuring a drop down of the Fixed Field Suspense Type the code is not populating the drop down in the screen.
The following fixed fields are not supported in the search code
- Check Number
- Created by User
- Suspense Type

1. Base code is not resolving SQL in case of Suspense Search screen Fixed Field(s). The Type Code field is being populated when it is moved to Fixed Field section.
2. When composing Suspense Search SQL, any field other than those listed below are considered as Dynamic Field. It’s for that reason Field TypeCode is considered as SuspenseField when composing the search SQL by the base code. Below list should be updated with TypeCode.


  EffectiveDate
  PolicyNumber
  LastName
  FirstName
  BankName
  BatchNumber
  SuspenseNumber
  Amount
  AttachedAmount
  EffectiveFromDate
  EffectiveToDate


EXPECTED BEHAVIOR
-----------------------
Business users need to be able to search on these fixed fields.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In Suspense search screen enter data in Check Number or Client Number or select value from drop down from Type Code.
2. These are fixed fields but being recognized as such. Click Search and nothing is returned even when values exist in the database.



Cause

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
Symptoms
Cause
Solution
References


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