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?


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