Oracle Applications

Oracle for Beginners

Posts Tagged ‘General Ledger’

Define System Profile Values for General Ledger

Posted by shameemakhtar on June 22, 2009


Set the following profile options at site level unless otherwise specified / required:

  1. HR: Business Group
  2. HR: Security Profile
  3. HR: User Type (responsibility level)
  4. GL: Ledger Name
  5. GL: Data Access Set
  6. MO: Operating Unit
  7. MO: Security Profile

Refer to document ‘Define System Profile Values’ for detailed explanation on how to proceed.

GL: Data Access Set required only if you have defined Data Access Set

(Document to follow on ‘Defining Data Access Set’).

Shameem Bauccha

23 June 2009

Posted in Financials, General Ledger, Oracle Apps | Tagged: , , , , , | 1 Comment »

Accounting Setup Manager

Posted by shameemakhtar on June 22, 2009


Accounting Setup Steps

In R12, Accounting setup steps are divided into 3 parts as follow:

  1. Create Accounting Structure
  2. Define Accounting Options
  3. Complete Accounting Setup

Detailed documentation to be uploaded tomorrow

Apologies

Shameem Bauccha

23 June 2009

Posted in Financials, General Ledger, Oracle Apps | Tagged: , , , , , , | Leave a Comment »

Enable Currencies

Posted by shameemakhtar on June 22, 2009


General Ledger Super User –> Setup –> Financials –> Currencies –> Define

Query for the appropriate currency. Scroll to the right and enable the currency by checking the box if it is not checked.

If your currency is not available, add the currency in the list and enable it.

Enable all currencies required and disable whatever is not required.

Posted in Financials, General Ledger, Oracle Apps | Tagged: , , , , , | Leave a Comment »

Define Transaction Calendar

Posted by shameemakhtar on June 22, 2009


Define Transaction Calendar

Transaction Calendar

Secure Transaction Calendar

(Document to follow during course of the week)

Apologies

Shameem Bauccha

23 June 2009

Posted in Financials, General Ledger, Oracle Apps | Tagged: , , , , | Leave a Comment »

Define Accounting Calendar

Posted by shameemakhtar on June 22, 2009


Calendar Types

General Ledger Super User –> Setup –> Financials –> Calendars –> Types

You can use any of the seeded Calendar Types or create your own custom Calendar type.

For Year Type: Calendar or Fiscal

Accounting Calendar

General Ledger Super User –> Setup –> Financials –> Calendars –> Accounting

Prerequisite

Carefully consider the type of calendar you need for your organization, since it can be difficult to change your calendar (e.g., from a fiscal year to a calendar year) once you’ve used it to enter accounting data. Changing your calendar may require assistance from an Oracle consultant.

Define your accounting period types

Be careful not to miss out on any day when defining your calendar periods.

In the example above you can see that we have defined an additional adjusting period that overlaps with our last period of the year and allows us to make adjustments after we have closed the last period. We can have more than one adjusting period in a year with any from date and to date.

You can enable Security by checking the box (optional). You can secure your calendar definition using definition access sets. Definition access sets are an optional security feature that allows you to control use, view, and modify access to your General Ledger definitions.

For accounting calendars, only View and Modify access are applicable.

When you exit the Calendar Form, the Calendar Validation Report is automatically launched. You can view the request. You can also launch the request manually.

Shameem Bauccha

23 June 2009

Posted in Financials, General Ledger, Oracle Apps | Tagged: , , , , , , | 2 Comments »

Oracle Apps R12 – GL – Creating a territory

Posted by shameemakhtar on June 17, 2009


Legal Entity Administrator –> Lookups –> Define Lookups

Legal Entity Configurator Lookup

Legal Entity Configurator Lookup

You can define your own values for Legal Entity, Establishment and Legal Entity Person Registration.

Query ‘LE Registration Code’, ‘Establishment Registration Code’ or ‘Legal Entity Person Registration Code’ in the description field and update accordingly.

Clear the cache to ensure the values appear in your lookups.

Legal Entity Administrator –> Jurisdictions

Legal Entity Configurator

Legal Entity Configurator

Select the Legislative Category

Legislative Category

Legislative Category

Click on ‘Go’.

Jurisdictions

Jurisdictions

Add Legal Functions if required.

Add Legal Functions

Add Legal Functions

You can add any combination of the following functions:

Legal Functions

Legal Functions

Click on ‘Apply’.

You should get a confirmation message.

Confirmation

Confirmation

Your jurisdiction must now be available.

The territory will now be available when you create your Legal Entity.

Shameem Bauccha

18 June 2009

Click here to download the file.

Posted in Financials, General Ledger, Oracle Apps | Tagged: , , , , | 4 Comments »