How to Display Dependent Designation Data in View or Table (BEN_CVRD_DPNT_CTFN_PRVDD_F)
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
Million Knowledge Articles and hundreds of Community platforms