Approval History - AP Invoice Account Coding Workflow Notification Customization
Summary:
We need to customize "AP Invoice Account Coding Workflow Notification" to display approval history using SQL Query.
In BPM Workflow notification we can see the approval history in UI (Navigation: BPM Worklist -> Open a notification - > Actions -> View Approvals).
The same approval information we want to display in the bottom of the notification. For this we have customized the below BIP Data Model and Template:
Data Model: Invoice Approval Data Model
Path: /shared/Custom/Financials/Workflow Notifications/Payables/Invoices/Data Models
We have used below query to fetch the approval history. But it is not fetching correct information for some of the scenarios: