SQL to fine the total records extracted in changesonly hcm extract — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!