Setting Up Extensible Attributes

This chapter covers the following topics:

• Setting Up Extensible Attributes
• Setting Up Profile Options
• Creating Attribute Groups
• Creating Attributes
• Viewing Attribute Group Details
• Updating Attribute Group Details
• Defining Classifications
• Viewing Classifications
• Attaching Attribute Groups to Classifications
• Creating Pages
• Populating Data

Setting Up Extensible Attributes

Oracle Manufacturing Operations Center (MOC) enables you to define and analyze data for custom attributes in addition to analyzing data for the predefined attributes to support their functional scenarios. Oracle MOC enables you to set up extensible attributes that help you capture additional parameters with respect to entities such as Product, Batch Operation, User Defined Entities, Equipment, and Others.

You can create user-defined attribute groups and attributes to capture detailed information such as, humidity, light, room temperature etc. for entities, to support the needs of your organization and add them to a classification. All entities present in the Entity Master table display as Classifications. Seeded attributes are provided for the Equipment and Batch Operation classifications. Extensible attribute setup consists of the following steps:

• Setup profile options (For the Equipment and Item entities only).

• Create attribute groups. Seeded attribute groups and attributes are provided for the Equipment and Batch only.

• Create attributes.

• Define classifications (For the Others entity only).

• Associate attribute groups to classifications.

• Create Pages

• Populate attributes for single rows and multi-rows.

Setting Up Profile Options

Set up the following profile options:

• MTH: Equipment Classification for Extensible Attributes to define extensible attributes for Equipment.

• MTH: Item Classification for Extensible Attributes to define extensible attributes for Items.

  Refer to the "Profile Options" chapter for more information.

Creating Attribute Groups

You can create single-row or multi-row attribute groups. For multi-row attribute groups, you can have data stored in multiple rows. In single-row attribute groups, existing data is overwritten when new data is entered. Oracle MOC provides seeded attribute groups for Equipment and Item entities.

Seeded Attribute Groups

The following attribute groups are seeded in Oracle MOC:

• Specifications (Multi-row attributes) : The Specifications attribute group holds upper and lower control specifications for equipment parameters. The following table lists the attributes of this attribute group:

  Attribute Name	Data Type	Description	Mandatory
  Parameter	Varchar	The parameter for which the control limits are collected	Yes
  Upper Control Limit	Numeric	Upper control limit	Optional
  Lower Control Limit	Numeric	Lower control limit	Optional
  UOM	Varchar	Unit of Measure	Optional
  Work Order	Varchar	Work Order for which control limits to be set	Optional
  Operation	Varchar	Operation of Work Order for which control limits to be set	Optional
  Item	Varchar	Item for which control limits to be set	Optional

• Actuals (Multi-Row Attribute) : The Actuals attribute group holds Pressure, Temperature, Revolution Per Minute (RPM), Length, Width, Thickness, and Weight attribute readings from tags. These are time bound attributes and can be collected at various intervals.

  Attribute Name	Data Type	Description	Mandatory
  Pressure	Numeric	Pressure readings	Optional
  Temperature	Numeric	Temperature readings	Optional
  RPM	Numeric	RPM readings	Optional
  Length	Numeric	Length readings	Optional
  Width	Numeric	Width readings	Optional
  Thickness	Numeric	Thickness readings	Optional
  Weight	Numeric	Weight readings	Optional

To create attribute groups

1. Using the Manufacturing Operations Center Administrator responsibility, navigate to the Extensible Attributes Workbench menu.

2. Click User Defined Entities. The Entity: User Defined Entities page appears. The Classifications region displays all the entities available in the Entity Master table as Classifications.

3. Click Attributes. The Entity: User Defined Entities page appears that displays all the attribute groups. You can search for attribute groups and attributes that you want to configure to a Classification or create a new attribute group and attributes.

4. To find an attribute group, use the Search region to enter the following criteria:

   • Attribute Group Display Name

   • Internal Name

   • Attribute Group Description

   • Business Entity

   You cannot edit or delete seeded attribute groups.

5. To create a new attribute group, click Create. The Create Attribute Group for User Defined Entities page appears.

   

