Br100 General Ledger Complete
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Br100 General Ledger Complete as PDF for free.
More details
- Words: 2,822
- Pages: 28
247 CUSTOMERS BR.100 Application Setup General Ledger 11i
Author:
Madhava Rao.M
Date:
07-JUN-2007
Control Number:
1.0
Approvals: Amith Amarnath
VP-India-247
Document Control Change Record
Date
Author
Change Reference
07-JUN-07
Madhav Rao
No previous document
Reviewers
Name
Position
Sehadri.V
Distribution Copy No.
Name
Location
1 2 3 4
2
General Ledger Setup Flow Create Set of Books Step 1 - Define Value Sets Step 2 - Define Flex field Structure Step 3 - Define & Load Segment Values Step 4 - Define Period Types Step 5- Define Accounting Calendar Step 6 - Define Currencies Step 7 - Define Set of Books
Define Organization Step 8 - Define Business Organization Step 9 - Run multi-org conversion
Define Controls Step 10 - Define Journal Sources Step 11 - Define Categories Step 12 - Define a Budget Step 13 - Define a Budget Organization Step 14 - Run optimizer Document Define System Controls Step 15 - Set Profile Options
Additional Steps Design & Create Parent Accounts Design, Write, & Test FSG’s Design & Create Budgets and Budget Organizations Setup Users
3
Step 1 - Define Value Sets - Segment 1 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Value Set Name: Entity Description: Entity Format Type: Char Maximum Size: 3 Validation Type: Independent
Page 1 of 9
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flex field, Report, Flex builder, Other) Entity
Sample Values 001
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: No No Value Sets that Depend on this Value Set (if any): None
Used by (Flex field Structure, Context, Function, Other) Entity
Minimum Value: NO Maximum Value: No
Used by (Segment or Parameter) SEGMENT 1
Value Descriptions Manila Philippines
4
Step 1 - Define Value Sets - Segment 2 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Value Set Name: Natural Accounts Description: Natural Accounts Format Type: Char Maximum Size: 8 Validation Type: Independent
Page 2 of 9
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flexfield, Report, Flexbuilder, Other) Natural Accounts
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: No No Value Sets that Depend on this Value Set (if any): None
Used by (Flexfield Structure, Context, Function, Other) Natural Accounts
Minimum Value: No Maximum Value: No
Used by (Segment or Parameter) SEGMENT 2
Sample Values
Value Descriptions
2000000
Liability
5
Step 1 - Define Value Sets - Segment 3 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Value Set Name: Program Description: Program Format Type: Char Maximum Size: 8 Validation Type: Independent
Page 3 of 9
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flexfield, Report, Flexbuilder, Other) Program
Sample Values 1020100
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: No No Value Sets that Depend on this Value Set (if any): None
Used by (Flexfield Structure, Context, Function, Other) Program
Minimum Value: No Maximum Value: NO
Used by (Segment or Parameter) SEGMENT 3
Value Descriptions UNABSORBED COSTS
6
Step 1 - Define Value Sets - Segment 4 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Value Set Name: Revenue Origin Description: Revenue Origin Format Type: Char Maximum Size: 3 Validation Type: Independent
Page 4 of 9
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flexfield, Report, Flexbuilder, Other) Revenue Origin
Sample Values 001
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: NO No Value Sets that Depend on this Value Set (if any): None
Used by (Flexfield Structure, Context, Function, Other) Revenue Origin
Minimum Value: No Maximum Value: No
Used by (Segment or Parameter) SEGMENT 4
Value Descriptions United States
7
Step 1 - Define Value Sets - Segment 5 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Value Set Name: Client Code Description: Client Code Format Type: Char Maximum Size: 5 Validation Type: Independent
Page 5 of 9
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flexfield, Report, Flexbuilder, Other) Client Code
Sample Values 001
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: NO No Value Sets that Depend on this Value Set (if any): None
Used by (Flexfield Structure, Context, Function, Other) Client Code
Minimum Value: No Maximum Value: No
Used by (Segment or Parameter) SEGMENT 5
Value Descriptions ADOBE
8
Step 1 - Define Value Sets - Segment 6 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Value Set Name: Line Of Business Description: Line Of Business Format Type: Char Maximum Size: 3 Validation Type: Independent
Page 6 of 9
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flexfield, Report, Flexbuilder, Other) Line Of Business
Sample Values 100
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: NO No Value Sets that Depend on this Value Set (if any): None
Used by (Flexfield Structure, Context, Function, Other) Line Of Business
Minimum Value: No Maximum Value: No
Used by (Segment or Parameter) SEGMENT 6
Value Descriptions Financial Services
9
Step 1 - Define Value Sets - Segment 7 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Value Set Name: Entity (Inter Unit) Description: Entity Format Type: Char Maximum Size: 3 Validation Type: Independent
Page 7 of 9
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flex field, Report, Flex builder, Other) Entity
Sample Values 001
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: No No Value Sets that Depend on this Value Set (if any): None
Used by (Flex field Structure, Context, Function, Other) Entity
Minimum Value: NO Maximum Value: No
Used by (Segment or Parameter) SEGMENT7
Value Descriptions 247-US
10
Step 1 - Define Value Sets - Segment 8 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Two accounting flex field segments have been reserved for future use. Value Set Name: Spare 1 Description: Spare 1 Format Type: Char Maximum Size: 3 Validation Type: Independent
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flexfield, Report, Flexbuilder, Other) Spare 1
Sample Values 000
Page 8 of 9
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: No No Value Sets that Depend on this Value Set (if any): None
Used by (Flexfield Structure, Context, Function, Other) Spare 1
Minimum Value: NO Maximum Value: NO
Used by (Segment or Parameter) SEGMENT 8
Value Descriptions Default Value
11
Step 1 - Define Value Sets - Segment 6 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Two accounting flexfield segments have been reserved for future use. Value Set Name: Spare 2 Description: Spare 2 Format Type: Char Maximum Size: 3 Validation Type: Independent
Alphabetic Char. Allowed: Yes Uppercase Only: Yes
Value Set Used by Name of Flexfield, Report, Flexbuilder, Other) Spare 2
Sample Values 000
Page 9 of 9
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: No No Value Sets that Depend on this Value Set (if any): None
Used by (Flexfield Structure, Context, Function, Other) Spare 2
Minimum Value: NO Maximum Value: No
Used by (Segment or Parameter) SEGMENT 9
Value Descriptions Default Value
12
Step 2 - Define Flexfield Structures (Setup-Financials-Flexfields-Key-Segments) Date: Notes:
Page 1 of 2
Application: Oracle General Ledger
Title
24 7 CUSTOMER ACCOUNTING_FLEX
Flex field Title:247 Customer Accounting Flex
Description
24 7 CUSTOMER ACCOUNTING_FLEX
View Name
24 7 CUSTOMER ACCOUNTING_F LEX
Freeze Flex field Def
Enabled
Seg. Sep.
Cross Val. Seq
Yes
Yes
. (Period)
No
Freeze Roll Ups
Allow Dynamic Inserts
No. of Seg
Yes
9
13
Step 2 - Define Flex field Structures (Setup-Financials-Flex fields-Key-Segments)
Page 2 of 2
Date: Notes: Key Flex field Title: 24 7 CUSTOMER ACCOUNTING_FLEX
Number of Segments (columns) 9
Structure Name/Description: 24 7 CUSTOMER ACCOUNTING FLEXFIELD
Number
Name
Window Prompt
Column
Value Set
Displayed
Enabled
Flexfield Qualifier
1
Entity
Entity
Segment 1
Entity
Yes
Yes
Balancing Segment
2
Natural Accounts
Segment 2
Natural Accounts
Yes
Yes
Natural Account Segment
3
Program
Natural Accounts Program
Segment 3
Program
Yes
Yes
4
Revenue Origin
Revenue Origin
Segment 4
Revenue Origin
Yes
Yes
5
Client Code
Client Code
Segment 5
Client Code
Yes
Yes
6
Line of Business
Line of Business
Segment 6
Line of Business
Yes
Yes
Cost Center Segment
7
Inter Unit
Inter Unit
Segment 7
Inter Unit
Yes
Yes
Inter Company Segment
8
Spare 1
Spare 1
Segment 8
Spare 1
Yes
Yes
9
Spare 2
Spare 2
Segment 9
Spare 1
Yes
Yes
14
Step 3 - Define Period Types (Setup-Calendar-Types) Process:
Business Area:
Date:
General Ledger Description: Use this form to define your accounting period types.
General Ledger provides standard period types Month, Quarter and Year. These period types are used when defining the accounting calendar for your organization. 247 Customer will use the Fiscal Calendar.
Accounting Period Types Zone Name
Number/Year
Year Type in Name
Description
Month (seeded)
12
Calendar
Month
Quarter (seeded)
4
Fiscal
Quarter
Year (seeded)
1
Fiscal
Year
247-13
13
Fiscal
24 7 Customer Calendar
15
Step 4 - Define Calendar (Setup-Calendar-Accounting) Required Step Process:
Business Area:
Date:
General Ledger Description: Use this form to define your calendar. You associate a calendar and a period type with each set of books. Once the first accounting period is opened, prior periods cannot be opened. The General Ledger Super user may open additional future periods when desired or required.
Calendar Zone
Use this zone to specify a name and a description for your calendar. 247 Cust Calendar Name Description
247 Customer Calendar
Accounting Periods Zone
Use this zone to specify the accounting periods you will include in you calendar and to provide detailed information for each of these periods. For example Name
Period Type
Year
Quarter
Period
From
To
System Name
Adjusting Period
APR-2007
247-13
2008
1
1
01-APR-2007
30-APR-07
APR-2007-08
No
MAY 2007
247-13
2008
1
2
01-MAY-2007
31-MAY-2007
MAY 2007-08
No
JUN 2007
247-13
2008
1
3
01-JUN-2007
30-JUN-2007
JUN 2007-08
No
JUL 2007
247-13
2008
2
4
01-JUL-2007
31-JUL-2007
JUL-2007-08
No
AUG 2007
247-13
2008
2
5
01-AUG-2007
31-AUG-2007
AUG-2007-08
No
SEP-2007
247-13
2008
2
6
01-SEP-2007
30-SEP-2007
SEP-2007-08
No
OCT 2007
247-13
2008
3
7
01-OCT-2007
31-OCT-2007
OCT-2007-08
No
NOV-2007
247-13
2008
3
8
01-NOV-2007
30-NOV-2007
NOV-2007-08
No
DEC-2007
247-13
2008
3
9
01-DEC-2007
31-DEC-2007
DEC-2007-08
No
JAN-2007
247-13
2008
4
10
01-JAN-2008
31-JAN-2008
JAN-2008-08
No
FEB-2007
247-13
2008
4
11
01-FEB-2008
29-FEB-2008
FEB-2008-08
No
MAR-2007
247-13
2008
4
12
01-MAR-2008
31-MAR-2008
MAR-2008-08
No
ADJ-2007
247-13
2008
4
13
31-MAR-2008
31-MAR-2008
ADJ-2008-08
Yes
16
Step 5 - Define Currency (Setup-Currencies-Define) Process:
Business Area:
Date:
General Ledger Description: Use this form to enable currencies and to define non-ISO (International Standards Organization) currencies. Oracle General Ledger has predefined all International Standards Organization (ISO) currencies used for the precision fields. 24 7 CUSTOMER WILL BE USING USD FOR INITIAL IMPLEMENTATION. THESE WILL NEED TO BE ENABLED.
USD
Code Name Description Issuing Territory
US Dollar
STAT
US Dollar
STAT
USA $
Symbol Standard Precision Extended Precision
STAT
2 5
Minimum Accountable Unit Effective Date From Effective Date To Enabled
Yes
17
Step 6 - Define Set Of Books (Setup-Books) Process:
Business Area:
Date:
General Ledger Description: Use this form to define a set of books as well as to define your budgetary control options. Attention: ENSURE THE ACCOUNTING FLEXFIELD IS SET UP BEFORE ATTEMPTING THIS PROCESS Set Of Books Zone Name
247 Customer, Inc.
Short Name
247-US
Description
24/7 Customer, Inc.
Chart Of Accounts
247 CUSTOMER ACCOUNTING_FLEX
Functional Currency
USD
Calendar
247_Calendar
Period Type
247-13
Future Periods
13
Standard Options Allow Suspense Posting
Yes
Balance Intercom any Journals
Yes
Enable Average Balances
No
Enable Journal Approval
No
Enable Journal Entry Tax
No
Average Balance Options Consolidation Set of Books
No
18
Transaction Calendar
No
Transaction Rate Type
No
Translate Optional Amount Types EOD
No
QATD
No
YATD
No
Budgetary Control Options Enable Budgetary Control
Yes
Require Budget Journals
Yes
Reporting Currency Option
Not applicable (option selected)
Accounts Zone Accounting Flex field Retained Earnings
001.3405215.0000000.001.00000.000.001.000.000
Suspense
001.80001.0000000.001.00000.000.001.000.000
Intercompany
Yes
Translation Adjustment
Yes
Reserve For Encumbrances Net Income
Description
Retained Earnings
001.2230220.0000000.001.00000.000.001.000.000 N/A
19
GL: Define Intercompany/Interfund Accounts General Ledger>Setup>Accounts>Inter-Company Business Area: Date: Process: <Business Area> Description: Use this form to define additional Inter-Company Accounts. This form lets you control Oracle General automatic Inter-Company balancing.
Use this region to define additional Inter-Company Account for each of your journal sources and categories. Source
Category
Type (Debit/Credit)
Entity
Due From Account
Due To Account
Others
Others
Many to Many Inter company
001
001.9500005.0000000.001.00000.000.001.000.000
001.9500005.0000000.001.00000.000.001.000.000
Others
Others
Many to Many Inter company
051
051.9500015.0000000.051.00000.000.051.000.000
051.9500015.0000000.051.00000.000.051.000.000
Others Others Others Others Others Others
Others Others Others Others Others Others
Many to Many Inter company
101
101.9500010.0000000.101.00000.000.101.000.000
101.9500010.0000000.101.00000.000.101.000.000
Many to Many Inter company
111
111.9500010.0000000.101.00000.000.111.000.000
111.9500010.0000000.101.00000.000.111.000.000
Many to Many Inter company
121
121.9500010.0000000.101.00000.000.121.000.000
121.9500010.0000000.101.00000.000.121.000.000
Many to Many Inter company
131
131.9500080.0000000.101.00000.000.131.000.000
131.9500080.0000000.101.00000.000.131.000.000
Many to Many Inter company
201
201.9500030.0000000.201.00000.000.201.000.000
201.9500030.0000000.201.00000.000.201.000.000
Many to Many Inter company
All Other
001.9500005.0000000.001.00000.000.001.000.000
001.9500005.0000000.001.00000.000.001.000.000
20
Step 7 - Define Journal Entry Sources (Setup-Journal-Sources) Required Step-247 Customer Provided FastForward Financial will be using Default Journal Sources Process:
General Ledger Description:
Business Area:
Date:
Use this form to define your journal entry sources and specify for a given source whether you want Oracle Journal Ledger to import journal reference information from your feeder systems.
Journal sources identify the origin of journal entries. General Ledger supplies a number of predefined journal sources. In addition to these predefined sources, at least one journal source for each non-Oracle feeder systems should be defined to help track imported journal entries.
Journal Entry Sources Zone Name
Description
Journal Import Reference (Yes/No)
Freeze Journals (Yes/No)
Manual
Manual
No
Yes
Multisoft
Multisoft Interface
Yes
Yes
Payables
Accounts Payable System
Yes
Yes
Payroll
Payroll System
Yes
Yes
Projects
Projects
Yes
Yes
Receivables
Accounts Receivable System
Yes
Yes
Spreadsheet
Spreadsheet
Yes
Yes
Treasury
Treasury
Yes
Yes
Budget - Indexation
Budget - Indexation
21
Step 8 - Define Journal Entry Categories (Setup-Journal-Categories) Process:
Business Area:
Date:
General Ledger Description: Use this form to define your journal entry categories. Oracle General Ledger uses these categories to describe the purpose of your Journal entry, such as accrual, payments, or receipts. Journal categories help differentiate journal entries by purpose or type, such as accrual, payments or receipts. Oracle General Ledger provides a number of predefined journal categories. See the following page for a listing of categories provided as Oracle defaults.
22
General Ledger provides the following predefined journal categories: Name
Description
247 Manuals Budget Allocation Addition Adjustment CIP Addition CIP Adjustment CIP Reclassification CIP Retirement CIP Transfer Credit Memo Applications Cross Currency Credit Memos Depreciation Depreciation Adjustment Masc. Receipts Payments Purchase Invoices Reclass Retirement Revaluation Revalue Profit/Loss Trade Receipts Transfer Credit Memos Deferred Depreciation Credit Memo Applica Addition Adjustment CIP Addition CIP Adjustment CIP Reclassification CIP Retirement CIP Transfer Credit Memo Applications Cross Currency Credit Memos Depreciation
247 Manuals Budget Allocation Addition Adjustment CIP Addition CIP Adjustment CIP Reclassification CIP Retirement CIP Transfer Credit Memo Applications Cross Currency Credit Memos Depreciation Depreciation Adjustment Masc. Receipts Payments Purchase Invoices Reclass Retirement Revaluation Revalue Profit/Loss Trade Receipts Transfer Credit Memos Deferred Depreciation Credit Memo Applica Addition Adjustment CIP Addition CIP Adjustment CIP Reclassification CIP Retirement CIP Transfer Credit Memo Applications Cross Currency Credit Memos Depreciation
23
Step 12 - Update System Profile Option (In Systems Administration module: Profile-System) Required Step Process:
General Ledger Description: more
Business Area:
Date:
Profile Options how the Oracle General Ledger application control access to and processing data. Profile options can be set at one or
Following levels. Oracle General Ledger applications use the Update Personal Profile Options form to set profile options only at the user Level. In order for a Set of Books to be accessible, the profile for the book must be created in the System Administration module.
System Profile Options: Option
Site Level Setting
FSG: Accounting Flexfield
Accounting Flexfeild
FSG: Allow Portrait Print Style
Yes
FSG: Expand Parent Value
Yes
FSG: Message Detail
Minimal
FSG: Enforce Segment Value Security
Yes
GL AHE: Saving Allowed
Yes
Setting
User Setting
GL Set of Books ID GL Set of Books Name
247-US
Journals: Allow Multiple Exchange Rates
No
Journals: Allow Non-Business Day Transactions
No
Journals: Allow Preparer Approval
No
Journals: Default Category Journals: Display Inverse Rate
Yes
Journals: Enable Prior Period Notification
Yes
Journals: Find Approver Method
N/A
Journals: Mix Statistical and Monetary
Yes
Journals: Override Reversal Method
No
24
Open And Close Periods (Setup-Open/Close) Process:
Business Area:
Date:
General Ledger Description: Use this form to open and close accounting periods in your calendar.
Accounting Period Zone
Use this zone to review the latest open accounting period and to open the next accounting period. APR-2004-05 Latest Open Open Next
MAY-2004-05
Encumbrance Year 2006 Latest Open Open Next
2007
Accounting Periods Zone
Use this zone to review information such as period status, period number, fiscal year, period name, and date ranges for each accounting period. Status
Number
Fiscal Year
Name
Start End
Open
APR-2004-05
2005
01-APR-2004
30-APR-2004
Open
MAY-2004-05
2005
01-MAY-2004
31-MAY-2004
Open
JUN-2004-05
2005
01-JUN-2004
30-JUN-2004
25
26
Open and Closed Issues for this Deliverable Open Issues ID
Issue
1
Budgets
Resolution
Responsibility
Target Date
Impact Date
Resolution
Responsibility
Target Date
Impact Date
Closed Issues ID
Issue
27
28
Author:
Madhava Rao.M
Date:
07-JUN-2007
Control Number:
1.0
Approvals: Amith Amarnath
VP-India-247
Document Control Change Record
Date
Author
Change Reference
07-JUN-07
Madhav Rao
No previous document
Reviewers
Name
Position
Sehadri.V
Distribution Copy No.
Name
Location
1 2 3 4
2
General Ledger Setup Flow Create Set of Books Step 1 - Define Value Sets Step 2 - Define Flex field Structure Step 3 - Define & Load Segment Values Step 4 - Define Period Types Step 5- Define Accounting Calendar Step 6 - Define Currencies Step 7 - Define Set of Books
Define Organization Step 8 - Define Business Organization Step 9 - Run multi-org conversion
Define Controls Step 10 - Define Journal Sources Step 11 - Define Categories Step 12 - Define a Budget Step 13 - Define a Budget Organization Step 14 - Run optimizer Document Define System Controls Step 15 - Set Profile Options
Additional Steps Design & Create Parent Accounts Design, Write, & Test FSG’s Design & Create Budgets and Budget Organizations Setup Users
3
Step 1 - Define Value Sets - Segment 1 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Value Set Name: Entity Description: Entity Format Type: Char Maximum Size: 3 Validation Type: Independent
Page 1 of 9
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flex field, Report, Flex builder, Other) Entity
Sample Values 001
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: No No Value Sets that Depend on this Value Set (if any): None
Used by (Flex field Structure, Context, Function, Other) Entity
Minimum Value: NO Maximum Value: No
Used by (Segment or Parameter) SEGMENT 1
Value Descriptions Manila Philippines
4
Step 1 - Define Value Sets - Segment 2 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Value Set Name: Natural Accounts Description: Natural Accounts Format Type: Char Maximum Size: 8 Validation Type: Independent
Page 2 of 9
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flexfield, Report, Flexbuilder, Other) Natural Accounts
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: No No Value Sets that Depend on this Value Set (if any): None
Used by (Flexfield Structure, Context, Function, Other) Natural Accounts
Minimum Value: No Maximum Value: No
Used by (Segment or Parameter) SEGMENT 2
Sample Values
Value Descriptions
2000000
Liability
5
Step 1 - Define Value Sets - Segment 3 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Value Set Name: Program Description: Program Format Type: Char Maximum Size: 8 Validation Type: Independent
Page 3 of 9
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flexfield, Report, Flexbuilder, Other) Program
Sample Values 1020100
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: No No Value Sets that Depend on this Value Set (if any): None
Used by (Flexfield Structure, Context, Function, Other) Program
Minimum Value: No Maximum Value: NO
Used by (Segment or Parameter) SEGMENT 3
Value Descriptions UNABSORBED COSTS
6
Step 1 - Define Value Sets - Segment 4 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Value Set Name: Revenue Origin Description: Revenue Origin Format Type: Char Maximum Size: 3 Validation Type: Independent
Page 4 of 9
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flexfield, Report, Flexbuilder, Other) Revenue Origin
Sample Values 001
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: NO No Value Sets that Depend on this Value Set (if any): None
Used by (Flexfield Structure, Context, Function, Other) Revenue Origin
Minimum Value: No Maximum Value: No
Used by (Segment or Parameter) SEGMENT 4
Value Descriptions United States
7
Step 1 - Define Value Sets - Segment 5 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Value Set Name: Client Code Description: Client Code Format Type: Char Maximum Size: 5 Validation Type: Independent
Page 5 of 9
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flexfield, Report, Flexbuilder, Other) Client Code
Sample Values 001
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: NO No Value Sets that Depend on this Value Set (if any): None
Used by (Flexfield Structure, Context, Function, Other) Client Code
Minimum Value: No Maximum Value: No
Used by (Segment or Parameter) SEGMENT 5
Value Descriptions ADOBE
8
Step 1 - Define Value Sets - Segment 6 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Value Set Name: Line Of Business Description: Line Of Business Format Type: Char Maximum Size: 3 Validation Type: Independent
Page 6 of 9
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flexfield, Report, Flexbuilder, Other) Line Of Business
Sample Values 100
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: NO No Value Sets that Depend on this Value Set (if any): None
Used by (Flexfield Structure, Context, Function, Other) Line Of Business
Minimum Value: No Maximum Value: No
Used by (Segment or Parameter) SEGMENT 6
Value Descriptions Financial Services
9
Step 1 - Define Value Sets - Segment 7 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Value Set Name: Entity (Inter Unit) Description: Entity Format Type: Char Maximum Size: 3 Validation Type: Independent
Page 7 of 9
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flex field, Report, Flex builder, Other) Entity
Sample Values 001
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: No No Value Sets that Depend on this Value Set (if any): None
Used by (Flex field Structure, Context, Function, Other) Entity
Minimum Value: NO Maximum Value: No
Used by (Segment or Parameter) SEGMENT7
Value Descriptions 247-US
10
Step 1 - Define Value Sets - Segment 8 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Two accounting flex field segments have been reserved for future use. Value Set Name: Spare 1 Description: Spare 1 Format Type: Char Maximum Size: 3 Validation Type: Independent
Alphabetic Char. Allowed: Yes Uppercase Only: NO
Value Set Used by Name of Flexfield, Report, Flexbuilder, Other) Spare 1
Sample Values 000
Page 8 of 9
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: No No Value Sets that Depend on this Value Set (if any): None
Used by (Flexfield Structure, Context, Function, Other) Spare 1
Minimum Value: NO Maximum Value: NO
Used by (Segment or Parameter) SEGMENT 8
Value Descriptions Default Value
11
Step 1 - Define Value Sets - Segment 6 (Setup-Financials-Flexfields-Validation-Sets) Date: Notes: Two accounting flexfield segments have been reserved for future use. Value Set Name: Spare 2 Description: Spare 2 Format Type: Char Maximum Size: 3 Validation Type: Independent
Alphabetic Char. Allowed: Yes Uppercase Only: Yes
Value Set Used by Name of Flexfield, Report, Flexbuilder, Other) Spare 2
Sample Values 000
Page 9 of 9
Precision: Security Available: N/A Yes Right-justify-Zero-fill Nrs: Enable QuickPick LongList: No No Value Sets that Depend on this Value Set (if any): None
Used by (Flexfield Structure, Context, Function, Other) Spare 2
Minimum Value: NO Maximum Value: No
Used by (Segment or Parameter) SEGMENT 9
Value Descriptions Default Value
12
Step 2 - Define Flexfield Structures (Setup-Financials-Flexfields-Key-Segments) Date: Notes:
Page 1 of 2
Application: Oracle General Ledger
Title
24 7 CUSTOMER ACCOUNTING_FLEX
Flex field Title:247 Customer Accounting Flex
Description
24 7 CUSTOMER ACCOUNTING_FLEX
View Name
24 7 CUSTOMER ACCOUNTING_F LEX
Freeze Flex field Def
Enabled
Seg. Sep.
Cross Val. Seq
Yes
Yes
. (Period)
No
Freeze Roll Ups
Allow Dynamic Inserts
No. of Seg
Yes
9
13
Step 2 - Define Flex field Structures (Setup-Financials-Flex fields-Key-Segments)
Page 2 of 2
Date: Notes: Key Flex field Title: 24 7 CUSTOMER ACCOUNTING_FLEX
Number of Segments (columns) 9
Structure Name/Description: 24 7 CUSTOMER ACCOUNTING FLEXFIELD
Number
Name
Window Prompt
Column
Value Set
Displayed
Enabled
Flexfield Qualifier
1
Entity
Entity
Segment 1
Entity
Yes
Yes
Balancing Segment
2
Natural Accounts
Segment 2
Natural Accounts
Yes
Yes
Natural Account Segment
3
Program
Natural Accounts Program
Segment 3
Program
Yes
Yes
4
Revenue Origin
Revenue Origin
Segment 4
Revenue Origin
Yes
Yes
5
Client Code
Client Code
Segment 5
Client Code
Yes
Yes
6
Line of Business
Line of Business
Segment 6
Line of Business
Yes
Yes
Cost Center Segment
7
Inter Unit
Inter Unit
Segment 7
Inter Unit
Yes
Yes
Inter Company Segment
8
Spare 1
Spare 1
Segment 8
Spare 1
Yes
Yes
9
Spare 2
Spare 2
Segment 9
Spare 1
Yes
Yes
14
Step 3 - Define Period Types (Setup-Calendar-Types) Process:
Business Area:
Date:
General Ledger Description: Use this form to define your accounting period types.
General Ledger provides standard period types Month, Quarter and Year. These period types are used when defining the accounting calendar for your organization. 247 Customer will use the Fiscal Calendar.
Accounting Period Types Zone Name
Number/Year
Year Type in Name
Description
Month (seeded)
12
Calendar
Month
Quarter (seeded)
4
Fiscal
Quarter
Year (seeded)
1
Fiscal
Year
247-13
13
Fiscal
24 7 Customer Calendar
15
Step 4 - Define Calendar (Setup-Calendar-Accounting) Required Step Process:
Business Area:
Date:
General Ledger Description: Use this form to define your calendar. You associate a calendar and a period type with each set of books. Once the first accounting period is opened, prior periods cannot be opened. The General Ledger Super user may open additional future periods when desired or required.
Calendar Zone
Use this zone to specify a name and a description for your calendar. 247 Cust Calendar Name Description
247 Customer Calendar
Accounting Periods Zone
Use this zone to specify the accounting periods you will include in you calendar and to provide detailed information for each of these periods. For example Name
Period Type
Year
Quarter
Period
From
To
System Name
Adjusting Period
APR-2007
247-13
2008
1
1
01-APR-2007
30-APR-07
APR-2007-08
No
MAY 2007
247-13
2008
1
2
01-MAY-2007
31-MAY-2007
MAY 2007-08
No
JUN 2007
247-13
2008
1
3
01-JUN-2007
30-JUN-2007
JUN 2007-08
No
JUL 2007
247-13
2008
2
4
01-JUL-2007
31-JUL-2007
JUL-2007-08
No
AUG 2007
247-13
2008
2
5
01-AUG-2007
31-AUG-2007
AUG-2007-08
No
SEP-2007
247-13
2008
2
6
01-SEP-2007
30-SEP-2007
SEP-2007-08
No
OCT 2007
247-13
2008
3
7
01-OCT-2007
31-OCT-2007
OCT-2007-08
No
NOV-2007
247-13
2008
3
8
01-NOV-2007
30-NOV-2007
NOV-2007-08
No
DEC-2007
247-13
2008
3
9
01-DEC-2007
31-DEC-2007
DEC-2007-08
No
JAN-2007
247-13
2008
4
10
01-JAN-2008
31-JAN-2008
JAN-2008-08
No
FEB-2007
247-13
2008
4
11
01-FEB-2008
29-FEB-2008
FEB-2008-08
No
MAR-2007
247-13
2008
4
12
01-MAR-2008
31-MAR-2008
MAR-2008-08
No
ADJ-2007
247-13
2008
4
13
31-MAR-2008
31-MAR-2008
ADJ-2008-08
Yes
16
Step 5 - Define Currency (Setup-Currencies-Define) Process:
Business Area:
Date:
General Ledger Description: Use this form to enable currencies and to define non-ISO (International Standards Organization) currencies. Oracle General Ledger has predefined all International Standards Organization (ISO) currencies used for the precision fields. 24 7 CUSTOMER WILL BE USING USD FOR INITIAL IMPLEMENTATION. THESE WILL NEED TO BE ENABLED.
Code Name Description Issuing Territory
US Dollar
STAT
US Dollar
STAT
USA $
Symbol Standard Precision Extended Precision
STAT
2 5
Minimum Accountable Unit Effective Date From Effective Date To Enabled
Yes
17
Step 6 - Define Set Of Books (Setup-Books) Process:
Business Area:
Date:
General Ledger Description: Use this form to define a set of books as well as to define your budgetary control options. Attention: ENSURE THE ACCOUNTING FLEXFIELD IS SET UP BEFORE ATTEMPTING THIS PROCESS Set Of Books Zone Name
247 Customer, Inc.
Short Name
247-US
Description
24/7 Customer, Inc.
Chart Of Accounts
247 CUSTOMER ACCOUNTING_FLEX
Functional Currency
USD
Calendar
247_Calendar
Period Type
247-13
Future Periods
13
Standard Options Allow Suspense Posting
Yes
Balance Intercom any Journals
Yes
Enable Average Balances
No
Enable Journal Approval
No
Enable Journal Entry Tax
No
Average Balance Options Consolidation Set of Books
No
18
Transaction Calendar
No
Transaction Rate Type
No
Translate Optional Amount Types EOD
No
QATD
No
YATD
No
Budgetary Control Options Enable Budgetary Control
Yes
Require Budget Journals
Yes
Reporting Currency Option
Not applicable (option selected)
Accounts Zone Accounting Flex field Retained Earnings
001.3405215.0000000.001.00000.000.001.000.000
Suspense
001.80001.0000000.001.00000.000.001.000.000
Intercompany
Yes
Translation Adjustment
Yes
Reserve For Encumbrances Net Income
Description
Retained Earnings
001.2230220.0000000.001.00000.000.001.000.000 N/A
19
GL: Define Intercompany/Interfund Accounts General Ledger>Setup>Accounts>Inter-Company Business Area: Date:
Use this region to define additional Inter-Company Account for each of your journal sources and categories. Source
Category
Type (Debit/Credit)
Entity
Due From Account
Due To Account
Others
Others
Many to Many Inter company
001
001.9500005.0000000.001.00000.000.001.000.000
001.9500005.0000000.001.00000.000.001.000.000
Others
Others
Many to Many Inter company
051
051.9500015.0000000.051.00000.000.051.000.000
051.9500015.0000000.051.00000.000.051.000.000
Others Others Others Others Others Others
Others Others Others Others Others Others
Many to Many Inter company
101
101.9500010.0000000.101.00000.000.101.000.000
101.9500010.0000000.101.00000.000.101.000.000
Many to Many Inter company
111
111.9500010.0000000.101.00000.000.111.000.000
111.9500010.0000000.101.00000.000.111.000.000
Many to Many Inter company
121
121.9500010.0000000.101.00000.000.121.000.000
121.9500010.0000000.101.00000.000.121.000.000
Many to Many Inter company
131
131.9500080.0000000.101.00000.000.131.000.000
131.9500080.0000000.101.00000.000.131.000.000
Many to Many Inter company
201
201.9500030.0000000.201.00000.000.201.000.000
201.9500030.0000000.201.00000.000.201.000.000
Many to Many Inter company
All Other
001.9500005.0000000.001.00000.000.001.000.000
001.9500005.0000000.001.00000.000.001.000.000
20
Step 7 - Define Journal Entry Sources (Setup-Journal-Sources) Required Step-247 Customer Provided FastForward Financial will be using Default Journal Sources Process:
General Ledger Description:
Business Area:
Date:
Use this form to define your journal entry sources and specify for a given source whether you want Oracle Journal Ledger to import journal reference information from your feeder systems.
Journal sources identify the origin of journal entries. General Ledger supplies a number of predefined journal sources. In addition to these predefined sources, at least one journal source for each non-Oracle feeder systems should be defined to help track imported journal entries.
Journal Entry Sources Zone Name
Description
Journal Import Reference (Yes/No)
Freeze Journals (Yes/No)
Manual
Manual
No
Yes
Multisoft
Multisoft Interface
Yes
Yes
Payables
Accounts Payable System
Yes
Yes
Payroll
Payroll System
Yes
Yes
Projects
Projects
Yes
Yes
Receivables
Accounts Receivable System
Yes
Yes
Spreadsheet
Spreadsheet
Yes
Yes
Treasury
Treasury
Yes
Yes
Budget - Indexation
Budget - Indexation
21
Step 8 - Define Journal Entry Categories (Setup-Journal-Categories) Process:
Business Area:
Date:
General Ledger Description: Use this form to define your journal entry categories. Oracle General Ledger uses these categories to describe the purpose of your Journal entry, such as accrual, payments, or receipts. Journal categories help differentiate journal entries by purpose or type, such as accrual, payments or receipts. Oracle General Ledger provides a number of predefined journal categories. See the following page for a listing of categories provided as Oracle defaults.
22
General Ledger provides the following predefined journal categories: Name
Description
247 Manuals Budget Allocation Addition Adjustment CIP Addition CIP Adjustment CIP Reclassification CIP Retirement CIP Transfer Credit Memo Applications Cross Currency Credit Memos Depreciation Depreciation Adjustment Masc. Receipts Payments Purchase Invoices Reclass Retirement Revaluation Revalue Profit/Loss Trade Receipts Transfer Credit Memos Deferred Depreciation Credit Memo Applica Addition Adjustment CIP Addition CIP Adjustment CIP Reclassification CIP Retirement CIP Transfer Credit Memo Applications Cross Currency Credit Memos Depreciation
247 Manuals Budget Allocation Addition Adjustment CIP Addition CIP Adjustment CIP Reclassification CIP Retirement CIP Transfer Credit Memo Applications Cross Currency Credit Memos Depreciation Depreciation Adjustment Masc. Receipts Payments Purchase Invoices Reclass Retirement Revaluation Revalue Profit/Loss Trade Receipts Transfer Credit Memos Deferred Depreciation Credit Memo Applica Addition Adjustment CIP Addition CIP Adjustment CIP Reclassification CIP Retirement CIP Transfer Credit Memo Applications Cross Currency Credit Memos Depreciation
23
Step 12 - Update System Profile Option (In Systems Administration module: Profile-System) Required Step Process:
General Ledger Description: more
Business Area:
Date:
Profile Options how the Oracle General Ledger application control access to and processing data. Profile options can be set at one or
Following levels. Oracle General Ledger applications use the Update Personal Profile Options form to set profile options only at the user Level. In order for a Set of Books to be accessible, the profile for the book must be created in the System Administration module.
System Profile Options: Option
Site Level Setting
FSG: Accounting Flexfield
Accounting Flexfeild
FSG: Allow Portrait Print Style
Yes
FSG: Expand Parent Value
Yes
FSG: Message Detail
Minimal
FSG: Enforce Segment Value Security
Yes
GL AHE: Saving Allowed
Yes
Setting
User Setting
GL Set of Books ID GL Set of Books Name
247-US
Journals: Allow Multiple Exchange Rates
No
Journals: Allow Non-Business Day Transactions
No
Journals: Allow Preparer Approval
No
Journals: Default Category Journals: Display Inverse Rate
Yes
Journals: Enable Prior Period Notification
Yes
Journals: Find Approver Method
N/A
Journals: Mix Statistical and Monetary
Yes
Journals: Override Reversal Method
No
24
Open And Close Periods (Setup-Open/Close) Process:
Business Area:
Date:
General Ledger Description: Use this form to open and close accounting periods in your calendar.
Accounting Period Zone
Use this zone to review the latest open accounting period and to open the next accounting period. APR-2004-05 Latest Open Open Next
MAY-2004-05
Encumbrance Year 2006 Latest Open Open Next
2007
Accounting Periods Zone
Use this zone to review information such as period status, period number, fiscal year, period name, and date ranges for each accounting period. Status
Number
Fiscal Year
Name
Start End
Open
APR-2004-05
2005
01-APR-2004
30-APR-2004
Open
MAY-2004-05
2005
01-MAY-2004
31-MAY-2004
Open
JUN-2004-05
2005
01-JUN-2004
30-JUN-2004
25
26
Open and Closed Issues for this Deliverable Open Issues ID
Issue
1
Budgets
Resolution
Responsibility
Target Date
Impact Date
Resolution
Responsibility
Target Date
Impact Date
Closed Issues ID
Issue
27
28
Related Documents
Br100 General Ledger Complete
May 2020 6
General Ledger
November 2019 11
Profile Program General Ledger
December 2019 5
Courtney Downs - 2006 General Ledger
December 2019 22
Romanian Speaker General Ledger Accountant.pdf
June 2020 2