AFFDesign

I-MANAGE Design Review: 

I-MANAGE Design Review Accounting Flexfield Terms & Definition Flexfield features DOE’s Proposed AFF Design DOE’s use of Descriptive Flexfields Accounting Flexfield

Accounting Flexfield (AFF) Terms & Definitions: 

Accounting Flexfield (AFF) Terms & Definitions Accounting Flexfield: The code you use to identify a general ledger account in an Oracle Financials application. Each Accounting Flexfield segment value corresponds to a summary or rollup account within your chart of accounts. Accounting Flexfield Structure: The account structure you define to fit the specific needs of your organization. You choose the number of segments, as well as the length, name, and order of each segment in your Accounting Flexfield structure. Account segment: One of up to 30 different sections of your Accounting Flexfield, which together make up your general ledger account code. Each segment is separated from the other segments by a symbol you choose (such as –, /, or \). Each segment typically represents an element of your business structure, such as Company, Cost Center or Account. Oracle Accounting Flex-Field (AFF)

Accounting Flexfield (AFF) Terms & Definitions: 

Accounting Flexfield (AFF) Terms & Definitions Balancing Segment: An Accounting Flexfield segment that you define so that General Ledger automatically balances all journal entries for each value of this segment. For example, Fund Code segment is the balancing segment, so the General Ledger module ensures that, within every journal entry, the total debits for Fund 01 equal the total credits for Fund 01. Chart of Accounts: The account structure (i.e. the accounting flexfield structure within Oracle) your organization uses to record transactions and maintain account balances. In certain discussions, the U.S. Standard General Ledger may be referred to as the chart of accounts, but this differs from the standard definition within Oracle. Descriptive Flexfield: A field that your organization can configure to capture extra information not otherwise tracked by Oracle Applications. A descriptive flexfield appears in your window as a single character, unnamed field. Your organization can customize this field to capture additional information unique to your business. Oracle Accounting Flex-Field (AFF)

Accounting Flexfield (AFF) Terms & Definitions: 

Accounting Flexfield (AFF) Terms & Definitions Journal Entry: A debit or credit to a general ledger account. Natural Account Segment: In Oracle General Ledger, the segment that determines whether an account is an asset, liability, owners’ equity, revenue, or expense account. When you define your chart of accounts, you must define one segment as the natural account segment. The U.S. SGL segment is the natural account segment. Parent Segment Value: An account segment value that references a number of other segment values, called child segment values. General Ledger uses parent segment values for creating summary accounts, and for reporting on summary balances. Rollup Group: A collection of parent segment values for a given segment. You use rollup groups to define summary accounts based on parents in the group. You can use letters as well as numbers to name your rollup groups. Oracle Accounting Flex-Field (AFF)

Accounting Flexfield (AFF) Features: 

Accounting Flexfield (AFF) Features Allows funds control and reporting by any of the segments Numeric segment values provide flexibility when grouping ranges for query or reporting purposes (e.g. 10000 – 19999, 20000 – 29999, etc.) DOE’s current accounting flexfield has 11 segments consisting of 64 characters Oracle Accounting Flex-Field (AFF)

DOE’s AFF Segments: 

DOE’s AFF Segments Fund Balancing segment Control segment Identifies fund type and appropriation for funds control and statutory reporting Rolls up to the Treasury appropriation symbol Replaces legacy Fund Type Examples: 10000=89X0240 (FT TC); 13000=89X4180 (FT VE) Oracle Accounting Flex-Field (AFF)

DOE’s AFF Segments: 

DOE’s AFF Segments Appropriation Year Control segment Identifies the four-digit year in which funding is appropriated Adds capability to meet new/future Treasury & OMB requirements Required by Oracle to handle FACTS-II and upward & downward adjustments Examples: 2001; 2002 Oracle Accounting Flex-Field (AFF)

DOE’s AFF Segments: 

