PA Project Asset Upload creates, updates and deletes the capital assets defined on an Oracle Projects capital project – and optionally their asset-to-task assignments – from Excel, via the standard Oracle public API. It maintains the project asset records; it does not capitalize them.
When to use it
- Bulk-load estimated capital assets onto capital projects early in the project lifecycle.
- Record as-built capital assets before capitalization.
- Mass-assign capital assets to project tasks (top-task rollup or leaf-task assignments).
- Maintain asset attributes (description, category, book, location, units, estimated cost, identification, flexfields) across many assets.
- Add or remove asset-to-task assignments in bulk.
Before you start
- Blitz Report is installed and you are signed in to a responsibility with access to the operating unit and project.
- A capital project already exists in the target operating unit.
- The FA classification values you reference (book, asset category, asset key, location, depreciation account, parent asset) and any assignment tasks already exist.
Step 1 – Choose a mode, set the parameters and download
In Blitz Report, open PA Project Asset Upload, choose an Upload Mode (Create for an empty template, or Create, Update to download existing project assets), and set the parameters:
| Parameter | Purpose |
|---|---|
| Upload Mode | Create or Create, Update. Default is Create. |
| Operating Unit | The operating unit (required); filters the project list. |
| Project Number | The capital project whose assets are uploaded (required). |
Run the upload to download and open the Excel file. Each asset is automatically handled as a create or an update depending on whether it already exists.
Step 2 – Enter the assets
On each row enter the Project Number, Asset Name, Description and Asset Type (Estimated or As-Built), and the FA classification (Book, Asset Category, Location), dates, units and cost. To also create an asset-to-task assignment, fill the Assignment Task Number (repeat the asset on extra rows for multiple task assignments).
Step 3 – Delete assignments (optional)
To remove an asset’s assignment to a task, set Delete Assignment to Yes on its row.
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 asset and maintains its assignments. When it finishes, a result report opens showing each row as success or error.
What’s produced
- Created and updated project assets with their task assignments.
- A result report listing every row with a status (success or error) and a message.
Common questions
Does this capitalize the assets or create FA assets?
No. It defines and maintains the project asset records and their task assignments only. Capitalization is a separate process.
How do I create an asset with no task assignment?
Leave the Assignment Task Number blank on the row – only the asset header is created/updated.
How do I assign one asset to several tasks?
Repeat the asset’s columns on multiple rows, each with a different Assignment Task Number.
How do I change an existing assignment’s attributes?
You can’t update an assignment in place – set Delete Assignment = Yes on one row, then add it again on another row with the new values.
What asset types can I load?
Only Estimated and As-Built.
Why doesn’t the depreciation account I expect appear?
The account list is the project’s ledger chart of accounts (expense accounts only); accounts from other ledgers aren’t offered.
Troubleshooting
| Message | Cause | What to do |
|---|---|---|
| Invalid Asset Category / Asset Key / Location | The KFF value doesn’t match an enabled FA flexfield combination. | Pick from the column’s list; the Asset Category list is filtered by the chosen Book. |
| Invalid Depreciation Expense Account | The account isn’t a valid, enabled expense account in the project’s ledger. | Choose from the account list (scoped to the project’s ledger and to expense accounts). |
| Rollup = Yes requires the task to be a top task | Rollup = Yes was set on a task that is not a top task. | Use a top task for rollup, or leave Rollup blank for a leaf-task assignment. |
| Failed to create/update project asset (API error) | The underlying API rejected the data (dates, units, book/category combination, etc.). | Read the API message, correct the field and re-upload. |
| Assignment to task not found (nothing to delete) | Delete Assignment = Yes but no such assignment exists. | Informational – remove the Delete flag if not intended. |