Take the pain out of Public Sector Budgeting Implementation Setups

Richard Byrom

Oracle Applications Consultant

richard@richardbyrom.com

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 - DemoStage Detailed Step Requirement

26 Define Budget Year Types* Required27 Define Budget Calendar* Required28 Define Standard Budget Items Optional29 Setup General Ledger Interfaces* Required30 Setup General Ledger Budget Sets* Required31 Define Global Account Sets* Optional32 Define Budget Group Categories* Optional33 Define Budget Stages* Required34 Setup Budget Groups And Security Required35 Define Budget Review Groups And Budget

Group Rules for Account SetsOptional

36 Set Line-item Budgeting Profile Options Optional

Non – Position Steps demoStage Detailed Step Requirement

37 Define PSB Position Key Flexfield Required38 Define Position Attributes* Required39 Define Data Extract* Required40 Run Data Extract* Required41 Review or Modify Position Attribute Values* Optional42 Define Global Position Sets Optional43 Define Budget Review Groups for Position Sets Budget44 Define Elements Required45 Define Position Default Rules Required46 Apply Position Defaults Required47 Review or Modify Positions Required48 Refresh Data Extract Optional49 Repeat steps Optional50 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

Number

FTE Number

Hire Date Date

Job Character

Organization Character

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 SectorBudgeting Worksheet

Spreadsheet InterfaceTable

Excel

Import

ExportExport

Import

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.

AQ&

Speaker Information

Name: Richard Byrom

e-mail: richard@rpcdata.com

richard@richardbyrom.com

Company: RPC Data Ltd

Web Site: http://www.rpcdata.com

http://www.richardbyrom.com

Mobile: +267-72671285