Create Manufacturing Work Definition Reports with Additional Attributes Using Oracle Transactional Business Intelligence or OTBI

Welcome to the demo of the 25C feature, Create Manufacturing Work Definition Reports with Additional Attributes Using Oracle transactional Business Intelligence or OTBI in Oracle Fusion Cloud Manufacturing. This feature provides additional metrics in the Manufacturing Work Definitions Real Time subject area. The additional metrics are count of complete standard item work definitions, count of incomplete standard item work definitions, and count of work definitions with structure changes.

In addition, the following attributes have been added: descriptive flexfields, component hierarchy, effectivity date, disable date, step name, and work area inactive on. Manufacturing engineers need to deliver work definitions for usage in downstream processes, such as supply planning, costing, and work execution. The additional metrics help ensure the readiness of work definitions, resulting in correct work orders for execution.

This demo shows how to create an analysis to review work definitions that are incomplete in an organization. First, I'll discuss the criteria to select. Then I'll show the results of the analysis. We'll review the data in Fusion Manufacturing Cloud and complete the work definition.

We'll go back to OTBI. Rerun the analysis. And review the results. I'm logged in as a manufacturing engineer. Click Reports and Analytics tile to navigate to Oracle Transactional Business Intelligence. Click Browse Catalog.

To create an analysis, click Create. Then click Analysis. When prompted to select subject area, enter work definition in the search field. Select Manufacturing Work Definitions Real Time. The subject area provides information about manufacturing work definitions.

This includes work definition headers, operations, operation outputs, operation items, and operation resources. Manufacturing Work Definitions Real Time subject area is selected. The dimensions available in the subject area are listed. This feature delivers these new metrics: count of complete standard item work definitions, count of incomplete standard item work definitions, and count of work definitions with structure changes.

A work definition is considered complete when all the item structure components are assigned to work definition operations. If there is at least one item structure component that's not assigned to a work definition operation, then the work definition is considered incomplete. The count of complete and incomplete standard item work definitions metrics don't include ATL model work definitions.

The count of work definitions with structure changes metric includes model work definitions only if the structure changes are at the first level components of the ATL model. I'm going to create an analysis to review incomplete standard item work definitions. First, I need to define the criteria for the analysis.

I select the metric count of incomplete standard item work definitions, inventory organization code, item name, and work definition name. I'm going to filter the inventory organization code to organization code MAP1. Click on the gear icon. And select Filter. I specify operator as is equal to or is in. I specify value as MAP1. Click OK.

Similarly, I apply a filter to the metric count of incomplete standard item work definitions to be equal to 1. Count equals to 1 returns the true condition for the metric. Click Results.

The system returns the results based on the criteria I've specified. There are two work definitions that are incomplete in organization MAP1. The first work definition is main for item SAPS-CEMENT-Type5.

The second work definition is main for item SAPS-MTD-Lamps. I'm going to review the incomplete work definitions in Fusion Manufacturing Cloud. I've navigated to the Work Definition landing page and set the organization to MAP1.

I typed in cement in the search field and clicked search. The work definition main that I'm interested in reviewing for item SAPS-CEMENT-Type5 is returned in the search results. I clicked on the work definition name hyperlink Main. It opens the Operations page. Click Operation Items tab.

I clicked Item Structure toggle button. I'm going to use the Unassigned filter. Select Yes. Those item structure components that aren't assigned to work definition operations are returned. These components are missing operation sequence and material sequence.

I need to assign these components to operations to complete the work definition. Otherwise, the work order will be missing these components. I specified the operation sequence for these unassigned components. The system automatically defaults the material sequence. I verified that the data I entered were accurate. Click Save and Close.

Now that I completed the work definition main for item SAPS-CEMENT-Type5, let's rerun the analysis in OTBI. I clicked Open under Incomplete Work Definitions Analysis, which I saved earlier. Because all the item structure components for work definition Main for item SAPS-CEMENT-Type5 are now assigned, that work definition no longer shows as incomplete when the analysis was rerun. Now, there's only one incomplete work definition left, which I need to act on and ensure that all the components are assigned.

To summarize, with this feature, you can use additional metrics and attributes in the Manufacturing Work Definitions Real Time subject area to ensure work definition readiness. This concludes the feature demo. Thank you for watching.