1. HCM Data Loading Business Objects
  2. Guidelines for Loading Time Record Groups

Guidelines for Loading Time Record Groups

A time record group includes related time entries, such as all reported time entries in a weekly time card. You can use HCM Data Loader to load only approved time record groups, meaning historical data. You can't edit time record groups after upload.

This topic describes aspects of the Time Record Group object that you must understand to load time record groups successfully using HCM Data Loader.

Preparing to Load Time Record Groups

Before you can load time record groups:

  • Setup of Oracle Fusion Time and Labor must be complete.

  • Relevant person records, each with a valid worker assignment, must exist in the target environment.

  • A worker time processing profile must exist for each worker whose time card details you're loading. The time processing profile may identify other consumers of the time card data.

    • If Oracle Fusion Global Payroll is a consumer of time card data, then the relevant payroll element entries must exist.

    • If Oracle Fusion Project Costing is a consumer of time card data, then the relevant Project Costing setup data must exist.

You may also need:

  • Time rules, if the data being loaded required validation and calculation

  • A worker time entry profile, if the worker or time and labor manager can view the loaded data in the application

Supplying Keys

The Time Record Group object doesn't support source keys. Therefore, supply user keys when creating time record groups.

Querying Predefined Time Attributes

Predefined time attributes and their data types aren't visible on a user interface. To query time attribute names, use this SQL query:

SELECT ATRB.NAME, ATRB.DISPLAY_NAME, ATRB.CLASS, ATRB.ATTRIBUTE_TYPE
FROM HWM_TM_ATRB_FLDS_VL ATRB
WHERE ATRB.ATTRIBUTE_CATEGORY NOT IN ('TIME_BUILDING_BLOCK', 'TIME_RECORD',
'TIME_RECORD_GROUP');

This table shows example results from this query.

Attribute Name

Attribute Display Name

Attribute Class

Attribute Data Type

PJC_PROJECT_ID

Project

SIMPLE

Number

PayrollTimeType

Payroll Time Type

MASTER

Varchar

Updating Time Record Groups

When updating a time record group, you must supply the complete Time Record Group object in the TimeRecordGroup.dat file, not just the changed records.

Deleting Time Record Groups

You can delete Time Record Group objects using HCM Data Loader only if you identify them using surrogate IDs. When you delete a Time Record Group object, its child components are also deleted. You can't delete individual components of the object. This example TimeRecordGroup.dat file deletes a time record group and its child components. It references the record by its surrogate ID.

METADATA|TimeRecordGroup|TimeRecordGroupId|ResourceId|ResourceType|TcStartTime|TcStopTime|GroupType|SubResourceId
DELETE|TimeRecordGroup|100000001|100000008153756|PERSON|2010/01/04 00:00:01|2010/01/09 23:59:59|RPTD_TIME|100000008154060

To obtain the surrogate IDs of existing objects, use the HCM Data Loader extract Integration Object User Key Map Extract.

Related Topics