HCM Extract status stays in Pending after all Flow Tasks has been completed

Summary:

We have an inbound interface extract used to get the data using a report and load that into the application table. But after the data is get extracted and loaded to the application table the status of the extract is still in Pending status.

Content (required):

Version (include the version you are using, if applicable):

23A

Code Snippet (add any code snippets that support your topic, if applicable):

All the flow task has been completed but the extract's overall status remains pending. the first flow task is to get the report output and then the second will load to the application table by initiating an HCM Data loader.