Oracle Asset Life Cycle Management (ALM)

This chapter covers the following topics:

Create Asset, Work Request and Work Order: EAM PLSQL

The flow creates an Asset Group through UI. Using PLSQL API, multiple Capital Assets are created. The flow creates Work Request and Work Order subsequently for the created asset through PLSQL API. The created Work Order is verified and completed using UI.

Flow Type

Hybrid: PLSQL & UI

Technical Name

Create_Assets_WR_WO_PLSQL

Prerequisites

Not Applicable

Profile Options

Not Applicable

Predefined Data

The following predefined data must be used:

Entity Field Name Field Value
User User Name OPERATIONS
Responsibility Responsibility Enterprise Asset Management
Organization Inventory Organization EM1-EAM Enabled Organization
Create Asset Groups Use Item Template @Asset Group

Setup Data

The following data must be set up:

Interface Field Name Field Value
Define WIP Accounting Class WIP Accounting Class MaintWAC
Define Departments and Resources Department W-Maint

Description of the Scenarios in the Flow (Asset Life Cycle Management)

Following are the details of the scenarios in the flow:

Scenario Objective Artifact Method Component Set Main Component
Create_Asset_Group_UI This scenario creates a Capital Asset Group though Form   Create_Asset_Group -
Select_Query Query identifies the inventory item ID of the created Asset Group from Item Master table   - SELECT
Create_Multiple_Asset_Number The scenario creates multiple Capital Assets using the above created Asset Group EAM_ASSETNUMBER_PUB_INSERT_ASSET_NUMBER - EAM_ASSETNUMBER_PUB_INSERT_ASSET_NUMBER_Main
Create_Work_Request The scenario creates singles Work request using an Asset created in above scenario WIP_EAM_WORKREQUEST_PUB_WORK_REQUEST_IMPORT - WIP_EAM_WORKREQUEST_PUB_WORK_REQUEST_IMPORT_Main
Select_Query_MaintenanceObjectID     - SELECT
Create_Work_Order The scenario creates Work Order for a created Asset EAM_PROCESS_WO_PUB_PROCESS_MASTER_CHILD_WO EAM_PROCESS_WO_PUB_PROCESS_MASTER_CHILD_WO EAM_PROCESS_WO_PUB_PROCESS_MASTER_CHILD_WO_Main
Conditional_Commit     - VERIFICATION_COMPONENT
Work_Order_Completion_UI The scenario verifies created Work Order and completes it through UI   Query_Verify_Action_WO_OA Complete_Work_Order_OA  

Create Asset Number: EAM Open Interface

This flow creates Capital Asset using Open Interface API.

Flow Type

OI

Technical Name

Create_Asset_Number_OI

Prerequisites

Not Applicable

Profile Options

Not Applicable

Predefined Data

The following predefined data must be used:

Entity Field Name Field Value
User User Name OPERATIONS
Responsibility Responsibility Enterprise Asset Management
Organization Inventory Organization EM1-EAM Enabled Organization
Asset Groups Asset Group Fork Lifts

Setup Data

The following data must be set up:

Interface Field Name Field Value
Define WIP Accounting Class WIP Accounting Class MaintWAC
Define Departments and Resources Department W-Maint

Description of the Scenarios in the Flow (Asset Life Cycle Management)

Following are the details of the scenarios in the flow:

Scenario Objective Artifact Method Component Set Main Component
Create_Asset_Number This scenario creates a Capital Asset through Open Interface API   Asset_Number_Import_EAMANIMP Asset_Number_Import_EAMANIMP
Verification     - VERIFICATION_COMPONENT

Create EAM Asset Attributes for Existing Asset Numbers: PLSQL

This flow adds Attribute Group and Attribute Values to an existing Asset.

Flow Type

PLSQL

Technical Name

Create_Associate_Asset_Attr_With_Asset_Number_PLSQL

Prerequisites

Not Applicable

Profile Options

Not Applicable

Predefined Data

The following predefined data must be used:

Entity Field Name Field Value
User User Name OPERATIONS
Responsibility Responsibility Enterprise Asset Management
Organization Inventory Organization EM1-EAM Enabled Organization
Asset Groups Asset Group Fork Lifts

Setup Data

The following data must be set up:

Interface Field Name Field Value
Define WIP Accounting Class WIP Accounting Class MaintWAC
Define Departments and Resources Department W-Maint
Attribute Assignment Attribute Group Fork Lift Classifications to be assigned to Asset Group Fork Lifts

Description of the Scenarios in the Flow (Asset Life Cycle Management)

Following are the details of the scenarios in the flow:

Scenario Objective Artifact Method Component Set Main Component
Create_Asset_Number This scenario creates a Capital Asset through PLSQL API EAM_ASSETNUMBER_PUB_INSERT_ASSET_NUMBER - EAM_ASSETNUMBER_PUB_INSERT_ASSET_NUMBER_Main
Assoc_Asset_Attr_With_Number The scenario adds Attribute Group and Attribute Values against the created asset EAM_ASSETATTR_VALUE_PUB_INSERT_ASSETATTR_VALUE - EAM_ASSETATTR_VALUE_PUB_INSERT_ASSETATTR_VALUE_Main
Verification     - VERIFICATION_COMPONENT

