Guidance on Override Translation Rule

Summary:

Hi all, I'm trying to set a Override Translation rule that uses the Prior Year/ Last Period / Ending Rate for a regular balance sheet account

Based on Oracle Video that would be the Setup:

For my case:

I'm expecting , that the system uses the Ending Rate for FY23 Last period, ( I tried using the direct name instead of Prior Year and last period but nothing changed on my Closing Balance USD_Reporting)

I'm testing for a Canadian entity on a specific data source / regular balance sheet account:
Also tried YTD instead of Periodic, but no changes

Any thoughts ?

Content (please ensure you mask any confidential information):