The quick answer
Use a manual two-pass search. First filter journal lines by the account and collect distinct transaction Internal IDs. Then remove Account and add Internal ID = any of those selected IDs. The second pass retrieves the journal-entry lines that satisfy the remaining criteria. Another line-level criterion can still exclude lines.
Main Line does not work as a filter for Journal Entry transaction searches, so it is omitted here. This workaround stores a manual ID list. It does not dynamically discover new journals containing the account.
Before you start
You need permission to edit the Transaction saved search and view its source journals. Labels and available fields can vary with role and account configuration.
This example uses Journal Lines Account Review, with Type = Journal, Date within 10/01/2026 and 10/31/2026, Posting = Yes, and Account = 1100 Accounts Receivable. The illustrative journals are approved, posted ordinary journals in one subsidiary and currency. Date here means transaction date. Keep the reporting scope consistent across both passes, including any intended subsidiary, book, currency, approval-status, custom body or other criteria. Remove any unintended line restriction. Subsidiaries, accounting books, currency, statistical journals and other journal-like transaction types need their own scope.
01. Inspect the original entry
From the account-filtered results, click View for JE531. Its Lines show an A/R debit of 360, a service-revenue credit of 240 and a freight-income credit of 120. Total debits and credits are both 360. This original entry establishes the lines the account-filtered search omits.
02. Collect distinct transaction IDs
Return to the results. The Account criterion returns only three A/R lines: transaction 8401 once and transaction 8402 twice. Record 8401 and 8402 once each. JE531 maps to transaction Internal ID 8401; JE532 maps to 8402. Use the Internal ID result column, not the journal number or a line identifier.
03. Replace Account with selected IDs
Click Edit this Search. Select the Account criterion and Remove it. Add Internal ID, keeping any of. Use the record selector to resolve the values: type an ID prefix, press Tab and choose 8401. Open Select Multiple, choose 8402, then Done. Confirm both resolved values and click Set. Typing arbitrary unresolved numbers is not the same as selecting records.
Keep Type, Date and Posting unchanged. Confirm Account is absent, Main Line is absent, and the new description says is any of 8401, 8402.
04. Reconcile complete entries
Click Preview. JE531 returns three lines, including both non-A/R credits. JE532 returns its two A/R debits, 200 and 100, and service-revenue credit of 300. In this controlled example, the six lines retain their original nonzero amounts. JE533 remains excluded because it did not qualify.
The next crop shows the debit and credit columns from the same six-line preview, in the same row order. Enlarge either image to compare identifiers, accounts and amounts together.
Compare the original lines and each journal's debit and credit totals. The unused debit or credit side can display blank or zero depending on output context. Do not group or remove repeated-looking rows merely to reduce the count.
05. Save the manual population
Return to the criteria and Save the existing search. Confirm the same six rows remain. This overwrites the existing search criteria. Use Save As instead if you need to preserve the original account-filtered search. The saved search stores the selected transaction IDs; it does not rerun account qualification automatically.
Before a later review, repeat account qualification and replace the list. New qualifying journals do not appear automatically. A selected journal can remain in the list even if its account lines later change.
Common questions
Why does the Account criterion return only part of a journal?
It restricts the returned lines to those matching the account. It does not automatically retain every other line of each matching journal.
Will changing Main Line fix this Journal Entry search?
No. Oracle documents that the Main Line filter does not work for Journal Entry transaction searches. This example omits it.
Is Internal ID the same as a journal line ID?
No. Use transaction Internal ID, which repeats across the journal's lines. Line ID and Line Unique Key identify a different level of data.
Which duplicates should I remove?
Collect each qualifying transaction ID once in the first pass. Preserve all actual lines in the second pass, including multiple legitimate lines on the same account.
Will the saved ID list keep itself current?
No. Repeat qualification and refresh the list when journals, account membership or reporting scope change.