Self-Paced R12 Oracle GL Configuration Training



Self-Paced R12 Oracle GL Configuration Training

A Guide to Completing the Training

Self-Paced R12 Oracle GL Configuration Training

Intended Audience

Welcome to the Release 12 Oracle General Ledger Self-Paced Training Program.

This guide assumes you have a working knowledge of the following:

• The principles and customary practices of the Accounting-to-Reporting business cycle

• Computer desktop application usage and terminology

The R12 Oracle GL Configuration Training Program is designed to be used by:

• Auditors

• Accounting and Finance Professionals

• Oracle Professionals

Structure

I prepared this document using Oracle General Ledger Implementation Guide for Release 12.0, Part No. B31219-03, dated June 2007. The Steps documented in Table map directly back to Setup Checklist that begins on Page 1-6.

Prerequisities

You will need access to the following tools and resources to effectively complete this self-paced training program:

• Oracle Metalink

• Oracle Partner Network (OPN) Portal

• Oracle Test and/or Development instance for Release 12.0.4 or 12.0.6.

• Members’ Area of the website for Oracle Independent Consultants LLC

• Install Oracle Tutor Author (Requires Access to Oracle Metalink)

Training Documentation

Oracle developed training courseware using Oracle Tutor Author and Microsoft Power Point. I reorganized the documentation so that the setup steps map to the sequence of setup steps identified in the Oracle Implementation Guide for Release 12. I also provided you with links to the documentation associated with each setup step. Oracle did not provide links. Moreover, Oracle did not list the setup tasks in the sequence in which they must be completed. I also added notes; lessons learned and identified best practices in the documentation.

I will continue to improve the documentation based upon your comments and feedback.

Completing the Training Program

I recommend that you complete this training program in the following manner:

1. Ensure you can access the tools and resources listed under Prerequisities.

Table 1: Unable to Access Tools and Resources?

|Note: |

|Contact me at to: roger.drolet@ if you have problems accessing any of these tools and resources. |

2. Review the appropriate UPK training documents for R12 Oracle General Ledger.

3. Open the GL Implementation Guide and review the Oracle documentation for each Step. The Setup Checklist in the implementation guide provides references to the documentation for each setup step.

4. Review the Education Power Point (ppt) presentations for each step.

5. Log into the Oracle Vision Instance for Release 12.

6. Use the Oracle General Ledger Super Responsibility to complete the lab exercises for the step (if available). Use your initials when prompted to enter your terminal number or unique id.

7. Complete the Lap Exercises.

8. Update the Oracle GL Setup Checklist to record your progress.

Table 2: Seek Answers to your Questions

|Note: |

|If you have questions regarding the functionality, I urge you to post your questions on the General Leger forum at |

| in Oracle Metalink. |

|You can use post questions on the Oracle Financials forum on Oracle’s website. |

|Post questions on the Oracle Groups on and . |

Oracle GL Setup Check List

The following table lists all of the required and optional setup steps associated with the setup of Oracle General Ledger. The steps are numbered in the sequence you need to complete each step. This table maps back to the Setup Check List contained in the Oracle Implementation Guide for Release 12.

Simply, click on the hyperlink for the File Name that you want to review and follow the steps identified in the training document. Currently, we do not have an Oracle Training documents for every step.

Table 3: Oracle GL Setup Check List

|Step No. |Required |Setup Task |File Name |File Name HTML |Description |Comment |Date Reviewed / |

| | | | | | | |Completed |

|1 |Required |GL: Define Chart of Accounts |EDU3428Y | |Oracle General Ledger Process |Very good overview | |

| | | |EDU3428Y | |Oracle General Ledger Process |Power Point Version | |

| | | | | |- PPT | | |

| | | |LABP0303 |LABP0303 |Practice - Define an | | |

| | | | | |Accounting Key Flexfield | | |

| | | | | |Structure | | |

| | | |LABP0302 | |Practice - Define Value Sets | | |

| | | |LABP0306 | |Practice - Enter Values | | |

| | | |LABP0313 | |Practice - Define and Test | | |

| | | | | |Shorthand Aliases (Required) | | |

|2 |Optional |Define Cross-Validation Rules |LABP0309 | |Practice - View account | | |

| | | | | |combinations Created with | | |

| | | | | |Dynamic Insertion | | |

| | | |LABP0312 | |Practice - Define Cross | | |

| | | | | |Validation Rules (Required) | | |

| | | |LABP0309 | |Practice - View account | | |

| | | | | |combinations Created with | | |

| | | | | |Dynamic Insertion | | |

|3 |Optional |Define a chart of accounts mapping to map | | | | | |

| | |two or more charts of accounts. | | | | | |

|4 |Optional |GL: Define Descriptive Flexfields | | | | | |

|5 |Optional |GL: Define Period Types | | | | | |

|6 |Required |GL: Define Accounting Calendar |LABP0304 | |Practice - Define an | | |

| | | | | |Accounting Calendar | | |

|7 |Optional |GL: Define Transaction Calendar | | | | | |

|8 |Required |GL: Define Functional Currency |LABP0305 | |Practice - Verify Functional | | |

| | | | | |Currencies are Enabled | | |

| | | |LABP0701 | |Practice - Define Currencies | | |

