Question: Supplier API Child Filters Not Working as Expected in APEX (Procurement BU and DFF Filter)
Hi everyone,
I’ve configured the Suppliers REST API in Oracle APEX using the endpoint:
GET /fscmRestApi/resources/11.13.18.05/suppliers
and I’m expanding the child resources as follows:
?expand=sites,sites.dff,sites.assignments
In my query parameters, I’ve added two filters:
?q=sites.dff.vendor_site_type='S&P';sites.ProcurementBU='GBL_3PP'
Here’s what I’m observing:
When I use only sites.dff.vendor_site_type='S&P', it works correctly.
When I use only sites.ProcurementBU='GBL_3PP', the API executes successfully but still returns all records instead of just those with that Procurement BU.
When I combine both filters together, no records are returned, even though data matching both conditions exists in the system.
It seems like the second filter (sites.ProcurementBU='GBL_3PP') is not being applied correctly when used with the expanded child entities.
Can anyone please confirm:
Is this a known limitation with filtering on child-level fields (like sites or sites.dff) in the Suppliers REST API?
Or is there a specific syntax or workaround to apply multiple filters on expanded child resources in a single API call?