Fa-oracle on the non-conventional function of ERP asset module ____oracle

Excerpt from: http://bbs.erp100.com/thread-266444-1-1.html

Title: [Closed post] [sharing knowledge Original series] Oracle ERP Asset Module's unconventional function discussion, a tip [print this page]
Author: chtwo Time: 2013/7/6 20:35
Title: [Closed post] [sharing knowledge Original series] Oracle ERP Asset Module's unconventional function discussion
This article is for "share knowledge original Serial" activity recommend article.
The opening.

Personal Profile: Party B financial Advisor
Serial theme: FA module operation and Related financial knowledge
Release plan: July 8
Planned release in that sector: Oracle ERP Implementation
Update cycle: article/1-2 weeks,
The highlights of this series are: some unconventional functions of the FA module to explore

Speaking of the function is still secondary, ERP or business-oriented. Now the customer demand for management consulting more, more to do the heart more virtual Ah, so it is still here to talk about specific functions. Learning function or more learning industry and professional knowledge is kingly.

Fixed asset module has some functions, the actual implementation is rarely used, so I hope to take this opportunity to test a lot, and share with you. The key point is to think about the design of some of the EBS modules and improve the knowledge of the relevant financial information.

Index:

First article Asset increase
The second piece of asset initial data collation
Third article accelerated depreciation
The third supplementary yield method depreciation
Fourth Paper tax book
Fifth Financial Leasing
Sixth asset group/sub-assets
Seventh Account Builder
PostScript of the eighth article


The content of this paste is tested in 11i environment. Unfortunately there is no R12 environment, but the operation is not very different.


Thank you for your support.




Author: Zongheng Sihai time: 2013/7/6 20:45
Personal Profile: Party B financial advisor.
Serial theme: FA module operation and Related financial knowledge
Release plan: July 8
Planned release in that sector: Oracle ERP Implementation
Update cycle: article/1-2 weeks,
The highlights of this series are: some unconventional functions of the FA module to explore
Other things to say: ERP still needs to be business-oriented. Fixed asset module has some functions, the actual implementation is rarely used. Hope to take this opportunity to test a lot, to think about the EBS some of the module design ideas, but also a deeper understanding of financial knowledge. After all, customers now actually need more management consulting.

About: FA module some use less function this piece I need to study in depth study, look forward to your masterpiece, if you can analyze some design and management ideas will be better;
Author: chtwo Time: 2013/7/6 21:17
Title: "First article" Asset increase
This post was last edited by Chtwo at 2013/7/7 08:17

1. Overview:
The asset increase itself is part of the general operation of the asset module, but for overall integrity, or from the start of an asset increase, this document introduces the direct write table approach to importing assets.

2. Asset Module Management scope
Here, by the way, asset modules are generally used to manage fixed assets, but in the FA module you can manage fixed assets, intangible assets, projects under construction, long-term amortization costs, spare parts, low value consumables, etc. The system is dead, the scheme is alive.

3. New Asset Mode
Mainly includes 3 aspects, manual input, Webadi Import, other module import. In fact, Webadi is the bulk import of data through the write interface. Our introduction is to complete the work of Webadi by way of writing table directly.
During the import process, Webadi will proofread the data a lot, proofread the system standard interface, and then verify the interface data again by submitting the request. From the previous version, Webadi checksum is still less than the standard 1-2 items, Webadi bug is also very inexplicable, in short, very troublesome. (There has been a project, the DBA has been tracking debugging Webadi, found that there is no shutdown after the cursor opened, resulting in a maximum of 500 assets can be imported at a time, very silent)

The Asset System Interface table is relatively simple, with two tables. Fa_mass_additions and Fa_massadd_distributions. Fa_mass_additions is used to store asset information, fa_massadd_distributions to store allocation information. Two tables are associated by mass_addition_id fields. Note Fa_massadd_distributions automatically generates data after writing to the Fa_mass_additions table, and does not need to be written again, but needs to be updated.

4, Method Introduction:
1. Create temporary tables: including two temporary tables, one for storing imported asset data, another for storing checksum error messages;

2. Verify the data: According to the Webadi and system interface logic to check the data, and will be checked to the error table, easy to query.

2.1 Check steps:

