Hi @Varun_Vickraman Oracle has confirmed its a bug and their development team is still working on providing solution. I have raised question in CCC and there too i got response from one of the oracle person.…

Hi @Varun_Vickraman Thank you for sharing the issued sql of 25A. Will have a look at it. Regards, Aditya

Hi @JA1 Do let us know on the Oracle respone here. Thanks, Aditya

Hi @JA1 did you tried raising an Oracle SR? Thanks, Aditya

Hi @Varun_Vickraman Is it possible for you to share the physical or logical query from 25A POD by fetching few Partcipants and dependents columns for paln type Medical? So that i will compare both the queries and understand if there was any change?

Hi @Varun_Vickraman For our initial analysis we extracted the output without any filter conditions and analysed the physical query to understand the behaviour of the subject area Benefits - Enrollments Real Time. Upon analysis, we found that it pulls dependents only when dependent certification is present at the time of…

Hi @Varun_Vickraman , Are you also facing the same issue?

Hi @JA1 Even I am facing the same Issue. I am using the subject area Benefits - Enrollments Real Time to fetch participants and dependents details. Before 25B release, I was able to get the data. However, since 25B depenents data is not coming somehow. It is unclear whether this behaviour was introduced in the 25B release,…