SQL to fine the total records extracted in changesonly hcm extract
Summary:
Hi Team,
We had using belowSQL to check the total records extracts by particular flow instance .
=============
Select
flow.FI_TOTAL_COMPLETED
FROM
pay_flow_instances flow
Where 1=1
andflow.INSTANCE_NAME like'AP_ADP_WFN_Worker_Hires_Changes_Extract_V2_Changeonly_UTC4: 2025-05-1900:00:0%'
=============
Above sql is workingbefore 25B(25B (11.13.25.04.0)) . Our production instance got upgraded to 25B last week. Post thatthe SQL is showing full records been compared instead of changed records asbelow. Request you to provide Working tabledetails to capture.
This issue isoccuring in OTBI report as well.
========
SET VARIABLEPREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Payroll - Payroll Flows RealTime"."Flow Instance"."Instance Name" s_1,