1), clear error table data, 2, calculate assets from the beginning of the month to date, 3, calculate the residual value (the data may give a residual value), 4, calculate the cumulative depreciation and depreciation of the year (in the following script are calculated by straight-line method); 5), check data, 6, write error data table;
2.2 Inspection Items:
          1)          asset books exist;       & nbsp   2)          Asset class value exists, combination exists, whether the portfolio is assigned to the asset book        ,   3          Asset key value exists, combination exists           4)       & nbsp;  Asset location value exists, portfolio exists           5)          Employee Presence & nbsp         6)          depreciation accounts exist, depreciation account combinations exist, account is expense type    & nbsp      7)          depreciation method and life span           8          The asset tag number is duplicated in the data, and whether the asset tag exists in the system           9)          Asset model, explanatory elastic domain length check          10)        This year depreciation cannot be greater than the cumulative depreciation       &NBsp  11)        Recent year enabled assets, this year depreciation must be equal to cumulative depreciation          12)         Cumulative depreciation cannot be greater than net asset          13)        View whether the cumulative depreciation variance is large (not mandatory, but the consultant needs to observe whether the cumulative depreciation provided by the customer is abnormal)

3. Update Provisional table 1) modify the data according to the error; 2 for the combination does not exist, you can create a combination through the script, such as the subject combination, the location of the elastic field, etc. 3) again, verify the correct, insert the relevant ID, asset class, keyword, place, depreciation account in the temporary table. households, employees; 4 Update system tables Other necessary fields, Posting_status, queue_name, Payables_units, Feeder_system_name, Inventorial, Asset_type, Payables _cost, create_batch_id, Create_date, create_by
4. To be on the safe side, you need to check again
5. After the successful verification of the standard interface table, write clear the interface table before the fa_mass_additions, pay attention to the unprecedented check data, whether there are other organizations of data.
6. Update interface table Fa_massadd_distributions, note that this is not new;
7. Run System standard request, completion.
5, Accessories: Import scripts and data collection table. You can change them as needed. It's also a good thing to generate a combination ID from a script. It's risky to write a table, be careful.


The following announcement: To write some experience of FA asset data collation. Asset data import after the trouble, before the import in Excel full checksum has a multiplier effect. In the implementation of the project, the focus is to calculate the monthly depreciation of the assets in the Eexel, and the difference between the current monthly depreciation of the customer is large, otherwise it is difficult for the customers to accept the influence of the profit. So in Excel to do a simple simulation, to find the difference in the focus, and fully communicate with customers, or very necessary.

Thank you.

Fa_ asset Import. rar

82.98 KB, download times: 202, Download points: effort-3 points

Scripts and Data templates Author: Vertical Sihai time: 2013/7/7 21:03
Report a friend's feedback: spare parts and low consumption or special system management is better, while under construction, long-term to stand and so on with FA management is a better way, because it can provide more comprehensive information than the accounting subjects. I would like to ask the landlord how to view this statement.

Low-value consumable refers to items in the implements that have the unit value below the stipulated limit or have a short service life (generally within one year). It is similar to fixed assets, in the production process can be used many times do not change its physical form, in use also need to repair, scrap may also have residual value. Because of its low value and short use time, it is easy to apply its value to product cost.
Author: chtwo Time: 2013/7/7 22:56
Heng Sihai published in 2013/7/7 21:03
Report a friend's feedback: spare parts and low consumption or special system management is better, while under construction projects, long-term to be amortized and so on with FA management is better ...
Certainly support this view.

The asset module simply says "Yes" to manage spare parts and low consumption, not optimal. Some customers do not have a dedicated system (or do not need a dedicated system), these asset management requirements are not very high, then you can use the asset module to deal with, simple management under the quantity, status, inventory and other needs. Other modules can also be implemented.
Author: song_godsaybye Time: 2013/7/9 16:08
Study and study author: chtwo Time: 2013/7/10 22:21
This post was last edited by Chtwo at 2013/7/11 23:13

the experience of asset data collation in the second article

I guess I'm going to have to be busy, I have some free time to put up some content as soon as possible and see if I can do the first knot. (Consultant is the life of the bitter, serial posts I always feel that there is a thing not done, ^_^)

It's a surprise to discover that this is not an unconventional operation, but to be consistent, share some experience. The book belongs to the story.

1. Data collection
As for the data collection, the experience of sharing is that the default customer-supplied data is wrong, not too much fantasy.

For the asset module, monthly depreciation is not one of the initialization data, but it is recommended that customers also be provided for the analysis of future system-generated depreciation and current monthly depreciation differences, to avoid online after the customer response too strong.

