Oracle EBS Asset Definition

First, the asset definition is the project task of the river the material generates asset information in a certain format, where each individual item generates an asset, with the following steps:

1, the province Headquarters inventory Super User system generate picking list, approval picking list, and finally out of the library processing operations formally the material out of the library (the item is sent to the project)

2, the provincial Department of the Project Accounting super users submit cost collection Manager requests and transaction import requests within the system, both requests can generate expense information for the task

3, the provincial Department of the project manager in the Transfer preparation function Select the task that requires an asset definition, and then click the asset definition, the item information on the task will generate the asset information according to the asset format and insert the data into the table Pa_project_assets_all after the second request runs. Where the user material type is independent of the quantity of items generated by the number of assets, the project manager in the maintenance of asset information.

Second, generate asset lines

Project Accountant in the project transfer function Select the task that requires the asset line to be generated, and then click Generate Asset Line, which generates an asset line for each expense on the task and inserts the data into the table Pa_project_asset_lines_all.

III. Allocation of asset lines

Assigning asset line Requests first associates the asset line with the data in the asset table, that is, updating the project_asset_id column in the Asset row table so that the asset has value. The data is also generated in the table Pa_project_asset_line_details, and the Asset Line table and the asset schedule are associated with the project_asset_line_detail_id column Pa_project_asset_line_ The details table can also be used as a way to determine whether the expense generates an asset line

Iv. Transfer of funds

The query SQL starting from the transfer operation is:

SELECT * from Qpa_asset_lines_v qal where qal.project_id=6238 and qal.task_id=281808;