No data available on simple filters

Lauriane Massin Whitaker · Jan 20, 2025 1:56PM

Hi,

How come I can no longer fitler easy metrics like legal employers, assignment type… etc in basic reports from HCM-Workforce Core ?

I used to be available to filter them before…

Regards,

LAuriane

Lauriane Massin Whitaker · Jan 21, 2025 3:11PM

Hi again…

This is becoming quite critical.

No data for simple filters… what's happening ?

Sumanth V -Oracle · Jan 21, 2025 3:25PM

@Lauriane Massin Whitaker - Kindly check the session log, it could be because of the data level security.

Lauriane Massin Whitaker · Jan 21, 2025 9:16PM

Hi Sumanth,

Could you please be more specific ?

I'm a bit lost here.

Regards

Lauriane

Sumanth V -Oracle · Jan 22, 2025 6:44AM

@Lauriane Massin Whitaker - Please check the session log and see if the security tables are called as shown in screen shot below:

Table Name:

SEC_SECURE_BY_OBJ_MEMBER_USER

Lauriane Massin Whitaker · Jan 22, 2025 7:59AM

Hi Sumanth,

Thanks for your quick reply.

I've checked and you were right, I was able to find the table name you mentioned in the execution log.

What should I do ?

Regards,

Lauriane

Abdul R Shaik-Oracle · Jan 24, 2025 6:00AM

You can check for data roles assigned to the user running this report. He/She may have data restricted.

MFA for Oracle Community