2. Asset Data Collation
The data collected is always flawed, so the consultant needs to be validated, targeted feedback to the customer to modify, the process may take a lot of time. As a consultant, I personally feel that Excel's ability is necessary, one can be more effective, another point is to close the relationship with customers a way, especially financial advisers. (In some users ' eyes, the consultant is installed the system, even through the network, broken the software, make the hardware, do not know the joy of the sad).

Fixed asset data needs to be validated in the previous article has been introduced, in the process of verifying the previous article, it is best to check in Excel once, and customer communication confirmation. The key points of the checking are two aspects: cumulative depreciation and monthly depreciation, and whether the allocation adjustment should be considered.

3. Verification method
Everyone in the validation of data, there must be their own way, the people of different ways, here to introduce my usual way of verifying, only straight-line method.
Step: Calculate the life-span--> has been used since the start of the asset calculation do not enable the next month depreciation--> calculate the cumulative depreciation--> estimate the difference of the monthly depreciation of the future assets--> estimated by enabling the allocation condition.
When validating data, you can add these secondary columns after the datasheet: The service life, the monthly depreciation 1, the difference 1, the cumulative depreciation, the monthly depreciation 2, the difference 2, whether amortization, monthly depreciation, difference.

3.1 Calculation has enabled life. Here is a key recommended formula: Datedif (date 1, date 2, parameter), parameter is "M", "D", "Y". This formula can directly return the month, day, or year between two dates. (Excel contains several hidden functions for compatibility with lotus1-2-3, which is useful and can be used directly in Excel, but is not found in Help and insert formulas, ^_^).

3.2 Calculate the monthly depreciation of the amortization adjustment. Monthly Depreciation 1 = IF (lifetime >= asset life, 0, (original value-residual value)/asset life);

3.3 Calculates the difference between the monthly depreciation 1 and the monthly depreciation provided by the customer as the difference of 1;

3.4 Calculate cumulative depreciation. Calculates the cumulative depreciation based on the number of years used. IF (Use Life >= asset Life, original value-residual value, original value * monthly depreciation 1);

3.5 Compare the cumulative depreciation difference provided by customers;

3.5 Calculate the amortization adjustment under the monthly depreciation. Monthly Depreciation 2 = IF (lifetime >= asset life, 0, (original value-residual value-user provided cumulative depreciation)/(Asset life-asset lifetime));

3.6 calculates the monthly depreciation difference of 2 and the monthly depreciation provided by the customer, as difference 2;

3.7 to take the difference between the smaller side, as an asset initialization is the basis for the activation of amortization. IF (ABS (difference 1) <=abs (difference 2), "No", "yes");

3.8 Difference small monthly depreciation, as the on-line monthly depreciation, monthly depreciation =if (Enable amortization = "No", monthly depreciation 1, monthly depreciation 2);

3.9 summarize the difference between monthly depreciation and monthly depreciation provided by the customer.

4. Communication and communication. After this verification can be seen, the general assets will not be too big difference, but some of the tail difference. The difference of larger assets, is generally due to the use of assets in the process of adjusting the original value, such as overhaul, to reduce the value of the preparation, such assets need to be amortized adjustment, the activation of amortization adjusted monthly depreciation, the difference is very small.
If the difference is still very large, need and customer understand what causes, how to adjust. After the on-line system depreciation can not intervene, so inform the customer in advance, facilitate the later confirmation.

5. Refer to schedule. Please also share the experience of the data collation process. Thank you.




Next notice: Several depreciation methods will be introduced in the next period. It is mainly accelerated depreciation, such as double balance, the sum of life, and the method of yield. To tie in with the subject, I intend to say a few words about the financial principle of depreciation. I hope you will discuss it actively. Thank you.

Example. xlsx

11.56 KB, download times: 93, Download points: effort-3 points

Validate Asset Data Instance Author: Mondeo Time: 2013/7/12 11:14
Luo, Lu ...
Author: dingding1983 Time: 2013/7/12 14:41
Write very well and learn from you author: chtwo Time: 2013/7/12 23:18
This post was last edited by Chtwo at 2013/7/21 06:38

the third article accelerated depreciation

1. The Concept

A lot has been pulled in front of it, and there is no financial content involved. To tie in with the subject, here is a description of the financial aspects of asset depreciation,