Forum Stats

  • 3,780,565 Users
  • 2,254,410 Discussions
  • 7,879,385 Comments

Discussions

UNABLE TO FETCH HISTORICAL ASSIGNMENT DATA VIA REST API

Iam not beeing able to fetch historical Data using REST API for Oracle HCM Cloud.
Example:

URI=http://xxxxx.xxxxx.oraclecloud.com/hcmRestApi/resources/11.13.18.05/jobs
Fetch:

"JobId": 99999999,

"JobCode": "TEST_01",

"JobFamilyId": null,

"ActiveStatus": "A",

"FullPartTime": "PART_TIME",

"JobFunctionCode": "LEGAL",

"ManagerLevel": "5",

"MedicalCheckupRequired": "Y",

"RegularTemporary": "T",

"SetId": 0,

"EffectiveStartDate": "1952-01-01",

"EffectiveEndDate": "2020-06-29"

If you try to fetch de same job but with another EffectiveStartDate, for example using de filter ?q=EffectiveStartDate=1951-01-01, the result is 0 Items.

This is happeing with all the objects we are traing to fetch.

Is there a way to fetch all the historical rows from the same object ?

Thanks