Comprehensive and Detailed In-Depth
To incorporate new transactional attributes into the Expense Approver Report workflow notification in Oracle Financials Cloud, you need to customize specific Business Intelligence Publisher (BI Publisher) catalog objects. The two primary objects that require customization are:
The Data Model (Option B):
Purpose: The Data Model defines the data structure and sources for the report. It determines which attributes from the application's data sources are available for inclusion in the report.
Customization Process:
Navigate to the BI Catalog: Shared Folders > Financials > Workflow Notifications > Expenses.
Locate the Expense Approval Data Model.
Use the Customize option to create a copy of the data model in the Custom folder.
Edit the copied data model to include the new transactional attributes required for the notification.
The Layout Template (Option A):
Purpose: The Layout Template defines the visual presentation of the notification, including which data fields are displayed and their formatting.
Customization Process:
In the same BI Catalog location, find the Expense Report Approval report.
Use the Customize option to create a copy of the report layout template in the Custom folder.
Download the copied layout template (an .rtf file) and open it using Microsoft Word with the BI Publisher Template Builder add-in.
Insert the new transactional attributes into the template as needed.
Upload the modified template back to the BI Catalog and set it as the default layout.
By customizing both the Data Model and the Layout Template, you ensure that the new transactional attributes are not only retrieved from the data source but also properly displayed in the workflow notification.
Note: Options C (The Original Source) and D (The Output types) are not directly involved in the process of adding new attributes to the workflow notification and therefore are not relevant to this requirement.
