Example of Loading a Recurring Element Entry With an Open End Date along with Costing Information
Lisa Jones is posted to a project location where there is no company provided accommodation available. Hence, the company provided her a housing allowance of 2000 per pay period.
This element entry is costed to the cost center Company Head Quarters for which the Cost Center value is 100 and Funding Source is 200.
Load the element entry details for Lisa, as shown in this table:
Attribute |
Value |
---|---|
Legislative Data Group |
Vision Corp |
Element Name |
Housing Allowance |
Assignment Number |
E3141464 |
Start Date |
01-Apr-2019 |
Cost Center |
100 |
Funding Source |
200 |
Load the element entry values, as shown in these tables:
Attribute |
Value |
---|---|
Legislative Data Group |
Vision Corp |
Element Name |
Housing Allowance |
Assignment Number |
E3141464 |
Start Date |
01-Apr-2019 |
Input Value Name |
Amount |
Screen Entry Value |
1000 |
This ElementEntryWithCosting.dat file creates the element entry values with costing information.
METADATA|ElementEntryWithCosting|SourceSystemOwner|SourceSystemId|ElementName|EffectiveStartDate|EffectiveEndDate|AssignmentId(SourceSystemId)|EntryType|CreateEntrySequence|InputValueName1|ScreenEntryValue1|InputValueName2|ScreenEntryValue2|Segment1|Segment2|Segment3|Segment4|Segment5|Segment6|Segment7|Segment8
MERGE|ElementEntryWithCosting|VISION|E3141464_HSEALW_190401|Housing Allowance|2019/04/01||E3141464|E|1|Amount|1000||200|100|
Let's assume that you're loading an ElementEntryWithCosting.dat
file to create
50 element entries. The HCM Data Loader application loads the valid
element entries. However, some of the 50 element entries fail. You
correct the underlying issue and now need to submit the load process
again to load the previously failed records.
On the Import and Load Data page, select your data set and select the Element Entry With Costing business object within it. Click Submit to submit the process with an action of Load. If you're using HCM Spreadsheet Data Loader, click Upload to submit previously failed records. If you import the file again after supplying the user keys, you'll get new element entries, provided the element type supports multiple entries in a period.
You're recommended to supply source keys when using HCM Data Loader. The source key can then be used to identify the element entry, entry value, or costing record when you want to maintain or delete it.
For the load to be successful, the costing segment value must be active as on the load date.