EAM: AM Spreadsheet Upload using RECAT Template Results to Calculate Depreciation Process Not Calculating for Half Year (HY) Convention. (Doc ID 3012607.1)

Last updated on APRIL 09, 2024

Applies to:

Symptoms

AM Spreadsheet Upload using RECAT template results to Calculate Depreciation process not calculating for Half Year (HY) convention.  This is after using the Spreadsheet Uploader RECAT template
to recategorize an asset and resume depreciation.  The depreciation calculation uses the Transaction Date instead of the convention (i.e. HY).

Steps to replicate:

  1.  Add a non-depreciable Asset, using Profile LAND.  (Set Up Financials/Supply Chain > Product Related > Asset Management > Profiles > Asset Profiles)
  2.  Run Depreciation Calculation.   (Asset Management > Depreciation > Processing > Calculate Depreciation)
  3.  Recategorize Asset from non-depreciable to depreciable using AM Spreadsheet Template.   (Set Up Financials/Supply Chain > Product Related > Asset Management > Import Spreadsheet Setup > Define AM Spreadsheet Template)
  4.  Generate a Recategorize (RCT) Spreadsheet Template.
  5.  Open the Spreadsheet Template and populate the details including the ‘To Category’ = FF (depreciable). Trans Dt = i.e. 2020/05/20; Acctg Dt = i.e. 2020/05/20.
  6.  Upload the RCT Spreadsheet Data / Run the AM_LOAD process.    (Asset Management > Send/Receive Information > Import Data via Spreadsheet > Upload Spreadsheet Data)
  7.  Load Interface ID into AM (AMIF1000).   (Asset Management > Send/Receive Information > Interface Transactions > Load into AM)
  8.  Run Depreciation Calculation.  (Asset Management > Depreciation > Processing > Calculate Depreciation)
  9.  Review Cost History. Note that re-categorization is successful.   (Asset Management > Asset Transactions > History > Review Cost)
10.  Go to Define Tax/Depr Criteria and make changes suggested:    (Asset Management > Asset Transactions > Financial Transactions > Cost Adjust/Transfer Asset)
         Status = Depreciable
         Convention = Half Year
         Retire Conv = Half Year
         Adjust Conv = Half Year
         Then, Save.
11.  Run Depreciation Calculation.   (Asset Management > Depreciation > Processing > Calculate Depreciation)
12.  Check Asset Depreciation Info:    (Asset Management > Depreciation > Review Depreciation Info > Asset Depreciation)
         In Service Date = i.e. 2020/05/11
         Convention = HY
         Begin Date = i.e. 2020/05/01
         Depr Status = Depreciable

See the attached replication document here.

NOTE: In the <images or examples> <above or below> and/or the attached document, user details / customer name / address / email / telephone number represent a fictitious sample (based up made up data used
in the Product name test environment). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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.