Expense Report Stuck In 'AP approval process/Block' After Manager Approval

Few days back I got a situation where APEXP workflow failed for manager approval because manager had left the job and related role/user was not valid.

I then updated the workflow attributes with correct manager details and rewind it so it went to new manager and got approved but got stuck in 'AP approval process/Block' activity.

What 'Block' function does?
The Block function lets you pause a process until some external program or manual step completes.
You can not skip this activity.

I checked the ap_expense_report_headers_all table, coumn 'source' had value 'NonValidatedWebExpense' and column workflow_approved_flag had value 'M'

Before going further lets know about source/workflow_approved_flag columns values and meaning

Column: source

‘NonValidatedWebExpense’
Expense report transaction has been inserted into the expense report transaction tables but have not passed the Payables Validation Function in the Server Side Validation Process of the Expense Report Workflow process. This transaction is not viewable in the Oracle Payables Enter Expense Reports Window.

‘WebExpense’
Expense Report transactions has successfully passed the Payables Validation function in the Expense Report Workflow Server Side Validation Process and is viewable in the Oracle Payables Enter Expense Reports Window. Transaction has not completed the Expense Report Workflow yet.

‘XpenseXpress’
If Expense Report was created through the Web Interface (identified by the workflow_approved_flag), expense report transaction has successfully completed the Expense Report Workflow process and is ready to be picked up by Oracle Payables Invoice Import program.

‘SelfService’
Expense Report transaction has successfully completed the expense Report Workflow process and is ready to be picked up by Oracle Payables Invoice Import program.

Column: workflow_approved_flag

NULL
If Expense Report transaction is created from the web (check the source), then expense report has been submitted, but not been manager or payables approved. Expense Report transactions not created from the web will have workflow_approved_flag = NULL.

‘S’
Expense Report transaction has been saved and not yet fully completed or submitted.

‘I’
Implicit save, in OIE.K/R12 there is an implicit save when navigating from one page to another.

‘R’
Expense Report transaction has been Manager rejected.

‘M’
Expense Report transaction has been Manager approved.

‘P’
Expense Report transaction has been Payables approved.

‘A’
Expense Report transaction has been ‘Automatically’ approved, i.e. Manager approved but Payables approval not needed because expense report didn’t need payables to check for receipts or policy.

‘W’
Expense Report has been Withdrawn.

‘Y’

Expense Report transaction has been both Manager and Payables approved.

> Now when I checked the workflow, 'AP Audit Expense Report' process was completed with result 'Audit'. 'Block' activity was waiting this process to complete with result approved/auto approved.

>> Try to rewind the 'AP Audit Expense Report' process, if it does not work check with payables if any approval is pending.