Get all roles

get

/hcmRestApi/resources/11.13.18.05/emps/{empsUniqID}/child/roles

Request

Path Parameters
  • This is the hash key of the attributes which make up the composite key for the (emps) resource and used to uniquely identify an instance of (emps). The client should not generate the hash key value. Instead, the client should query on the (emps) collection resource in order to navigate to a specific instance of (emps) to get the hash key.
Query Parameters
  • This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2

    Format: <attr1>=<val1>,<attr2>=<value2>
  • When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
  • This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.

    Format: ?fields=Attribute1,Attribute2

    Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2
  • Used as a predefined finder to search the collection.

    Format ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>

    The following are the available finder names and corresponding finder variables

    • PrimaryKey Finds all employee roles that match the primary key criteria specified.
      Finder Variables
      • RoleGUID; string; Globally unique identifier for the employee role in Oracle Fusion.
    • findByRoleGUIDAndStartDate Finds all worker roles that match the start date and unique identifier.
      Finder Variables
      • RoleGUID; string; Globally unique identifier for the employee role in Oracle Fusion.
      • StartDate; string; Start date for the worker role.
  • This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
  • This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>

    Example:
    self,canonical
  • Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
  • The resource item payload will be filtered in order to contain only data (no links section, for example).
  • This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
  • This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY

    Format: ?q=expression1;expression2

    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • AsgResponsibilityId; integer; Primary key autogenerated by the application.
    • AssignmentId; integer; Internal identifier for the assignment.
    • PersonId; integer; Internal unique identifier for the person.
    • ResponsibilityName; string; Name of an area of responsibility.
    • ResponsibilityTypeCode; string; Identifier of the responsibility type for which this record holds the criteria. The value is validated against HCM_LOOKUPS with the lookup type PER_RESPONSIBILITY_TYPES.
    • ResponsibilityTypeName; string; Name of the responsibility type for which this record holds the criteria. For example, Benefits Representative.


    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • CreationDate; string; Date and time of creation of the employee role record.
    • EndDate; string; End date of the role.
    • LastUpdateDate; string; Date and time of update of the employee role record.
    • RoleCommonName; string; Short name of the role.
    • RoleGUID; string; Globally unique identifier for the role record in Oracle Cloud. Valid values are defined in the list RoleGUIDLOV.
    • RoleName; string; Name of the role.
    • StartDate; string; Start date of the role.


    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • EnabledFlag; string
    • EndDateActive; string
    • StartDateActive; string
    • _ID_FLEX_NUM; integer
    • _PEOPLE_GROUP_ID; integer


    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • AddressLine1; string; First line of the primary mailing address.
    • AddressLine2; string; Second line of the primary mailing address.
    • AddressLine3; string; Third line of the primary mailing address.
    • CitizenshipId; integer; Primary key autogenerated by the application.
    • CitizenshipLegislationCode; string; Legislation code derived from the legal entity. Valid values are defined in the list CitizenshipLegislationCodeLOV.
    • CitizenshipStatus; string; Status of the person's citizenship. Valid values are defined in the list CitizenshipStatusLOV.
    • CitizenshipToDate; string; End date of citizenship.
    • City; string; Town or city in which the address is located.
    • CorrespondenceLanguage; string; Preferred language for communication. Valid values are defined in the list CorrespondenceLanguageLOV.
    • Country; string; Country in which the address is located.
    • CreationDate; string; Date and time of creation of the employee record.
    • DateOfBirth; string; Date of birth of the person.
    • DisplayName; string; Person's display name.
    • DriversLicenseExpirationDate; string; Expiration date of the driver's license.
    • DriversLicenseId; integer; System-generated primary key. Surrogate key.
    • DriversLicenseIssuingCountry; string; Country that issued the driver's license.
    • EffectiveStartDate; string; Date at the beginning of the period within which the employee is effective.
    • Ethnicity; string; Person's ethnicity for the legislation code. Valid values are defined in the list EthnicityLOV.
    • FirstName; string; Person's first name.
    • Gender; string; Person's gender. Valid values are defined in the list GenderLOV.
    • HireDate; string; Hire date of the employee.
    • HomeFaxAreaCode; string; Area code of the phone number for the home fax machine.
    • HomeFaxCountryCode; string; Country code of the phone number for the home fax machine.
    • HomeFaxExtension; string; Extension of the phone number for the home fax machine.
    • HomeFaxLegislationCode; string; Legislation code of the home fax number.
    • HomeFaxNumber; string; Phone number for the home fax machine.
    • HomePhoneAreaCode; string; Area code of the home phone number.
    • HomePhoneCountryCode; string; Country code of the home phone number.
    • HomePhoneExtension; string; Extension of the home phone number.
    • HomePhoneLegislationCode; string; Legislation code of the home phone number.
    • HomePhoneNumber; string; Home phone number.
    • Honors; string; Higher qualification appended to a person's name. For example, PhD.
    • LastName; string; Person's last name.
    • LastUpdateDate; string; Date and time of update of the employee record.
    • LicenseNumber; string; Person's driving license number.
    • MaritalStatus; string; Person's marital status. Valid values are defined in the list MaritalStatusLOV.
    • MiddleName; string; Person's middle name.
    • MilitaryVetStatus; string; Indicates whether the person is on military service. Valid values are defined in the list MilitaryVetStatusLOV.
    • NameSuffix; string; Part of the name appended to a person's last name.
    • NationalId; string; Primary key autogenerated by the application.
    • NationalIdCountry; string; Country of nationality.
    • NationalIdExpirationDate; string; Expiration date of the national identifier.
    • NationalIdPlaceOfIssue; string; Place where the national identifier was issued.
    • NationalIdType; string; Type of national identifier. Valid values are defined in the list NationalIdTypeLOV.
    • PassportExpirationDate; string; Expiration date of the passport.
    • PassportId; integer; Primary key autogenerated by the application.
    • PassportIssueDate; string; Date of issue of passport.
    • PassportIssuingCountry; string; Country that issued the passport.
    • PassportNumber; string; Person's passport number.
    • PersonId; integer; Internal unique identifier for the person.
    • PersonNumber; string; Number assigned to a person to identify the person uniquely. Doesn't depend on the person type (employee, contingent worker, and so on). Search on this attribute isn't case sensitive.
    • PostalCode; string; Postal code of the address.
    • PreferredName; string; Person's preferred first name.
    • PreviousLastName; string; Previous last name of the person, if any.
    • ProjectedTerminationDate; string; Projected termination date for the worker.
    • Region; string; Primary region in which the address is located.
    • Region2; string; Secondary region within the primary region.
    • Religion; string; Person's religion. Valid values are defined in the list ReligionLOV.
    • ReligionId; integer; Primary key autogenerated by the application.
    • Salutation; string; Person salutation such as Mr., Ms., and so on. Valid values are defined in the list SalutationLOV.
    • TerminationDate; string; Termination date of the employee.
    • UserName; string; User name for the record. This value is optional and is automatically generated if not specified. Also works with UsernameMatching attribute. Search on this attribute isn't case sensitive.
    • WorkEmail; string; Person's work email address. Search on this attribute isn't case sensitive.
    • WorkFaxAreaCode; string; Area code of the phone number for the work fax machine.
    • WorkFaxCountryCode; string; Country code of the phone number for the work fax machine.
    • WorkFaxExtension; string; Extension of the phone number for the work fax machine.
    • WorkFaxLegislationCode; string; Legislation code of the work fax number.
    • WorkFaxNumber; string; Phone number for the home fax machine.
    • WorkMobilePhoneAreaCode; string; Area code of the work mobile phone number.
    • WorkMobilePhoneCountryCode; string; Country code of the work mobile phone number.
    • WorkMobilePhoneExtension; string; Extension of the work mobile phone number.
    • WorkMobilePhoneLegislationCode; string; Legislation code of the work mobile phone number.
    • WorkMobilePhoneNumber; string; Work mobile phone number.
    • WorkPhoneAreaCode; string; Area code of the work phone number.
    • WorkPhoneCountryCode; string; Country code of the work phone number, such as 39 for Italy.
    • WorkPhoneExtension; string; Extension of the work phone number.
    • WorkPhoneLegislationCode; string; Legislation code of the work phone number.
    • WorkPhoneNumber; string; Work phone number.
    • WorkerType; string; Primary type of a worker such as employee (E), contingent worker (C), pending worker (P), or nonworker (N). This is a read-only attribute as indicated in the describe metadata.


    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • EffectiveStartDate; string; Date at the beginning of the period within which the employee direct report is effective.
    • FullName; string; Full name of the manager.
    • ManagerId; integer; Internal identifier for the manager.
    • PersonId; integer; Internal unique identifier for the person.


    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • AssignmentId; integer
    • AssignmentType; string
    • EffectiveEndDate; string
    • EffectiveLatestChange; string
    • EffectiveSequence; integer
    • EffectiveStartDate; string
    • __FLEX_Context; string
    • __FLEX_Context_DisplayValue; string


    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • ActionCode; string; Action performed on a particular record, such as Hire, Add Pending Worker, Manager Change, and so on. Valid values are defined in the list ActionCodeLOV.
    • ActionReasonCode; string; User-defined code for the action reason. Specifies the reason for the action performed on the record. Valid values are defined in the list ActionReasonCodeLOV.
    • ActualTerminationDate; string; Actual date of termination of employment. This is required during termination, when the TerminateWorkRelationshipFlag is set to Y.
    • AssignmentCategory; string; User-defined category such as Full-Time Permanent or Part-Time Permanent. Valid values are defined in the list AssignmentCategoryLOV.
    • AssignmentId; integer; Unique identifier for the assignment. This is a primary key generated by the application.
    • AssignmentName; string; Name of the assignment.
    • AssignmentNumber; string; Unique identifier for the assignment or terms. Valid for workers and nonworkers.
    • AssignmentProjectedEndDate; string; Date on which the assignment is expected to end.
    • AssignmentStatus; string; HR status of the assignment, such as Active or Inactive. Valid values are defined in the list AssignmentStatusLOV.
    • AssignmentStatusTypeId; integer; Unique identifier for the user-defined assignment status. Valid values are defined in the list AssignmentStatusTypeIdLOV.
    • BusinessUnitId; integer; Unique identifier for the business unit. Valid values are defined in the list BusinessUnitIdLOV.
    • CreationDate; string; Date and time of creation of the employee assignment record.
    • DepartmentId; integer; Unique identifier for the department. Valid values are defined in the list DepartmentIdLOV.
    • EffectiveEndDate; string; Date at the end of the period within which the employee assignment is effective.
    • EffectiveStartDate; string; Date at the beginning of the period within which the employee assignment is effective.
    • EndTime; string; Work day normal end time.
    • Frequency; string; Frequency of normal working hours such as week, month, year. Valid values are defined in the list FrequencyLOV.
    • FullPartTime; string; Indicates whether the position the employee is hired for is full-time or part-time. Valid values are defined in the list FullPartTimeLOV.
    • GradeId; integer; Unique identifier for the grade. Valid values are defined in the list GradeIdLOV.
    • GradeLadderId; integer; Unique identifier for the grade ladder.
    • JobId; integer; Unique identifier for the job. Valid values are defined in the list JobIdLOV.
    • LastUpdateDate; string; Date and time of update of the employee assignment record.
    • LegalEntityId; integer; Unique identifier for the legal entity.
    • LocationId; integer; Unique identifier for the location. Valid values are defined in the list LocationIdLOV.
    • ManagerAssignmentId; integer; Identifier for the manager's assignment.
    • ManagerId; integer; Unique identifier for a manager. Valid values are defined in the list ManagerIdLOV.
    • ManagerType; string; Role of the manager with regards to the overall organization structure. For example, functional, project leader, and so on.
    • OriginalHireDate; string; Original date of hire for employment.
    • PeopleGroup; string; People group represented as a concatenated value of all the related key flexfield segments.
    • PeriodOfServiceId; integer; Primary key autogenerated by the application.
    • PersonTypeId; integer; Unique identifier for the person type. Valid values are defined in the list PersonTypeIdLOV.
    • PositionId; integer; Unique identifier for a position. Valid values are defined in the list PositionIdLOV.
    • PrimaryAssignmentFlag; boolean; Indicates whether the current assignment is the primary assignment. Valid values are Yes and No.
    • PrimaryWorkRelationFlag; boolean; Indicates whether the current work relationship is primary. Valid values are Yes and No.
    • PrimaryWorkTermsFlag; boolean; Indicates whether the current employment terms are primary. Valid values are Yes and No.
    • ProbationPeriodEndDate; string; End date of the probation period.
    • ProbationPeriodLength; number; Duration of the probation period.
    • ProbationPeriodUnitOfMeasure; string; Units for the probation period duration. Valid values are defined in the list QUALIFYING_UNITS.
    • ProjectedStartDate; string; Proposed start date for the pending worker.
    • ProposedPersonTypeId; string; Unique identifier for the worker class. This value is valid only if the PersonTypeId is Pending Worker. It can be any of the employee or contingent worker types. Valid values are defined in the list ProposedPersonTypeIdLOV.
    • RegularTemporary; string; Indicates whether the position the employee is hired for is regular or temporary. Valid values are defined in the list RegularTemporaryLOV.
    • SalaryAmount; number; Salary amount entered based on the salary frequency.
    • SalaryBasisId; integer; Identifier for the set of details linked to a worker's base pay. It identifies the payroll characteristics used to pay base earnings, the duration for which base pay is quoted, the factor used to annualize base pay, any components used to attribute base pay adjustments to different reasons, and any associated grade rate for salary validation. Valid values are defined in the list SalaryBasisIdLOV.
    • SalaryCode; string; Identifies whether the assignment is paid by the hour or by a salary. Either maintained at the assignment level or employment or placement terms but not both. Valid values are defined in the list SalaryCodeLOV.
    • StartTime; string; Work day normal start time.
    • TermsEffectiveStartDate; string; Date at the beginning of the period within which the employee term is effective.
    • WorkTaxAddressId; integer; Unique identifier for the address that's used for taxation purposes. This can be different from a mailing address. Valid values are defined in the list WorkTaxAddressIdLOV.
    • WorkerCategory; string; Category of the worker such as Blue Collar, Civil Servant, and so on. Valid values are defined in the list WorkerCategoryLOV.
    • WorkingAsManager; string; Indicates whether the person is a manager. Valid values are Yes and No.
    • WorkingAtHome; string; Indicates whether the person is working at home. Valid values are Yes and No.
    • WorkingHours; number; Normal working hours.


    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • CreationDate; string; Date and time of creation of the employee visa record.
    • LastUpdateDate; string; Date and time of update of the employee visa record.
    • VisaPermitCountry; string; Country for which visa or permit is valid. Valid values are defined in the list IssuingCountryLOV.
    • VisaPermitExpiration; string; Expiration date of visa or permit.
    • VisaPermitId; integer; Primary key autogenerated by the application.
    • VisaPermitNumber; string; Visa or permit number.
    • VisaPermitType; string; Visa or permit type. Valid values are defined in the list VisaPermitTypeLOV.


    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • Image; string; Unique location of the image. Encrypted version of the file.
    • ImageId; integer; Primary key autogenerated by the application.
    • ImageName; string; Name of the image.
    • ObjectVersionNumber; integer; Used to implement optimistic locking. This number is incremented every time a row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
    • PersonId; integer; Person associated with the image. Foreign key to PER_ALL_PEOPLE_F.
    • PrimaryFlag; boolean; Indicates whether the image is primary.
  • The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.

