GL Budget Amounts Upload

➜ Back to Library
Description

GL Budget Amounts Upload loads General Ledger budget amounts – by account, by period – into an open GL budget, from Excel. Depending on how the budget is configured, the upload either creates budget journals and runs Journal Import, or loads the amounts directly through the budget interface; either way it runs the standard Oracle program for you and reports the result for each row.

When to use it

  • Seed or load annual budget figures for many accounts and periods at once.
  • Update an existing open budget’s amounts for a new fiscal year.
  • Replace budget amounts, or add to existing amounts, on the accounts that allow it.
  • Load budgets that require budget journals – the upload creates the journals and runs Journal Import for you.
  • Review current budget balances by downloading in Create, Update mode.

Before you start

  • Blitz Report is installed and you are signed in to a General Ledger responsibility with access to the target ledger.
  • An open budget, a budget organization, and accounts assigned to that organization already exist.
  • The budget’s fiscal-year period range is open.
  • For budgets that require journals, a valid Journal Source and Journal Category are available.

Step 1 – Choose a mode, set the parameters and download

In Blitz Report, open GL Budget Amounts Upload, choose an Upload Mode (Create for an empty template, or Create, Update to download existing amounts), and set the parameters:

ParameterPurpose
LedgerThe ledger (limited to your GL access set).
Upload ModeCreate or Create, Update. Default is Create.
Budget OrganizationThe budget organization within the ledger.
BudgetAn open budget for that organization.
CurrencyThe budget entry currency.
Fiscal YearThe budget fiscal year (restricts the periods downloaded).
AccountOptionally download a single budget account.

For a Create, Update download, supply the Budget Organization, Budget and Currency. Run the upload to download and open the Excel file.

Step 2 – Enter the budget amounts

Each row is one account. Its identity – Ledger Name, Budget Organization, Budget Name, Currency Code, Fiscal Year and Account – is required and list-validated. Enter the amount in each Period column, and set Add Or Replace to control whether the amount replaces or adds to the existing balance. For budgets that require journals, also fill the Journal Source and Journal Category.

Step 3 – Validate and Save

Click Validate and Save. This checks for missing required values and runs the upload’s validation (for example, that journal-required budgets carry a Journal Source and Category), then saves the file. Correct anything it flags before continuing.

Step 4 – Upload and view the result

Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which runs Journal Import (for budgets that require journals) or Upload Budget Amounts (for direct-update budgets). When it finishes, a result report opens showing each row as success or error, with a link to the Oracle request output.

What’s produced

  • Budget amounts loaded into the chosen GL budget – posted as budget journals for journal-required budgets, or applied directly to the budget balances.
  • A result report listing every row with a status and a message, with a link to the Oracle request output so you can review what was processed.

Common questions

Does it overwrite my existing budget amounts?
It depends on the Add Or Replace value you choose per row. Replace updates the balance; Add increments it. For budgets that require journals, only the Add option is available (changes are posted as budget journals).

Why are the Journal Source and Journal Category columns empty for my budget?
They apply only to budgets configured with Require Budget Journals. For direct-update budgets they are left blank.

What happens after I upload?
For journal-required budgets the upload submits Journal Import and reserves funds; for direct-update budgets it submits Upload Budget Amounts. The result row links to the request output so you can review it.

Can I run the same file twice?
Yes. The upload first removes its own prior interface rows, so a re-run replaces rather than duplicates.

Why can’t I pick my budget or account?
The lists show only open budgets, assigned budget organizations, the budget’s open fiscal-year periods, and postable detail accounts for the selected ledger, organization and currency.

Troubleshooting

