Guidelines for Working with the Supply Chain Financial Orchestration - Real Time Subject Area

This topic provides guidelines for working with the Supply Chain Financial Orchestration - Real Time subject area in Oracle Transactional Business Intelligence.

While working with this subject area, you can do the following:

Apply a filter on the Event Status Code column so that you can filter the rows in your analysis by the event statuses that you require.
Ensure that item names are displayed for all event status codes.
Create an analysis to return rows for both task-level and event-level messages without any empty rows.

Use the Event Status Code Column To Filter Event Statuses

Applying a filter on the Event Status Code column is useful because the Event Status column returns similar information for some event status codes. For example, for the DISCARDED and WAITING_FOR_DOC_ENRICHMENT event status codes, the event status is "Transaction event is not started."

To filter rows in your analysis by event status codes, follow these steps:

In Oracle Transactional Business Intelligence, create an analysis for the Supply Chain Financial Orchestration - Real Time subject area.
On the Criteria tab, from Ownership Change Events > Ownership Change Event Details, add the Event Status Code and Event Status columns to your analysis.

Add other columns that you require to your analysis.
In the Options menu for the Event Status Code column, select Filter.

The New Filter dialog box opens.
In Operator, select is equal to / is in.
In Value, select the check boxes for the event status codes by which you want to filter the event statuses.
Click OK.
Modify the other columns as required, and save your analysis.

Ensure That Item Names Are Displayed for All Event Status Codes

For some event status codes such as DISCARDED, the Item Name column returns the null value unless a formula is applied to the column.

To return item names for all event status codes, follow these steps:

In Oracle Transactional Business Intelligence, create an analysis for the Supply Chain Financial Orchestration - Real Time subject area.
On the Criteria tab, from Ownership Change Events > Item > Main, add the Item Name column to your analysis.

Add other columns that you require to your analysis.
In the Options menu for the Item Name column, select Edit Formula.

The Edit Column Formula dialog box opens.

On the Column Formula tab, in Column Formula, enter the following code:

Case when "Ownership Change Event Details"."Transaction Status" is null then "Source Document Details"."Source Document Item Number" else "Main"."Item Name" end

Click OK.
Modify the other columns as required, and save your analysis.

Create an Analysis for Returning Both Task-Level and Event-Level Messages

You can create an analysis to return rows for both task-level and event-level messages in alternate rows without any empty rows.

To create the analysis for returning rows for both task-level and event-level messages, follow these steps:

In Oracle Transactional Business Intelligence, create an analysis for the Supply Chain Financial Orchestration - Real Time subject area.
On the Criteria tab, add columns to your analysis:
- Ownership Change Events > Ownership Change Event Details: Business Process Type, Event Number, Event Type, Event Id, Event Date, Event Status, and Event Status Code
- Financial Orchestration Flow Details > Financial Route Details: Financial Route Id
- Task Messages: Message Type, Message Details, Message Category, and Additional Information
Add other columns that you require to your analysis.
In the Options menu for the Event Status Code column, select Filter.

The New Filter dialog box opens.
In Operator, select is equal to / is in.
In Value, select the check boxes for the COMPLETED and ORCHESTRATED event status codes.

These event status codes pertain to task-level messages.
Click OK.
On the Selected Columns section title, click the Combine results based on union, intersection, and difference operations icon, and in the Select Subject Area dialog box, select the Supply Chain Financial Orchestration - Real Time subject area.
Under Result Columns, ensure that Union is selected for combining the results of the two queries.
For the second query, select the same columns that you selected for the first query and in the same order.
In the Options menu for the Event Status Code column, select Filter.

The New Filter dialog box opens.
In Operator, select is equal to / is in.
In Value, select the check boxes for the DISCARDED, EVENT_UNUSED, PARENT_FLOW_NOT_COMPLETED, and WAITING_FOR_DOC_ENRICHMENT event status codes.

These event status codes pertain to event-level messages.
Click OK.
Modify the other columns as required, and save your analysis.