| | | | | |(Required | | |

|9 |Optional |GL: Define Conversion Rate Types and Enter |LABP0702 | |Practice - Define Rate Types | | |

| | |Rates | | |(Required) | | |

| | | |LABP0703 | |Practice - Define Daily | | |

| | | | | |Conversion Rates (Required) | | |

|10 |Option |Define Additional Journal Entry Sources |LABP0405 | |Practice - Set up Journal | | |

| | | | | |Sources | | |

|11 |Optional |Define Additional Journal Categories |LABP0406 | |Practice - Set up a Journal | | |

| | | | | |Category (Required) | | |

|12 |Optional |Define Journal Reversal Criteria |LABP0504 | |Practice - Set up Automatic | | |

| | | | | |Journal Reversal (Required) | | |

|13 |Required |Define an Accounting Setup using Account |EDU3FB1Y | |Accounting Setup Manager | | |

| | |Setup Manager | | | | | |

| | | |EDU3FB1Y | |Accounting Setup Manager. PPT | | |

| | | |EDU3FB2Y | |Using Accounting Setup Manager| | |

| | | |EDU3FB2Y | |Using Accounting Setup Manager| | |

| | | | | |- PPT | | |

| | | |LAB3FB7Y | |Guided Demonstration - Create | | |

| | | | | |Accounting Setup | | |

| | | |LABP0307 | |Practice - Define a Ledger | | |

| | | | | |(Required) | | |

| | | |LAB3FB7Y | |Guided Demonstration - Create | | |

| | | | | |Accounting Setup | | |

| | | |LABP0307 | |Practice - Define a Ledger | | |

| | | | | |(Required) | | |

|14 |Optional |Define Ledger Sets |LAB3FB9Y | |Guided Demonstration - Ledger | | |

| | | | | |Set Processing | | |

| | | |LAB3FB8Y | |Guided Demonstration - View | | |

| | | | | |Ledger Set | | |

| | | |LAB3FB9Y | |Guided Demonstration - Ledger | | |

| | | | | |Set Processing | | |

| | | |LAB3FBAY | |Guided Demonstration - FSG | | |

| | | | | |Reporting Using Ledger Sets | | |

| | | |LABP0801 | |Practice - Create a Ledger Set| | |

|15 |Optional |Define Data Access Sets |LAB3FBBY | |Guided Demonstration - Create | | |

| | | | | |Data Access | | |

| | | |LAB3FBBY | |Guided Demonstration - Create | | |

| | | | | |Data Access Sets with | | |

| | | | | |Read/Write Access | | |

| | | |LABP0802 | |Practice - Create a Data | | |

| | | | | |Access Set | | |

|16 |Required |Assign a ledger to the profile option GL | | | | | |

| | |Ledger Name for each Oracle Subledger. | | | | | |

|17 |Required |Assign a data access set to the profile | | | | | |

| | |option GL: Data Access Set for each General | | | | | |

| | |Ledger responsibility | | | | | |

|18 |Optional |Define Definition Access Sets and assign |LAB3FBDY | |Guided Demonstration - Define | | |

| | |them to responsibilities | | |Definition | | |

| | | |LAB3FBDY | |Guided Demonstration - Define | | |

| | | | | |Definition Access Sets and | | |

| | | | | |Secure Definitions | | |

|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. | | | | | |

|20 |Optional |Define and assign document sequences | | | | | |

| | | |LAB432EY | |Practice - Define Sequencing | | |

|21 |Optional |Define Your Employees. | | | | | |

|22 |Optional |Setup Journal Approval | | | | | |

|23 |Optional |Define Suspense Accounts and Statistical |LABP0407 | |Practice - Set up Suspense | | |

| | |Units of Measure | | |Accounts (Required) | | |

| | | |LABP0408 | |Practice - Define Statistical | | |

| | | | | |Units of Measure (Optional) | | |

| | | |LAB432AY | |Practice - Define Suspense and| | |

| | | | | |Statistical Accounts | | |

|24 |Required |Define transaction codes if you use Public | | | | | |

| | |Sector General Ledger. | | | | | |

|25 |Optional |Create Summary Accounts |EDU342BY | |Summary Accounts | | |

| | | |EDU342BY | |Summary Accounts - PPT | | |

| | | |LABP1501 | |Practice - Define Summary | | |

| | | | | |Accounts (Required) | | |

| | | |LAB3434Y | |Guided Demonstration - | | |

| | | | | |Maintain Summary Templates | | |

| | | | | |Program | | |

|26 |Optional |Set up Automatic Tax Calculation if you do | | | | | |

| | |not have Oracle Receivables and Oracle | | | | | |

| | |Payables installed. | | | | | |

|27 |Optional |Define your automatic posting criteria. | | | | | |

|28 |Optional |Define encumbrance types. | | | | | |

|29 |Optional |Setup Budgets | | | | | |

|30 |Optional |If you enabled budgetary control, define one| | | | | |

| | |or more budgetary control groups. | | | | | |

|31 |Optional |Define Security Rules |LABP0311 | |Practice - Define Security | | |

| | | | | |Rule | | |

|32 |Required |Set Your General Ledger Profile Options | | | | | |

|33 |Required |Open An Accounting Period |LABP0314 | |Practice - Open the First | | |

| | | | | |Accounting Period (Required) | | |

|34 |Optional |Set up the Global Consolidation System | | | | | |

| | |(GCS). | | | | | |

| | | | | | | | |

Send Us Your Comments and Feedback

Oracle Independent Consultants LLC welcomes your comments and suggestions on the quality and usefulness of the documentation included in the Self-Paced R12 Oracle General Ledger Configuration Training Program. Your input is an important part of the information used for revision.

• Did you find any errors?

• Is the information clearly presented?

• Do you need more information? If so, where?

• Are the examples correct? Do you need more examples?

• What features did you like most about this manual?

If you find any errors or have any other suggestions for improvement, please indicate the chapter, section, and page number (if available). You can email you comments to us at roger.drolet@.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download