Perform a Mass Retirement Using an Integrated Workbook
This example shows how to retire multiple assets by cost by entering retirement information in a spreadsheet and uploading the information to Oracle Assets.
This example shows a cost retirement, but you can also perform a mass retirement by units.
Enter Mass Retirement Information
-
On the Assets page, click the Retire Assets in Spreadsheet panel tab.
-
On the Enter Mass Retirement dialog box window, select OPS CORP in the Book field
-
In the Transaction Type field, select Retirement.
-
Click Next.
-
Click the Open with option and select Microsoft Office Excel.
-
Click OK.
-
Click Yes.
-
Enter your sign in information and click Sign In.
-
On the Manage Mass Retirements spreadsheet, enter New Mass Retirements in the Batch Name field.
-
On the Manage Mass Retirements spreadsheet, complete the fields as shown in the following table:
Field
Value 1
Value 2
Interface Line Number
1
2
Asset Number
0011
0012
Asset Description (If necessary, double click in the Description field to make the value appear.)
Desk
Chair
Posting Status
Post
Post
Retire Date
JAN-31-13
JAN-31-13
Cost Retired
1200
500
Retirement Convention
MID-MONTH
MID-MONTH
-
Click Save and Post Transactions.