How to Display Dependent Designation Data in View or Table (BEN_CVRD_DPNT_CTFN_PRVDD_F)
(Doc ID 2368222.1)
Last updated on MARCH 01, 2018
Applies to:Oracle Advanced Benefits - Version 12.1.3 and later
Information in this document applies to any platform.
Customer is using HRMS Manager and navigating to the Non-Flex form.
From there, dependents can be seen via the 'Designee' button.
On the Dependent/Beneficiary Designation form, go to 'Help > Diagnostics > Examine' and look at the last query, there is a view (BEN_CVRD_DPNT_CTFN_PRVDD_V).
When queried, no data is returned from the view - even with a 'select * from'.
When searching for the underlying table (BEN_CVRD_DPNT_CTFN_PRVDD_F), zero rows return.
Customer needs this data for a reporting requirement.
Is there any reason why no data is displayed, or is there another view/table that can be used?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!