Introduction
Oracle General Ledger Trial Balance report is used to satisfy legal, statutory, and internal management reporting requirements in Portugal. There are five separate reports with a standard layout; however, each report has different parameters. The reports display the current period, up to the end of the previous period, year-to-date, and current balance.
Script to Trial Balance – Detail Report
SELECT glcc.segment4 natural_account, ffv.description description,
glcc.segment1
|| ‘-‘
|| glcc.segment2
|| ‘-‘
|| glcc.segment3
|| ‘-‘
|| glcc.segment4
|| ‘-‘
|| glcc.segment5
|| ‘-‘
|| glcc.segment6 accounting_flexfield,
NVL (begin_balance_dr, 0)
– NVL (begin_balance_cr, 0) beginning_balance,
NVL (period_net_dr, 0) – NVL (period_net_cr, 0) period_activity,
NVL (period_net_dr, 0)
– NVL (period_net_cr, 0)
+ NVL (begin_balance_dr, 0)
– NVL (begin_balance_cr, 0) ending_balance
FROM gl_balances GLB,
gl_code_combinations glcc,
fnd_flex_values_vl ffv,
fnd_flex_value_sets ffvs
WHERE GLB.actual_flag = ‘A’
AND GLB.ledger_id = :sob
AND GLB.currency_code = :currency_code
AND (GLB.translated_flag != ‘R’ OR GLB.translated_flag IS NULL)
AND GLB.period_name = :period_name
AND GLB.code_combination_id = glcc.code_combination_id
AND glcc.chart_of_accounts_id = (SELECT chart_of_accounts_id
FROM gl_sets_of_books
WHERE set_of_books_id = :sob)
AND glcc.template_id IS NULL
AND ( NVL (begin_balance_dr, 0)
– NVL (begin_balance_cr, 0)
+ NVL (period_net_dr, 0)
– NVL (period_net_cr, 0)
+ NVL (period_net_dr, 0)
– NVL (period_net_cr, 0)
+ NVL (begin_balance_dr, 0)
– NVL (begin_balance_cr, 0)
) != 0
AND ffv.flex_value_set_id = ffvs.flex_value_set_id
AND ffvs.flex_value_set_name = ‘MPP_ACCOUNT’
AND ffv.flex_value = glcc.segment4
ORDER BY 1, 3;
What we except in the script.
This script helps us to comprehend how. Couple of ** which is being used in this query are
gl_balances,gl_code_combinations,fnd_flex_values_vl, fnd_flex_value_sets ffvs etc.
Summary
This Post described Trial Balance – Detail Report in Oracle EBS R12.
Got any queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