6. Enter the following information for the new attribute group:

   • Internal Name

   • Display Name

   • Description

   • Behavior as Single-row or Multi-row

   • Number of columns in the page layout

7. From the list of business entities that display in the Name column, select the business entity to which you want to associate the attribute group to.

8. Enter the Privileges for viewing and editing in the View and Edit fields respectively.

9. Select the Raise Attribute Change Event as:

   • Pre to raise an event before changing the attribute group.

   • Post to raise an event after changing the attribute group.

10. Click Apply and Add Attribute to create the attribute group and add attributes to it using the Create Attribute page. Refer to the topic "Creating Attributes" for more information.

11. Click Apply to create the attribute group and navigate to the Attribute Group Details page to view the group details.

Creating Attributes

You can add attributes to an attribute group using the Create Attribute page.

To add attributes

1. Using the Manufacturing Operations Center Administrator responsibility, navigate to the Extensible Attributes Workbench menu.

2. Click User Defined Entities. The Entity: User Defined Entities page appears.

3. Click Attributes. The Entity: User Defined Entities page appears that displays all the attribute groups.

4. Select the attribute group for which you want to add attributes. The Attribute Group Details page appears.

5. In the Attributes region, click Add Attribute. The Create Attribute page appears.

   

6. Enter the following fields:

   • Internal Name

   • Display Name

   • Sequence as the display sequence number of the attribute in the context of the attribute group.

   • Tip

   • Data Type as Character, Number, Standard Date, Standard DateTime or Translatable Text.

   • Column as the attribute column in the table where the data is stored.

7. Select Enable to enable the attribute. It is enabled by default.

8. Select Required if the data for the attribute is required.

9. Select the display format for the attribute in the Display As field. Options are: Checkbox, Dynamic URL, Hidden, Radio Group, Static URL, Text Area, and Text Field.

   

10. Enter a Value Set Name for the attribute. Default is Null.

11. Enter a Default Value for the attribute. Default is Null.

12. Click Apply to add the attribute and navigate to the Attribute Group Details page.

13. Click Apply and Add Another to add the attribute to the group and add another attribute.

Viewing Attribute Group Details

You can view the attribute group details using the Attribute Group Details page.

To view attribute group details

1. Using the Manufacturing Operations Center Administrator responsibility, navigate to the Extensible Attributes Workbench menu.

2. Click User Defined Entities. The Entity: User Defined Entities page appears.

3. Click Attributes. The Entity: User Defined Entities page appears that displays all the attribute groups.

4. Click the attribute group for which you want to view the details. The Attribute Group Details page appears.

   

5. To update the attribute group details, click Update. The Edit Attribute Group for User Defined Entities page appears. Refer to the topic "Updating Attribute Group for User Defined Entities" for more information.

6. The following information displays for the attribute group:

   • Business Entities region displays the business entities.

   • Attributes region displays the attributes in the attribute group. You can click Add Attribute to navigate to the Create Attributes page and add attributes to the attribute group or click Delete to delete the attribute from the group. Refer to the "Creating Attributes" topic for more information.

   • Where Used region displays the classifications to which the attribute group is associated.

   

Updating Attribute Group Details

You can use the Edit Attribute Group for User Defined Entities page to update the attribute group details.

To update attribute group details

1. Using the Manufacturing Operations Center Administrator responsibility, navigate to the Extensible Attributes Workbench menu.

2. Click User Defined Entities. The Entity: User Defined Entities page appears.

3. Click Attributes. The Entity: User Defined Entities page appears that displays all the attribute groups.

4. Click the attribute group for which you want to view the details. The Attribute Group Details page appears.

5. Click Update. The Edit Attribute Group for User Defined Entities page appears.

   

6. You can edit the following fields:

   • Display Name

   • Description

   • Number of columns in the page layout

   • View and Edit Privileges

7. Click Apply.

Defining Classifications

Define classifications for the entity Others. For all other entities, classifications are provided.

