My Oracle Support Banner

How to Display Dependent Designation Data in View or Table (BEN_CVRD_DPNT_CTFN_PRVDD_F) (Doc ID 2368222.1)

Last updated on JULY 18, 2022

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!

In this Document

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