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.

Note: This example shows a cost retirement, but you can also perform a mass retirement by units.

Enter Mass Retirement Information

  1. On the Assets page, click the Retire Assets in Spreadsheet panel tab.

  2. On the Enter Mass Retirement dialog box window, select OPS CORP in the Book field

  3. In the Transaction Type field, select Retirement.

  4. Click Next.

  5. Click the Open with option and select Microsoft Office Excel.

  6. Click OK.

  7. Click Yes.

  8. Enter your sign in information and click Sign In.

  9. On the Manage Mass Retirements spreadsheet, enter New Mass Retirements in the Batch Name field.

  10. 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

  11. Click Save and Post Transactions.