You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to Filter Nested Child Resource Fields via REST API — Any Workaround Using Business Objects

in HCM REST APIs

Hi Community,

We are using the Oracle HCM Workers REST API and need to filter assignments based on:

  • AssignmentType = 'E'
  • AssignmentStatusType = 'ACTIVE'
  • PrimaryFlag = true

However, the q= filter parameter only works on top-level fields and does not support filtering on nested child resources like workRelationships.assignments.

We have tried:

  • Using q= parameter (does not work for nested fields)
  • Passing filters as headers (ignored by Oracle API)

Currently we fetch all records and filter in our integration layer which is inefficient.

Is there a supported Finder or a way to achieve this filtering through Business Objects in Oracle Fusion?
Oracle Fusion : 25D

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!