GL Budget Account Range Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Creates, updates and deletes the account ranges of GL budget organizations - the Excel equivalent of the Ranges region of the Define Budget Organization form (Budgets > Define > Organization).

Each row is one account range (line) of a budget organization. Account Low and Account High are entered with all segments, separated by the segment delimiter of the chart of accounts.

As in the form, the account range, Entry Type and Currency of an existing line cannot be changed: delete the line and create a new one. Deleting a line also removes its account assignments and budgetary control options.

After the upload, Assign Budget Account Ranges is submitted for every budget organization that has new lines. It assigns the accounts of the new ranges to the budget organization; its request is shown in the Assignment Request column.

Funds Check Level, Amount Type, Boundary and Funding Budget are the budgetary control options of a line, available for entered lines in the ledger currency of a ledger with budgetary control enabled. A line with several funding budgets takes one row per funding budget.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Ledger, Upload Mode, Budget Organization

Oracle EBS Tables Used

gl_budget_assignment_ranges, gl_ledgers, gl_budget_entities, gl_budorg_bc_options, gl_budget_versions, xxen_report_org_access

Report Categories

Enginatics, R12 only, Upload

GL Budget Amounts Upload, GL Account Analysis, GL Account Distribution Analysis, GL Account Analysis (Drilldown) (with inventory and WIP), GL Account Analysis 11g, INV Items, GL Setup Upload

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Example
Blitz Report™ XML Import GL_Budget_Account_Range_Upload.xml
SQL Source GL Budget Account Range Upload.sql
Full Report on Enginatics www.enginatics.com/reports/gl-budget-account-range-upload/

© Enginatics GmbH