My Oracle Support Banner

Contact DBI's Not Return The Correct Value (Doc ID 2593906.1)

Last updated on SEPTEMBER 15, 2020

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Goal

We used Contact DBI's 'PER_EXT_CONT_CONTACT_TYPE' and 'PER_PER_CONTACT_DATE_OF_BIRTH' in custom formula, but unfortunately its not working fine for some employees, it's returning the type of the first contact but the Birth date of the second contact and for the second contact its return the Birth date for the first Contact.
Ex: Contact No.1 Type: Son BD: 11-Jun-2015
Contact No.2 Type: Spouse BD: 01-Jan-1981
the formula return Type: Son and BD: 01-Jan-1981 and Type: Spouse BD: 11-Jun-2015, which is wrong.
 

Solution

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
Goal
Solution


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