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

Last updated on JUNE 17, 2022

Applies to:

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

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