Oracle Applications

Oracle for Beginners

Archive for the ‘General Ledger’ Category

General Ledger

View for Chart of Accounts KFF

Posted by shameemakhtar on October 19, 2009


The script below allows you creates a view for your chart of accounts.
Modify to suit your requirements. Note that the value set name of each segment is passed as parameter.

CREATE OR REPLACE VIEW ABH_GL_ACC_CONCAT_SEGMENTS
AS
SELECT cc.code_combination_id,
 cc.chart_of_accounts_id,
 cc.detail_posting_allowed_flag post,
 cc.detail_budgeting_allowed_flag budget,
 cc.account_type,
 cc.show_account_type,
 cc.enabled_flag,
 cc.summary_flag,
 --segment: segments used in COA definition
 cc.segment1,
 cc.segment2,
 cc.segment3,
 cc.segment4,
 cc.segment5,
 cc.segment6,
 concat(concat(concat(concat(concat(concat(concat(concat(concat(concat(segment1, '-'), segment2),'-'), segment3), '-'), segment4), '-'), segment5), '-'), segment6) account_comb,
 get_flex_vs_desc('ABH Company', cc.segment1, '') Company,
 get_flex_vs_desc('ABH Cost Center', cc.segment2, '') "Cost Center",
 get_flex_vs_desc('ABH Account', cc.segment3, '') "Account",
 get_flex_vs_desc('ABH Sub Account', cc.segment4, cc.segment3) "Sub Account",
 get_flex_vs_desc('ABH Location', cc.segment5, '') "Location",
 get_flex_vs_desc('ABH Entity-Services', cc.segment6, '') "Entity-Services"
FROM GL_CODE_COMBINATIONS_V cc

Refer to document ‘Fetching Key Flexfield Value Description‘ for get_flex_vs_desc.
Shameem Bauccha

19 October 2009

Advertisements

Posted in General Ledger, Oracle Apps, Scripts, System Administrator, Technical | Tagged: , , , | 3 Comments »

E-Business Tax Setup: Create First PartyLegal Entity and Establishment

Posted by shameemakhtar on July 2, 2009


Platform: R12

Create First Party: Legal Entity and Establishments

This is a required step if you want to use E-Business Tax. If you are using General Ledger, then you will have already defined the Legal Entity and Establishment.

Refer to the following documents:

–          Accounting Setup Manager

–          Legal Entity and Establishment

You need to define the following:

–          Legal Entity

–          Legal Establishments for the Legal Entity

Note that Legal Establishments are setup under a parent Legal Entity.

Click on the ‘Go to Task’ icon. Alternatively you may also navigate as follows:

Legal Entity Manager –> Legal Entity Configurator

Legal Entity Configurator Homepage

Legal Entity Configurator Homepage

First Party: Legal Establishment

Setup a Legal Establishment for each office, warehouse, centre etc. which requires registration with a tax authority for one or more taxes. You can setup Party Tax Profiles for each Legal Establishment.

First Party Legal Entity and Establishment

First Party Legal Entity and Establishment

Set the following for each Legal Establishment:

–          Party Tax Profiles

–          Tax Registrations

Establishment

Establishment

Also setup your Operating Unit.

See Document ‘Operating Unit’ (Document to follow).

Shameem Bauccha

1 July 2009

Posted in E-Business Tax, Financials, General Ledger, Legal Entity Configurator, Oracle Apps | Tagged: , , , , , , , , | 1 Comment »

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 »

Accounting Key Flexfield – Create Chart of Accounts

Posted by shameemakhtar on June 22, 2009


(doc will be ready tomorrow)

apologies

Refer to the document ‘Define Key Flexfield Structure‘ for further details.

Shameem Bauccha

23 June 2009

Posted in Financials, General Ledger, Oracle Apps | Tagged: , , , , | 3 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 »