add

About Me

My photo
Oracle Apps - Techno Functional consultant

Thursday, October 27

General Ledger Setups

1. Define Value Sets 
2. Define Key Flexfield Segments
3. Define Rollup Groups
4. Define Accounting Flexfield Values 
5. Define Cross Validation Rule 
6. Define Key Flexfield Security Rule and Define Security Rule
7. Define Shorthand Aliases
8. Define Descriptive Flexfields 
9. Define Calendar Types 
10. Define Calendar 
11. Define Currencies 
12. Define Set Of Books 
13. Multi-Org Setups 
14. Assign Key Flexfield Security Rule and Assign Security Rule 
15. Define Accounting Flexfield Combinations 
16. Define Journal Entry Sources 
17. Define Journal Entry Categories 
18. Define Suspense Accounts (ONE defined for each SOB, other, other) 
19. Define Intercompany Accounts 
20. Define Conversion Rate Types 
21. Define Daily Exchange Rates 
22. Define Period Exchange Rates 
23. Define Historical Exchange Rates 
24. Translate Balances 
25. Define Summary Accounts 
26. Define Statistical Units of Measure 
27. Define Automatic Posting Options 
28. Define Concurrent Program Controls 
29. Generate Optimizer 
30. Update Storage Parameters 
31. Define Document Sequences 
32. Assign Document Sequences 
33. Update System Profile Options 
34. Define Database Links
35. Define Consolidation Mapping 
36. Define Consolidation Mapping Sets 
37. Open/Close Periods 
38. Journal Reversal Criteria 


Step 1 [Oracle Required/ERP Required]

Define Value Sets

Level: Enterprise

Change responsibility to General Ledger Super User

Navigator: Setup > Financials > Flexfields > Validation > Sets
Purpose: Define a value set. Value Sets are set up for each segment of the Accounting Flexfield.


Step 2 [ Oracle Required/ERP Required]

Define Key Flexfield Segments
Level: Enterprise

Change Responsibility to Application Developer

Navigator: Flexfields->Key->Segments

Purpose: Defines the key flexfield segments that make up the flexfield structure. This form uses the information about the Segments from Step 1, defines rules for each, and enables each segments.


Step 3 [Oracle Optional / ERP Optional]

Define Rollup Groups

Navigator: Setup> Financial > Flexfields >Key >Groups
Purpose: Define Rollup Groups to create summary accounts whose summary balances you can review. You assign parent segment values to rollup groups.


Step 4 [Oracle Required / ERP Required]

Define Accounting Flexfield Values

Level: Enterprise
Change responsibility to General Ledger Super User
Navigator: Setup > Financials > Flexfields > Key >Values
Purpose: This screen is used to enter values for each of the segments defined in Step 2.


Step 5 [Oracle Optional / ERP Optional]

Define Cross Validation Rule

Level: Enterprise
Navigator: Setup > Financials > Flexfields > Key > Rules
Purpose: Define key flexfield cross-validation rules, which check code combinations at journal entry and budget entry.


Step 6 [ Oracle Optional / ERP Required]

Define Key Flexfield Security Rule and Define Security Rule

Level: Enterprise (For each new Set of Books, this will need to be completed)
Navigator: Setup > Financials > Flexfields > Key > Security > Define
Purpose: Define security rules to restrict user access to certain account segment values. These rules also extend security to the standard Trial Balance and Account Analysis reports


Step 7 [Oracle Optional / ERP Optional]
Define Shorthand Aliases

Level: Enterprise
Navigator: Setup > Financials > Flexfields > Key > Aliases
Purpose: Define and maintain shorthand aliases for key flexfields.


Step 8 [Oracle Optional / ERP Optional]

Define Descriptive Flexfields

Level: Enterprise
Navigator: Setup > Financials > Flexfields > Descriptive > Segments
Purpose: Define Descriptive Flexfields


Step 9 [Oracle Required / ERP Required]

Define Calendar Types 

Level: Enterprise
Navigator: Setup > Financials > Calendar > Types
Purpose: Define accounting period types. Oracle provides the following seeded values: Month, Quarter, and Year.


Step 10 [Oracle Required / ERP Required]

Define Calendar 

Level: Enterprise
Navigator: Setup > Financials > Calendars > Accounting
Purpose: Define the financial calendar


Step 11 [Oracle Required / ERP Required]

Define Currencies

Level: Enterprise (For each new Set of Books, this will need to be completed)
Navigator: Setup > Currencies > Define
Purpose: To enable currencies ISO currencies.


Step 12 [ Oracle Required / ERP Required]

Define Set Of Books 

Level: Enterprise (needs to be completed for each Set of Books)
Navigator: Setup > Financials > Books > Define
Purpose: Define a set of books and budgetary control options.


Step 13 [Oracle Required / ERP Required]

Multi-Org Setups

Level: Enterprise (needs to be completed for each Set of Books)


Step 14 [Oracle Optional / ERP Required]

Assign Key Flexfield Security Rule and Assign Security Rule
Level: Enterprise
Navigator: Setup > Financials > Flexfields > Key > Security > Assign
(Alternatively click on Assign button from Step 5)
Purpose: Assign flexfield security rules to an application responsibility.


Step 15 [Oracle Required / ERP Required]

Define Accounting Flexfield Combinations

Level: Enterprise
Navigator: Setup > Accounts > Combinations
Purpose: Define new Accounting Flexfield combinations and to maintain existing Accounting Flexfield combinations.


Step 16 [Oracle Required / ERP Required]
Define Journal Entry Sources

