Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Row Limit? Missing Rows
Content
Hi all - I have a query (Logical SQL) that I use to run for changes. It runs Assignment and Salary changes. When I ran the report in April, it pulled back ~132K rows (BETWEEN 2019-01-01 AND CURRENT_DATE). I ran that same report today, and now I have about 13K rows.
I notice there are people missing from the query as well. So I ran the query, limiting it to someone I know was on the April report, and their data returns. But if I remove that filter, they no longer appear on the report.
It's not a security issue, since I can see the data when I filter to one person, but that one person disappears on the final output (and I have access to all data, so should be no issue).
Tagged:
0