Self-Paced R12 Oracle gl configuration Training




Download 141.98 Kb.
NameSelf-Paced R12 Oracle gl configuration Training
A typeDocumentation
manual-guide.com > manual > Documentation
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@theoicllc.com 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 https://communities.oracle.com/portal/server.pt/community/general_ledger/240 in Oracle Metalink.

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

Post questions on the Oracle Groups on Ning.Com and LinkedIn.Com.

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































Create a New User
















1

Required

GL: Define Chart of Accounts

EDU3428Y




Oracle General Ledger Process

Very good overview













EDU3428Y




Oracle General Ledger Process - PPT

Power Point Version













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 Rates

LABP0702




Practice - Define Rate Types (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 Setup Manager

EDU3FB1Y




Accounting 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 them to responsibilities

LAB3FBDY




Guided Demonstration - Define 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 Units of Measure

LABP0407




Practice - Set up Suspense 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@theoicllc.com.

Copyright © Oracle Independent Consultants LLC, . All rights reserved.

DRAFT

Self-Paced R12 Oracle GL Configuration Training 41838.doc

Effective 09-May-2009 Page of Rev 1

Share in:

Related:

Self-Paced R12 Oracle gl configuration Training iconOracle R12. 1 Fa, pa, gl and ap modules, sap

Self-Paced R12 Oracle gl configuration Training iconArchitecture, Installing, monitoring and maintaining (Single Node...

Self-Paced R12 Oracle gl configuration Training iconPartners in 17 Categories Recognized at Oracle OpenWorld for Excellence...

Self-Paced R12 Oracle gl configuration Training iconIdc white Paper sponsored by Oracle Corporation, "Oracle e-business...

Self-Paced R12 Oracle gl configuration Training iconFull life cycle development, implementation and support with expertise...

Self-Paced R12 Oracle gl configuration Training iconOracle® e-business Suite, Siebel crm, PeopleSoft Enterprise and jd...

Self-Paced R12 Oracle gl configuration Training iconThis Handout is intended to supplement training normally performed...

Self-Paced R12 Oracle gl configuration Training iconConfiguration as code: Automating Windows Server 2016 configuration with PowerShell and dsc

Self-Paced R12 Oracle gl configuration Training iconManual configuration on the camera or automatic assignment via dhcp...

Self-Paced R12 Oracle gl configuration Training iconManual configuration on the camera or automatic assignment via dhcp...

Self-Paced R12 Oracle gl configuration Training iconI am a technical professional who thrives in a variety of fast-paced...

Self-Paced R12 Oracle gl configuration Training iconAbstract This integration is a part of Siebel Integrations between...

Self-Paced R12 Oracle gl configuration Training iconUniversal Laser Systems Printer Driver installation and usage instructions...

Self-Paced R12 Oracle gl configuration Training iconLive classroom and online training from the world’s leading telecommunications training company

Self-Paced R12 Oracle gl configuration Training iconThere are five general heart rate training zones of different levels...

Self-Paced R12 Oracle gl configuration Training iconTraining mode : Live Instructor led online training

Self-Paced R12 Oracle gl configuration Training iconThe content and materials of this training are property of the Great...

Self-Paced R12 Oracle gl configuration Training iconProfile Experienced training consultant with over 14 years experience...

Self-Paced R12 Oracle gl configuration Training iconLocation: The Academy Burnaston work & training activitities relating...

Self-Paced R12 Oracle gl configuration Training iconMatching sce training packages for these training curriculums




manual




When copying material provide a link © 2017
contacts
manual-guide.com
search