Assets Analysis in the Oracle E-Business Suite

The standard assets analysis in ORACLE© Assets was upgraded to reflect the commonly used assets analysis (according to HGB - German Commercial Code). The following changes were implemented: The depreciation allowance was divided into 3 columns:

1st column:
Receipts (includes all depreciation, current receipts or assets which depreciated at a normal rate)

2nd column:
Debits (includes all depreciation of assets which have been debited in the current fiscal year)

3rd column:
Transfers (includes the depreciation of assets which were transferred from one asset category to another)

In the course of this itemization, the design of the asset analysis was modified to match the German standard. We made a change by including three further segment qualifiers (in addition to company segment, cost centre segment, and account segment). Due to this implementation, the asset analysis can be performed not just for the asset group and company, but also for these new qualifiers, which can be set to any arbitrary segment of the user-defined accounting field. Furthermore, there is the option of expanding in-house asset reports by this qualifier (which can also be applied to standard reports).

Technical Implementation
Technical implementation is carried out via a de-normalized table. This table has transaction-specific (receipts, debits, etc.) programs (SQL*Plus report set processes) and contains the basis for ORACLE© Reports, which merely formats and sums the data. The programs can be run individually, at any time and as needed. This results in a very transparent and easily-maintained construct. The base table is well suited as the foundation for further customer-specific adaptations.