PER_DATE_OF_BIRTH Database Item Does Not Work When Query On Accrual Balance In Self Service (Doc ID 432594.1)

Symptoms

-- Problem Statement:
When attempting to When trying to request the current accrual balance for an employee (using ESS/MSS), an error message is shown when clicking the Entitlement balances tab (Manager Self-Service > Absence Management > Entitlement Balances):

You have encountered an unexpected error. Please contact the System Administrator for assistance.

the following error occurs:

Cause: A SQL SELECT statement, obtained from the application dictionary, returned no rows
when executed.

Action: Please refer to your local support representative.
ORA-06512: at "APPS.PER_FORMULA_FUNCTIONS", line 608
ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 70
ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 129
ORA-06512: at "APPS.PER_ACCRUAL_CALC_FUNCTIONS", line 808
ORA-06512: at "APPS.PER_DISPLAY_ACCRUAL_BALANCE", line 162
ORA-06512: at line 2


-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1) Create an accrual plan according to <note 302584.1>, with the following differences:

In the accrual form:
- Payroll Balance Reset Date: Other, assignment year to date instead of 1 june
- Accrual Category: Classification: Balances (earnings not in LOV!)
- Accrual units: Hours (Recurring not in LOV!)
- Formulas: custom formulas (validated, compiled and working as intended)

Furthermore, when attaching to the assignment, <note 302584.1> claims that an element is created by
the name of <Accrualplan> Plan (3rd line from the bottom). I don't recall this ever to have
happened. Clearly, I have not created an element link for this non-existing element.

2) Navigate to Manager Self-Service > Absence Management > Entitlement Balances

Cause

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