Table-Based Depreciation Method Not Enforcing 20% Annual Cap with Custom Fiscal Year Logic

Summary:

Table-Based Depreciation Method Not Enforcing 20% Annual Cap with Custom Fiscal Year Logic

Content (please ensure you mask any confidential information):

We have a unique business requirement for asset depreciation in Oracle Fusion Assets that involves a custom depreciation pattern based on fiscal years and government limits.

Business Requirement Summary:

Asset Life: 5 years (60 months)

Depreciation Method: Straight-line but with custom fiscal year logic

Government Cap: Annual depreciation cannot exceed 20% of original asset cost

Fiscal Year: July to June

Custom Depreciation Pattern:

First Fiscal Year:

Depreciate exactly 10% of original asset cost, prorated by months in service during the fiscal year.

For example, if an asset is placed in service halfway through the fiscal year, the 10% amount is spread across those months only (not exceeding 10% total).