The Generate Asset Lines process creates summarized asset lines for capital assets and retirement adjustment assets.
For capital assets, the process generates capital asset lines only from capitalizable expenditure items on tasks that are assigned to a capital asset with an actual date placed in service.
For retirement adjustment assets, the process generates retirement adjustment asset lines only from expenditure items on tasks that are marked as Retirement Cost tasks, and are assigned to a retirement adjustment asset with a defined retirement date.
Oracle Projects creates asset lines based on the asset grouping level you choose within a project and the CIP grouping method you designate for the corresponding project type. The grouping level represents the WBS level at which you assign assets or group common costs.
You determine the grouping level by assigning assets to a WBS component (for example, the project, a top task, or a lowest task), or by designating a WBS component as a grouping level for common costs. For more information on grouping levels, see: Asset Summary and Detail Grouping Options.
The CIP grouping method determines how Oracle Projects summarizes asset costs within an asset grouping level. For example, you can choose to summarize asset costs by expenditure type or expenditure category. For more information on specifying a grouping method, see: Project Types, Oracle Projects Implementation Guide.
The AutoAccounting rules you define for CIP and RWIP costs also influence the amount of summarization. Oracle Projects creates asset lines by summarizing by grouping level, grouping method, and CIP/RWIP account.
If you define your own detailed accounting rules in Oracle Subledger Accounting, then Oracle Subledger Accounting overwrites default accounts, or individual segments of accounts, that Oracle Projects derives using AutoAccounting. The generate asset lines process uses final accounting from Oracle Subledger Accounting to determine the CIP or RWIP accounts for asset lines. To obtain CIP or RWIP account information from Oracle Subledger Accounting, the generate asset lines process uses information from the predefined post-accounting programs that Oracle Projects provides in Oracle Subledger Accounting. For additional information on the post-accounting programs, see: Implementing Oracle Project Costing, Oracle Projects Implementation Guide.
Note: The generate asset lines process obtains the CIP or RWIP accounts from the cost distribution lines in Oracle Projects, and not from Oracle Subledger Accounting, in the following two situations:
The Interface Costs to GL option for the type of cost is set to No in Oracle Projects implementation options.
You import costs from an external non-Oracle system into Oracle Projects as accounted costs. As a result, Oracle Projects does not generate accounting events or create accounting for these costs.
When more than one asset is assigned to a grouping level or common costs are entered for a project, you must define an asset allocation method if you want Oracle Projects to automatically assign all asset costs to assets. Otherwise, you must manually assign any unassigned or common costs. For information on defining an asset allocation method, see Allocating Asset Costs.
The following table describes how Oracle Projects maps costs to assets:
| Number of assets assigned to a grouping level | Expected results after running Generate Asset Lines process |
|---|---|
| One asset assigned to a grouping level | All detail costs charged to that level are automatically mapped to that asset. |
| More than one asset assigned to a grouping level, only one asset is placed in service | If the asset allocation method specified for the project has a value of None, then Oracle Projects generates asset lines for all costs, but does not assign an asset to the asset lines. If the asset allocation method is other than None, then Oracle Projects generates asset lines for the grouping level. However, costs are allocated and assigned only to the assets being placed in service. When you use the Asset Assignment client extension to assign asset lines, Oracle Projects assigns the assets placed in service, as well as assets without an in-service date, to the asset lines. |
| The cost distribution is for purchased goods from a purchase order which has an inventory item with a default asset category | Costs are mapped to the single asset that matches the default asset category for that grouping level. |
| More than one asset has the same asset category as the default asset category for a purchased item | When the asset allocation method specified for the project has a value other than None, Oracle Projects creates asset lines, and allocates costs and assigns assets having the same default asset category to the asset lines. When the asset allocation method has a value of None, the assets are not assigned automatically. |
The generate asset lines process calculates reporting currency amounts for asset lines. For information on the generate asset lines process, see: Generate Asset Lines.
For example, assume you assign one asset to a capital project at the project grouping level. As shown in the following table, you charge the following expenditure items to the project, all of which are capitalizable and charged to the same CIP account:
| Expenditure Type | Expenditure Category | Amount |
|---|---|---|
| Supplies | Operating | 5,000.00 |
| Supplies | Operating | 20,000.00 |
| Professional | Labor | 5,800.00 |
| Clerical | Labor | 1,500.00 |
| Computer | Service Center | 14,000.00 |
| Meals | Travel | 300.00 |
| Lodging | Travel | 500.00 |
| Air Travel | Travel | 900.00 |
| Miscellaneous | Operating | 5,000.00 |
| Total Costs | 53,000.00 |
If you use a grouping method of Expenditure Category, Oracle Projects creates the asset lines shown in the following table:
| Asset Lines | Amount |
|---|---|
| Labor | 7,300.00 |
| Operating | 30,000.00 |
| Service Center | 14,000.00 |
| Travel | 1,700.00 |
If you use a grouping method of Expenditure Type, Oracle Projects creates the asset lines shown in the following table:
| Asset Lines | Amount |
|---|---|
| Air Travel | 900.00 |
| Clerical | 1,500.00 |
| Computer | 14,000.00 |
| Lodging | 500.00 |
| Meals | 300.00 |
| Miscellaneous | 5,000.00 |
| Professional | 5,800.00 |
| Supplies | 25,000.00 |
If you use a grouping method of All, Oracle Projects creates a single asset line for the total cost amount of 53,000.00.
Note: If expenditures are accounted to separate CIP accounts, then Oracle Projects summarizes the asset lines by CIP account, even when the grouping method is All. Oracle Projects creates asset lines by summarizing by grouping level, grouping method, and CIP/RWIP account.
Prerequisites:
Before you run the Generate Asset Lines process, cost the transactions by running the following processes:
PRC: Distribute Labor Costs
PRC: Interface Supplier Costs
PRC: Distribute Expense Report Adjustments
PRC: Distribute Usage and Miscellaneous Costs
PRC: Distribute Supplier Cost Adjustments
PRC: Distribute Total Burdened Costs (always required if you are capitalizing burdened costs)
PRC: Create and Distribute Burden Transactions (required if you are capitalizing burdened costs and you capture burden as a separate expenditure item)
PRC: Generate Cost Accounting Events
Note: You must run this process for each process category for which you have costs. Alternatively, you can leave the Process Category parameter blank to generate accounting events for all costs.
PRC: Create Accounting
Note: You must run this process for each process category for which you have costs. Alternatively, you can leave the Process Category parameter blank to create accounting events for all costs.
Attention: You must run the process PRC: Create Accounting in final mode for the expenditure items before you run the process PRC: Generate Asset Lines. The generate process does not create asset lines for the costs if the corresponding expenditure items are not successfully accounted in final mode.
Run the Update Project Summary Amounts process so you can see the total expensed, CIP, and RWIP amounts in the Capital Projects window.
You can generate asset lines for a single project or capital event, and for a range of projects.
Attention: You must create accounting for the costs in final mode before you can generate asset lines for the costs.
To generate summary asset lines for a single project or capital event
Navigate to the Capital Projects or Capital Events window.
For capital events, select either the Capital Project Events Workbench or the Retirement Cost Events Workbench to continue.
Find and select a capital project or capital event for which you want to generate asset lines.
Choose the Generate button.
Enter the Asset Date Through. Oracle Projects creates asset lines from assets with an actual date placed in service/retirement date before and including this date only.
For PA Through Date, enter the last day of the PA period through which you want the costs to be considered for capitalization.
If you enter a date that falls within the PA period, the process uses the period ending date of the preceding period. If the date you enter is the end date of a period, the process uses the end date of that period, as shown in the example in the following table:
| Period | Start Date | End Date | You enter... | The process uses... |
|---|---|---|---|---|
| P1 | 07-Jun-99 | 13-Jun-99 | 19-Jun-99 | 13-Jun-99 |
| P2 | 14-Jun-99 | 20-Jun-99 | 20-Jun-99 | 20-Jun-99 |
Choose Include Common Tasks, if you want to create asset lines from costs assigned to a grouping level type of Common Cost.
Choose OK to submit the Generate Asset Lines process. Oracle Projects creates asset lines for your project or event and runs the Generate Asset Lines Report.
Review the Generate Asset Lines Report. See: Generate Asset Lines Report.
You can also generate asset lines for a single project or capital event by submitting the PRC: Generate Asset Lines for a Single Project process from the Submit Request window.
To generate summary asset lines for a range of projects:
Choose the PRC: Generate Asset Lines for a Range of Projects process in the Submit Request window. In the Parameters window, enter a project or range of projects, date placed in service/retirement date through, and PA through date. Also indicate if you want to include common tasks. Choose Submit to generate asset lines and run the Generate Asset Lines Report. Review the report to verify the creation of asset lines.