© 2009 oracle corporation – proprietary and confidential 1 oracle online training materials –...

1 © 2009 Oracle Corporation – Proprietary and Confidential

Oracle Online Training Materials – Usage Agreement

Use of this Site (“Site”) or Materials constitutes agreement with the following terms and conditions:

1. Oracle Corporation (“Oracle”) is pleased to allow its business partner (“Partner”) to download and copy the information, documents, and the online training courses (collectively, “Materials") found on this Site. The use of the Materials is restricted to the non-commercial, internal training of the Partner’s employees only. The Materials may not be used for training, promotion, or sales to customers or other partners or third parties.

2. All the Materials are trademarks of Oracle and are proprietary information of Oracle. Partner or other third party at no time has any right to resell, redistribute or create derivative works from the Materials.

3. Oracle disclaims any warranties or representations as to the accuracy or completeness of any Materials. Materials are provided "as is" without warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.

4. Under no circumstances shall Oracle be liable for any loss, damage, liability or expense incurred or suffered which is claimed to have resulted from use of this Site of Materials. As a condition of use of the Materials, Partner agrees to indemnify Oracle from and against any and all actions, claims, losses, damages, liabilities and expenses (including reasonable attorneys' fees) arising out of Partner’s use of the Materials.


Disclaimer:This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Software License and Service Agreement or other applicable contract with Oracle, with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced ordistributed to anyone outside Oracle without Oracle’s prior written consent. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates. This document is for informational purposes only and is intended solely to assist you in planning for the implementation and upgrade of the product features described. This is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality are always at Oracle’s sole discretion. This document is not considered part of the applicable program documentation. Due to the nature of the product architecture, it may not be possible to safely include all features described in this document without risking significant destabilization of the code.

Purpose:This document provides an overview of features and enhancements included in Oracle E-Business Suite Release 12.1. It is intended solely to help you assess the business benefits of upgrading your existing Oracle Products to Release 12.1, or implementing completely new Oracle developed products, and planning your I.T. Projects.

<Insert Picture Here>

Oracle E-Business Suite Release 12.1.1 Transfer of Information Oracle Enterprise Asset Management Functional Overview

Construction Estimating and Google Maps Integration


Objectives

This session will prepare you to:

• Identify the new functionality included in this release• Learn how to configure the new functionality• Understand any dependencies or interactions• Find additional release information and resources


Agenda

• New Feature• Construction Estimating• Google Maps Integration

• Description• Setup and Process• Dependencies and Interactions• Additional Resources



Construction Estimating


Construction EstimatingDescription

• Construction units are standardized repetitive units of construction work, involving labour, material and equipments.

• This feature enables users to define construction units by grouping activities. Such construction units are further grouped together to define construction estimates and create work orders through an estimating workbench.

• Work order costs are collected and posted for mass addition to create new fixed asset numbers or add value to existing asset numbers. So it not mandatory to have FA Number association with the eAM Asset Number.


Construction EstimatingBusiness Value

• Construction estimating is often used by industries with repetitive element of design, higher planning & scheduling cycles and complex resource requirements.

• This feature will enable the users to define the repetitive elements of design as construction units and perform efficient planning and scheduling using the estimation workbench.

• This feature would be useful to a variety of industries like Utilities/T&D, E&C, Telecom etc. where construction work is routinely carried out.


Construction EstimatingSetup and Process

SETUP STEPS

Profile for Fixed Asset Book

EAM: FA Book Type Code

Routing and BOM defined in the activities

with estimates/ units will explode into resource

and material rows

Select various options of grouping rows for work orders to be generated

Optionally enter defaults for the work orders.

Apply Defaults

Create Construction Estimate by adding construction units/

activities on create page

Navigate to Estimation workbench by pressing

Next button

Create Construction Estimate by selecting

Construction Units from Search page results

Process : Construction Estimating and Creating Work Orders

Optionally update the rows, add new rows for

material / resources

Optionally add or select option to

create parent work order.

Define Difficulty Codes with Resource Multiplier

Create Construction Units by selecting one or

more activities

Generate Work Orders

by using Create Work

Orders button


Construction Estimating Setup – Define Difficulty Codes

Search for the Difficulty Codes based on Code

and Description1

In the same page add or update difficulty

codes 3

Resource Multiplier is a non-zero number which is

multiplied with resources to adjust for extra requirements

due various factors

2


Construction Estimating Setup – Set Profile Options

• EAM: Fixed Asset Book Type Code• This profile will set the Fixed Asset Book for the fixed asset

number created through the work order capitalization form.

Profile Value Description

<User entered book code>

Select the fixed asset book for depreciation from the available books. Book can be setup at the level of Organization or Site. Preference is to the book at Organization level. If there is no book setup at Organization level, book at site level is considered.


• Create Construction Unit• Search Construction Unit • Update Construction Unit• Copy Construction Unit

Construction EstimatingProcess – Construction Units


Construction EstimatingProcess – Create Construction Unit

Click on Create Construction Unit button to open the

create page2

New tab for Construction unit

opens up search page

1


Construction EstimatingProcess – Create Construction Unit

1

2

3

Enter name and description for the construction unit

Enter Activities, Activity Quantity and other details

Press Save / Apply button to save the

records


Construction EstimatingProcess – Search Construction Unit

1

2 4

Search construction unit based on

available options and press Go. Units from other orgs can also be searched.

Copy units to create new construction unit

or create new estimates.

Navigate to update construction unit

pageSelect rows from

results table for Step 3

3


Construction EstimatingProcess – Copy Construction Unit

1Name should be

entered for the construction unit

Rows are defaulted from the selected

construction units. Users can add

more rows

If the activity Is not assigned to this org, this check box will be highlighted. By checking this

box and save, system will assign the activity to the org but not the BOM and routing.

Save / Apply to save records

2 3

4


Construction EstimatingProcess – Update Construction Unit

1

3

Update the name, description. Also by entering Effective Date construction unit will

get end-dated.

Add more rows or end date existing rows.

Save / Apply to save records

2


• Create Construction Estimate• Estimation Workbench• Search Construction Estimate • Copy Construction Estimate

Construction EstimatingProcess – Construction Estimates


Construction EstimatingProcess – Create Construction Estimate

Click on Create Construction

Estimate button to open the create

page

2

New tab for Construction Units,

sub-tab Construction Estimates opens up

search page

1



Enter or select construction unit from the LOV and tab=out. This opens the CU qty box, enter the qty and

tab-out

2

1 Enter name and description for

the construction estimate

Construction unit explode with activity lines. Add activities, difficulty code and accounting class

3

Apply Next to navigate to Estimation Workbench

4


Construction EstimatingProcess – Estimate Workbench

1

Name and description is defaulted from create

page or has to be entered if navigated

through CU search page

Optionally enter values to be

defaulted on the work orders and Apply Defaults

2

3

Select option to group resource

and material rows exploded from activities



1 Work Order Sequence, Work Order, Asset Number and WO Description columns are blank in details region

User selects one of grouping options and optionally enters work

order defaults. After Apply Defaults button is pressed

rows are refreshed WO sequence number

assigned by the system and user entered defaults

2

Users can enter WO number of choice or else system assigns a number when

Create WO button is pressed



1Optionally assign a parent

work order or select the option to create a parent

work order for work orders generated by workbench

Save the data entered to continue later.

Press Create Work Orders to generate

the work orders in the system. Work Order numbers would be

displayed as confirmation else

error messages would be shown.

4

Estimate Costs gives the costs for each work order and the total of all work

orders.3

Select Activities button navigates back to create page to allow addition of

construction units or activities

2


Construction EstimatingProcess – Copy and Update Construction Estimate

Copy button navigates to the estimation workbench. Name

and description are defaulted, users can change

the same. All the rows of source estimate are defaulted

Update button navigates to the estimation workbench


• Find Work Orders• Initiate Capitalization

Construction EstimatingProcess – Capitalization


Construction EstimatingProcess – Find Work Orders (Capitalization)

1

2

Work Orders can be searched by the

Construction Estimates

Press find to execute search

Select work order for capitalization and press Capitalize

Work Order

3


• WIP• Define Maintenance BOM and Routing

• Fixed Assets• Prepare / Post Mass Additions

Construction EstimatingDependencies and Interactions



Google Maps Integration


Google Maps IntegrationDescription

• This feature addresses the integration with the web based source map viewer of Google Maps. eAM assets can be geocoded and displayed on the map viewer based on user entered search criteria.

• The user can select any asset icon on the map viewer, view the Asset’s detail and perform various actions like Work Request/ Work Order creation.


Google Maps Integration Business Value

• The ability to find and view Assets on a map is a key requirement for numerous eAM customers especially those in the Utilities and Public Sector verticals.

• The prime advantage of the 3rd party mapping tool like Google Maps is that users are already familiar with the tool and it comes out with reasonable amount of out-of-box features like map-based services that will help the users service assets more efficiently.


Geocode Assets

SETUP STEPS

Set Profile Options

Google Maps Integration Setup and Process

Select Asset icon

View Asset Details

Asset Details Page

Launch Google Map viewer

Search the Asset using Asset Search Page

Process : Display Assets on Map From Maintenance Super User

Create Work Request

Create Work Order

View Open Work Req

View Open Work Order

View Asset Hierarchy


Google Maps Integration Setup – Set Profile Options

• CSI: Map viewer name• This profile will select the map viewer to enable GIS

Integration.


<null> No Integration

Google Map Enables Integration using Google Map viewer

Custom Enables Integration using Customized Map viewer



• CSI: Google Maps Registration key• This profile will capture the registration key for enabling the

integration using Google Maps


<User entered> User shall enter the Google Maps Registration key



• CSI: Google Maps Client Id• This profile will capture the client Id for integration using

Google Maps


<User entered> User shall enter the Google Maps Client Id



• CSI: Customized Mapviewer class• This profile can be used to specify the fully qualified name

of Java Class for Customized map viewer. • Use this profile when customized map viewer is being

implementedProfile Value Description

<User entered> User shall enter java class name here


Google Maps Integration Setup – Asset Number Geocodes

• Asset Numbers can be optionally geocoded• Latitude and

Longitude information captured in DMS format


Google Maps Integration Setup – Mass Entry of Geocodes

Modify / delete Asset geocodes

Add Asset geocodes


Google Maps Integration Process – Launch Google Map Viewer

Search Assets

Launch Google Map viewer

1

2


Google Maps Integration Process – View Assets on Map and Perform Actions

Select Asset1

Perform Actions

2


Google Maps Integration Dependencies and Interactions

• Google Maps• Customers will have to buy Google Maps license separately.



Additional Resources


Additional Resources

• For more release information on MetaLink• https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocu

ment?p_database_id=NOT&p_id=403259.1• For more information about Oracle Applications

• http://www.oracle.com/applications/home.html• For more information about Education

• http://www.oracle.com/education/index.html• For more information about Support

• http://www.oracle.com/support/• For MetaLink information

• http://metalink.oracle.com/ • For Oracle Product documentation

• http://www.oracle.com/technology/documentation/applications.html

https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=403259.1

https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=403259.1

http://www.oracle.com/applications/home.html

http://www.oracle.com/education/index.html

http://www.oracle.com/support/

http://metalink.oracle.com/

http://www.oracle.com/technology/documentation/applications.html

© 2009 oracle corporation – proprietary and confidential 1 oracle online training materials –...

Documents