PSA Budgetary Control Transactions

Description

Categories
Enginatics, R12 only
Application
Public Sector Financials
Source
Budgetary Control Results Report
Short Name
PSABCRRP
DB package
XXEN_PSA
Repository
GitHub
Imported from Concurrent Program
Budgetary Control Results Report Program

The Expand Amounts Yes/No Parameter determines whether or not the Budget, Encumbrances, Expenditures, and Funds Available Amounts are displayed on the same excel row (Expand=No) or are split into separate excel rows (Expand=Yes) in the generated excel.

The following templates are provided with this report:

Budgetary Control Transactions Pivot
===========================
Corresponds to the standard Oracle Budgetary Control Status Report.
Budget, Encumbrances, Expenditures, and Funds Available Amounts are displayed on separate rows in the generated Excel

Budgetary Control Transactions Extract
============================
Flat File one row per transaction extract.
Budget, Encumbrances, Expenditures, and Funds Available Amounts are included as separate columns on the same excel row

SQL 82 lines

Parameters 9

ParameterTypeList of values SQL
Ledger NameLOV Oracle
Period FromLOV Oracle
Period ToLOV Oracle
JE Batch NameLOV Oracle
Account FromLOV
Account ToLOV
Funds Result StatusLOV
Order ByLOV
Expand AmountsLOV Oracle
pbrg.budget_posted_balance,
pbrg.budget_approved_balance,
pbrg.budget_pending_balance,
pbrg.budget_total_balance,
pbrg.encumbrance_posted_balance,
pbrg.encumbrance_approved_balance,
pbrg.encumbrance_pending_balance,
pbrg.encumbrance_total_balance,
pbrg.actual_posted_balance,
pbrg.actual_approved_balance,
pbrg.actual_pending_balance,
pbrg.actual_total_balance,
pbrg.available_posted_balance,
pbrg.available_approved_balance,
pbrg.available_pending_balance,
pbrg.available_total_balance,