Level: Enterprise
Navigator: Setup > Journal > Sources
Purpose: Define journal entry sources and specify for a given source the whether to import journal reference information from feeder systems.


Step 17 [Oracle Required / ERP Required]

Define Journal Entry Categories 

Level: Enterprise
Navigator: Setup > Journal > Categories
Purpose: Define journal entry categories.


Step 18 [Oracle Optional / ERP Required]

Define Suspense Accounts (ONE defined for each SOB, other, other)

Level: Set of Books
Navigator: Setup > Accounts > Suspense
Purpose: Define additional suspense accounts based upon the source and category of journal entries.


Step 19 [Oracle Optional / ERP Required]
Define Intercompany Accounts

Level: Set of Books
Navigator: Setup > Accounts > Intercompany
Purpose: Define additional intercompany accounts.


Step 20 [Oracle Required / ERP Required]
Define Conversion Rate Types

Level: Enterprise

Change responsibility to General Ledger Super User

Navigator: Setup > Currencies > Rates > Types
Purpose: Use conversion rate types to automatically assign a rate when you convert foreign currency journal amounts to functional currency equivalents – GL 21.


Step 21 [Oracle Required / ERP Required]
Define Daily Exchange Rates

Level: Set of Books

Change responsibility to General Ledger Super User

Navigator: Setup > Currencies > Rates > Daily
Purpose: To enter daily conversion rates for foreign currencies as defined in Step 10.


Step 22 [Oracle Required / ERP Required]

Define Period Exchange Rates
Level: Set of Books
Navigator: Setup > Currencies > Rates > Period
Purpose: To enter period conversion rates for foreign currencies for consolidation.


Step 23 [Oracle Required / ERP Required]
Define Historical Exchange Rates

Level: Enterprise
Navigator: Setup > Currencies > Rates > Historical
Purpose: To enter daily conversion rates for foreign currencies as defined in Step 10.


Step 24 [Oracle Required / ERP Required]
Translate Balances

Level: Set of Books
Navigator: Currency > Translation
Purpose: Translate the journal balance from FJD to NZD for consolidation.


Step 25 [Oracle Optional / ERP Optional]
Define Summary Accounts

Level: Enterprise

Navigator: Setup > Accounts > Summary

Purpose: Create and delete summary accounts.


Step 26 [Oracle Optional / ERP Optional]
Define Statistical Units of Measure

Level: Enterprise
Navigator: Setup > Accounts > Units
Purpose: Define statistical units of measures and assign them to account segment values. User Profile Option Journals: Mix Statistical and Monetary must be set to Yes.


Step 27 [Oracle Optional / ERP Optional]
Define Automatic Posting Options

Level: Set of Books
Navigator: Setup > Journal > Autopost
Purpose: Specify journal batches for automatic posting.


Step 28 [Oracle Required / ERP Required]
Define Concurrent Program Controls

Level: Enterprise
Navigator: Setup > System > Control
Purpose: Control the performance of the Journal Import and MassAllocation/MassBudgeting programs by varying the amount of memory usage This is completed after the Optimizer is run. This screen should be completed by a DBA


Step 29 [ Oracle Required/ ERP Required]

Generate Optimizer

Change responsibility to General Ledger ????

Level: Enterprise
Navigator: Reports > Request > Standard
Purpose: Runs the Oracle GL Optimizer. The Optimizer creates or drops indexes for those segments in the COA that have been marked for indexing. This helps journal entry posting and financial reporting processes run faster. It is recommended that the Optimizer is run at least once a period, or any time a large number of segment values are added, a new COA is defined, summary templates added or deleted.


Step 30 [Oracle Optional / ERP Optional]
Update Storage Parameters 

Level: Enterprise
Navigator: Setup > System > Storage
Purpose: Maintain storage parameters for all interim tables and indexes in General Ledger.


Step 31 [Oracle Optional / ERP Optional]
Define Document Sequences
Level: Enterprise
Navigator: Setup > Financials > Sequences > Define
Purpose: Name a new document sequence and define how the sequence numbers each document. See GL Reference Manual for more detail information.


Step 32 [Oracle Optional / ERP Optional]

Assign Document Sequences

Level: Enterprise
Navigator: Setup > Financials > Sequences > Assign

Purpose: Define the documents a document sequence will number and then assign the document sequence to your definition.


Step 33 [Oracle Required/ ERP Required]

Update System Profile Options 

Level: Enterprise

Change Responsibility to System Administrator

Navigator: Profile > System
Purpose: To choose which user profile options to include in a particular user profile at the site, application, responsibility, or user level.


Step 34 [Oracle Optional / ERP Optional]
Define Database Links

Level: Enterprise
Navigator: Setup >System > Database Links
Purpose: To define links to other General Ledger databases in order to copy FSG report objects from the linked database into your current database.


Step 35 [Oracle Optional / ERP Optional]
Define Consolidation Mapping

Level: Enterprise
Navigator: Consolidation > Define> Mapping
Purpose: Mapping Subsidiaries to your parent account


Step 36 [Oracle Optional / ERP Optional]
Define Consolidation Mapping Sets

Level: Enterprise
Navigator: Consolidation > Define> Mapping Set
Purpose: Mapping Subsidiaries to your parent account


Step 37 [Oracle Required / ERP Required]

Open/Close Periods

Level: SOBP
Navigator: Setup > Open/Close
Purpose: Change the status of the accounting periods in the set of books.


Step 38 [Oracle Optional / ERP Required]

Journal Reversal Criteria
Level: Set of Books
Navigator: Setup > Journal > AutoReverse

No comments: