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
Copied!
Failed!