In Oracle Financials, We have a provision to create a recurring journal in GL application. This blog will helping in extracting that journals.
SELECT
b.name batch,
b.description batch_description,
(
SELECT
meaning
FROM
apps.fnd_lookup_values flv
WHERE
flv.lookup_type = ‘GL_RECURRING_BATCH_TYPE’
AND
flv.lookup_code = b.recurring_batch_type
AND
flv.language = ‘US’
) recurring_batch_type,
b.ledger_name batch_ledger_name,
b.security_flag,
b.le_period_name last_executed_period,
b.le_date last_executed_date,
h.name journal_name,
h.ledger_name journal_ledger_name,
h.je_category_name category,
h.currency_code currency,
h.currency_conversion_type,
h.start_date_active,
h.end_date_active,
l.recurring_line_num,
l.description line_description,
glacc.concatenated_segments account,
l.entered_dr,
l.entered_cr,
lcr.rule_num step,
DECODE(
lcr.operator,
‘E’,
‘Enter’,
lcr.operator
) operator,
lcr.amount
FROM
apps.gl_recurring_batches_v b,
apps.gl_recurring_headers_v h,
apps.gl_recurring_lines l,
apps.gl_code_combinations_kfv glacc,
apps.gl_recurring_line_calc_rules lcr
WHERE
1 = 1
AND
b.recurring_batch_id = h.recurring_batch_id
AND
h.recurring_header_id = l.recurring_header_id
AND
l.code_combination_id = glacc.code_combination_id
AND
l.recurring_header_id = lcr.recurring_header_id (+)
AND
l.recurring_line_num = lcr.recurring_line_num (+)
AND
b.ledger_name = ‘US Ledger’
— AND
— b.name = ‘Test REC INV #91189033’