MessageCauseWhat to do
Journal Source / Journal Category is requiredThe budget requires journals but the row left them blank.Enter a valid Journal Source and Journal Category for journal-required budgets.
Journal Import not submittedThe Journal Import request could not be submitted.Check the reason shown, and that Journal Import can run for this ledger.
Could not reserve funds for the journalBudgetary-control funds checking failed for a created budget journal.Review the budgetary control setup and the named journal, correct, and re-run.
Upload Budget Amounts not submittedThe Upload Budget Amounts request could not be submitted.Check the reason, and your access to the budget version and organization.
Row error – check the request outputThe Oracle program rejected the row.Open the Request Output link on the row to see the rejection, fix the data and re-upload.
select
null action_,
null status_,
null message_,
null modified_columns_,
null row_id,
null request_id_,
null request_output,
to_number(null) group_id,
glv.name ledger_name,
gbe.name budget_organization,
gbve.budget_name,
xxen_util.meaning(gbv.require_budget_journals_flag ,'YES_NO',0) budget_requires_journal,
null journal_source_name,
null journal_category_name,
gbauv.currency_code,
gbpr.period_year fiscal_year,
null add_or_replace,
gcck.concatenated_segments account,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=1 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period1_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=1 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=1 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period1_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=2 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period2_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=2 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=2 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period2_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=3 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period3_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=3 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=3 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period3_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=4 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period4_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=4 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=4 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period4_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=5 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period5_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=5 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=5 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period5_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=6 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period6_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=6 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=6 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period6_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=7 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period7_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=7 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=7 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period7_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=8 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period8_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=8 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=8 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period8_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=9 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period9_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=9 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=9 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period9_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=10 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period10_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=10 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=10 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period10_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=11 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period11_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=11 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=11 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period11_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=12 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period12_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=12 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=12 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period12_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=13 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period13_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=13 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=13 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period13_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=14 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period14_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=14 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=14 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period14_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=15 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period15_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=15 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=15 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period15_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=16 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period16_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=16 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=16 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period16_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=17 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period17_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=17 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=17 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period17_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=18 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period18_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=18 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=18 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period18_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=19 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period19_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=19 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=19 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period19_amount,
(select
gps.period_name
from
gl_period_statuses gps
where
gps.ledger_id=glv.ledger_id and
gps.period_year=gbpr.period_year and
gps.application_id=101 and
gps.period_num=20 and
gps.period_num between gbpr.start_period_num and gbpr.end_period_num
) period20_name,
case when gbv.require_budget_journals_flag='Y' then
(select
sum(nvl(gbp.entered_dr,0) - nvl(gbp.entered_cr,0))
from
gl_bc_packets gbp
where
gbp.budget_version_id=gbve.budget_version_id and
gbp.ledger_id=gbe.ledger_id and
gbp.period_num=20 and
gbp.period_year=gbpr.period_year and
gbp.actual_flag='B' and
gbp.status_code='A' and
gbp.code_combination_id=gcck.code_combination_id)
else
(
select
sum(nvl(gb.period_net_dr,0) - nvl(gb.period_net_cr,0))
from
gl_balances gb
where
gb.budget_version_id=gbve.budget_version_id and
gb.ledger_id=gbe.ledger_id and
gb.period_num=20 and
gb.period_year=gbpr.period_year and
gb.actual_flag='B' and
gcck.code_combination_id=gb.code_combination_id
) 
end period20_amount
from
gl_budget_assignments_unique_v gbauv,
gl_budgets_v gbv,
gl_budget_entities gbe,
gl_entity_budgets geb,
gl_budget_versions gbve,
gl_ledgers_v glv,
gl_budget_period_ranges gbpr,
gl_code_combinations_kfv gcck
where
1=1 and
gbauv.entry_code='E' and
gbauv.code_combination_id=gcck.code_combination_id and
gbauv.ledger_id=glv.ledger_id and
glv.chart_of_accounts_id=gcck.chart_of_accounts_id and
gbe.budget_entity_id=gbauv.budget_entity_id and
gbv.budget_name=gbve.budget_name and
gbv.budget_name=gbve.budget_name and
glv.ledger_id=gbe.ledger_id and
geb.budget_version_id=gbve.budget_version_id and
gbe.budget_entity_id=geb.budget_entity_id and
gbpr.budget_version_id=gbv.budget_version_id and
gbpr.open_flag='O' and
gcck.enabled_flag='Y' and
gcck.summary_flag='N' and
gcck.detail_budgeting_allowed='Y' and
gcck.template_id is null and
sysdate between nvl(gcck.start_date_active,sysdate) and nvl(gcck.end_date_active,(sysdate+1))
Parameter NameSQL textValidation
Ledger
:ledger=:ledger
LOV
Upload Mode
:upload_mode like '%' || xxen_upload.action_update
LOV
Budget Organization
gbe.name=:budget_organization
LOV
Budget
gbv.budget_name=:budget
LOV
Currency
gbauv.currency_code=:currency
LOV
Fiscal Year
gbpr.period_year=:fiscal_year
LOV
Account
gcck.concatenated_segments=:account
LOV
Download
Blitz Report™