Fusion REST API filtering based on child resources: journal batches, journal headers, journal lines? — Cloud Customer Connect
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

Fusion REST API filtering based on child resources: journal batches, journal headers, journal lines?

edited Aug 21, 2025 11:42PM in General Ledger & Intercompany

Summary:

Querying the Fusion Financials journalBatches REST API with the filter, q=journalHeaders.journalLines.AccountCombination='ABC-123-DEF-456' returns all batches. The expectation was that only journal batches containing journal entries for the specific account combination would be in the response.

The basis for this expectation was the documentation, "In REST framework version 2 and later, advanced query syntax is supported: more operators, filtering based on child resource fields," found here: Set the REST Framework Version

Content (please ensure you mask any confidential information):

An example request:

GET https://omitted-instance.fa.ocs.oraclecloud.com/fscmRestApi/resources/11.13.18.05/journalBatches?q=journalHeaders.journalLines.AccountCombination='ABC-123-DEF-456'&limit=500&fields=JeBatchId&onlyData=true

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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