Extraction of data using Workday V2 connector in IICS

In my implementation , I am fetching the invoice data from revenue management module of workday using workday V2 connector and writing it to a csv file in IICS.

while doing so , sometimes it returns null values and sometimes it will not.

For example , The output file will look like this when it returns null values

"PK_Invoice","Invoice_ID","Invoice_Date","Invoice_Number"

1,,,

2,,,

3,,,

4,,,

5,"INVOICE745","08/03/2022","INV_745"

6,"INVOICE277","08/03/2022","INV_277"

On checking the Logs, it shows no error .

TRANSF_1_1_1> Workday Hierarchy Connector_10005 [2022-08-03 07:03:53.211] [INFO] Length of SOAP response : [1300220]

TRANSF_1_1_1> Workday Hierarchy Connector_10014 [2022-08-03 07:03:53.215] [INFO] Total No of Page to be fetched : [154]

TRANSF_1_1_1> Workday Hierarchy Connector_10016 [2022-08-03 07:03:53.215] [INFO] Total no of execution cycles : [154]

TRANSF_1_1_1> Workday Hierarchy Connector_10015 [2022-08-03 07:03:53.217] [INFO] Fetching pages from [2] to [2]

TRANSF_1_1_1> Workday Hierarchy Connector_10010 [2022-08-03 07:03:53.217] [INFO] sending SOAP Request

TRANSF_1_1_1> Workday Hierarchy Connector_10011 [2022-08-03 07:03:54.634] [INFO] SOAP Response Received

TRANSF_1_1_1> Workday Hierarchy Connector_10015 [2022-08-03 07:03:54.635] [INFO] Fetching pages from [3] to [3]

TRANSF_1_1_1> Workday Hierarchy Connector_10010 [2022-08-03 07:03:54.635] [INFO] sending SOAP Request

TRANSF_1_1_1> Workday Hierarchy Connector_10011 [2022-08-03 07:03:58.556] [INFO] SOAP Response Received

and so .. on

The same mapping that is fetching null values using workday connector at certain point of time is fetching the data when executed at some time later (Assuming the input parameters are same). Wanted to understand what could be the possible reason that a workday v2 connector call is fetching null values at some time and data at another point of time.

Could you please help in resolving this issue . why is it returning null values ? Is there a way to track the missing invoices.

Thanks, John