R13 20A HSDL Person Benefit Groups--obtain or query existing records loaded previously in order to end date records (Doc ID 2672088.1)

Last updated on JUNE 10, 2022

Applies to:

Symptoms

On : 11.13.20.01.0 version, Data Load

ACTUAL BEHAVIOR
---------------
After opening HSDL Person Benefit Group Spreadsheet Template, able to create a new Dataset, but when searching for an existing Dataset--the value appears, but when selecting All Record option and clicking on Search, no records appear in the search results. This issue occurs when Datasets were created after 30 days or more. Able to search for Datasets which were created within 30 days.

Able to access existing records via Benefits spreadsheet templates, and able to search for Benefit Group Name. Copied and pasted records into HSDL Person Benefit Group Spreadsheet Template, in which she can update the existing records by including an end date. Wondering how long the Benefit spreadsheet templates will be available for use. Inquired about an SQL query to find existing records, if needed

EXPECTED BEHAVIOR
-----------------------
If Dataset is returned in drop-down LOV for search, the associated records should be returned.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open existing HSDL Person Benefit Group Spreadsheet Template
2. Create a new Dataset button
3. Click on prior Dataset from drop-down LOV Data Set Name in Search area, and select All Records for Search Mode
4. Observe that no records are returned

a. if Datatset was created after 30 days. Last year was able to search for Datasets which were a year old or so
b. If Dataset was created wihtin 30 days, the expected records are populated

5. due to issue,

a. open Benefits-related spreadsheets, and query for existing records associated with Benefit Group Name
b. copy records, and paste within HSDL Person Benefit Group Spreadsheet Template, and make changes

Cause

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