Can we query the Journal Details using REST API based on the Journal Line level DFF ?

Oct 2, 2025 4:17PM

Summary:

I am trying to query the Journals Batches,Journal Headers, Lines and its DFF details based on q parameter, by passing Line level DFF value.

Content (please ensure you mask any confidential information):

First i tried to check by passing the Journal Name , even this is failing, any idea on this ?

https://test.oraclecloud.com/fscmRestApi/resources/11.13.18.05/journalBatches?q=journalHeaders.JournalName='TESTJOURNAL'

Version (include the version you are using, if applicable):

25c

Code Snippet (add any code snippets that support your topic, if applicable):

https://test.oraclecloud.com/fscmRestApi/resources/11.13.18.05/journalBatches?q=journalHeaders.JournalName='TESTJOURNAL'

Error,

URL request parameter q with value journalHeaders.JournalName='TESTJOURNAL' is not valid.