There's no request body for this operation.

Back to Top

Response

Supported Media Types

Default Response

The following table describes the default response for this task.
Headers
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Body ()
Root Schema : emps-roles
Type: object
Show Source
Nested Schema : Items
Type: array
Title: Items
The items in the collection.
Show Source
Nested Schema : emps-roles-item-response
Type: object
Show Source
Back to Top

Examples

The following example shows how to retrieve all the employee roles by submitting a GET request on the REST resource using cURL.

curl -i -u "<username>:<password>" -X GET https://<host>:<port>/hcmRestApi/resources/11.13.18.05/emps/000200000069ACED00057372000D6A6176612E73716C2E4461746514FA46683F3566970200007872000E6A6176612E7574696C2E44617465686A81014B597419030000787200106A6176612E6C616E672E4F626A656374000000000000000000000078707708000000E3C95EA800780000000EACED00057708000110F07AE74780/child/roles

Example of Response Header

The following shows an example of the response header.

Status: HTTP/1.1 200 OK
Content-Type : application/json

Example of Response Body

The following example shows the contents of the response body in JSON format.

{
  "RoleName" : "Employee",
  "RoleCommonName" : "PER_EMPLOYEE_ABSTRACT",
  "RoleGUID" : "40C4AE052EC2582286A6A0FB1514656C",
  "StartDate" : "2013-01-01",
  "EndDate" : null,
  "CreationDate" : "2009-05-12T11:27:38-08:00",
  "LastUpdateDate" : "2016-03-08T17:14:06-08:00",
  "links" : [4]
     0:  {...
        ...}
  },
  {
  "RoleName" : "Line Manager",
  "RoleCommonName" : "ORA_PER_LINE_MANAGER_ABSTRACT",
  "RoleGUID" : "05E9F3576995F83E74EB3818FDCA8639",
  "StartDate" : "2012-05-01",
  "EndDate" : null,
  "CreationDate" : "2013-12-22T23:26:14-07:00",
  "LastUpdateDate" : "2016-03-29T11:44:24-07:00",
  "links" : [4]
     0:  {...
        ...}
}
Back to Top