Update EAM Asset Attributes for Existing Asset: PLSQL

This flow updates Attribute Values for an existing Asset.

Flow Type

PLSQL

Technical Name

Update_Associate_Asset_Attr_With_Asset_Number_PLSQL

Prerequisites

Not Applicable

Profile Options

Not Applicable

Predefined Data

The following predefined data must be used:

Entity Field Name Field Value
User User Name OPERATIONS
Responsibility Responsibility Enterprise Asset Management
Organization Inventory Organization EM1-EAM Enabled Organization
Asset Number Asset Number FL1010

Setup Data

The following data must be set up:

Interface Field Name Field Value
Attribute Assignment Attribute Group Fork Lift Classifications to be assigned to Asset Group Fork Lifts

Description of the Scenarios in the Flow (Asset Life Cycle Management)

Following are the details of the scenarios in the flow:

Scenario Objective Artifact Method Component Set Main Component
Assoc_Asset_Attr_With_Number The scenario updates Attribute Values against asset FL1010 EAM_ASSETATTR_VALUE_PUB_UPDATE_ASSETATTR_VALUE - EAM_ASSETATTR_VALUE_PUB_UPDATE_ASSETATTR_VALUE_Main
Verification     - VERIFICATION_COMPONENT

Meter Creation, Meter Update & Create and Update Meter Association: PLSQL

This flow creates a new Meter. The flow will update the attribute values of the created meter. The Meter will be associated to an Asset through the flow. Once the Meter is associated to an Asset, the association data will be updated.

Flow Type

PLSQL

Technical Name

Create_Update_Meter_And_Asset_Meter_Association_PLSQL

Prerequisites

Not Applicable

Profile Options

Not Applicable

Predefined Data

The following predefined data must be used:

Entity Field Name Field Value
User User Name OPERATIONS
Responsibility Responsibility Enterprise Asset Management
Organization Inventory Organization EM1-EAM Enabled Organization
Asset Number Asset Number FL1010

Setup Data

Not Applicable

Description of the Scenarios in the Flow (Asset Life Cycle Management)

Following are the details of the scenarios in the flow:

Scenario Objective Artifact Method Component Set Main Component
Create_Meter This scenario will create a new Meter EAM_METER_PUB_CREATE_METER - EAM_METER_PUB_CREATE_METER_Main
Update_Meter This scenario will update some attribute values of the Meter EAM_METER_PUB_UPDATE_METER - EAM_METER_PUB_UPDATE_METER_Main
Create_Asset_Meter_Association This scenario associates the created Meter to an existing Asset EAM_METERASSOC_PUB_INSERT_ASSETMETERASSOC - EAM_METERASSOC_PUB_INSERT_ASSETMETERASSOC_Main
Update_Asset_Meter_Association The scenario updates the Asset & Meter Association data EAM_METERASSOC_PUB_UPDATE_ASSETMETERASSOC - EAM_METERASSOC_PUB_UPDATE_ASSETMETERASSOC_Main
Verification     - VERIFICATION_COMPONENT

Create and Disable Meter Readings: PLSQL

This flow captures a new reading against an existing Meter. The flow also disables the reading record of that Meter.

Flow Type

PLSQL

Technical Name

Create_Disable_Meter_Reading_PLSQL

Prerequisites

Not Applicable

Profile Options

Not Applicable

Predefined Data

The following predefined data must be used:

Entity Field Name Field Value
User User Name OPERATIONS
Responsibility Responsibility Enterprise Asset Management
Organization Inventory Organization EM1-EAM Enabled Organization
Asset Number Asset Number FL1010
Meter Meter FL1010 Hour Meter

Setup Data

Not Applicable

Description of the Scenarios in the Flow (Asset Life Cycle Management)

Following are the details of the scenarios in the flow:

Scenario Objective Artifact Method Component Set Main Component
Create_Meter_Reading This scenario will add a new meter reading - EAM_METERREADING_PUB_CREATE_METER_READING EAM_METERREADING_PUB_CREATE_METER_READING_Main
Disable_Meter_Readings The scenario disable the reading of the Meter   - EAM_METERREADING_PUB_DISABLE_METER_READING_Main

Create and Update Preventive Maintenance Set Name: PLSQL

This flow creates and updates Set Name in Preventive Maintenance.

Flow Type

PLSQL

Technical Name

Create_Update_Preventive_Maintenance_Set_Name_PLSQL

Prerequisites

Not Applicable

Profile Options

Not Applicable

Predefined Data

The following predefined data must be used:

Entity Field Name Field Value
User User Name OPERATIONS
Responsibility Responsibility Enterprise Asset Management
Organization Inventory Organization EM1-EAM Enabled Organization

Setup Data

Not Applicable

Description of the Scenarios in the Flow:

Following are the details of the scenarios in the flow:

