根据项目比例分摊任务成本.docx

Split task amount by project
Step 1 : change the cost allocation method to ‘ Client extension’ from Capital information option when you define new project

Step 2: Modify the code from backend by SQL tool (this is key step).
Here is the code you need to look at:
Body template PAPGALCB.pls
Specification template PAPGALCS.pls
Package pa_client_extn_gen_asset_lines
Procedure client_asset_assignment
Another procedure need to be reviewed : pa_client_extn_asset_alloc.ASSET_ALLOC_BASIS
For ex:
From the Task ID on asset line, you can get the asset assignments on the task
You can then pick the project assets based on your rules to allocate the cost and the amount you want to allocate to each projecT_asset_id
For ex: Asset Line amount is 100, and you want to allocate to two assets A1(60%),A2(40%) on a task.
Based on your rules you can calculate the amount to be allocated to each asset and assign the amounts.
We basically populate the p_asset_basis_table (pl/sql table) which is an out variable in the extension procedure.
Allocation extension will validate if the total amount = sum(amounts allocated to indvidual assets)

Step 3: Define allocation rules by selecting client extension basis method as following

Source

Target

Offset

No matter what project / task you specify , the system will get customized source/target/offset in step 2
Step 4 : Capital Project and generate asset line

When you capital asset , the customized allocation rule was selected to split task raw cost . then you can generate asset line by clicking Generate button.