Friday May 29, 2015

Depreciation Calculation Considerations in Fixed Assets

There are many variables that can affect the depreciation calculation for an asset.  Some of the basic variables include: 

  • Cost Financial Inquiry
  • Depreciation method
  • Date Placed in Service (DPIS)
  • Prorate convention
  • Prorate date

You can view these variables for an asset via the Financial Inquiry form and make changes to these via the Asset Workbench / Books form.

Additional factors in the calculation of depreciation for an asset include:

  • Specifics of the depreciation method
  • Depreciation calendar
  • Depreciate when placed in service flag
  • Dividing depreciation evenly or by days
  • Other specifics of the prorate convention
  • Prorate calendar

Some of the factors that seem to cause more confusion than others surround the allocation (divide evenly or by days) setting on the Book Controls form and the the prorate information.

If the book is set to divide depreciation evenly, the annual depreciation for the assets will be divided evenly over the number of periods in the fiscal year.  If the book is set to divide daily, the annual depreciation will be divided based on the number of days of the periods in the fiscal year, with the amount of depreciation varying in each period.  For sample calculations of depreciation using "Divide Depreciation By Days" (the less common scenario), review the Depreciation Methods White Paper found in Fixed Assets Depreciation Methods and Calculations With Examples (Doc ID 1179655.1).  There are a number of examples using different parameters, starting on page 25.  Look for those that use "Depreciation Allocation" = "Daily."

For prorates, the prorate calendar determines the number of prorate periods in your fiscal year.  The depreciation program uses the prorate calendar to determine the prorate period, which is used to determine the annual depreciation amount.  The prorate convention is used to determine how much depreciation to take in the first and last years of the asset's life.  Together with the date placed in service (DPIS), the prorate convention helps to determine the prorate date.  For example, if you use a prorate convention with a defined period of 1-JUN-2015 to 30-JUN-2015 and a corresponding prorate date of 30-JUN-2015, an asset with a DPIS of 16-JUN-2015 will start depreciating in the current month of June.  If the prorate convention, instead, is set to a defined period of 1-JUN-2015 to 30-JUN-2015 with a prorate date of 01-JUL-2015, an asset with a DPIS of 16-JUN-2015 will start depreciating in the following month of July.  Thus, the prorate date is tied to the DPIS, but the DPIS might not be when the asset starts depreciating.  Examples of varying prorate setups can be found in the white paper in The Wonderful World of Prorate Conventions White Paper (Doc ID 115323.1) 

Thursday Apr 03, 2014

New Log Analyzer for Depreciation Error Logs

We have a new depreciation error log analyzer for Fixed Assets.  This new tool can be found in the document:  Log Inspector: Assets Depreciation (FADEPR) Terminated in Error (Doc ID 1626908.1).  When your depreciation process has terminated in error, you can use this tool to explore possible causes and find solutions. The Log Inspector will step you through the process. 

When you first view the Log Inspector document, you can select the link to view a short presentation about the use of the tool.  When you are ready to access the tool, you first select your release 12.0.x, 12.1.x, or 12.2.x.  Then select "Next."

The Log Inspector presents the second screen to you.  You will paste the contents of your depreciation error log file into the blank entry field.  When you select "Next," the Inspector will process the information provided to obtain a possible solution.

Error log

In this example, the depreciation error log was pasted into the Log Inspector's window, "Next" was selected, and the Inspector returned a solution:


The next time you encounter an error when running the depreciation process, consider utilizing the Log Inspector for analysis of the issue.  


Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected



« November 2015