1. Implementing Assets
  2. Create a Location Mapping

Create a Location Mapping

Follow these steps to create a location mapping using either the Update Fixed Assets Configuration spreadsheet or the Export/Import service.

Create a Location Mapping Using the Update Fixed Assets Configuration Spreadsheet

  1. Navigate to the Setup and Maintenance page.

  2. Search for the task Update Fixed Assets Configuration in Spreadsheet and download the spreadsheet.

  3. Select the Location Mapping worksheet.

  4. For an Assets location, enter either an HR location code or a customer site.

    Note: Enter two separate rows to map an asset location to both an HR location and a customer location, because each row can map to only one type of location.

  5. Upload the generated .csv file in the File Export Import page.

  6. Run the Upload Fixed Assets Configuration process from the Scheduled Processes page.

Create a Location Mapping Using the Export/Import Service

  1. Navigate to the Setup and Maintenance page and select the Financials offering.

  2. Select the Fixed Assets functional area.

  3. On the View menu, select Columns and then Actions.
  4. Search for the Manage Asset Locations task.

  5. On the Actions menu, select Export to CSV File select Create New, and download the Manage Asset Locations .zip file.

  6. Edit the ORA_FA_ASSET_LOCATION_TO_HR_LOCATION_MAPPING.csv file and enter the Assets location and HR codes, or Assets location and party site number and ID, and compress the file.

  7. From the Actions menu, click Import From CSV File and select Create New.

  8. Browse and attach the .zip file and click Submit.