Scenario Objective Artifact Method Component Set Main Component
Create_Preventive_Maintenance_Set_Name This scenario will create a new Set Name in Preventive Maintenance EAM_SETNAME_PUB_INSERT_PMSETNAME - EAM_SETNAME_PUB_INSERT_PMSETNAME_Main
Update_Preventive_Maintenance_Set_Name This scenario will update description of the created Set Name EAM_SETNAME_PUB_UPDATE_PMSETNAME - EAM_SETNAME_PUB_UPDATE_PMSETNAME_Main

Create and Update Activity Suppression: PLSQL

This flow creates and updates Activity Suppression in Preventive Maintenance.

Flow Type

PLSQL

Technical Name

Create_Update_Activity_Supressions_PLSQL

Prerequisites

Not Applicable

Profile Options

Not Applicable

Predefined Data

The following predefined data must be used:

Entity Field Name Field Value
User User Name OPERATIONS
Responsibility Responsibility Enterprise Asset Management
Organization Inventory Organization EM1-EAM Enabled Organization
Parent Association ID Activity Name Lubricate Fork Lift Mast
Child Association ID Activity Name Change Fork Lift Battery

Setup Data

Not Applicable

Description of the Scenarios in the Flow (Asset Life Cycle Management)

Following are the details of the scenarios in the flow:

Scenario Objective Artifact Method Component Set Main Component
Create_Activity_Supressions This scenario will create new Activity Suppressions EAM_ACTIVITYSUPN_PUB_INSERT_ACTIVITYSUPN - EAM_ACTIVITYSUPN_PUB_INSERT_ACTIVITYSUPN_Main
Update_Activity_Supressions This scenario will update new Activity Suppressions EAM_ACTIVITYSUPN_PUB_UPDATE_ACTIVITYSUPN - EAM_ACTIVITYSUPN_PUB_UPDATE_ACTIVITYSUPN_Main

Add Department Approvers: PLSQL

This flow adds a user as an Approver for a Department.

Flow Type

PLSQL

Technical Name

Add_Department_Approvers_PLSQL

Prerequisites

Not Applicable

Profile Options

Not Applicable

Predefined Data

The following predefined data must be used:

Entity Field Name Field Value
User User Name OPERATIONS
Responsibility Responsibility Enterprise Asset Management
Organization Inventory Organization EM1-EAM Enabled Organization
Department Department W-Maint
Primary Approver Primary Approver MNT

Setup Data

Not Applicable

Description of the Scenarios in the Flow (Asset Life Cycle Management)

Following are the details of the scenarios in the flow:

Scenario Objective Artifact Method Component Set Main Component
Add_Department_Approvers This scenario will create new department approvers EAM_DEPT_APPROVERS_PUB_INSERT_DEPT_APPR - EAM_DEPT_APPROVERS_PUB_INSERT_DEPT_APPR_Main

Create and Update Asset Area: PLSQL

This flow creates and updates Asset Area.

Flow Type

PLSQL

Technical Name

Create_Update_Asset_Area_PLSQL

Prerequisites

Not Applicable

Profile Options

Not Applicable

Predefined Data

The following predefined data must be used:

Entity Field Name Field Value
User User Name OPERATIONS
Responsibility Responsibility Enterprise Asset Management
Organization Inventory Organization EM1-EAM Enabled Organization

Setup Data

Not Applicable

Description of the Scenarios in the Flow (Asset Life Cycle Management)

Following are the details of the scenarios in the flow:

Scenario Objective Artifact Method Component Set Main Component
Create_Asset_Area This scenario will create a new Area EAM_ASSET_AREAS_PUB_INSERT_ASSET_AREAS - EAM_ASSET_AREAS_PUB_INSERT_ASSET_AREAS_Main
Get_Location_ID_With_Select     - SELECT
Update_Asset_Area This scenario will update the Area EAM_ASSET_AREAS_PUB_UPDATE_ASSET_AREAS - EAM_ASSET_AREAS_PUB_UPDATE_ASSET_AREAS_Main

Update EAM Parameter: PLSQL

This flow updates EAM Parameter against a Maintenance Organization.

Flow Type

PLSQL

Technical Name

Update_EAM_Parameters_PLSQL

Prerequisites

Not Applicable

Profile Options

Not Applicable

Predefined Data

The following predefined data must be used:

Entity Field Name Field Value
User User Name OPERATIONS
Responsibility Responsibility Enterprise Asset Management
Organization Inventory Organization EM1-EAM Enabled Organization
Cost Element Cost Element Equipment
Cost Category Cost Category Maintenance
Maintenance Offset Maintenance Offset 01-520-7530-0000-000

Setup Data

The following data must be set up:

Interface Field Name Field Value
Define WIP Accounting Class WIP Accounting Class MaintWAC

Description of the Scenarios in the Flow (Asset Life Cycle Management)

Following are the details of the scenarios in the flow:

Scenario Objective Artifact Method Component Set Main Component
Update_EAM_Parameters This scenario will update the created EAM Parameter EAM_PARAMETERS_PUB_UPDATE_PARAMETERS - EAM_PARAMETERS_PUB_UPDATE_PARAMETERS_Main