EAM Asset Activity Association Upload  Help

EAM Asset Activity Association Upload creates and updates the associations between an Oracle EAM maintenance activity and an asset group or a specific asset number from Excel, via the standard Oracle EAM public API. It maintains the association attributes (dates, priority, owning department, WIP accounting class, cause/type/source, tagging, flexfields); associations are end-dated rather than deleted.

When to use it

• Mass-associate one or many maintenance activities to asset groups or specific asset numbers instead of doing it one at a time in the form.
• Roll out a standard set of activities across a fleet of assets after defining the activity items.
• Bulk-update association attributes – priority, cause/type/source, owning department, WIP accounting class, shutdown type, tagging.
• Adjust association effective dates in bulk, including end-dating associations that should no longer apply.
• Bulk-maintain the association descriptive flexfield.

Before you start

• Blitz Report is installed and you are signed in to a responsibility with access to an EAM-enabled maintenance organization.
• The activity item exists in the maintenance organization, and the asset group or asset number exists.

Step 1 – Choose a mode, set the parameters and download

In Blitz Report, open EAM Asset Activity Association Upload, choose an Upload Mode (Create, Update – the default – downloads existing associations to edit; Create gives an empty template), and set the parameters:

Run the upload to download and open the Excel file. Each association is automatically handled as a create or an update depending on whether the activity + asset combination already exists.

Step 2 – Enter the associations

On each row enter the Maintenance Organization, the Activity, the Asset Type, and the Asset Group and/or Asset Number. Supplying an Asset Number makes the association instance-specific. Set the From Date/To Date, Priority, Owning Department and WIP Accounting Class as needed.

Step 3 – End-date an association (optional)

To stop an association applying, set its To Date. There is no delete – end-dating is the supported way to retire an association.

Step 4 – Validate and Save

Click Validate and Save. This checks for missing required values and runs the upload’s validation, then saves the file. Correct anything it flags before continuing.

Step 5 – Upload and view the result

Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which creates or updates each association. When it finishes, a result report opens showing each row as success or error.

What’s produced

• Created and updated activity-to-asset associations.
• A result report listing every row with a status (success or error) and a message.

Common questions

How do I delete an association?
You can’t with this upload – the public API has no delete. End-date the association by setting its To Date instead.

What’s the difference between an asset-group and an asset-number association?
An asset-group association applies the activity at the group level; an asset-number association applies it to one specific asset instance. Supplying an Asset Number makes it instance-specific.

I re-uploaded the same rows and they say “No changes detected” – is that an error?
No. The upload compares each field to what’s stored and skips the update when nothing changed.

Which combination decides create vs update?
The activity plus the specific asset group or asset number. If that combination already has an association it’s updated; otherwise it’s created.

My flexfield values won’t validate.
They are validated against the configured association flexfield for the chosen attribute category – pick a valid attribute category first, then values valid for it.

Troubleshooting