Entity	Classification
Equipment	Classified by the MTH: Equipment Classification for Extensible Attributes profile option.
Item	Classified by the MTH: Item Classification for Extensible Attributes profile option.
Work Order	Work Order
Batch Operation	Work Order
Others	User-defined classifications
User Defined Entities	User defined entities including Site and Resource

Viewing Classifications

Use the Entity: User Defined Entities page to view classifications.

To view classifications

1. Using the Manufacturing Operations Center Administrator responsibility, navigate to the Extensible Attributes Workbench menu.

2. Click User Defined Entities. The Entity: User Defined Entities page appears. The Classification region displays all the classifications available. You can use the Search region to search for a specific classification.

   

3. Click in the Classification field. The Classifications page displays the details of the classification.

   

Attaching Attribute Groups to Classifications

You can attach attribute groups to classifications using the Attribute Groups for User Defined Entities page.

To attach attribute groups

1. Using the Manufacturing Operations Center Administrator responsibility, navigate to the Extensible Attributes Workbench menu.

2. Click User Defined Entities. The Entity: User Defined Entities page appears.

3. In the Classification region, select a classification to which you want to add attribute groups. The Classifications page appears.

4. Select Attribute Groups. The Attribute Groups for User Defined Entities page appears.

5. Click Add Attribute Groups. The Add Attribute Groups for User Defined Entities page appears. The page displays a list of attribute groups. You can also search for an attribute group using the Search fields.

   

6. Select an attribute group and click Apply. The Attribute Groups for User Defined Entities page displays the added attribute group.

Creating Pages

Use the Add Pages for User Defined Entities to add pages to a classification. Pages enable you to add values to the attributes that you create.

To add pages to a classification

1. Using the Manufacturing Operations Center Administrator responsibility, navigate to the Extensible Attributes Workbench menu.

2. Click User Defined Entities. The Entity: User Defined Entities page appears.

3. In the Classification region, select a classification to which you want to add pages. The Classifications page appears.

4. Select Pages. The User Defined Entities Pages page appears.

5. Click Create. The Add Pages for User Defined Entities page appears.

   

6. Enter the following fields:

   • Display Name

   • Internal Name

   • Description

   • Sequence as the display sequence number of the page in the context of the Classification.

7. To add an attribute group to the page, click Add Another Row in the Attributes region.

8. Enter the Sequence and select an attribute group in the Display Name field.

9. Click Apply. The User Defined Entities Pages display the added page.

Populating Data

The Oracle MOC application provides a common staging table where you can upload extensible attributes data. You can then run process flows in the MTHUDANP module that transfer data from the staging table to the extensible attribute table. The attribute group names must be unique for a given entity type. For example, attribute group names cannot repeat in the context of items. For single row attribute groups, you must ensure that there is only one record for equipment. If there are multiple records, the value of the second row will overwrite the value of the first row.

You can add attribute values using the Entity user interface from the Extensible Attributes Data menu of the MOC User responsibility. Refer to the topic "Viewing and Creating Attribute Group Data for Entities" in the Administrator Role chapter of the Oracle Manufacturing Operations Center User's Guide for more information.

Single Row Attributes

For Extensible Attributes, data can be populated from OWB into interface tables, or pages if it is a single row of data. For data populated from OWB into interface tables, run the following process flows in the MTHUDANP module in MOC after loading the data.

Entity	Process Flow
Equipment	MTH_EXT_ATTR_EQ_PF
Item	MTH_EXT_ATTR_IT_PF
Work Order	MTH_EXT_ATTR_PS_PF
Others	MTH_EXT_ATTR_OT_PF
Batch Operations (Work Order Segment)	MTH_EXT_ATTR_PSG_PF
User Defined Entities	MTH_EXT_ATTR_UE_PF

Multi-Row Attributes

To populate multi-row attributes for the Equipment entity:

1. Set up the attribute tags for entity mapping.

2. Run OWB process flows to load data sequentially.

3. Run the MTH_DEV_DATA_INCR_PF process flow in the MTHDDICP module in MOC to load the data into the staging table.

4. Run the MTH_EXT_ATTR_TB_PF process flow in the MTHUDADP module in MOC to transfer the data from the staging table to the external attributes table.