DOE’s AFF Segments Allottee Control segment Represents the allottee to which funds are distributed by HQ budget Ranges to be established by cluster Replaces legacy Allotment symbol (1st 2 positions) Examples: 01=Albuquerque Operations; 31=NETL Oracle Accounting Flex-Field (AFF)

DOE’s AFF Segments: 

DOE’s AFF Segments Reporting Entity Control segment Groups allottee specific information Ranges to be established to differentiate between integrated contractor and DOE direct activity Replaces legacy Field Office, Reporting Unit, Financial Plan, Local Organization, Cost Center (as used organizationally), and integrated contractor information Examples: 000001=Albuquerque, Sandia National Lab; 008201=Oak Ridge, Finance Division Oracle Accounting Flex-Field (AFF)

DOE’s AFF Segments: 

DOE’s AFF Segments Standard General Ledger (SGL) Natural account Control segment Identifies four-digit Treasury account, two- digit DOE sub-account, two-digit reserved for future SGL expansion Replaces legacy Balance Sheet Code Examples: 1310D100=A/R Direct, OFA; 49010000=Expended Authority, Unpaid Oracle Accounting Flex-Field (AFF)

DOE’s AFF Segments: 

DOE’s AFF Segments Object Class Control segment using roll-up groups Represents three digit object class and two digit DOE sub-object class Replaces legacy Object Class and Cost Center (as used to breakdown object class information) and includes breakdown of Budget Reference Number prefixes in the last two positions Examples: 25200=Other Services; 21103=Local Travel Oracle Accounting Flex-Field (AFF)

DOE’s AFF Segments: 

DOE’s AFF Segments Program Control segment using roll-up groups Represents (and replaces) the current B&R code structure and includes Major Items of Equipment (MIE), line item construction (39B&R), and Project Baseline Summary (PBS) information Numerous parent/child relationships Examples: 0010520=ST0202000, Stable Isotope Services; 0029100=DP0702000 EQU91H1, Radio Conversion Oracle Accounting Flex-Field (AFF)

DOE’s AFF Segments: 

DOE’s AFF Segments Project Total segment Identifies and replaces legacy Activity Data Sheets (ADS) and Technical Task Plans (TTP). Allows for new project requirements such as Field Work Proposal (FWP), Nuclear Energy Research Initiative (NERI), and Annual Operating Plan (AOP) numbers. Oracle Accounting Flex-Field (AFF)

DOE’s AFF Segments: 

DOE’s AFF Segments WFO or Work for Others Control segment Identifies (and replaces) Reimbursable Work Order number and Inter-company Work Orders Ranges to be established for the two different types of projects Examples: 3200000 = Reimbursable Work Order number 189A91342, Reimbursable Work; 4000200 = Inter-company Work Order number M1NVLL086, Petawatt Laser Oracle Accounting Flex-Field (AFF)

DOE’s AFF Segments: 

DOE’s AFF Segments Local Use Control segment using roll-up groups Represents and replaces Local Project, B&Rs, and Cost Center (when used to break down project/program activity) Includes actual GPP/GPE numbers (BRN type captured in Object Class) Allows flexibility on providing lower level information Examples: 4010000 = Safety Equipment; 5011000 = GPP, GPD10100305 – Glove Box Oracle Accounting Flex-Field (AFF)

DOE’s AFF Segments: 

DOE’s AFF Segments Future Total segment Default zero filled segment reserved to satisfy future reporting requirements No legacy replacement No examples Oracle Accounting Flex-Field (AFF)

Use of Descriptive Flexfields (DFF): 

Use of Descriptive Flexfields (DFF) General Ledger (GL) needs DFFs for: Contract ID (CID – used as Purchase Order ID, will allow querying and reporting on all costs associated with a CID) Trading Partner Accounts Receivable (AR) needs DFF for the CID PO needs DFF for the Work Authorization System (WAS) Continue to use DFF in PO, AP, & AR to capture Trading Partner Continue to use PO # to capture CID info in PO & AP