Microapps

Oracle HCM connector specifications

Deploy the Oracle HCM Cloud integration to deliver actionable notifications to item managers about their items, and view and edit items directly in Workspace.

Version Details

Citrix microapps supports the latest Oracle HCM Cloud APIs.

Endpoints

POST

/11.13.18.05/absences
/11.13.18.05/timeRecordEventRequests

GET

/11.13.18.05/absences
/11.13.18.05/absences/{absence_id}/lov/AbsenceTypeVA
/11.12.1.0/emps
/11.13.18.05/workersLov
/11.13.18.05/planBalances
/11.13.18.05/timeCardsLOV/
/11.13.18.05/timeRecords/
/11.13.18.05/legalEmployersLov
/11.13.18.05/publicWorkers
/11.13.18.05/publicWorkers/{person_id}/child/assignments

Service Actions

  • Create Absence - Create a new absence entry.
  • Create Time Entry - Create a new time entry.

Entities with Attributes

The following is a full list of entities and their attributes:

absences

  • absence_case_id: STRING(255)
  • absence_disp_status: STRING(255)
  • absence_entry_basic_flag: BOOLEAN
  • absence_pattern_cd: STRING(255)
  • absence_reason: STRING(255)
  • absence_status_cd: STRING(255)
  • absence_type: STRING(255)
  • absence_type_id: LONG
  • absence_type_reason_id: STRING(255)
  • agreement_id: STRING(255)
  • agreement_name: STRING(255)
  • approval_status_cd: STRING(255)
  • auth_status_update_date: STRING(255)
  • band_dtl_id: STRING(255)
  • blocked_leave_candidate: STRING(255)
  • certification_auth_flag: BOOLEAN
  • child_event_type_cd: STRING(255)
  • comments: STRING(255)
  • condition_start_date: STRING(255)
  • confirmed_date: STRING(255)
  • consumed_by_agreement: STRING(255)
  • created_by: STRING(255)
  • creation_date: TIMESTAMP
  • data_security_person_id: LONG
  • disease_code: STRING(255)
  • duration: INTEGER
  • effective_end_date: DATE
  • effective_start_date: DATE
  • employee_shift_flag: BOOLEAN
  • employer: STRING(255)
  • end_date: DATE
  • end_date_duration: STRING(255)
  • end_date_time: TIMESTAMP
  • end_time: TIME
  • establishment_date: STRING(255)
  • frequency: STRING(255)
  • initial_report_by_id: STRING(255)
  • initial_timely_notify_flag: BOOLEAN
  • last_update_date: TIMESTAMP
  • last_update_login: STRING(255)
  • last_updated_by: STRING(255)
  • late_notify_flag: BOOLEAN
  • legal_entity_id: LONG
  • legislation_code: STRING(255)
  • legislative_data_group_id: LONG
  • notification_date: DATE
  • object_version_number: INTEGER
  • object_version_number_1: INTEGER
  • open_ended_flag: BOOLEAN
  • payment_detail: STRING(255)
  • period_of_incap_to_work_flag: BOOLEAN
  • period_of_service_id: STRING(255)
  • person_absence_entry_id: LONG
  • person_id: LONG
  • person_number: STRING(255)
  • planned_end_date: STRING(255)
  • processing_status: STRING(255)
  • project_id: STRING(255)
  • single_day_flag: BOOLEAN
  • source: STRING(255)
  • spl_condition: STRING(255)
  • start_date: DATE
  • start_date_duration: STRING(255)
  • start_date_time: TIMESTAMP
  • start_time: TIME
  • submitted_date: DATE
  • timeliness_override_date: STRING(255)
  • unit_of_measure: STRING(255)
  • user_mode: STRING(255)

absences_types

  • absence_type_id: LONG
  • absence_type_name: STRING(255)
  • description: STRING(255)
  • person_absence_entry_id: LONG

employees

  • address_line_1: STRING(255)
  • address_line_2: STRING(255)
  • city: STRING(255)
  • country: STRING(255)
  • date_of_birth: DATE
  • display_name: STRING(255)
  • first_name: STRING(255)
  • hire_date: DATE
  • last_name: STRING(255)
  • legal_entity_id: LONG
  • middle_name: STRING(255)
  • name_suffix: STRING(255)
  • person_id: LONG
  • person_number: STRING(255)
  • postal_code: STRING(255)
  • preferred_name: STRING(255)
  • region: STRING(255)
  • region_2: STRING(255)
  • termination_date: STRING(255)
  • user_name: STRING(255)
  • work_email: STRING(255)
  • worker_type: STRING(255)

anytime_notes

  • assignment_id: LONG
  • assignment_name: STRING(255)
  • assignment_number: STRING(255)
  • assignment_primary_flag: BOOLEAN
  • assignment_status_type: STRING(255)
  • assignment_type: STRING(255)
  • business_unit_name: STRING(255)
  • department_name: STRING(255)
  • display_name: STRING(255)
  • grade_name: STRING(255)
  • image_id: STRING(255)
  • image_ovn: STRING(255)
  • job_name: STRING(255)
  • legal_employer_name: STRING(255)
  • list_name: STRING(255)
  • location_name: STRING(255)
  • manager_display_name: STRING(255)
  • manager_list_name: STRING(255)
  • person_id: LONG
  • person_number: INTEGER
  • position_name: STRING(255)
  • username: STRING(255)
  • work_email_address: STRING(255)
  • worker_number: STRING(255)

