|
Step No.
|
Required
|
Step
|
Reference
|
|
Step 1
|
Required
|
Define your chart of
accounts. See: Defining
Your Chart of Accounts.
|
Common Applications
|
|
Step1-1
|
Required
|
Defining Segments
|
Common Applications
|
|
Navigation:
|
|
General Ledger èSetupèFinancialsèFlexfeildsèKeyèSegments
|
|
|
Tables:
|
|
FND_ID_FLEX_STRUCTURES, FND_ID_FLEX_SEGMENTS
|
|
|
Views:
|
|
FND_ID_FLEX_STRUCTURES_VL
|
|
|
Description
|
|
|
|
|
Step1-2
|
Required
|
Defining Value Sets
|
Common Applications
|
|
Navigation:
|
|
General Ledger èSetupèFinancialsèFlexfeildsèValidationèSet
|
|
|
Tables:
|
|
FND_FLEX_VALUE_SETS
|
|
|
Views:
|
|
None
|
|
|
Description
|
|
|
|
|
Step1-3
|
Required
|
Defining Values
|
Common Applications
|
|
Navigation:
|
|
General Ledger èSetupèFinancialsèFlexfeildsèValidationèValues
|
|
|
Tables:
|
|
FND_FLEX_VALUE_SETS, FND_FLEX_VALUES
|
|
|
Views:
|
|
FND_FLEX_VALUES_VL
|
|
|
Description
|
|
|
|
|
Step 2
|
Optional
|
Define Cross-Validation
Rules to prevent certain account combinations from being created.
|
Common Applications
|
|
Navigation:
|
|
General Ledger èSetupèFinancialsèFlexfeildsèKeyèRulesè
Define Cross Validation Rules
|
|
|
Tables:
|
|
FND_FLEX_VALIDATION_RULES, FND_FLEX_VALIDATION_RULE_LINES
|
|
|
Views:
|
|
FND_FLEX_VDATION_RULES_VL
|
|
|
Description
|
|
|
|
|
Step 3
|
Optional
|
Define a chart of accounts
mapping to map two or more charts of accounts. The chart of
accounts mapping is used by Accounting Setup Manager to complete the setup
steps for secondary ledgers, and it is used by the Global Consolidation
System (GCS) to consolidate data between ledgers.
|
Common Applications
|
|
Navigation:
|
|
|
|
|
Tables:
|
|
|
|
|
Views:
|
|
|
|
|
Description
|
|
|
|
|
Step 4
|
Optional
|
Define Your Descriptive
Flexfields
See: Defining Descriptive Flexfields for General Ledger |
Common Applications
|
|
Navigation:
|
|
General Ledger èSetupèFinancialsèFlexfeildsèDescriptiveèSegment
|
|
|
Tables:
|
|
FND_DESCR_FLEX_COLUMN_USAGES
|
|
|
Views:
|
|
FND_DESCR_FLEX_COL_USAGE_VL
|
|
|
Description
|
|
|
|
|
Step 5
|
Optional
|
If you want to use period types not installed with General Ledger, define your accounting period
types.
See: Period Types |
Common Applications
|
|
Navigation:
|
|
General Ledger èSetupèFinancialsèCalendars èTypesèDefine Period Types
|
|
|
Tables:
|
|
GL_PERIOD_TYPES
|
|
|
Views:
|
|
None
|
|
|
Description
|
|
|
|
|
Step 6
|
Required
|
Define your accounting
calendar. Review the Calendar Validation report to note common setup errors.
See: Defining Calendars |
Common Applications
|
|
Navigation:
|
|
General Ledger èSetupèFinancialsèCalendarsèAccounting èDefine Accounting Calendars
|
|
|
Tables:
|
|
GL_PERIOD_SETS, GL_PERIODS
|
|
|
Views:
|
|
GL_PERIODS_V
|
|
|
Description
|
|
|
|
|
Step 7
|
Optional
|
If you plan to use average balance processing, define a transaction calendar and valid business
days for that calendar.
The transaction calendar ensures that journals created in Oracle General Ledger and Oracle Subledger Accounting (SLA), if used, will be posted on valid business days. See: Defining Transaction Calendars |
Common Applications
|
|
Navigation:
|
|
General Ledger èSetupèFinancialsèCalendarsèTransactionèDefine Transaction Calendar
|
|
|
Tables:
|
|
GL_TRANSACTION_CALENDAR, GL_TRANSACTION_DATES
|
|
|
Views:
|
|
None
|
|
|
Description
|
|
|
|
|
Step 8
|
Required
|
Define the currency for your
ledger. Also define or enable any reporting currencies you plan to use.
See: Oracle General Ledger User's Guide Defining Currencies, Oracle General Ledger User's Guide |
Common Applications
|
|
Navigation:
|
|
General Ledger èSetupèCurrenciesèDefineèDefine or enable currencies
|
|
|
Tables:
|
|
FND_CURRENCIES
|
|
|
Views:
|
|
|
|
|
Description
|
|
|
|
|
Step 9
|
Optional
|
Define conversion rate types
and conversion rates, such as daily rates and historical
rates.
See: Overview of Multi–Currency Accounting, Oracle General Ledger User's Guide |
Common Financials
|
|
Navigation:
|
|
General Ledger èSetupèCurrenciesèCurrency Rate Manager
|
Urrience Rate
|
|
Tables:
|
|
GL_DAILY_RATES
|
|
|
Views:
|
|
|
|
|
Description
|
|
|
|
|
Step 10
|
Optional
|
Define additional journal
entry sources. If you have enabled average balance processing,
specify an Effective Date Rule for each journal source you define.
See: Journal Sources |
Oracle General Ledger
|
|
Navigation:
|
|
General Ledger èSetupèJournalsèSourcesèDefine Journal Source
|
|
|
Tables:
|
|
GL_JE_SOURCES_TL
|
|
|
Views:
|
|
GL_JE_SOURCES
|
|
|
Description
|
|
|
|
|
Step 11
|
Optional
|
Define additional journal
categories.
See: Journal Categories |
Oracle General Ledger
|
|
Navigation:
|
|
General Ledger èSetupèJournalsèCategoryèDefine Journal Categories
|
|
|
Tables:
|
|
GL_JE_CATEGORIES_TL
|
|
|
Views:
|
|
GL_JE_CATEGORIES
|
|
|
Description
|
|
|
|
|
Step 12
|
Optional
|
Define Journal Reversal
criteria. See: Automatic Journal Reversal Overview, Oracle General Ledger
User's Guide
|
Oracle General Ledger
|
|
Navigation:
|
|
General Ledger èSetupèJournalsèAutomatic Journal Reversal criteria
|
|
|
Tables:
|
|
GL_AUTOREVERSE_OPTIONS
|
|
|
Views:
|
|
GL_AUTOREVERSE_OPTIONS_V
|
|
|
Description
|
|
|
|
|
Step 13
|
Required
|
Define an accounting setup
using Accounting Setup Manager to combine legal entities,
ledgers, reporting currencies, subledger accounting methods, and other setup
information.
Before you can enter transactions and journal entries to ledgers, you must complete the ledger options for all ledgers assigned to an accounting setup and the accounting setup status must be complete. See: Creating Accounting Setups Oracle Financials Implementation Guide Define additional journal entry sources and categories. If you have enabled average balance processing, specify an Effective Date Rule for each journal source you define. See: Journal Sources and Journal Categories. |
Oracle General Ledger
|
|
Navigation:
|
|
General Ledger èSetupèFinancialsèAccounting Setup ManagerèAccount Setup Manager
|
|
|
Tables:
|
|
GL_LEDGERS
|
|
|
Views:
|
|
|
|
|
Description
|
|
|
|
|
Step 14
|
Optional
|
Define Ledger Sets to group ledgers that share the same chart of accounts and accounting calendar/period
type combination to take advantage of processing efficiencies, such as
opening and closing periods across ledgers in a ledger set.
|
Oracle General Ledger
|
|
Navigation:
|
|
General Ledger èSetupèFinancialsèLedger Setsè Define Ledger Set
|
|
|
Tables:
|
|
None
|
|
|
Views:
|
|
GL_LEDGER_SETS_V
|
|
|
Description
|
|
|
|
|
Step 15
|
Optional
|
Define data access sets to
secure read and write access to ledgers, balancing
segment values, and management segment values for one or more ledgers.
See: Data Access Sets |
Public Sector Applications
|
|
Navigation:
|
|
General Ledger èSetupèFinancialsèData Access SetsèDefine Data Access Sets
|
|
|
Tables:
|
|
GL_ACCESS_SETS
|
|
|
Views:
|
|
GL_ACCESS_SETS_V
|
|
|
Description
|
|
|
|
|
Step 16
|
Required
|
Assign a ledger to the
profile option GL Ledger Name for each Oracle subledger. This profile option controls the ledger chart of accounts that each subledger
will use for transaction processing.
|
Oracle General Ledger
|
|
Navigation:
|
|
System Administratorè Profile èSystem è Profile Name è GL Ledger Name
|
|
|
Tables:
|
|
FND_PROFILE_OPTIONS
|
|
|
Views:
|
|
FND_PROFILE_OPTIONS_VL
|
|
|
Description
|
|
|
|
|
Step 17
|
Required
|
Assign a data access set to
the profile option GL: Data Access Set for each General Ledger
responsibility.
See: Data Access Sets See: Setting General Ledger Profile Options, Oracle General Ledger Reference Guide |
Oracle General Ledger
|
|
Navigation:
|
|
System Administratorè Profile èSystem è Profile Name è GL: Data Access Set
|
|
|
Tables:
|
|
FND_PROFILE_OPTIONS
|
|
|
Views:
|
|
FND_PROFILE_OPTIONS_VL
|
|
|
Description
|
|
|
|
|
Step 18
|
Optional
|
Define Definition Access
Sets and assign them to responsibilities. Once you begin
securing your definitions, you can assign the Definition Access Sets assigned
to your responsibilities.
See: Definition Access Sets |
Oracle General Ledger
|
|
Navigation:
|
|
General Ledger èSetupèFinancialsèDefinition Access Sets èDefine/Assign
|
|
|
Tables:
|
|
|
|
|
Views:
|
|
|
|
|
Description
|
|
|
|
|
Step 19
|
Optional
|
Define account combinations
that can be used for data entry if you did not enable Dynamic Insertion for your
chart of accounts structure.
See: Defining Accounts |
Oracle General Ledger
|
|
Navigation:
|
|
General Ledger èSetupèAccountsèCombinations
|
|
|
Tables:
|
|
GL_CODE_COMBINATIONS
|
|
|
Views:
|
|
GL_CODE_COMBINATIONS_V
|
|
|
Description
|
|
|
|
|
Step 20
|
Optional
|
Define and assign document
sequences.
See: Defining Document Sequences |
Oracle General Ledger
|
|
Navigation:
|
|
General Ledger èSetupèFinancialsèSequencesèDocumentèDefine/Assign
|
|
|
Tables:
|
|
FND_DOCUMENT_SEQUENCES, FND_DOC_SEQUENCE_ASSIGNMENTS
|
|
|
Views:
|
|
|
|
|
Description
|
|
|
|
|
Step 21
|
Optional
|
Define Your Employees. (Oracle Human Resources Management System User’s Guide)
See: Entering a New Employee |
Oracle General Ledger
|
|
Navigation:
|
|
Human ResourcesèPeopleèEnter & Maintainè
|
|
|
Tables:
|
|
PER_ALL_PEOPLE_F
|
|
|
Views:
|
|
PER_PEOPLE_V
|
|
|
Description
|
|
|
|
|
Step 22
|
Optional
|
Setup Journal Approval.
See: Setting Up Journal Approval |
Oracle General Ledger
|
|
Navigation:
|
|
General LedgerèSetupèEmployeesèLimitsèDefine Employee Journal Authorization Limits
|
|
|
Tables:
|
|
GL_AUTHORIZATION_LIMITS
|
|
|
Views:
|
|
GL_AUTHORIZATION_LIMITS_V
|
|
|
Description
|
|
|
|
|
Step 23
|
Optional
|
Define one or more of the
following optional accounts:
|
Oracle General Ledger
|
|
Navigation:
|
|
General Ledger èSetupèAccountsè Suspense èDefine Suspense Accounts
|
|
|
Tables:
|
|
GL_SUSPENSE_ACCOUNTS
|
|
|
Views:
|
|
GL_SUSPENSE_ACCOUNTS_V
|
|
|
Description
|
|
|
|
|
Step 24
|
Required
|
Define transaction codes if
you use Public Sector General Ledger.
See: Setting Up Transaction Codes |
Oracle General Ledger
|
|
Navigation:
|
|
|
|
|
Tables:
|
|
|
|
|
Views:
|
|
|
|
|
Description
|
|
|
|
|
Step 25
|
Optional
|
Create summary accounts.
See: Defining Summary Accounts |
Oracle General Ledger
|
|
Navigation:
|
|
General Ledger èSetupèAccountsèSummary è Define Summary Accounts
|
|
|
Tables:
|
|
GL_SUMMARY_TEMPLATES
|
|
|
Views:
|
|
GL_SUMMARY_TEMPLATES_V
|
|
|
Description
|
|
|
|
|
Step 26
|
Optional
|
Set up Automatic Tax
Calculation if you do not have Oracle Receivables and Oracle Payables
installed.
See: Setting Up Automatic Tax Calculation |
Oracle General Ledger
|
|
Navigation:
|
|
|
|
|
Tables:
|
|
|
|
|
Views:
|
|
|
|
|
Description
|
|
|
|
|
Step 27
|
Optional
|
Define your automatic
posting criteria.
See: Posting Journal Batches Automatically, Oracle General Ledger User's Guide |
Oracle General Ledger
|
|
Navigation:
|
|
General LedgerèSetupèJournalèAuto PostèDefine Auto Post Criteria
|
|
|
Tables:
|
|
GL_AUTOMATIC_POSTING_SETS
|
|
|
Views:
|
|
GL_AUTOMATIC_POSTING_SETS_V
|
|
|
Description
|
|
|
|
|
Step 28
|
Optional
|
Define encumbrance types.
See: Defining Encumbrance Types, Oracle General Ledger User's Guide |
Oracle General Ledger
|
|
Navigation:
|
|
General Ledger èSetup èJournal èEncumbrancesèDefine Encumbrance Type
|
|
|
Tables:
|
|
|
|
|
Views:
|
|
|
|
|
Description
|
|
|
|
|
Step 29
|
Optional
|
Set up Budgets.
See: Defining Budgets, Oracle General Ledger User's Guide |
Oracle General Ledger
|
|
Navigation:
|
|
General LedgerèBudgetèDefine Budget
|
|
|
Tables:
|
|
GL_BUDGETS
|
|
|
Views:
|
|
GL_BUDGETS_V
|
|
|
Description
|
|
|
|
|
Step 30
|
Optional
|
If you enabled budgetary control, define one or more budgetary control groups.
See: Creating a Budgetary Control Group, Oracle General Ledger User's Guide |
|
|
Navigation:
|
|
General LedgerèBudgetsèDefine ControlsèDefine Budgetary Control groups
|
|
|
Tables:
|
|
GL_BC_OPTIONS
|
|
|
Views:
|
|
|
|
|
Description
|
|
|
|
|
Step 31
|
Optional
|
Define Security Rules.
See: Defining Security Rules |
|
|
Navigation:
|
|
General Ledger èSetupèFinancialsèFlexfeildsèKeyèSecurityèDefine/Assign
|
|
|
Tables:
|
|
FND_FLEX_VALUE_RULES, FND_FLEX_VALUE_RULE_LINES
|
|
|
Views:
|
|
FND_FLEX_VALUE_RULES_VL
|
|
|
Description
|
|
|
|
|
Step 32
|
Required
|
Set your General Ledger
profile options.
See: Setting General Ledger Profile Options, Oracle General Ledger Reference Guide |
 |
|
Navigation:
|
|
System Administratorè Profile èSystem è Profile Name
|
|
|
Tables:
|
|
FND_PROFILE_OPTIONS
|
|
|
Views:
|
|
FND_PROFILE_OPTIONS_VL
|
|
|
Description
|
|
|
|
|
Step 33
|
Required
|
Open an accounting period.
See: Opening and Closing Accounting Periods |
|
|
Navigation:
|
|
General Ledger èSetupèOpen/CloseèOpen and Close periods
|
|
|
Tables:
|
|
GL_PERIODS
|
|
|
Views:
|
|
|
|
|
Description
|
|
|
|
|
Step 34
|
Optional
|
Set up the Global
Consolidation System (GCS).
See: Global Consolidation System, Oracle General Ledger User's Guide |
|
|
Navigation:
|
|
|
|
|
Tables:
|
|
|
|
|
Views:
|
|
|
|
|
Description
|
|
|
|
Friday, 22 June 2012
General Ledger Setup Checklist with Tables details
Subscribe to:
Posts (Atom)