GL Journal Activity
Shows detailed GL journal activity lines with ledger, source/category, batch/journal, period, legal entity, COA segments, accounting date, currency, accounted DR/CR, creator/approver, approval status, and filters for ledger, source, posted status, period, and account range—ideal for close and audit.
Finance General Ledger (GL)
Back to Vault
SQL Query for GL Journal Activity
Parameters for GL Journal Activity
| Parameter Name | SQL Text | Validation |
|---|---|---|
| Period Name | SELECT glp.period_name
FROM gl_periods glp
WHERE glp.period_set_name = 'AccountingMMYY'
AND sysdate>=glp.start_date
AND glp.adjustment_period_flag = 'N'
order by glp.start_date desc | String |
| Ledger | SELECT DISTINCT gl.name FROM gl_ledgers gl ORDER BY gl.name | String |
| Journal Source | SELECT DISTINCT gjs.user_je_source_name FROM gl_je_sources gjs ORDER BY gjs.user_je_source_name | String |
| Posted Status | Select DISTINCT gjh.STATUS From gl_je_headers gjh | String |
| Account From | SELECT B.FLEX_VALUE FROM fnd_flex_value_sets a ,fnd_flex_values b WHERE a.flex_value_set_id = b.flex_value_set_id AND a.flex_value_set_name='Corporate Account' AND b.enabled_flag='Y' AND b.summary_flag'Y' ORDER BY b.flex_value | String |
| Account To | SELECT B.FLEX_VALUE FROM fnd_flex_value_sets a ,fnd_flex_values b WHERE a.flex_value_set_id = b.flex_value_set_id AND a.flex_value_set_name='Corporate Account' AND b.enabled_flag='Y' AND b.summary_flag'Y' ORDER BY b.flex_value | String |
GL Journal Activity in BI Connector
