In this post, we will try to see how to load the Cost Allocation Account Information. The Cost Allocation Account can be loaded at multiple levels Job, Position, Organization, Payroll, Payment Method, Assignment, Assignment Terms, Payroll Relationship, Person, Element Entry and Element Link (Element Eligibility) levels.
How the Payroll Costing works is out of scope of this article.. We will try and see how this information can be loaded using HDL..Source Type would be different for costing at each of the above levels.
Table of Contents
Costing levels and the hierarchy:
For more info on payroll costing refer to https://docs.oracle.com/en/cloud/saas/global-human-resources/r13-update18a/faipc/payroll-costing.html#FAIPC1266589
Sample HDL File to load the Cost Allocation Account details:
METADATA|CostAllocationAccountV3|SourceType|ElementLinkName|DepartmentName|JobCode|PositionName|SetCode|PaymentSourceName|PayrollName|Name|AssignmentNumber|PayrollRelationshipNumber|TermNumber|ElementTypeName|MultipleEntryCount|LegislativeDataGroupName|EffectiveDate|SourceSubType|Proportion|SubTypeSequence|ConcatenatedSegment|Segment1|Segment2|Segment3|Segment4|Segment5|GUID|SourceSystemId|SourceSystemOwner MERGE|CostAllocationAccountV3|ORG||DDT_DEPT01|||COMMON|||||||||LDG US|2011/12/31|COST|0.8|1||3|330|1333||210||| MERGE|CostAllocationAccountV3|JOB|||DDT_JOB01_CD||COMMON|||||||||LDG US|2011/12/31|COST|1|1||4|340|1100|1400|240||| MERGE|CostAllocationAccountV3|POS||||DDT_POS01|COMMON|||||||||LDG US|2011/12/31|COST|1|1||5|350|1320|1410|200||| MERGE|CostAllocationAccountV3|PAY|||||||PAY01_TEST|||||||LDG US|2011/12/31|COST|1|1||1|300|1300|1420|||| MERGE|CostAllocationAccountV3|PM||||||DDT_CHECK_PS01||||||||LDG US|2011/12/31|CASH|1|1|81.421.1510.2100.8784|||||||| MERGE|CostAllocationAccountV3|ASG|||||||||ASG_PER01|PER_01||||LDG US|2011/12/31|COST|1|1||||||300||| MERGE|CostAllocationAccountV3|TERM|||||||||ASG_PER01|PER_01||||LDG US|2011/12/31|COST|1|4|||||2102|400||| MERGE|CostAllocationAccountV3|PREL||||||||ASG_PER01_NAME||PER_01||||LDG US|2011/12/31|COST|1|7||||1400|2103|500||| MERGE|CostAllocationAccountV3|AET|||||||||ASG_PER01|PER_01||StdEarning_ASS_OFFSET_TEST Earnings Results||LDG US|2011/12/31|COST|1|10|||330|1410||||| MERGE|CostAllocationAccountV3|TET|||||||||ASG_PER01|PER_01||StdEarning_TEM_001_TEST Earnings Results||LDG US|2011/12/31|COST|1|13||28|340|1420||||| MERGE|CostAllocationAccountV3|PRET||||||||ASG_PER01_NAME||PER_01||VolDeduction_PR_001_TEST Results||LDG US|2011/12/31|COST|1|16||29|350|1431||||| MERGE|CostAllocationAccountV3|EE|||||||||ASG_PER01|PER_01|WT_PER01|StdEarning_ASS_COST_TEST|1|LDG US|2011/12/31|COST|1|1||||||600||| MERGE|CostAllocationAccountV3|EL|StdEarning_ASS_COST|||||||||||||LDG US|2011/12/31|COST|1|1|||100|1200|5000|100|||
Hope this helps when you have requirement to load the Cost Allocation Account information using HDL.
Tip: For more HDL file samples, check out the latest article https://fusionhcmknowledgebase.com/2020/04/sample-hdl-files-for-all-business-objects/
Hello Sricharan,
This website has been really helpful. Thank you for sharing this post with us. I have been working on loading costing for element entries. As pe rmy understanding I need three files ElementEntry, CostAllocationV3, CostAllocationAccountV3. Can I generate all three files using one fast formula or I need to create 3 different fast formulas to generate 3 files. Also, can you share some sample code for fast formula for uploading costing with element entries.
Any help is appreciated.
Thanks,
Gaurav
Hi Gaurav,
Yes. With a single input file having element entry and costing information, we can create three output hdl files using a single transformation formula. It is possible and oracle has provided a sample on how to use multiple business objects in single formula. You can refer that and try to achieve your requirement. I saw someone implemented it successfully on Cloud Customer Connect. However he is not responding to the questions posted on if the sample code can be shared. Try your luck by looking at sample oracle code.
Thanks,
Sricharan