SQL to fine the total records extracted in changesonly hcm extract

Jul 22, 2025 4:29AM

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,

SQL to fine the total records extracted in changesonly hcm extract

Howdy, Stranger!