Oracle General Ledger

Oracle General Ledger

GL INTERFACE TABLES

GL_BUDGET_INTERFACE
GL_DAILY_RATES_INTERFACE
GL_IEA_INTERFACE
GL_INTERFACE
GL_INTERFACE_CONTROL
GL_INTERFACE_HISTORY

GL BASE TABLES

FND_FLEX_VALUES_TL - FND_FLEX_VALUES - GL_SETS_OF_BOOKS - GL_IMPORT_REFERENCES - GL_DAILY_RATES - GL_JE_LINES - GL_PERIODS - GL_JE_HEADERS - GL_JE_BATCHES - GL_BALANCES - GL_CODE_COMBINATIONS

GL Budget Upload Interface

Pre-Req: set of books • flex field value sets • code combinations

Validations: Currency code • set of books id • budget entity name (budget organization)

Interface tables: GL_BUDGET_INTERFACE

Base tables: GL_BUDGETS • GL_BUDGET_ASSIGNMENTS • GL_BUDGET_TYPES

Concurrent Program Details: General Ledger Super user à Budgets à Enter à Upload

GL Daily Rates Interface

Pre-Req: currencies • conversion rate types

Validations: From Currency & to Currency, user_conversion_type

Interface tables: GL_DAILY_RATES_INTERFACE

Base tables: GL_DAILY_RATES • GL_DAILY_CONVERSION_TYPES

Concurrent Program Details: N/A à The insert, update, or deletion of rates in GL_DAILY_RATES is done automatically by database triggers on the GL_DAILY_RATES_INTERFACE. All that is required is to develop program to populate the interface table with daily rates information.

Tip: MODE_FLAG column is important (D= Delete, I = Insert, U = Update)

GL Journal Import Interface (GL Interface)

This will import journals from other sub ledger applications like Receivables, Payables into General Ledger.

Pre-Req: set of books • flex field value sets • code combinations valid & enabled • currencies • categories • journal sources •Open periods •Avoid duplicates

Validations: From Currency & to Currency, user_conversion_type

Interface tables: GL_INTERFACE

Base tables: GL_JE_HEADERS • GL_JE_LINES • GL_JE_BACTHES

Concurrent Program Details: Journal Import & Journal Posting (GL_BALANCES)

Tip: ACTUAL_FLAG column can be ‘A’ –Actual amount, ‘B’ – Budget amount & ‘E’ - Encumbrance amount. STATUS should be ‘NEW’ for new records.

Basics

• Setting up Accounting Periods and Calendars
• Defining the Accounting Flexfield Segments
• Defining General Ledger Security Rules
• Performing General Ledger Inquiries
• Setting Up General Ledger Journals
• Setting Journal Profile Options
• Setting Up Journal AutoReversal Criteria and Defining AutoPost Criteria
• Opening and Closing GL Accounting Periods
• Setting Up and Using Multi-Currency Accounting
• Defining Budgets and Budget Organizations
• Setting Budgetary Controls
• Performing Budget Inquiries
• Using the ADI Budget Wizard

FAQ

What is the use of GL_Interface?

A) Gl_Interface is the primary interface table of General ledger. It acts as an interface between data originating from other modules such as AP,AR, Legacy data and the Gl Base tables.

What is Actual Flag?

A) Actual flag represents the Journal type.
A-Actual
B-Budget
E- Encumbrance.

What is Encumbrance?

A) It is a process of Reservation of funds for anticipated expenditure from a budget. Encumbrance integrates GL, Purchasing and Payables modules.

How many Key Flex Fields are there in General Ledger?

A)One. Accounting Key Flex Field.

How many types of Budgets are there?

A) Two Types.
Expenditure Budgets
Revenue Budgets.

What are Spot Rate, Corporate Rate, Transaction Calendar and Accounting Calendar?

Spot Rate:

An exchange rate which you enter to perform conversion based on the rate on a specific date. It applies to the immediate delivery of currency.
Corporate Rate:
An Exchange rate that we define to standardize rates for our company. This rate is the standard market rate determined by the senior financial management for use through out the organization.
User Rate:
Conversion rate that is defined by the user.
EMU Fixed Rate: An exchange rate that is provided automatically by the General Ledger while entering journals. It uses a foreign currency that has a fixed relationship with the euro.
Transaction Calendar: Defines the business days and holidays for any calendar.
Accounting Calendar: Defines different types of calendars namely Fiscal, Federal Fiscal, Month etc.

What is Security Rule?

Security Rules are defined to control the access of a flexfield segment value (Financial information) at a responsibility level.

What are Cross Validation & ADI?

CVS – Cross validate segments – Allows only valid code combinations.
ADI – Allow dynamic inserts. – Allows any code combination irrespective of validity.
ADI would prevail if both of CVS and ADI are checked.

What is Translation?

A) Translation is a process used to convert functional currency to other reporting currencies at the account balances level.

What is Revaluation?

A) It is process used to revalue assets and liabilities denominated in foreign currency into functional currency based on period end exchange rate we specify. Unrealized gains/losses are resulted because of exchange rate fluctuations which are recorded in unrealized gain/loss account in GL.

What is FSG (Financial Statement Generator)?

A) Financial statement generator feature helps us to generate reports such as balance sheets and income statements with out programming. It also provides a high degree of control on the rows, columns, contents and calculations on the report. Different components such as row set, column set, content set, row order, display set have to be defined before a statement is generated, of which row set and column set are mandatory.

What is Consolidation?

A) Consolidation is a period-end process of combining the financial results of separate business subsidiaries with the parent company to form a single combined statement of financial results.

At what level General Ledger data is secured?

A) GL data is secured at Set of Book level. Sub ledger module data is secured at Responsibility level (i.e., at Operating Unit Level).