Skip to main content
Kofax

MarkView Expense Management - What do the values mean in the columns SOURCE and WORKFLOW_APPROVED_FLAG in the table AP_EXPENSE_REPORT_HEADERS_ALL?

Summary

3964
AP_EXPENSE_REPORT_HEADERS_ALL.SOURCE

Value

Meaning

'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'

(10.7 - 11.0.2) 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' (11.0.2+) Expense Report transaction has successfully completed the expense Report Workflow process and is ready to be picked up by Oracle Payables Invoice Import program.

 

AP_EXPENSE_REPORT_HEADERS_ALL.WORKFLOW_APPROVED_FLAG

Value

Meaning

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.
'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.

'Y' Expense Report transaction has been both Manager and Payables approved.
'W' If Expense Report transaction is withdrawn the Expense Report transactions will have workflow_approved_flag = W.

From Metalink Document 107849.1

Keywords: workflow approved flag