Relationship year to date balance Dimension displaying wrong Value
Summary:
We have our total Rewards Statement defined since 2023 and it has been working well when we used the Relationship Year to date dimension for Miscellaneous balances we created for the past two years and it was working correctly in our Total Rewards Statements all these years, however, only this year, the year to date dimension is not working expected. When I run the generate run balances flow, the relationship year to date dimension doesn't even show up in the parameters and it throws the error below:
"ORA-01403: no data found ORA-06512: at "FUSION.PAY_RUN_BALANCE_PKG", line 3491 ORA-06512: at line 1 https://docs.oracle.com/error-help/db/ora-01403/ 1 FThere was a ORA-01403: no data found ORA-06512: at "FUSION.PAY_RUN_BALANCE_PKG", line 3491 ORA-06512: at line 1 "