plan_balances

  • address_line_1: STRING(255)
  • address_line_2: STRING(255)
  • assignment_id: LONG
  • assignment_name: STRING(255)
  • assignment_number: STRING(255)
  • balance_as_of_balance_calculation_date: STRING(255)
  • balance_calculation_date: DATE
  • city: STRING(255)
  • country: STRING(255)
  • date_of_birth: DATE
  • display_name: STRING(255)
  • effective_end_date: DATE
  • effective_start_date: DATE
  • enrollment_end_date: STRING(255)
  • enrollment_start_date: DATE
  • preferred_name: STRING(255)
  • first_name: STRING(255)
  • hire_date: DATE
  • last_name: STRING(255)
  • legal_entity_id: LONG
  • level: STRING(255)
  • middle_name: STRING(255)
  • name_suffix: STRING(255)
  • person_id: LONG
  • person_number: STRING(255)
  • person_plan_enrollment_id: LONG
  • plan_display_status_flag: BOOLEAN
  • plan_enrollment_status: STRING(255)
  • plan_id: LONG
  • plan_name: STRING(255)
  • plan_status: STRING(255)
  • plan_status_meaning: STRING(255)
  • plan_type: STRING(255)
  • plan_unit_of_measure: STRING(255)
  • postal_code: STRING(255)
  • preferred_name: STRING(255)
  • region: STRING(255)
  • region_2: STRING(255)
  • sys_effective_date: DATE
  • termination_date: STRING(255)
  • unit_of_measure_meaning: STRING(255)
  • user_name: STRING(255)
  • work_email: STRING(255)
  • worker_type: STRING(255)

time_cards

  • assignment_number: STRING(255)
  • comment: STRING(255)
  • date_format_pattern: STRING(255)
  • favorite_icon: STRING(255)
  • favorite_name: STRING(255)
  • group_type: STRING(255)
  • parent_time_record_group_id: STRING(255)
  • parent_time_record_group_version: STRING(255)
  • person_id: LONG
  • person_number: STRING(255)
  • start_date: STRING(255)
  • start_time: TIME
  • stop_date: STRING(255)
  • stop_time: TIMESTAMP
  • time_record_group_id: LONG
  • time_record_group_version: INTEGER
  • timecard_period: STRING(255)
  • total_hours: DOUBLE

time_entries

  • assignment_number: STRING(255)
  • comment: STRING(255)
  • earned_date: STRING(255)
  • group_type: STRING(255)
  • measure: DOUBLE
  • overtime_date: STRING(255)
  • person_id: LONG
  • person_number: STRING(255)
  • record_type: STRING(255)
  • person_number: STRING(255)
  • selected_person_id: LONG
  • start_time: TIMESTAMP
  • stop_time: TIMESTAMP
  • time_record_group_id: LONG
  • time_record_group_version: INTEGER
  • time_record_id: LONG
  • time_record_version: INTEGER
  • unit_of_measure: STRING(255)

employers

  • effective_end_date: DATE
  • effective_start_date: DATE
  • legislation_code: STRING(255)
  • name: STRING(255)
  • organization_id: LONG
  • payroll_statutory_unit_id: LONG

public_workers

  • display_name: STRING(255)
  • first_name: STRING(255)
  • honors: STRING(255)
  • known_as: STRING(255)
  • last_name: STRING(255)
  • list_name: STRING(255)
  • middle_names: STRING(255)
  • order_name: STRING(255)
  • person_id: LONG
  • person_number: STRING(255)
  • pre_name_adjunct: STRING(255)
  • suffix: STRING(255)
  • title: STRING(255)
  • username: STRING(255)
  • work_email: STRING(255)

public_worker_assignments

  • assignment_id: LONG
  • assignment_name: STRING(255)
  • assignment_number: STRING(255)
  • business_unit_name: STRING(255)
  • department_name: STRING(255)
  • full_part_time: STRING(255)
  • grade_code: STRING(255)
  • grade_name: STRING(255)
  • internal_building: STRING(255)
  • internal_floor: STRING(255)
  • internal_mailstop: STRING(255)
  • internal_office_number: STRING(255)
  • job_code: STRING(255)
  • job_name: STRING(255)
  • legal_employer_name: STRING(255)
  • length_of_service_days: INTEGER
  • length_of_service_months: INTEGER
  • length_of_service_years: INTEGER
  • location_address_line_1: INTEGER
  • location_address_line_2: STRING(255)
  • location_address_line_3: DATE
  • location_address_line_4: STRING(255)
  • location_code: STRING(255)
  • location_country: STRING(255)
  • location_long_postal_code: STRING(255)
  • location_multi_line_address: STRING(255)
  • location_name: STRING(255)
  • location_postal_code: INTEGER
  • location_region_1: STRING(255)
  • location_region_2: STRING(255)
  • location_region_3: STRING(255)
  • location_single_line_address: STRING(255)
  • location_timezone_code: STRING(255)
  • location_town_or_city: STRING(255)
  • manager_name: STRING(255)
  • position_code: STRING(255)
  • position_name: STRING(255)
  • primary_assignment_flag: BOOLEAN
  • primary_flag: BOOLEAN
  • start_date: DATE
  • work_at_home_flag: BOOLEAN
  • worker_number: STRING(255)
  • worker_type: STRING(255)
Oracle HCM connector specifications