oracle EPBCS reports period offset function is not working
Hello Community,
The EPBCS reports which are using Peiod Offset function worked until last week have broke this week and not sure if this is the result of April patch. The reports use Current period substitution variable and traverse through 11 prior periods to generate the report. This week the report is picking the prior periods from a different hierarchy in period dimension which are not defined in the function and also the order is not accurate as shown below.
I tried updating the function again and saved the report to see if it works but no luck.
Is anyone facing similar issue and aware of the fix or workaround on this issue?