Download - GL BR 100 Application Setup
AIM
BR.100 GENERAL LEDGER APPLICATION SETUP
Author: <Author>
Creation Date: January 22, 2013
Last Updated: January 22, 2013
Document Ref: <Document Reference Number>
Version: DRAFT 1A
Approvals:
<Approver 1>
<Approver 2>
Document Control
Change Record:
Date Author Version Change Reference
7/10/09 xxx 2.0 Final document – to be signed off.
Reviewers:
Remarks
Distribution:
Copy No.
Name Location
1234
Table of Contents
Document Control................................................................................................................................1General Configuration Instructions.......................................................................................................3GL: Define Flexfield Value Sets............................................................................................................4GL: Define Accounting Key Flexfield Segments...................................................................................7GL: Define Accounting Segment Values............................................................................................14GL: Define Currencies........................................................................................................................15GL: Define Calendar Types................................................................................................................16GL: Define Accounting Calendar........................................................................................................17HR: Define Operating Units or GL: Accounting Setup Manager..........................................................19GL: Define Legal Entities....................................................................................................................31GL: Define Ledgers.............................................................................................................................34GL: Chart of Accounts Mapping..........................................................................................................49GL: Define Security Rules..................................................................................................................50GL: Assign Security Rules..................................................................................................................52GL: Define Accounting Cross Validation Rules...................................................................................54GL: Define Journal Entry Sources.......................................................................................................56GL: Define Journal Entry Categories..................................................................................................57GL: Define Journal Reversal Criteria..................................................................................................58GL: Define Automatic Posting Criteria...............................................................................................60GL: Define Journal Authorization Limits.............................................................................................67GL: Define Data Access Sets.............................................................................................................68GL: Define and Assign Security Access for Data Access Set Definitions............................................71GL: Define Intercompany/Interfund Accounts....................................................................................72GL: Define Statistical Units of Measure..............................................................................................73GL: Define Budgets and Years...........................................................................................................74GL: Miscellaneous Profile Options......................................................................................................76Open and Closed Issues for this Deliverable......................................................................................77
General Configuration InstructionsThe configuration for the General Ledger will dictate much of the setup for the other modules in the scope of Project X. Although the initial rollout will on include the Location E region, the GL will need to be globally configured.
The document below is referenced throughout the document, please use the copy provided as you work through this document.
GL: Define Flexfield Value Sets
General Ledger>Setup>Financials>Flexfields>Validation>Sets
FormName Value Sets<Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Use this form to define flexfield validation value sets.
<Value Sets>
Value Set Name Description List Type Security Type
XXX_GL_COMPANY Company Segment List of Values Non-Hierarchical Security
Format Validation
Format Type Numbers Only
Uppercase Only
Right-justify and Zero-fill Numbers
Maximum Size
Precision Min Value Max Value Validation Type
Char 3 Independent
<Value Sets>
Value Set Name Description List Type Security Type
Depatr
XXX_GL_DEPARTMENT Department Segment List of Values Non-Hierarchical Security
Format Validation
Format Type Numbers Only
Uppercase Only
Right-justify and Zero-fill Numbers
Maximum Size
Precision Min Value Max Value Validation Type
Char 2 Independent
<Value Sets>
Value Set Name Description List Type Security Type
XXX_GL_ACCOUNT Account Segment List of Values Non-Hierarchical Security
Format Validation
Format Type Numbers Only
Uppercase Only
Right-justify and Zero-fill Numbers
Maximum Size
Precision Min Value Max Value Validation Type
Char 6 Independent
<Value Sets>
Value Set Name Description List Type Security Type
XXX_GL_PROFIT_CENTER Profit Center Segment List of Values Non-Hierarchical Security
Format Validation
Format Type Numbers Only
Uppercase Only
Right-justify and Zero-fill Numbers
Maximum Size
Precision Min Value Max Value Validation Type
Char 4 Independent
<Value Sets>
Value Set Name Description List Type Security Type
XXX_GL_FUTURE Future Segment List of Values Non-Hierarchical Security
Format Validation
Format Type Numbers Only
Uppercase Only
Right-justify and Zero-fill Numbers
Maximum Size
Precision Min Value Max Value Validation Type
Char 5 Independent
<Value Sets>
Value Set Name Description List Type Security Type
XXX_GL_LEGAL_ENTITY Legal Entity Segment List of Values Non-Hierarchical Security
Format Validation
Format Type Numbers Only
Uppercase Only
Right-justify and Zero-fill Numbers
Maximum Size
Precision Min Value Max Value Validation Type
Char 3 Independent
GL: Define Accounting Key Flexfield Segments
General Ledger>Setup>Financials>Flexfields>Key>SegmentsKey Flexfield Segments<Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Use this form to Assign Balancing Segment, natural account, and cost center qualifiers to the correct segments of your accounting Flexfield structure.
XXX Primary Accounting Flexfield
<Key Flexfield Segments>
Application Flexfield Title
Accountin
General Ledger Accounting Flexfield
Structures
Code Title Description View Name
ACCOUNTING_FLEXFIELD XXX Primary XXX Primary Accounting Flexfield
Freeze Flexfield Definition
Enabled
Segment Separator Cross-Validate Segments
Freeze Rollup Groups Allow Dynamic Inserts
Dash (-) Yes – allow for Oracle Projects
**Note: Complete your entire Flexfield setup before you “Freeze” the flexfield definitions.
Segments<Segments Summary>
Number
Name Window Prompt
Column Value Set Displayed
Enabled
Qualifier Name
Qualifier Description
Qualifier Enabled
1 Company Company SEGMENT1 XXX_GL_COMPANY Yes Yes Balancing Segment
Balancing Segment
Yes
2 Department Department SEGMENT2 XXX_GL_DEPARTMENT Yes Yes Management Segment
Management Segment
Yes
3 Account Account SEGMENT3 XXX_GL_ACCOUNT Yes Yes Natural Account Segment
Natural Account Segment
Yes
4 Profit Center Profit Center SEGMENT4 XXX_GL_PROFIT_CENTER Yes Yes Cost Center Segment, Secondary Tracking Segment
Cost Center Segment, Secondary Tracking Segment
Yes
5 Future Future SEGMENT5 XXX_GL_FUTURE Yes Yes N/A N/A No
Flexfield Qualifiers `
Attention: The Qualifiers field has been added to the previous table
Open – Company (for each segment) <Segments>
Name Description Column Number Enabled Displayed Indexed
Company SEGMENT1 1 Yes Yes Yes
Validation
Value Set Description Default Type Default Value Required Security Enabled
Range
XXX_GL_COMPANY Company Segment Profile XXX_GL_COMPANY_DEFAULT
Yes Yes
Sizes and Prompts
Display Size Description Size Concatenated Description Size
List of Values Window
3 50 25 Company Company
Open - Department (for each segment) <Segments>
Name Description Column Number Enabled Displayed Indexed
Department SEGMENT2 2 Yes Yes Yes
Validation
Value Set Description Default Type Default Value Required Security Enabled
Range
XXX_GL_DEPARTMENT Department Segment Yes Yes
Sizes and Prompts
Display Size Description Size Concatenated Description Size
List of Values Window
2 50 25 Department Department
Open – Account (for each segment) <Segments>
Name Description Column Number Enabled Displayed Indexed
Account SEGMENT3 3 Yes Yes Yes
Validation
Value Set Description Default Type Default Value Required Security Enabled
Range
XXX_GL_ACCOUNT Account Segment Yes Yes
Sizes and Prompts
Display Size Description Size Concatenated Description Size
List of Values Window
6 50 25 Account Account
Open – Profit Center (for each segment) <Segments>
Name Description Column Number Enabled Displayed Indexed
Profit Center SEGMENT4 4 Yes Yes Yes
Validation
Value Set Description Default Type Default Value Required Security Enabled
Range
XXX_GL_PROFIT_CENTER Profit Center Segment Yes Yes
Sizes and Prompts
Display Size Description Size Concatenated Description Size
List of Values Window
4 50 25 Profit Center Profit Center
Open – Future (for each segment) <Segments>
Name Description Column Number Enabled Displayed Indexed
Future Future SEGMENT5 5 Yes Yes Yes
Validation
Value Set Description Default Type Default Value Required Security Enabled
Range
XXX_GL_FUTURE Future Segment Constant 00000 Yes No
Sizes and Prompts
Display Size Description Size Concatenated Description Size
List of Values Window
5 50 25 Future Future
NOTE: In order to make the company default when entering account combinations, inquiring no accounts, etc follow these steps.1. Create a profile option: XXX: GL Company Default (Application Developer > Profile > New Profile)
Name Application User Profile Name Description Hierarchy Type Access Level - Visible
Access Level - Updateable
XXX_GL_COMPANY_DEFAULT
General Ledger XXX: GL Company Default Security Site, Application, Responsibility, User
Responsibility, User
2. Input the following SQL Validation for the Profile Option’s List of ValuesSQL="SELECT a.flex_value, b.description INTO :PROFILE_OPTION_VALUE, :VISIBLE_OPTION_VALUEFROM fnd_flex_values a, fnd_flex_values_tl bwhere a.flex_value_id = b.flex_value_idand a.flex_value_set_id = 1013484and a.summary_flag = 'N' and a.enabled_flag = 'Y'order by flex_value"COLUMN="DESCRIPTION(*)"
3. Create a profile option: GL: Require AutoReverse Approval (Application Developer > Profile > New Profile)
Name Application User Profile Name Description Hierarchy Type Access Level - Visible
Access Level - Updateable
GL_APPROVE_AUTOREVERSE
General Ledger GL: Require AutoReverse Approval
Security Site, Application, Responsibility, User
Responsibility, User
4. Input the following SQL Validation for the Profile Option’s List of ValuesSQL="SELECT meaning \"Meaning\", lookup_codeINTO :visible_option_value, :profile_option_valueFROM fnd_lookupsWHERE lookup_type ='YES_NO'"COLUMN="\"Meaning\"(15)"
XXX Secondary (Tax) Accounting Flexfield
<Key Flexfield Segments>
Application Flexfield Title
Accon
General Ledger Accounting Flexfield
Structures
Code Title Description View Name
SECONDARY_ACCOUNTING_FLEXFIELD XXX Secondary XXX Secondary (Tax) Accounting Flexfield
Code Title Description View Name
Freeze Flexfield Definition
Enabled
Segment Separator Cross-Validate Segments
Freeze Rollup Groups Allow Dynamic Inserts
Dash (-) Yes
Segments<Segments Summary - XXX_ACCOUNTING_FLEXFIELD>
Number
Name Window Prompt
Column Value Set Displayed
Enabled
Qualifier Name
Qualifier Description
Qualifier Enabled
1 Legal Entity Legal Entity SEGMENT1 XXX_GL_LEGAL_ENTITY Yes Yes Balancing Segment
Balancing Segment
Yes
2 Account Account SEGMENT2 XXX_GL_ACCOUNT Yes Yes Natural Account Segment
Natural Account Segment
Yes
3 Profit Center Profit Center SEGMENT3 XXX_GL_PROFIT_CENTER Yes Yes Cost Center Segment;, Secondary Tracking Segment
Cost Center Segment, Secondary Tracking Segment
Yes
4 Future Future SEGMENT4 XXX_GL_FUTURE Yes Yes N/A N/A No
Open – Legal Entity (for each segment) <Segments>
Name Description Column Number Enabled Displayed Indexed
Legal Entity Legal Entity SEGMENT1 1 Yes Yes Yes
Validation
Value Set Description Default Type Default Value Required Security Enabled
Range
XXX_GL_LEGAL_ENTITY Legal Entity Segment Yes Yes
Sizes and Prompts
Display Size Description Size Concatenated Description Size
List of Values Window
3 50 25 Legal Entity Legal Entity
Open – Account (for each segment) <Segments>
Name Description Column Number Enabled Displayed Indexed
Account SEGMENT2 2 Yes Yes Yes
Validation
Value Set Description Default Type Default Value Required Security Enabled
Range
XXX_GL_ACCOUNT Account Segment Yes Yes
Sizes and Prompts
Display Size Description Size Concatenated Description Size
List of Values Window
6 50 25 Account Account
Open – Profit Center (for each segment) <Segments>
Name Description Column Number Enabled Displayed Indexed
Profit Center SEGMENT3 3 Yes Yes Yes
Validation
Value Set Description Default Type Default Value Required Security Enabled
Range
XXX_GL_PROFIT_CENTER Profit Center Segment Yes Yes
Sizes and Prompts
Display Size Description Size Concatenated Description Size
List of Values Window
4 50 25 Profit Center Profit Center
Open – Future (for each segment) <Segments>
Name Description Column Number Enabled Displayed Indexed
Future Future SEGMENT4 4 Yes Yes Yes
Validation
Value Set Description Default Type Default Value Required Security Enabled
Range
XXX_GL_FUTURE Future Description Constant 00000 Yes No
Sizes and Prompts
Display Size Description Size Concatenated Description Size
List of Values Window
5 50 25 Future Future
GL: Define Accounting Segment Values
General Ledger>Setup>Financials>Flexfields>Key>ValuesSegment Values
<Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Use this form to define the valid financial values for each of your Accounting Segments. You can also define your account parent - child relationships. When defining parent-child hierarchies, specifically grandparents, for the hierarchy to properly function you must include “all child values” for the given range. In addition you must define the grandparent and include “all only parent values” for the same range as the children were defined.
GL: Define Currencies
General Ledger>Setup>Currencies>DefineCurrencies<Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Oracle Applications has predefined all currencies specified in ISO standard #4217. To use a currency other than U.S. Dollars (USD), you must enable the currency. U.S. Dollars (USD) is the only currency that is enabled initially.
Attention: You cannot change a currency code after you enable the currency, even if you later disable that currency.
Code Name DescriptionIssuing
Territory Symbol
Precision
Extended Precision
Minimum Accountab
le Unit
CurrencyDerivatio
nType
CurrencyDerivatio
nFactor
CurrencyDerivatio
nEffective
EffectiveDates From
Effective
Dates To
Enabled
USD Country X Dollar
Country X Dollar Country X $ 2 5 Yes
STAT Statistical
Statistical Statistical 2 5 Yes
GL: Define Calendar Types
General Ledger>Setup>Financials>Calendars>TypesPeriod Types<Customer Short Name> Process:
<Process Name>Business Area:
<Business Area>Date:
<Date>Control Number:
<Control Number>Priority(H, M, L):
<Priority (H, M, L)>Process Owner:
<Process Owner>
Description: Use this form to define the period types for your accounting calendars.
Period Type Periods per Year Year Type Description
13 Month 13 Calendar 13 Month Calendar
GL: Define Accounting Calendar
General Ledger>Setup>Financials>Calendars>AccountingAccounting Calendar<Customer Short Name> Process:
<Process Name>Business Area:
<Business Area>Date:
<Date>Control Number:
<Control Number>Priority(H, M, L):
<Priority (H, M, L)>Process Owner:
<Process Owner>
Description: Use this form to define accounting calendars.
<Accounting Calendar>
NameXXX CAL
DescriptionXXX Calendar
Enable Security
<Periods> 01-JAN-2001 to 31-DEC-2009 (table only represents a small subset to given an idea of the setup.
Prefix Type Year Quarter
Number
From To Name Adjusting
JAN 13 Month 2007 1 1 01-JAN-2007 31-JAN-2007 JAN-07FEB 13 Month 2007 1 2 01-FEB-2007 29-FEB-2007 FEB-07MAR 13 Month 2007 1 3 01-MAR-2007 31-MAR-2007 MAR-07APR 13 Month 2007 2 4 01-APR-2007 30-APR-2007 APR-07MAY 13 Month 2007 2 5 01-MAY-2007 31-MAY-2007 MAY-07JUN 13 Month 2007 2 6 01-JUN-2007 30-JUN-2007 JUN-07JUL 13 Month 2007 3 7 01-JUL-2007 31-JUL-2007 JUL-07AUG 13 Month 2007 3 8 01-AUG-2007 31-AUG-2007 AUG-07SEP 13 Month 2007 3 9 01-SEP-2007 30-SEP-2007 SEP-07OCT 13 Month 2007 4 10 01-OCT-2007 31-OCT-2007 OCT-07NOV 13 Month 2007 4 11 01-NOV-2007 30-NOV-2007 NOV-07
Prefix Type Year Quarter
Number
From To Name Adjusting
DEC 13 Month 2007 4 12 01-DEC-2007 31-DEC-2007 DEC-07ADJ 13 Month 2007 4 13 31-DEC-2007 31-DEC-2007 ADJ-08 YesJAN 13 Month 2008 1 1 01-JAN-2008 31-JAN-2008 JAN-08FEB 13 Month 2008 1 2 01-FEB-2008 29-FEB-2008 FEB-08MAR 13 Month 2008 1 3 01-MAR-2008 31-MAR-2008 MAR-08APR 13 Month 2008 2 4 01-APR-2008 30-APR-2008 APR-08MAY 13 Month 2008 2 5 01-MAY-2008 31-MAY-2008 MAY-08JUN 13 Month 2008 2 6 01-JUN-2008 30-JUN-2008 JUN-08JUL 13 Month 2008 3 7 01-JUL-2008 31-JUL-2008 JUL-08AUG 13 Month 2008 3 8 01-AUG-2008 31-AUG-2008 AUG-08SEP 13 Month 2008 3 9 01-SEP-2008 30-SEP-2008 SEP-08OCT 13 Month 2008 4 10 01-OCT-2008 31-OCT-2008 OCT-08NOV 13 Month 2008 4 11 01-NOV-2008 30-NOV-2008 NOV-08DEC 13 Month 2008 4 12 01-DEC-2008 31-DEC-2008 DEC-08ADJ 13 Month 2008 4 13 31-DEC-2008 31-DEC-2008 ADJ-08 Yes
Once you are finished entering the period or periods you desire, the “validate calendars program” should be run using the concurrent manager to verify that all the calendar data was properly input.
HR: Define Operating Units or GL: Accounting Setup Manager
Human Resources>Work Structures>Organization>Description or (General Ledger > Setup > Accounting Setup > Financials > Accounting Setup Manager > Ledger: XXX Primary > Operating Units
Corporate
Name Type
Corporate Operating Unit
Dates
From To
01-JAN-1951
Location CorporateInternal or External InternalLocation Address 2925 Briarpark Rd, Ste 1050 Location A, TX 77042Internal Address
Organization Classifications
Name Enabled
HR Organization Operating UnitOperating UnitProject Expenditure/Event Organization
Others
<Operating Unit Information>Primary Ledger XXX PrimaryDefault Legal Context XXX & SubsidiaryOperating Unit Short Code
Human Resources>Work Structures>Organization>Description or (General Ledger > Setup > Accounting Setup > Financials > Accounting Setup Manager > Ledger: XXX Primary > Operating Units
Oklahoma
Name Type
Oklahoma Operating Unit
Dates
From To
01-JAN-1951
LocationInternal or ExternalLocation AddressInternal Address
Organization Classifications
Name Enabled
Operating Unit YesProject Expenditure/Event Organization YesProject Task Owning Organization Yes
Others
<Operating Unit Information>Primary Ledger XXX PrimaryDefault Legal ContextOperating Unit Short Code
Human Resources>Work Structures>Organization>Description or (General Ledger > Setup > Accounting Setup > Financials > Accounting Setup Manager > Ledger: XXX Primary > Operating Units
Ingram
Name Type
Ingram Operating Unit
Dates
From To
01-JAN-1951
LocationInternal or ExternalLocation AddressInternal Address
Organization Classifications
Name Enabled
Operating Unit YesProject Expenditure/Event Organization YesProject Task Owning Organization Yes
Others
<Operating Unit Information>Primary Ledger XXX PrimaryDefault Legal ContextOperating Unit Short Code
Human Resources>Work Structures>Organization>Description or (General Ledger > Setup > Accounting Setup > Financials > Accounting Setup Manager > Ledger: XXX Primary > Operating Units
XXXPG San Diego
Name Type
XXXPG San Diego Operating Unit
Dates
From To
01-JAN-1951
LocationInternal or ExternalLocation AddressInternal Address
Organization Classifications
Name Enabled
Operating Unit YesProject Expenditure/Event Organization YesProject Task Owning Organization Yes
Others
<Operating Unit Information>Primary Ledger XXX PrimaryDefault Legal ContextOperating Unit Short Code
GL: Define Legal Entities
General Ledger>Setup>Financials>Accounting Setup Manager>Accounting Setups
Legal Entities
Create Legal Entity
XXX Management Co., L.P.
Identification InformationTerritory Country XLegal Entity Name XXX Management Co., L.P.Organization Name XXX Management Co., L.P.Legal Entity Identifier 804EIN/TINTransacting Entity Yes
Legal AddressLocation Corporate HeadquartersCountry Country X
Address1 2925 XXX Rd.Address2 Suite. 1050Address3City Location AStateCountry Country XPostal Code 77042
General InformationPlace of Registration DelawareInception DateNAICS 1997Type of Company Corporation
<Save and Add Details>
General
Update
Transaction Tax ProfileSet for Self Assessment / Reverse ChargeTax Classification
Registrations
Create Registration
General Information
Jurisdiction Country X – Income Tax Place of Registration Delaware
Registration Number 760586680 Issuing Legal Authority
Registered Name XXX Issuing Legal Authority Address
Alternate Registered Name
Context Value
Registration Effective FromRegistration Effective To
Registered AddressesRegistered Address XXXXXX
Legal Functions
Function Name Legal Authority Name
Legal Authority Address
GL: Define Ledgers
General Ledger>Setup>Financials>Accounting Setup Manager>Accounting Setups
Accounting Setups
XXX Primary
Create Accounting Setup
Assign Legal Entities (All Legal Entities will be assigned).
Legal Entity Name Country Legal Entity Identifier
XXX. & Subsidiaries Country X 001
Define Accounting Representations
Name Chart of Accounts Accounting Calendar Currency Sub Ledger Accounting Method
XXX Primary ACCOUNTING_FLEXFIELD
13 Month USD Standard Accrual
<Ledger Options>
<Primary Ledger>
Standard InformationLedger XXX PrimaryShort Name XXX PrimaryDescription XXX Primary LedgerCurrency USDChart of Accounts XXX Primary
Accounting CalendarAccounting Calendar XXX CALPeriod Type 13 MonthFirst Ever Open Period JAN-01
Number of Future Enterable Periods
2
Subledger AccountingSubledger Accounting Method Standard AccrualSubledger Accounting Method Owner
Oracle
Journal Entry Language American EnglishEntered Currency Balancing AccountUse Cash Basis Accounting DisabledBalance Subledger Entries by Ledger Currency
Disabled
Year End ProcessingRetained Earnings Account 001-00-294000-0000-00000Track By Secondary Segment Enabled
Journal ProcessingSuspense AccountRounding Differences Tracking AccountEnable Intra Company Balancing EnabledEnable Journal Approval EnabledEnable Journal Entry tax DisabledJournal Reversal Criteria Set
Currency Translation OptionsDefault Period End Rate TypeDefault Period Average Rate TypeCumulative Translation Adjustment Account
Journal ReconciliationEnable Journal Reconciliation
Disabled
Budgetary ControlEnable Budgetary Control
Disabled
Require Budget Journals DisabledReserve for Encumbrance Account
<Balancing Segment Value Assignments> (NONE – BSV should not be assigned to any legal entities)
Balancing Segment Value
Description Start Date End Date
<Sub Ledger Accounting Options>
Application: AP, AR, Projects, Purchasing, FA, Inventory
Accounting OptionsGL JE Entry Summarization Summarized by GL PeriodReversal Method Switch Dr/CrRounding Rule ClosestThird Party Merge Accounting Option
None
Accounting Program Defaults
Accounting Program Mode
Final Accounting Report Level No Report
Allow Mode Override Yes Allow Report Override YesTransfer to GL Yes Stop at Error Limit NoAllow transfer Override Yes Error LimitPost in GL NoAllow Post Override Yes
Event Class Options
**Note: Use standard Oracle event classes and categories
Event Class Category
<Operating Units>
Add Operating UnitsName CorporateShort Code
AssignmentsBusiness Group XXX & SubsidiariesDefault Legal Context XXX & Subsidiaries
<Intercompany Accounts>
**Intercompany accounting is not being enabled.
Intercompany AccountsTransaction Account Definition
Legal Entities
Define Relationships: <LE Name>
Transacting Balancing Segment Value
Company Trading Partner Ledger
Trading Partner Legal Entity Trading Partner Balancing Segment Value
Define Accounts
Intercompany Receivables Accounts
Additional Information Context
Account Account Description Start Date End Date Use for Balancing
Yes
Intercompany Payables Accounts
Additional Information Context
Account Account Description Start Date End Date Use for Balancing
Yes
tho<Intracompany Balancing Rules>
Define Rules>
Create Rule>
Source and Category
Ledger XXX Primary Legal Entity XXXChart of Accounts ACCOUNTING_FLEXFIELD Source OtherCurrency USD Category OtherStatus EnabledAdditional Information Context
Legal Entity Name: <No Legal Entity> Country: <Country X>
Intracompany setups are defined between companies that will interact on a regular basis (i.e. interaction between companies within the same region). Please see the Intracompany Setup tab in:
Legal Entity No Legal EntitySource OtherCategory OtherEnabled Yes
Debit Balancing Segment
Credit Balancing Segment
Debit Account Credit Account
All Other All Other 001-00-272100-0000-0000
001-00-272100-0000-00000
OptionsLevel of Summarization Summary NetClearing Balancing Segment Value Use for all journalsDefault Options Use for Many-to-Many Journals OnlyDefault Clearing Balancing Segment Value Default Value
<Sequencing> NONELedger Name XXX PrimarySequence Event – Sequence Entity GL Journal Entry – GL Period Close
Create
Sequencing ContextName
Processing OptionsRequire AssignmentValidate Sequence ByAssign Sequence By
Balancing Segment Values
Balancing Segment Value
Description Calendar
Assign Sequences
Type Priority Sequence Name Start Date
End Date Balance Type
Journal Source Journal Category
Add Secondary Ledger
Name Chart of Accounts
Accounting Calendar Currency Subledger Accounting Method
Data Conversion Level
XXX Secondary
ACCOUNTING_FLEXFIELD
XXX CAL USD Standard Accrual N/A
System Administrator>Profile>System
Profile options
Profile Site
GL: Use Performance Module
Yes
GL: Number of Accounts in Memory
1000
GL: Number of Records to Process at Once
2500
GL: Ledger Name Country X C PrimaryGL: Data Access Set XXX Primary
XXX Secondary
Create Accounting Setup
Assign Legal Entities
Legal Entity Name Country Legal Entity Identifier
XXX & Subsidiaries Country X 001
Define Accounting Representations
Name Chart of Accounts Accounting Calendar Currency Sub Ledger Accounting Method
XXX Secondary ACCOUNTING_FLEXFIELD
XXX CAL USD Standard Accrual
<Ledger Options>
<Primary Ledger>
Standard InformationLedger XXX SecondaryShort Name XXX SecondaryDescription XXX Secondary (Tax) LedgerCurrency USDChart of Accounts XXX Secondary
Accounting CalendarAccounting Calendar XXX CALPeriod Type XXX CalendarFirst Ever Open Period Jan-07Number of Future Enterable Periods
2
Subledger AccountingSubledger Accounting Method Standard AccrualSubledger Accounting Method Owner
Oracle
Journal Entry Language American English
Entered Currency Balancing AccountUse Cash Basis Accounting DisabledBalance Subledger Entries by Ledger Currency
Disabled
Year End ProcessingRetained Earnings Account 001-00-294100-0000-00000Track By Secondary Segment Enabled
Journal ProcessingSuspense AccountRounding Differences Tracking AccountEnable Intra Company Balancing EnabledEnable Journal Approval EnabledEnable Journal Entry tax DisabledJournal Reversal Criteria Set
Journal ReconciliationEnable Journal Reconciliation
Disabled
Budgetary ControlEnable Budgetary Control
Disabled
Require Budget Journals DisabledReserve for Encumbrance Account
<Balancing Segment Value Assignments>
Debit Balancing Segment
Credit Balancing Segment Start Date End Date
<Intracompany Balancing Rules>
**Rules are not necessary as they will flow from the primary ledger rules.
<Sequencing> NONELedger Name XXX PrimarySequence Event – Sequence Entity GL Journal Entry – GL Period Close
Sequencing will not be defined. Move sequence status to “Complete”
Create
Sequencing ContextName
Processing OptionsRequire AssignmentValidate Sequence ByAssign Sequence By
Balancing Segment Values
Balancing Segment Value
Description Calendar
Assign Sequences
Type Priority Sequence Name Start Date
End Date Balance Type
Journal Source Journal Category
<Primary to Secondary Ledger Mapping>
Primary Ledger XXX PrimaryChart of Accounts XXX PrimaryAccounting Calendar XXX CALCurrency USDSubledger Accounting Standard AccrualSecondary Ledger XXX SecondaryChart of Accounts XXX SecondaryAccounting Calendar XXX CALCurrency USDSubledger AccountingData Conversion Level JournalStatus Active
<Journal Conversion Rules>
Post Journals Automatically to from Source Ledger
Yes
Retain Journal Creator from Primary Ledger
Yes
<Journal Source and Category Conversion>
Source Category Transfer
Other Other NoMove/Merge Other NoMove/Merge Reversal Other NoRevaluation Other No
**Currently due to the fact that the mapping from Primary to Secondary Ledger is not functioning we will not be transferring journals until this issues is resolved. We will not currently be using this functionality as it has been a continuing issue we are working with Oracle to resolve.
GL: Chart of Accounts Mapping
General Ledger Super User>Setup>Accounts>Chart of Accounts Mapping
Mapping Description Source Target
XXX_PRIMARY_SECONDARY Mapping for Profit Center of Primary Ledger to Secondary Ledger Legal Entity
XXX Primary XXX Secondary
Segment Rules
Target (XXX Secondary) Action Source (XXX Primary)
Legal Entity Use Roll Up Rules From Profit Center
Account Copy Value From Account
Profit Center Copy Value From Profit Center
Future Copy Value From Future
** Note: Please refer to PI_GL_LegalEntity_ProfitCenter.xls for the correct grouping.
GL: Define Security Rules***Note: Security Rules will be defined upon completion of the Roles and Responsibilities design.
System Administrator>Security>Responsibility>Value Set>DefineDefine Security Rules<Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Use this form to setup data entry security on your Flexfield segments and report parameters.
<Define Security Rules>
Value Set
Name Dependent Value Set Independent Value
XXX_GL_COMPANY
Key Flexfield
Title Structure Independent Segment Dependent Segment Independent Value Value Description
Descriptive Flexfield
Title Context Independent Segment Dependent Segment Independent Value Value Description
Concurrent Program
Name Description Independent Parameter
Dependent Parameter Independent Value Description
Security Rules
Security Rules: Name Security Rules: Description
Security Rules: Message
Security Rules Elements
Security Rules Elements: Type
Security Rules Elements: From
Security Rules Elements: To
GL: Assign Security Rules***Note: XXX Security Rules will be assigned upon completion of the Roles and Responsibilities design.
System Administrator>Security>Responsibility>Value Set>AssignAssign Security Rules<Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Use this form to Assign Security Rules to an application responsibility.
<Assign Security Rules>
Value Set
Name Dependent Value Set Independent Value
XXX_GL_COMPANY
Key Flexfield
Title Structure Independent Segment Dependent Segment Independent Value Value Description
Descriptive Flexfield
Title Context Independent Segment Dependent Segment Independent Value Value Description
Concurrent Program
Name Description Independent Parameter
Dependent Parameter Independent Value Value Description
Security Rules
Application Responsibility Name
Description
Message Y
GL: Define Accounting Cross Validation Rules***Note: Cross Validation Rule design is currently underway; this document will be updated once it is complete. Here are the rules captured thus far.
1. PROFIT CENTER RULES – a Profit Center from a specified company cannot be paired with a different company (i.e. a profit center from Location E cannot be paired with a Location C Company)
2. Balance Sheet accounts should only be used with the department 00 – Unallocated.
System Administrator>Application>Flexfield>Key>Cross ValidationCross Validation Rules<Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Use this form to define Cross Validation Rules.
<Cross Validation Rules>Application Flexfield Title Structure Description
General Ledger Accounting Flexfield XXX Primary XXX Primary Accounting Flexfield
Cross Validation RulesName Description Enabled
PC_COMPANY Profit Center and Company cross-validation rule.
Yes
ACCT_DEPT_XX (where XX is Region) Department and Natural Account cross-validation rule.
Yes
DEPT_PC_XX (where XX is Region) Department and Profit Center cross-validation rule
Yes
ACCT_DEPT _ALL Department and Natural Account cross-validation rule.
Yes
Error Message Error Segment From To
Error: Profit Center not valid for this Company
Profit Center
Error: Account not valid with this Department
Account
Error: Department not valid with this Profit Center
Department
Error: Account not valid with this Department
Account
Cross Validation Rule ElementsType From To
Include -00-000000--- -00-520000--
**Note: Please see Excel Spreadsheet with cross validation combinations. Cross-validation rules will be company specific with respect to profit centers and departments.
GL: Define Journal Entry Sources
General Ledger>Setup>Journal>SourcesJournal Sources<Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Use this form to define journal entry sources for journal approval.
<Journal Sources>Source Source
KeyDescription Import Journal
ReferencesFreeze Journals
Require Journal Approval
Import Using Key
Effective Date Rule
ADP ADP System Yes No Yes
TMT TMT System Yes No No
Great Plains Great Plains System Yes No No
Titan Titan System Yes No No
MAS200 MAS200 System Yes No Yes
Recurring Recurring Journal Entry No No Yes
Manual Manual Journal Entry No No Yes
Spreadsheet – Web ADI Spreadsheet No No Yes
Subledgers (Assets, Inventory, etc.)
Given by system Yes Yes No
Intercompany Intercompany No No No
MassAllocation MassAllocation No No Yes
Budget Journal Budget Journal No No Yes
All Seeded Values will be used
Default Default Default
When enabling Web ADI journal functionality, macros in Excel must be enabled and Visual Basic editing must be allowed for the functionality to work properly.
GL: Define Journal Entry Categories***The categories listed only represented a small subset of the actual categories available.
General Ledger>Setup>Journal>CategoriesJournal Categories<Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Use this form to define your Journal Entry Categories. Oracle uses these categories to describe the purpose of your journal entry, such as accrual, payments, or receipts.
<Journal Categories>The following listing only represents categories that were created in Oracle, numerous default categories already exist.
Category Category Key Description
Conversion Conversion All historical journals imported from Great Plains
Interface Interface Interface data from GP, Titan, or MAS200
Corporate Intercompany Corporate Intercompany Intercompany Journal Entries
Corporate Reverse Corporate Reverse Corporate Reversing Entries
GL: Define Journal Reversal Criteria***Note: XXX Journal Reversal Criteria will be defined upon completion of the Journal Sources/Categories definition.
General Ledger>Setup>Journal>AutoReverseJournal Reversal Criteria Set<Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Use this form to define your Journal Reversal Criteria Set.
<Journal Reversal Criteria Set>
Criteria Set Description Enable Security
Reversing Journals Reversing Journals No
Assign Access<Assign Access>
Definition Access Set Use View Modify
Journal Reversal Criteria
Category Reversal Period Reversal Date (Average Balances Only)
Method AutoReverse
AutoPost Reversal
Reverse Next non-Adjusting Period
First Day Switch Dr/Cr Yes Yes
Balance Sheet Close
Next non-Adjusting Period
First Day Switch Dr/Cr No No
Income Offset Next non-Adjusting Period
First Day Change Sign No No
Category Reversal Period Reversal Date (Average Balances Only)
Method AutoReverse
AutoPost Reversal
Income Statement Close
Next non-Adjusting Period
First Day Change Sign No No
Assign Reversal Criteria Set to Ledgers
General Ledger>Setup>Accounting Setup Manager > Accounting Setups > Go
Ledger: XXX Primary
<Update Accounting Options>
Setup Step: XXX Primary
<Update>
Journal Reversal Criteria Set = “Reversing Journals”
GL: Define Automatic Posting Criteria
General Ledger>Setup>Journal>AutoPostAutoPost Criteria Set<Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Use this form to specify journal batches for automatic posting. Journals coming from Sub-ledgers and interfaced journal entries from Great Plains will autopost.
Autopost Criteria Sets
Criteria Set Description Enabled Enable Security
Subledger Journal Batches Subledger Journal Batches Yes
Interface Journal Batches Interface Journal Batches Yes
Approved Journal Batches Approved Journal Batches Yes
Assign AccessAssign Access
Definition Access Set Use View Modify
Posting Submission Options
Submit All Priorities in Order Submit Only Priorities with Batches in Order
Number of Priorities
Yes
Journal Effective Dates
From ___ days before current date To ___ days after current date
500 500
<Subledger Journal Criteria Set>
Priority Ledger/Ledger Set
Source Category Balance Type Period
1 XXX Primary Payables All Actual All
1 XXX Primary Receivables All Actual All
1 XXX Primary Inventory All Actual All
1 XXX Primary Assets All Actual All
1 XXX Primary Projects All Actual All
1 XXX Primary Purchasing All Actual All
1 XXX Primary Cash Management All Actual All
1 XXX Primary Cost Management All Actual All
Schedule
<Submit Request>
Name SSubledger Journal Batches
Operating Unit A
Parameters
Language
Run the Job:
As Soon As Possible
Schedule
Once
PeriodicallyWeekly – Sunday at 3:00 a.m.
On Specific Days
Advanced
Options
Save All Output to Files
Layout
Template Name Template Language Format For Language
Notify the following People
Name For Language
Print the Output To:
StyleLandscape
Printer Copies For Language
Journal Effective Dates
From ___ days before current date To ___ days after current date
500 500
<Interface Journal Criteria Set>
Priority Ledger/Ledger Set
Source Category Balance Type Period
1 XXX Primary Great Plains All ALL All
1 XXX Primary MAS200 All ALL All
1 XXX Primary Titan All All All
1 XXX Primary Command All All All
Schedule
<Submit Request>
NameInterface Journal Posting
Operating Unit A
Parameters
Language
Run the Job:
As Soon As Possible
Schedule
OnceWill be adhoc once period is closed in Great Plains.
Periodically
On Specific Days
Advanced
Options
Save All Output to Files
Layout
Template Name Template Language Format For Language
Template Name Template Language Format For Language
Notify the following People
Name For Language
Print the Output To:
StyleLandscape
Printer Copies For Language
<Interface Journal Criteria Set>
Priority Ledger/Ledger Set
Source Category Balance Type Period
1 XXX Primary Manual All ALL All
1 XXX Primary Manual (Copied) All ALL All
1 XXX Primary Recurring All ALL All
1 XXX Primary MassAllocation ALL ALL All
1 XXX Primary Statistical ALL ALL ALL
Schedule
<Submit Request>
NameApproved Journals
Operating Unit A
Parameters
Language
Run the Job:
As Soon As Possible
Schedule
OnceWill be set to run on nightly basis, ad hoc capability is available.
Periodically
On Specific Days
Advanced
Options
Save All Output to Files
Layout
Template Name Template Language Format For Language
Notify the following People
Name For Language
Print the Output To:
StyleLandscape
Printer Copies For Language
GL: Define Journal Authorization Limits***Note: XXX Journal Authorization Limits will be defined upon completion of the Roles and Responsibilities design.
General Ledger>Setup>Employees>LimitsJournal Authorization Limits <Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Use this form to define journal authorization limits.
**Journal Authorization Limits will not be utilized by XXX.
In place of the journal authorization limits a customized journal approval workflow has been developed. The main features of this journal include that every manual journal must be approved prior to it being posted. The individual who created the journal cannot be approved by the person who also created it. In addition to that restriction, if a journal is applicable to more then one company the journal will require approval from both companies (can only be two) before the journal is actually approved.
GL: Define Data Access Sets***Note: The Data Access Sets detailed in this section represent the CRP Access Sets and are subject to change upon completion of the Roles and Responsibilities design.
Data Access Sets are only applicable to General Ledger responsibilities – subledger modules are not affected by these data access sets.
General Ledger>Setup>Financials>Data Access SetData Access Set<Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Use this form to define data access sets.
<Data Access Set> Location C Only
Data Access Set Description Chart of Accounts Calendar Access Set Type
Default Ledger Period Type
Location C Company Only Location C Company Values Only
XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Location C Transactional Location C Transactional XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Corporate Company Only Corporate Company Values Only
XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Corporate Transactional Corporate Transactional XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Location E Company Only Location E Company Values Only
XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Location E Transactional Location E Transactional XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Eastern Company Only Eastern Company Values Only XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Eastern Transactional Eastern Transactional XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Superior DC Company Only Superior DC Company Values Only
XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Superior DC Transactional Superior DC Transactional XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Redi-Mix Company Ony Redi-Mix Company Values Ony
XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Redi-Mix Transactional Redi-Mix Transactional XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Oklahoma Company Only Oklahoma Company Values Only
XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Oklahoma Transactional Oklahoma Transactional XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Data Access Set Description Chart of Accounts Calendar Access Set Type
Default Ledger Period Type
Ingram Company Only Ingram Company Values Only XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Ingram Transactional Ingram Transactional XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
XXXPG San Diego Company Only
XXXPG San Diego Company Values Only
XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
XXXPC San Diego Transactional
XXXPC San Diego Transactional
XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
XXXPG Phoenix Company Only
XXXPG Phoenix Company Only
XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
XXXPG Phoenix Transactional
XXXPG Phoenix Transactional XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
XXXPG Central PC Company Only
XXXPG Central PC Company Only
XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
XXXPG Central PC Transactional
XXXPG Central PC Transactional
XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
API Company Only API Company Values Only XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
API Transactional API Transactional XXX Primary XXX CAL Balancing Segment Value
XXX Primary 13 Month
Access Details
Ledger/Ledger Set Values – All Values – Specific Privilege
XXX Primary No 016 Read and Write
XXX Primary No 016, 001 Read and Write
XXX Primary No 001 Read and Write
XXX Primary Yes Read and Write
XXX Primary No 014, 015, 021, 022, 023 Read and Write
XXX Primary No 001. 014, 015, 021, 022, 023 Read and Write
XXX Primary No 002. 007, 025, 003, 024, 004 Read and Write
XXX Primary No 002. 007, 025, 003, 024, 004, 001 Read and Write
XXX Primary No 005, 006 Read and Write
XXX Primary No 005, 006, 001 Read and Write
XXX Primary No 008. 009. 012. 013 Read and Write
XXX Primary No 008. 009. 012. 013, 001 Read and Write
XXX Primary No 010 Read and Write
XXX Primary No 010, 001 Read and Write
XXX Primary No 011 Read and Write
XXX Primary No 011, 001 Read and Write
Ledger/Ledger Set Values – All Values – Specific Privilege
XXX Primary No 018 Read and Write
XXX Primary No 018. 001 Read and Write
XXX Primary No 019 Read and Write
XXX Primary No 019, 001 Read and Write
XXX Primary No 017 Read and Write
XXX Primary No 017. 001 Read and Write
XXX Primary No 020 Read and Write
XXX Primary No 020, 001 Read and Write
GL: Define and Assign Security Access for Data Access Set Definitions
General Ledger>Setup>Financials>Definition Access Sets>Define and AssignDefinition Access Sets<Customer Short Name> Process:
<Process Name>Business Area:
<Business Area>Date:
<Date>Control Number:
<Control Number>Priority(H, M, L):
<Priority (H, M, L)>Process Owner:
<Process Owner>
Description: Use this form to assign security access for data access set definitions. With this form you can grant access to definitions for a subset of users and deny access to other users. Super User Definition Access Sets cannot be updated or deleted.
Create
Name
Description
Definition Assignments
Type Name Privileges – Use
Privileges – View
Privileges - Modify
Responsibility Assignments
Responsibility Application Security Group Automatic Privileges – Use
Automatic Privileges – View
Automatic Privileges - Modify
GL: Define Intercompany/Interfund Accounts***Note: XXX will not utilize Intercompany/Interfund Accounting setups. They are not assigning any balancing segments to Legal Entities thus there is no need to define intercompany rules.
General Ledger>Setup>Accounts>Inter-CompanyIntercompany Accounts<Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Use this form to define additional Inter-Company Accounts. This form lets you control Oracle General automatic Inter-Company balancing.
Source Category Balanced by
Company Due From Account Due To Account Account Descriptions: Due From
Account Descriptions: Due To
Clearing Company Usage
Clearing Company Usage
Default Options
Action if No Clearing Company is Specified
GL: Define Statistical Units of Measure***NOTE: Statistical accounts will be utilized but the final accounts and statistics needed are still in design. We have finalized the STAT accounts and measures. Only those accounts that begin with 99XXXX will be STAT accounts, also the contra-STAT accounts that were present in Great Plains will not be utilized in Oracle because STAT accounts can be unbalances.
General Ledger>Setup>Accounts>UnitsStatistical Units of Measure<Customer Short Name> Process:
<Process Name>
Business Area: <Business Area>
Date: <Date>
Control Number: <Control Number>
Priority(H, M, L): <Priority (H, M, L)>
Process Owner: <Process Owner>
Description: Use this form to define your statistical Units of measure and assign them to your account segment values.
Use this region to define Statistical Units of Measure and assign them to your account segment values.
Account Unit of Measure Description
Headcount Gives a detailed headcount
Cubic Yards (cyds) Volume statistic for concrete poured
Tons Quantity of measure
Gallons Gallons
Kilowatts Killowatts
Therms Therms
Hours Hours
Units Units
Miles Miles
GL: Define Budgets and YearsAlthough budgeting will not be used in Oracle General Ledger, we are still importing the historical budget data for reporting purposes into the GL.
General Ledger>Budgets > Define > Organization
**It has been determined that only 4 years of budgets will be converted, this is 4 less than the original eight that were planned.
Ranges
Line Low High Currency
10 000-00-000000-0000-00000 ZZZ-ZZ-989990-ZZZZ-ZZZZ USD
20 000-00-990000-0000-00000 ZZZ-ZZ-998999-ZZZZ-ZZZZ STAT
30 000-00-999000-0000-00000 ZZZ-ZZ-ZZZZZZ-ZZZZ-ZZZZ USD
General Ledger>Budgets > Define > Budget
Budget Description Ledger Status Budget Period: First
Budget Period: Last
XXX2001 2001 XXX Budget XXX Primary Open Jan-01 Dec-01
XXX2001A 2001 XXX Budget A XXX Primary Open Jan-01 Dec-01
XXX2002 2002 XXX Budget XXX Primary Open Jan-02 Dec-02
XXX2002A 2002 XXX Budget A XXX Primary Open Jan-02 Dec-02
XXX2003 2003 XXX Budget XXX Primary Open Jan-03 Dec-03
XXX2003A 2003 XXX Budget A XXX Primary Open Jan-03 Dec-03
XXX2004 2004 XXX Budget XXX Primary Open Jan-04 Dec-04
Organiztion U.S. ConcreteDescription Legacy Conversion Budget
OrgLedger XXX PrimaryOrdering Segment AccountDisplay Sequence 1-2-3-4-5
Budget Description Ledger Status Budget Period: First
Budget Period: Last
XXX2004A 2004 XXX Budget A XXX Primary Open Jan-04 Dec-04
XXX2005 2005 XXX Budget XXX Primary Open Jan-05 Dec-05
XXX2005A 2005 XXX Budget A XXX Primary Open Jan-05 Dec-05
XXX2006 2006 XXX Budget XXX Primary Open Jan-06 Dec-06
XXX2006A 2006 XXX Budget A XXX Primary Open Jan-06 Dec-06
XXX2006B 2006 XXX Budget B XXX Primary Open Jan-06 Dec-06
XXX2007 2007 XXX Budget XXX Primary Open Jan-07 Dec-07
XXX2007A 2007 XXX Budget A XXX Primary Open Jan-07 Dec-07
XXX2007B 2007 XXX Budget B XXX Primary Open Jan-07 Dec-07
XXX2008 2008 XXX Budget XXX Primary Open Jan-08 Dec-08
XXX2008A 2008 XXX Budget A XXX Primary Open Jan-08 Dec-08
GL: Miscellaneous Profile Options
1. MO: Security Profile – Updateable and Viewable at General Ledger Application Level.
2. Sequential Number – Site Level = Partially Used; Application: General Ledger = Not Used
3. Viewer: Text = Browser
4. GL: Data Access Set (will be Company/Operating Unit Specific by Responsibility); Site = XXX Primary
a. XXX GL JOURNAL APPROVE CORP = Corporate Company Only
b. XXX GL JOURNAL APPROVE MICH = Location E Company Only
c. XXX GL (Responsibility Name) CORP = Corporate Transactional
d. XXX GL (Responsibility Name) MICH = Location E Transactional
5. GL Ledger Name: XXX Primary (Site)
6. Journals: Allow Preparer Approval (Site = No)
7. Journals: Mix Statistical and Monetary (Site = No)
Open and Closed Issues for this Deliverable
Open Issues
ID Issue Resolution Responsibility Target Date Impact Date
Closed Issues
ID Issue Resolution Responsibility Target Date Impact Date