EAM Asset Attribute Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Create and update Oracle Enterprise Asset Management asset attribute values, the attribute group values of an asset or rebuildable number.

Attribute groups are assigned to an asset group (Enterprise Asset Management: Asset Groups, Attributes) and their values are entered per asset number in the Asset Attributes window. Each row uploads one attribute group of one asset number, so an asset with several attribute groups has one row per group.

The attribute columns follow the flexfield segments of the selected attribute group: Attribute 1-20 hold the character segments, Number Attribute 1-10 the number segments and Date Attribute 1-10 the date segments.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Upload Mode, Organization, Asset Number From, Asset Number To, Asset Group, Attribute Group

Oracle EBS Tables Used

mtl_eam_asset_attr_values, mtl_eam_asset_numbers_all_v

Report Categories

Enginatics, Upload

INV Item Upload 11i, EAM Asset Number Upload, EAM Work Orders 11i

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Example
Blitz Report™ XML Import EAM_Asset_Attribute_Upload.xml
SQL Source EAM Asset Attribute Upload.sql
Full Report on Enginatics www.enginatics.com/reports/eam-asset-attribute-upload/

Case Study & Technical Analysis: EAM Asset Attribute Upload

Executive Summary

This upload creates and updates the attribute group values of Oracle Enterprise Asset Management (EAM) assets and rebuildable numbers. Maintenance planners and asset administrators use it to enter the descriptive attributes of many assets in one spreadsheet, rather than opening the Asset Attributes window for each asset. The file is worked in Excel through Blitz Report™ in Create, Update mode, so existing values are downloaded and changed in place.

Business Challenge

The Solution

Technical Architecture (High Level)

Primary Tables

Logical Relationships

  1. Each asset number in MTL_EAM_ASSET_NUMBERS_ALL_V is joined to its attribute values on the inventory item identifier and the serial number.
  2. The attribute category of each value row defines its attribute group, which is returned through the flexfield context display function under application identifier 401 for the table MTL_EAM_ASSET_ATTR_VALUES.
  3. Each character attribute column is passed through the flexfield value display function together with its segment name, so that value sets and meanings are resolved.
  4. Number and date attribute columns are returned directly from the value table.
  5. Rows carry blank action, status, message and modified-column columns, which the upload framework uses to record the outcome of each change.

Parameters & Filtering

Performance & Optimization

FAQ

Q: How are multiple attribute groups for one asset entered? A: Each attribute group of an asset is one row, so an asset with several attribute groups has one row for each group, identified by the Attribute Group column.

Q: Which columns hold the attribute values? A: Character values use Attribute 1 to 20, numbers use Number Attribute 1 to 10, and dates use Date Attribute 1 to 10, following the segments of the selected attribute group.

Q: Can this upload be used to create a new asset? A: No, the upload works on the attribute values of existing asset numbers, which are identified by organization and asset number.

© Enginatics GmbH