220 likes | 291 Vues
Getting the Most from Your Flexfields. Presented by: Dorothy Sheets FMT Systems Inc. MOUS Livonia, MI September 2009. Agenda. Introduction What’s the big deal about flexfields? What’s a flexfield, anyway? Flexfield design (psychology) What to put in & what to leave out
E N D
Getting the Most from Your Flexfields Presented by: Dorothy Sheets FMT Systems Inc. MOUS Livonia, MI September 2009
Agenda • Introduction • What’s the big deal about flexfields? • What’s a flexfield, anyway? • Flexfield design (psychology) • What to put in & what to leave out • Flexfield design (physiology) • Value sets, structure & valid segment values • Cross validation & flexfield security rules • Wrap Up Dorothy Sheets, FMT Systems Inc.
Introduction • Dorothy Sheets, FMT Systems Inc. • 16 years experience with Oracle applications • Implementing • Teaching • Selling Dorothy Sheets, FMT Systems Inc.
What’s the big deal about flexfields? • Company X – 17 segment accounting flexfield • Everything but the kitchen sink • Unwieldy • Very time consuming data entry • No aliases or shortcuts • Way too much information to enter & analyze! Dorothy Sheets, FMT Systems Inc.
What’s a flexfield, anyway? • Important feature of Oracle applications • One size does NOT fit all! • You configure according to your business needs • Protected during upgrades Dorothy Sheets, FMT Systems Inc.
Key vs. descriptive flexfields • Key flexfield examples • General ledger: accounting flexfield • Assets: asset key, category, location flexfields • Inventory: system item flexfield • Descriptive flexfield examples • Global: journal entry lines example • Context sensitive: asset category example Dorothy Sheets, FMT Systems Inc.
Flexfield design (psychology) • What to put in • What to leave out • What’s typical • Other considerations Dorothy Sheets, FMT Systems Inc.
What to put in? • Decision process can be challenging & political • Examine existing system for clues • What do you need that you do not currently have? • Example: budget centers Dorothy Sheets, FMT Systems Inc.
What to leave out? • Decision process can be challenging & political • Examine existing system for clues • What do you have that you do not currently need? • Example: sub departments Dorothy Sheets, FMT Systems Inc.
What’s typical? • It depends… • When was Oracle implemented? • Typical then is not typical now • Experience with AFF ranges: • From as few as 3 segments • To as many as 17 segments • Typical today is about 5-7 segments Dorothy Sheets, FMT Systems Inc.
Other considerations • Consider all modules implemented • Don’t just think about general ledger • What’s fine for GL may cause data entry issues in AP • What’s fine for controlling inventory items may cause hassles with shipping them Dorothy Sheets, FMT Systems Inc.
Flexfield design (physiology) • Value sets • Segment structure & segments • Valid segment values • Cross validation rules • Flexfield security rules Dorothy Sheets, FMT Systems Inc.
Value sets: security, format & validation Dorothy Sheets, FMT Systems Inc.
Segment structure: order Dorothy Sheets, FMT Systems Inc.
Segments: appearance Dorothy Sheets, FMT Systems Inc.
Segments: qualifiers Dorothy Sheets, FMT Systems Inc.
Valid segment values: company, cost center & account Dorothy Sheets, FMT Systems Inc.
Cross validation rules: combinations of segment data Dorothy Sheets, FMT Systems Inc.
Flexfield security rules: definewho can access what Dorothy Sheets, FMT Systems Inc.
Flexfield security rules: assign who can access what Dorothy Sheets, FMT Systems Inc.
Wrap up • We hope this presentation has give you some insight into: • Flexfield design psychology • Flexfield design physiology • “Getting the most from your flexfields” • Questions??? Dorothy Sheets, FMT Systems Inc.
We are . . . Integrating people, processes, and technology!™ THANK YOU! Dorothy Sheets, FMT Systems Inc.