My Oracle Support Banner

EAM: AM Spreadsheet Cost Adjustment Rounding Issue (Doc ID 2721297.1)

Last updated on OCTOBER 26, 2020

Applies to:

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

Symptoms

On : 9.2 version, Accounting Entries

Cost Adjustment Percentages via Spreadsheet Upload Leaves Fractional Pennies


REPLICATION STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Define Spreadsheet Template, accept defaults, download, and save to directory
  2. Validate AM BU Book Definition Round Options = Natural
  3. Validate Open Periods in GL and AM
  4. Add 2 Assets online via Express Add, accept Depreciation attributes default from Profile
  5. Run AM_DEPR_CALC and review Process Monitor for success
  6. Review Cost History online or query
  7. Complete Spreadsheet template—adjust cost by 10% for first asset
  8. Upload Spreadsheet for Cost Adjustment for first asset, review Process Monitor for success, and Message Log for Interface_ID
  9. Load into AM, run AMIF1000 and review Process Monitor for success
  10. Note query INTFC_FIN, shows cost adjustment with 3 decimal places
  11. Adjust second asset online by same 10%
  12. Review cost online, they are the same
  13. Review cost via query—note the behavior difference: Asset adjusted via spreadsheet carries over 3 decimal places; whereas Asset adjusted Online has 2
  14. Run AM_DEPR_CALC and review Process Monitor for success
  15. Review Depreciation online – shows same
  16. Run AMAEDIST to create accounting entries and review Process Monitor for success
  17. Review entries online—note the behavior difference: Asset adjusted via spreadsheet carries over 3 decimal places; whereas Asset adjusted Online has 2

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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