How do we get the management hierarchy for a user?
You can get the management hierarchy for a user by setting the RecordSet filter to 'ORA_MYMANAGERANDPEERS'. You need to make multiple API calls to get the results for the specific user as follows:
- "Get all" the resource users using:
https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsersResponse Body
{ "items": [ { "ResourceProfileId": 300100173505525, "PartyName": "autouisadminchat38 svc", "LastUpdateDate": "2018-12-03T22:57:27.447+00:00", "LastUpdatedBy": "FUSION", "CreationDate": "2018-12-03T22:57:18.527+00:00", "CreatedBy": "FUSION", "ResourceType": "INDIVIDUAL", "FormattedAddress": null, "TimezoneCode": null, "Username": "autouisadminchat38", "City": null, "Country": null, "PostalCode": null, "UpdateFlag": "true", "DeleteFlag": "false", "ResourceOrgRoleCode": null, "ResourceOrgRoleName": null, "FirstName": "autouisadminchat38", "LastName": "svc", "MiddleName": null, "Title": null, "ResourcePartyNumber": "CDRM_828596", "State": null, "ResourceEmail": "autouisadminchat38.svc@oracle.com", "WorkPhoneCountryCode": null, "RawWorkPhoneNumber": null, "MobilePhoneCountryCode": null, "RawMobilePhoneNumber": null, "FaxCountryCode": null, "RawFaxNumber": null, "AddressLine1": null, "AddressLine2": null, "ResourceStartDate": "2018-12-03", "ResourceEndDate": "4712-12-31", "ResourcePartyId": 300100173505516, "ResourceOrganizationName": null, "ResourceOrganizationUsage": null, "ResourceOrgMemRoleEndDate": null, "ResourceParentOrganizationName": null, "ResourceOrgManagerEmail": null, "ResourceManagerName": null, "ResourceManagerFirstName": null, "ResourceManagerLastName": null, "HRManagerEmailAddress": null, "HireDate": "2018-12-03", "ResourceOrgMemRoleStartDate": null, "IndividualRoleCode": "SALES_ADMINISTRATOR", "IndividualRoleStartDate": "2018-12-03", "IndividualRoleEndDate": "4712-12-31", "ResourceManagerPartyNumber": null, "County": null, "Province": null, "ResourceManagerPartyId": null, "TopResourceFlag": null, "PersonNumber": "955160008191324", "BusinessUnit": "Vision Financial Services (USA)", "LegalEntity": "Vision Corp - Canada", "JobCode": null, "JobTitle": null, "UserStatus": "A", "PersonType": "EMP", "CreateUserAccountFlag": null, "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596", "name": "resourceUsers", "kind": "item", "properties": { "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000009770400000009737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000027371007E0002000000027371007E0002000000057372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C71007E000871007E00087371007E00020000000171007E000871007E000878" } }, { "rel": "canonical", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596", "name": "resourceUsers", "kind": "item" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596/lov/BusinessUnitLOV", "name": "BusinessUnitLOV", "kind": "collection" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596/lov/LegalEmployerLOV", "name": "LegalEmployerLOV", "kind": "collection" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596/lov/MobilePhoneCountryCodeVA", "name": "MobilePhoneCountryCodeVA", "kind": "collection" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596/lov/ResourceRoleCodeLOV", "name": "ResourceRoleCodeLOV", "kind": "collection" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596/lov/YesNoLookupForTopResourceFlag", "name": "YesNoLookupForTopResourceFlag", "kind": "collection" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596/lov/CreateUserAccountFlagLOV", "name": "CreateUserAccountFlagLOV", "kind": "collection" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596/lov/TimezoneCodeLOV", "name": "TimezoneCodeLOV", "kind": "collection" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596/lov/WorkPhoneCountryCodeVA", "name": "WorkPhoneCountryCodeVA", "kind": "collection" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596/lov/JobCodeLOV", "name": "JobCodeLOV", "kind": "collection" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596/lov/FaxCountryCodeVA", "name": "FaxCountryCodeVA", "kind": "collection" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596/lov/PersonTypeLOV", "name": "PersonTypeLOV", "kind": "collection" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596/lov/TitleLOV", "name": "TitleLOV", "kind": "collection" }, { "rel": "child", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resourceUsers/CDRM_828596/child/ResourceRoleAssign", "name": "ResourceRoleAssign", "kind": "collection" } ] }, . . . { "ResourceProfileId": 300100149755960, "PartyName": "autobucsr6 svc", "LastUpdateDate": "2018-03-21T13:13:09.203+00:00", "LastUpdatedBy": "FUSION", "CreationDate": "2018-03-21T13:09:19.191+00:00", "CreatedBy": "FUSION", "ResourceType": "INDIVIDUAL", "FormattedAddress": null, "TimezoneCode": null, "Username": "autobucsr6", "City": null, "Country": null, "PostalCode": null, "UpdateFlag": "true", "DeleteFlag": "false", "ResourceOrgRoleCode": "SERVICE_REPRESENTATIVE", "ResourceOrgRoleName": "Service Representative", "FirstName": "autobucsr6", "LastName": "svc", "MiddleName": null, "Title": null, "ResourcePartyNumber": "CDRM_738680", "State": null, "ResourceEmail": "sendmail-test-discard@oracle.com", "WorkPhoneCountryCode": null, "RawWorkPhoneNumber": null, "MobilePhoneCountryCode": null, "RawMobilePhoneNumber": null, "FaxCountryCode": null, "RawFaxNumber": null, "AddressLine1": null, "AddressLine2": null, "ResourceStartDate": "2018-03-21", "ResourceEndDate": "4712-12-31", "ResourcePartyId": 300100149755952, "ResourceOrganizationName": "CRM Service Organization_6", "ResourceOrganizationUsage": "RESOURCE_ORGANIZATION", "ResourceOrgMemRoleEndDate": "4712-12-31", "ResourceParentOrganizationName": "CRM Service Organization_6", "ResourceOrgManagerEmail": "sendmail-test-discard@oracle.com", "ResourceManagerName": "automisrhdmgr1 svc", "ResourceManagerFirstName": "automisrhdmgr1", "ResourceManagerLastName": "svc", "HRManagerEmailAddress": null, "HireDate": "2018-03-21", "ResourceOrgMemRoleStartDate": "2018-03-21", "IndividualRoleCode": "SERVICE_REPRESENTATIVE", "IndividualRoleStartDate": "2018-03-21", "IndividualRoleEndDate": "4712-12-31", "ResourceManagerPartyNumber": "CDRM_842731", "County": null, "Province": null, "ResourceManagerPartyId": 300100176773204, "TopResourceFlag": null, "PersonNumber": "955160008190113", "BusinessUnit": "ABC Operations", "LegalEntity": "Vision Corp - Canada", "JobCode": null, "JobTitle": null, "UserStatus": "A", "PersonType": "EMP", "CreateUserAccountFlag": null, ... - Choose a user who has a value for ResourceOrganizationName and use the "Get a
resource" operation to get the PrimaryOrganization details using:
https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_738680Response Body
{ "ResourceProfileId": 300100149755960, "PartyId": 300100149755952, "PartyName": "autobucsr6 svc", "PartyNumber": "CDRM_738680", "StartDateActive": "2018-03-21", "EndDateActive": "4712-12-31", "LastUpdateDate": "2018-03-21T13:13:09.203+00:00", "LastUpdatedBy": "FUSION", "CreationDate": "2018-03-21T13:09:19.191+00:00", "CreatedBy": "FUSION", "LastUpdateLogin": "67EBBA3FF5683314E0534280F50A4BB7", "ResourceType": "INDIVIDUAL", "PrimaryOrganization": "CRM Service Organization_6", "EmailAddress": "sendmail-test-discard@oracle.com", "FormattedAddress": null, "FormattedPhoneNumber": null, "Usage": "HR Employee", "Manager": "automisrhdmgr1 svc", "Url": null, "JobMeaning": null, "Username": "autobucsr6", "PersonFirstName": "autobucsr6", "PersonLastName": "svc", "PersonLastNamePrefix": null, "PersonMiddleName": null, "PersonNameSuffix": null, "PersonPreNameAdjunct": null, "PersonPreviousLastName": null, "PersonSecondLastName": null, "ManagerPartyId": 300100176773204, "RecordSet": null, "UpdateFlag": "false", "DeleteFlag": "false", "ResourceOrgRoleCode": "SERVICE_REPRESENTATIVE", "ResourceOrgRoleName": "Service Representative", "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_738680", "name": "resources", "kind": "item", "properties": { "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000378" } }, { "rel": "canonical", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_738680", "name": "resources", "kind": "item" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_738680/lov/SearchFilters", "name": "SearchFilters", "kind": "collection" }, { "rel": "child", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_738680/child/PictureAttachment", "name": "PictureAttachment", "kind": "collection" } ] } - Now, use the PrimraryOrganization as query parameter and find all the managers
and peers in this organization
using:
https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources?q=PrimaryOrganization=CRM Service Organization_6Response Body
{ "items": [ { "ResourceProfileId": 300100176801280, "PartyId": 300100176801274, "PartyName": "automisrhdagent2 svc", "PartyNumber": "CDRM_842737", "StartDateActive": "2019-03-05", "EndDateActive": "4712-12-31", "LastUpdateDate": "2020-06-01T14:16:52.021+00:00", "LastUpdatedBy": "FUSION_APPS_HCM_SOA_SPML_APPID", "CreationDate": "2019-03-05T15:54:54.594+00:00", "CreatedBy": "FUSION", "LastUpdateLogin": "A4F2BFB6253CFA51E0533DFDF40AA672", "ResourceType": "INDIVIDUAL", "PrimaryOrganization": "CRM Service Organization_6", "EmailAddress": "sendmail-test-discard@oracle.com", "FormattedAddress": null, "FormattedPhoneNumber": null, "Usage": "HR Employee", "Manager": "automisrhdmgr1 svc", "Url": null, "JobMeaning": null, "Username": "automisrhdagent2", "PersonFirstName": "automisrhdagent2", "PersonLastName": "svc", "PersonLastNamePrefix": null, "PersonMiddleName": null, "PersonNameSuffix": null, "PersonPreNameAdjunct": null, "PersonPreviousLastName": null, "PersonSecondLastName": null, "ManagerPartyId": 300100176773204, "RecordSet": null, "UpdateFlag": "false", "DeleteFlag": "false", "ResourceOrgRoleCode": "SERVICE_ADMINISTRATOR", "ResourceOrgRoleName": "Service Administrator", "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_842737", "name": "resources", "kind": "item", "properties": { "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000378" } }, { "rel": "canonical", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_842737", "name": "resources", "kind": "item" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_842737/lov/SearchFilters", "name": "SearchFilters", "kind": "collection" }, { "rel": "child", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_842737/child/PictureAttachment", "name": "PictureAttachment", "kind": "collection" } ] }, { "ResourceProfileId": 300100149755960, "PartyId": 300100149755952, "PartyName": "autobucsr6 svc", "PartyNumber": "CDRM_738680", "StartDateActive": "2018-03-21", "EndDateActive": "4712-12-31", "LastUpdateDate": "2018-03-21T13:13:09.203+00:00", "LastUpdatedBy": "FUSION", "CreationDate": "2018-03-21T13:09:19.191+00:00", "CreatedBy": "FUSION", "LastUpdateLogin": "67EBBA3FF5683314E0534280F50A4BB7", "ResourceType": "INDIVIDUAL", "PrimaryOrganization": "CRM Service Organization_6", "EmailAddress": "sendmail-test-discard@oracle.com", "FormattedAddress": null, "FormattedPhoneNumber": null, "Usage": "HR Employee", "Manager": "automisrhdmgr1 svc", "Url": null, "JobMeaning": null, "Username": "autobucsr6", "PersonFirstName": "autobucsr6", "PersonLastName": "svc", "PersonLastNamePrefix": null, "PersonMiddleName": null, "PersonNameSuffix": null, "PersonPreNameAdjunct": null, "PersonPreviousLastName": null, "PersonSecondLastName": null, "ManagerPartyId": 300100176773204, "RecordSet": null, "UpdateFlag": "false", "DeleteFlag": "false", "ResourceOrgRoleCode": "SERVICE_REPRESENTATIVE", "ResourceOrgRoleName": "Service Representative", "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_738680", "name": "resources", "kind": "item", "properties": { "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000378" } }, { "rel": "canonical", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_738680", "name": "resources", "kind": "item" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_738680/lov/SearchFilters", "name": "SearchFilters", "kind": "collection" }, { "rel": "child", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_738680/child/PictureAttachment", "name": "PictureAttachment", "kind": "collection" } ] }, { "ResourceProfileId": 300100176802970, "PartyId": 300100176802964, "PartyName": "automisrhdqueue1 svc", "PartyNumber": "CDRM_842739", "StartDateActive": "2019-03-05", "EndDateActive": "4712-12-31", "LastUpdateDate": "2020-06-01T14:21:20.022+00:00", "LastUpdatedBy": "FUSION_APPS_HCM_SOA_SPML_APPID", "CreationDate": "2019-03-05T15:59:43.070+00:00", "CreatedBy": "FUSION", "LastUpdateLogin": "A5575A8A7BB89D63E0533DFDF40AA2EA", "ResourceType": "INDIVIDUAL", "PrimaryOrganization": "CRM Service Organization_6", "EmailAddress": "sendmail-test-discard@oracle.com", "FormattedAddress": null, "FormattedPhoneNumber": null, "Usage": "HR Employee", "Manager": "automisrhdmgr1 svc", "Url": null, "JobMeaning": null, "Username": "automisrhdqueue1", "PersonFirstName": "automisrhdqueue1", "PersonLastName": "svc", "PersonLastNamePrefix": null, "PersonMiddleName": null, "PersonNameSuffix": null, "PersonPreNameAdjunct": null, "PersonPreviousLastName": null, "PersonSecondLastName": null, "ManagerPartyId": 300100176773204, "RecordSet": null, "UpdateFlag": "false", "DeleteFlag": "false", "ResourceOrgRoleCode": "SERVICE_ADMINISTRATOR", "ResourceOrgRoleName": "Service Administrator", "links": [ { "rel": "self", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_842739", "name": "resources", "kind": "item", "properties": { "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000378" } }, { "rel": "canonical", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_842739", "name": "resources", "kind": "item" }, { "rel": "lov", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_842739/lov/SearchFilters", "name": "SearchFilters", "kind": "collection" }, { "rel": "child", "href": "https://servername.fa.us2.oraclecloud.com//crmRestApi/resources/11.13.18.05/resources/CDRM_842739/child/PictureAttachment", "name": "PictureAttachment", "kind": "collection" } ] }, ...