My Oracle Support Banner

Spreadsheet Import Template 'Cost Adjustment By Amount' Doesn't Convert Local Currency Amount (Doc ID 2806856.1)

Last updated on SEPTEMBER 14, 2021

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When adjusting the Cost of the asset with local currency using spreadsheet template, currency conversion got skipped on foreign currency book.
1. Create an asset using express add with AM BU having multi currency books.
2. Review cost history for ADD transaction, the base cost is updated as per base currency of the book.
3. Download the cost adjustment template from Main Menu-> Set Up Financials/Supply Chain>Product Related>Asset Management>Import Spreadsheet Setup>Define AM Spreadsheet Template
4. Provide the Business, Asset ID , Cost , transaction date ,accounting date and rate type in template.
5. Run AM_LOAD process from Main Menu
    Asset Management>Send/Receive Information>Import Data via Spreadsheet>Upload Spreadsheet Data.
6. Run AMIF1000 process from below navigation
     Asset Management>Send/Receive Information>Interface Transactions>Load into AM
7. Review the Cost History.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.