The PRC: Generate Asset Lines process generates summary asset lines for a single project or capital event, or a range of projects.

Determining CIP or RWIP Accounting

You must create the final accounting for costs in Oracle Subledger Accounting before you can generate asset lines for the costs. To create the final accounting, run the process PRC: Create Accounting in final mode before you run the process to generate asset lines.

The generate asset lines process uses the final accounting from Oracle Subledger Accounting to determine the CIP or RWIP accounts for asset lines. This approach ensures that Oracle Projects interfaces the final CIP or RWIP accounts to Oracle Assets.

The generate asset lines process uses the predefined post-accounting programs that Oracle Projects provides in Oracle Subledger Accounting to obtain final CIP or RWIP accounts from Oracle Subledger Accounting. If you define journal line types for Oracle Subledger Accounting that use different accounting classes, then you must add these accounting classes to the post-accounting program assignments. For additional information about the post-accounting programs, see: Implementing Oracle Project Costing, Oracle Projects Implementation Guide.

Calculating Reporting Currency Amounts

The generate asset lines process calculates reporting currency amounts for asset lines. The generate process calculates reporting currency amounts using one of two methods, depending upon where the transactions were accounted. The methods are as follows:

• Transactions accounted in Oracle Subledger Accounting: The process obtains the reporting currency amounts from Oracle Subledger Accounting.

• Transactions accounted in non-Oracle external systems and imported into Oracle Projects: The process calculates the reporting currency amounts using currency conversion information from Oracle General Ledger.

About Unassigned Asset Lines

The Generate Asset Lines process attempts to assign an asset to each line it generates. If the process is unable to assign an asset to a generated line (perhaps because a task is assigned to multiple assets), Oracle Projects lists UNASSIGNED in the Asset Name column of the report. You can then assign an asset to the line manually.

To minimize the number of unassigned asset lines, try the following:

• Define an asset cost allocation method for each project to automatically allocate unassigned asset lines to one or more assets. See: Allocating Asset Costs.

• Use the Asset Assignment extension to explicitly designate the assets you want to assign to specific tasks.

• After you manually assign an asset to a line, run the Interface Assets process before you run Generate Asset Lines again. If you do not run Interface Assets first, your assignments will be lost when you run Generate Asset Lines, and the lines will again be listed as UNASSIGNED. See: Interface Assets.

Overriding Asset Lines

You can use the Asset Assignment extension to override existing asset assignments.

Prerequisites

Before you run the process, perform the following steps:

1. Cost the transactions by running the following processes:

   • PRC: Distribute Labor Costs (if you use the Standing costing method to generate labor costs)

   • PRC: Process Payroll Actuals (if you use the Actual costing method to distribute labor costs)

   • PRC: Distribute Expense Report Adjustments

   • PRC: Distribute Usage and Miscellaneous Costs

   • PRC: Distribute Supplier Cost Adjustments

   • PRC: Interface Supplier Costs

   • PRC: Distribute Total Burdened Costs (required if you are capitalizing burdened costs and you capture burden cost on the same expenditure item)

   • 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.

2. Run the Update Project Summary Amounts process so you can see the total expense and CIP/RWIP amounts in the Capital Projects Summary window.

3. If you use periodic or manual capital events to group project assets and costs, then process the events. For more information, see: Creating Capital Events

Process Submission

To submit the process for all projects, submit the PRC: Generate Asset Lines for a Range of Projects process from the Submit Request window.

To submit the process for a single project or capital event, submit the PRC: Generate Asset Lines for a Single Project process from the Submit Request window.

See: Submitting Requests.

You can submit the process as part of a streamline process. For information about streamline processes, see: Submitting Streamline Processes.

When you submit this process, Oracle Projects calls the following extensions:

• Asset Lines Processing Extension. You can use this extension to automatically create project assets (capital assets and retirement adjustment assets) and asset assignments.

• CIP Account Override Extension. This extension enables you to override the CIP account associated with an asset line and specify a different account for posting CIP clearing amounts.

Process Parameters

From Project Number / To Project Number. If you are submitting the Generate Asset Lines for a Range of Projects process, enter the range of project numbers that you want to include. See: Entering a Project Number Range Parameter.

Project Number. If you are using the Generate Asset Lines for a Single Project process, enter a project number.

Date Placed in Service Through. Enter the in service/retirement date up through which you want to process assets. Asset lines will be generated from assets with an actual date placed in service/retirement date before and including this date only.

Include Common Tasks? Enter Yes to generate asset lines for costs associated with tasks with a Common Costs grouping level type. See: Specifying Grouping Level Types.

PA Through Date. Enter the last day of the PA period through which you want to include costs.

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 following table.

Capital Event Number. To process only assets and costs that are associated with a single capital event, enter a capital event number.

Reports

The Generate Asset Lines process automatically runs the Generate Asset Lines Report, which includes the sections Generate Asset Lines Exceptions, Reverse and Interface Exceptions, and Generate Asset Lines.

Some lines may display UNASSIGNED in the Asset Names column. For more information, see: About Unassigned Lines.

These reports show amounts in the project currency.

• The Generate Asset Lines Exception Report. This section shows asset lines that were not created for a project, and the reason each one was rejected. Rejection reasons include the following:

  • The project has no asset assignments

  • The project has no assets with valid in service dates

  • The project has no eligible costs to process

  • The project status does not allow this action

• Reverse and Interface Exceptions. The Reverse and Interface Exceptions Report shows reversing lines that were rejected during the Assets Interface process.

• Generate Asset Lines. This section displays the following:

  • The sum and count of reversed lines

  • The sum and count of generated lines

  • A subtotal for each project

  • The overall total for the generation run