Transcript Take the pain out of Public Sector Budgeting

Take the pain out of Public Sector
Budgeting Implementation Setups
Richard Byrom
Oracle Applications Consultant
[email protected]
http://www.richardbyrom.com
Appsworld January 2004
Agenda
•
•
•
•
•
•
Objectives
Processes and architecture
Setup Steps (Position and Non Position)
Excel Spreadsheet Interface
Conclusion
Questions & Answers
Objectives
• To outline and demonstrate the key setup steps
for Position and Non Position Budgeting
• To provide an overview of how to setup and use
the excel spreadsheet interface
Processes and architecture
• Understand the budgeting cycle
• Understand the organizational structure
– Employees and hierarchy
– Account Structure
• Understand the different types of budget
Position Steps - Demo
Stage Detailed Step
Requirement
26 Define Budget Year Types*
Required
27 Define Budget Calendar*
Required
28 Define Standard Budget Items
Optional
29 Setup General Ledger Interfaces*
Required
30 Setup General Ledger Budget Sets*
Required
31 Define Global Account Sets*
Optional
32 Define Budget Group Categories*
Optional
33 Define Budget Stages*
Required
34 Setup Budget Groups And Security
Required
35 Define Budget Review Groups And Budget
Optional
Group Rules for Account Sets
36 Set Line-item Budgeting Profile Options
Optional
Non – Position Steps demo
Stage Detailed Step
Requirement
37 Define PSB Position Key Flexfield
Required
38 Define Position Attributes*
Required
39 Define Data Extract*
Required
40 Run Data Extract*
Required
41 Review or Modify Position Attribute Values*
Optional
42 Define Global Position Sets
Optional
43 Define Budget Review Groups for Position Sets Budget
44 Define Elements
Required
45 Define Position Default Rules
Required
46 Apply Position Defaults
Required
47 Review or Modify Positions
Required
48 Refresh Data Extract
Optional
49 Repeat steps
Optional
50 Set Position Budgeting Profile Options
Optional
GL Steps – Ensure Budgetary
Control enabled
Define GL Budget
Define Budget Organization
Define Budget Year Types
Define Budget Calendar
Define Budget Group Categories
Budget Group Categories Example
Define Account Sets – Global
Define Account Sets Local
Assign Account Sets to the
Hierarchy – from bottom up
GL Budget Sets – Link PSB to GL
GL Interface
Define Position Attributes
Name
Data Type
Adjustment Date
Date
Default Weekly
Hours
FTE
Number
Hire Date
Date
Job
Character
Organization
Character
Number
Extract Data from HR
View validations of HR extract
Constraints/Ceilings
The end result – A budget
worksheet
Excel spreadsheet interface –
concept and demo
Oracle Public Sector
Budgeting Worksheet
Import
Export
Spreadsheet Interface
Table
Import
Excel
Export
Excel Spreadsheet Interface –
Setup Demo
•
•
•
•
Run PSBCRUSR.sql Script
Install PSBVEXCL.xla file
Test the connection
Perform worksheet operations
Conclusions
• Oracle E-business suite provides an effective
architecture and system for running your PSB
• Processes outside the system as well as the
people aspects are equally important in
ensuring an appropriate PSB infrastructure.
Speaker Information
Name: Richard Byrom
e-mail: [email protected]
[email protected]
Company: RPC Data Ltd
Web Site: http://www.rpcdata.com
http://www.richardbyrom.com
Mobile: +267-72671285