My Oracle Support Banner

OIPA REST Client Brings Back Incorrect Data (Doc ID 3048952.1)

Last updated on OCTOBER 02, 2024

Applies to:

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

Symptoms

Description
==========
For the GET specific client - /PASService/rest/services/clients/<Client GUID> the UpdatedGMT column is returned as null. For example, the following is returned:

  "dateOfBirth": "2000-01-10T00:00:00Z",
  "dateOfDeath": null,
  "updatedGmt": null,

However, when the database is queried there is a value. When you use the following: SELECT * FROM AsClient WHERE ClientGuid = '<Client Guid>'; You will see something like the following information in the database:

DATEOFBIRTH - 10-JAN-00 12.00.00.000000000 AM
DATEOFDEATH - (null)
UPDATEDGMT - 29-SEP-23 08.32.03.291000000 PM


Details
==========
Incorrect details returned in REST call

Expected Behavior
==========
All fields from database should be returned correctly

Steps To Reproduce
==========
Perform GET against a client


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.