Oracle Application Key words

A

account groups

Fixed asset or long-term liabilities for which governments usually maintain separate accountability. Governments usually maintain these transactions in account groups known as the general fixed assets account group and the general long-term debt account group.

account hierarchy

An Oracle Government Financials feature you use to perform summary level funds checking. An account hierarchy lets Purchasing and General Ledger quickly determine the summary accounts into which your detail accounts roll up.

Account segment

One of the sections of an Accounting Flexfield, separated from the other sections by a symbol you choose (such as -, /, or \). You can have up to 30 different Accounting Flexfield segments. Each segment can be up to 25 characters long. Each Accounting Flexfield segment typically captures one element of your agency's structure, such as Fund, Division, Department, or Program.

Account segment value

A series of characters and a description that define a unique value for a particular value set.

account structure

See Accounting Flexfield structure.

accounting calendar

The calendar that defines your accounting periods and fiscal years in Oracle General Ledger. You define accounting calendars using the Accounting Calendar window. Oracle Financial Analyzer will automatically create a Time dimension using your accounting calendar.

accounting classification code structure

See chart of accounts and chart of accounts structure.

Accounting Flexfield

The code you use to identify a general ledger account in an Oracle Government Financials application. Each Accounting Flexfield segment value corresponds to a summary or rollup account within your chart of accounts.

Accounting Flexfield structure

The account structure you define to fit the specific needs of your organization. You choose the number of segments, as well as the length, name, and order of each segment in your Accounting Flexfield structure.

Accounting Flexfield value set

A group of values and attributes of the values. For example, the value length and value type that you assign to your Accounting Flexfield segment to identify a particular element of your organization, such as Agency, Division, Region, or Project.

agency

An executive branch department, independent board, commission, bureau, committee, section, office, or other establishment of a government. In Oracle Government Financials, a representative organization of a federal government, state or local government, or institution of higher education.

agent

An individual responsible for providing goods or services or authorizing their provision to another government entity or recipient.

aggregate balance

The sum of the end-of-day balances for a range of days. There are three types of aggregate balances: period-to-date (PTD), quarter-to-date (QTD), and year-to-date (YTD). All three are stored in the General Ledger database for every calendar day.

allocation entry

A recurring journal entry you use to allocate revenues or costs.

appropriation

An authorization by a legislative body that permits a government to incur obligations and make payments for specified purposes. An appropriation usually follows enactment of authorizing legislation. Appropriations are limitations on the amounts agencies can obligate during the time specified in the appropriation act.

archive table

General Ledger copies your account balances from the Balances Table (GL_BALANCES) to your Archive Table (GL_ARCHIVE_BALANCES). General Ledger copies your journal details from the Journal Entry tables (GL_JE_BATCHES, GL_JE_HEADERS, and GL_JE_LINES) to your archive tables (GL_ARCHIVE_BATCHES, GL_ARCHIVE_HEADERS, and GL_ARCHIVE_LINES).

archive tablespace

The tablespace where your archive table is stored. A tablespace is the area in which an Oracle7 database is divided to hold tables.

attribute

An Oracle Financial Analyzer database object that links or relates the values of two dimensions. For example, you might define an attribute that relates the Sales District dimension to the Region dimension so that you can select data for sales districts according to region.

AutoCopy - budget organizations

An General Ledger feature that automatically creates a new budget organization by copying account assignments from an existing budget organization.

AutoCopy - budgets

AnGeneral Ledger feature that automatically creates a new budget by copying all of the data from an existing budget. Budget AutoCopy copies budget amounts only from open budget years.

AutoOffset

An General Ledger feature that automatically determines the offset (or credit) entry for your allocation entry. AutoOffset automatically calculates the net of all previous journal lines in your allocation entry, reverses the sign, and generates the contra amount.

AutoReduction

A feature in the list window that allows you to shorten a list so that you must scan only a subset of values before choosing a final value. Just as AutoReduction incrementally reduces a list of values as you enter additional character(s), pressing [Backspace] incrementally expands a list.

AutoSelection

A feature in the list window that allows you to choose a valid value from the list with a single keystroke. When you display the list window, you can type the first character of the choice you want in the window. If only one choice begins with the character you enter, AutoSelection selects the choice, closes the list window, and enters the value in the appropriate field.

AutoSkip

A feature specific to flexfields where Oracle Applications automatically moves your cursor to the next segment as soon as you enter a valid value into a current flexfield segment. You can turn this feature on or off with the user profile option Flexfields:AutoSkip.

average balance

The amount computed by dividing an aggregate balance by the number of calendar days in the related range.

average exchange rate

The average rate for an entire accounting period. General Ledger automatically translates revenue and expense account balances using period-average rates in accordance with FASB 52 (U.S.). For organizations in highly inflationary economies, General Ledger uses average exchange rates to translate non-historical revenue and expense accounts in accordance with FASB 8 (U.S.). Also known as period-average exchange rate.

B

back-value transactions

Transactions whose effective date is prior to the current accounting date. Also known as value-dated transactions.

balances table

An General Ledger database table that stores your account balances, called GL_BALANCES.

balancing segment

An Accounting Flexfield segment that you define so that General Ledger automatically balances all journal entries for each value of this segment. For example, if your fund segment is a balancing segment, Oracle Government General Ledger assures that, with every journal entry, the total debits to Fund 01 equals the total credits to Fund 01.

bank statement

A report sent from a bank to a customer showing all transaction activity for a bank account for a specific period of time. Bank statements report beginning balance, deposits made, checks cleared, bank charges, credits, and ending balance. Enclosed with the bank statement are cancelled checks, debit memos, and credit memos. Large institutional banking customers usually receive electronic bank statements as well as the paper versions.

budget

Estimated cost, revenue, labor hours or other quantities for a project or task. Each budget may optionally be categorized by resource. Different budget types may be set up to classify budgets for different purposes. In addition, different versions can exist for each user-defined budget type: current, original, revised original, and historical versions. The current version of a budget is the most recently baselined version.

budget formula

A mathematical expression used to calculate budget amounts based on actual results, other budget amounts and statistics. With budget formulas, you can automatically create budgets using complex equations, calculations and allocations.

budget hierarchy

A group of budgets linked at different levels such that the budgeting authority of a lower-level budget is controlled by an upper-level budget.

budget interface table

An General Ledger database table that stores information needed for budget upload.

budget organization

An entity, such as a department, division, or activity, responsible for entering and maintaining budget data.

budget rules

A variety of shorthand techniques you can use to speed manual budget entry. With budget rules you can divide a total amount evenly among budget periods, repeat a given amount in each budget period or enter budget amounts derived from your account balances.

budget upload

The ability to transfer budget information from a spreadsheet to General Ledger. For example, with the spreadsheet interface you can upload budget information from your spreadsheet to General Ledger.

budgetary account

An account segment value (such as 6110) that is assigned one of the two budgetary account types. You use budgetary accounts to record the movement of funds through the budget process from appropriation to expended appropriation.

Budgetary Account

An account that contains a budgetary account.

budgetary account type

Either of the two account types Budgetary DR and Budgetary CR.

budgetary control

An Oracle Government Financials feature you use to control actual and anticipated expenditures against a budget. When budgetary control is enabled, you can check funds online for transactions, and you can reserve funds for transactions by creating encumbrances. Oracle Government Financials automatically calculates funds available (budget less encumbrances less actual expenditures) when you attempt to reserve funds for a transaction. Oracle Government Financials notifies you online if funds available are insufficient for your transaction.

business day

Days on which financial institutions conduct business. In General Ledger, you choose which days of the calendar year are defined as business days. You can include or exclude weekends and holidays as needed.

C

child segment value

A detail-level segment value that is part of a parent segment value. See alsoparent segment value

chart of accounts

The account structure your organization uses to record transactions and maintain account balances.

chart of accounts structure

A classification of account segment values that assigns a particular range of values a common characteristic. For example, 1000 to 1999 might be the range of segment values for assets in the account segment of your accounting flexfield.

column set

A Financial Statement Generator report component you build within General Ledger by defining all of the columns in a report. You control the format and content of each column, including column headings, spacing and size, calculations, units of measure, and precision. A typical column set includes a header column for headings and subheadings, currency assignments, amount types, and calculation columns totals.

You can also define a column set with each column representing a different fund to enhance reporting by fund group.

commitment

A journal entry you make to record an anticipated expenditure as indicated by approval of a requisition. Also known as pre-commitment, pre-encumbrance orpre-lien.

concurrent manager

A unique facility that manages many time-consuming, non-interactive tasks within Oracle Applications for you, so you do not have to wait for their completion. When you submit a request in Oracle Applications that does not require your interaction, such as releasing shipments or running a report, the Concurrent Manager does the work for you, enabling you to complete multiple tasks simultaneously.

concurrent process

A non-interactive task that you request Oracle Applications to complete. Each time you submit a non-interactive task, you create a new concurrent process. A concurrent process runs simultaneously with other concurrent processes (and other interactive activities on your computer) to help you complete multiple tasks at once.

concurrent queue

A list of concurrent requests awaiting completion by a concurrent manager. Each concurrent manager has a queue of requests waiting to be run. If your system administrator sets up your Oracle Application to have simultaneous queuing, your request can wait to run in more than one queue.

concurrent request

A request to Oracle Applications to complete a non-interactive task for you. You issue a request whenever you submit a non-interactive task, such as releasing a shipment, posting a journal entry, or running a report. Once you submit a request, Oracle Applications automatically takes over for you, completing your request without further involvement from you or interruption of your work.

consolidation

An General Ledger feature that allows you to combine the results of multiple funds, even if they are in different sets of books with different currencies, calendars, and account classification code structures.

consolidation set of books

A set of books which has average balance processing enabled and which is defined as a consolidation set of books. A consolidation set of books must be used to consolidate average balances using the balances consolidation method.

consumption tax

An indirect tax imposed on transfer of goods and services at each stage of their supply. The difference between output tax (tax collected for revenue earned from the transfer) and the input tax (tax paid on expense paid on the transfer) will be the tax liability to the government. This tax is, in concept, value added tax (VAT).

content set

A report component you build within General Ledger that defines the information in each report and the printing sequence of your reports. For example, you can define a departmental content set which prints one report for each department.

context field prompt

A question or prompt to which a user enters a response, called a context field value. When Oracle Applications displays a descriptive flexfield pop-up window, it displays your context field prompt after it displays any global segments you have defined. Each descriptive flexfield can have up to one context prompt.

context field value

A response to your context field prompt. Your response is composed of a series of characters and a description. The response and description together provide a unique value for your context prompt, such as 1500, Journal Batch ID, or 2000, Budget Formula Batch ID. The context field value determines which additional descriptive flexfield segments appear.

context response

See context field value.

context segment value

A response to your context-sensitive segment. The response is composed of a series of characters and a description. The response and description together provide a unique value for your context-sensitive segment, such as Redwood Shores, Oracle Corporation Headquarters, or Minneapolis, Merrill Aviation's Hub.

context-sensitive segment

A descriptive flexfield segment that appears in a second pop-up window when you enter a response to your context field prompt. For each context response, you can define multiple context segments, and you control the sequence of the context segments in the second pop-up window. Each context-sensitive segment typically prompts you for one item of information related to your context response.

conversion

Converts foreign currency transactions to your functional currency.

D

database table

A basic data storage structure in a relational database management system. A table consists of one or more units of information (rows), each of which contains the same kind of values (columns). Your application's programs and windows access the information in the tables for you.

dependent segment

An account segment in which the available values depend on values entered in a previous segment, called the independent segment. For example, the dependent segment Sub-Account 0001 might mean Bank of Alaska when combined with the independent segment Account 1100, Cash, but the same Sub-Account 0001 might mean Building #3 when combined with Account 1700, Fixed Assets.

descriptive flexfield

A field that your organization can extend to capture extra information not otherwise tracked by Oracle Applications. A descriptive flexfield appears on your form as a single character, unnamed field. Your organization can customize this field to capture additional information unique to your business.

detail budget

A budget whose authority is controlled by another budget.

dimension

An Oracle Financial Analyzer database object used to organize and index the data stored in a variable. Dimensions answer the following questions about data: "What?" "When?" and "Where?" For example, a variable called Units Sold might be associated with the dimensions Product, Month, and District. In this case, Units Sold describes the number of products sold during specific months within specific districts.

dimension label

A text label that displays the name of the Oracle Financial Analyzer dimension associated with an element of a report, graph, or worksheet. For example, the data markers in a graph's legend contain dimension labels that show what data each data marker represents. Dimension labels can be short, meaning they display the object name of a dimension, or user-specified, meaning they display a label that you typed using the Dimension Labels option on the Graph, Report, or Worksheet menus.

dimension values

Elements that make up an Oracle Financial Analyzer dimension. For example, the dimension values of the Product dimension might include Tents, Canoes, Racquets, and Sportswear.

display group

A range of rows or columns in your row set or column set for which you want to control the display in your report. You assign a display group to a display set where you specify whether you want to display or hide your rows or columns.

display set

A Financial Statement Generator report component you build within General Ledger to control the display of ranges of rows and columns in a report, without reformatting the report or losing header information. You can define a display set that works for reports with specific row and column sets. Alternatively, you can define a generic display set that works for any report.

document sequence number

A number that is manually or automatically assigned to your documents to provide an audit trail. For example, you can choose to sequentially number invoices in Receivables or journal entries in General Ledger. See also voucher number.

Dual Currency

An General Ledger feature that allows you to report in your functional currency and in one or more foreign currencies.

due from

A liability account you use to record noncurrent portions of a long-term debt owed by one fund to another fund within the same reporting entity.

due to

An asset account you use to record the noncurrent portion of a long-term loan from one fund to another fund within the same reporting entity.

dynamic insertion

An Accounting Flexfields feature that allows you to enter and define new combinations of segment values directly in a flexfield pop-up window. The new combination must satisfy any cross-validation rules before it is accepted. Your organization can decide if an Accounting Flexfield supports dynamic insertion. If an account does not support dynamic insertion, you can only enter new combinations of segment values using the Define Accounts form.

E

effective date

The date a transaction affects the balances in the general ledger. This does not have to be the same as the posting date. Also known as the value date.

encumbrance

An entry you make to record anticipated expenditures of any type. Oracle Government Financials create requisition encumbrances and purchase order encumbrances automatically when encumbrance accounting or budgetary control is enabled. You can also record other encumbrances manually. For example, you can record encumbrances for your payroll.

encumbrance accounting

An Oracle Government Financials feature that create encumbrances automatically for requisitions, purchase orders, and invoices. If you enable encumbrance accounting only, you can create encumbrances automatically or manually. You cannot check funds online unless you also enable budgetary control. See alsobudgetary control.

encumbrance journal entry

A journal entry you create online that increases or relieves your encumbrances. Encumbrance entries can include encumbrances of any type. You can enter manual encumbrance entries, define encumbrance allocations, or use Journal Import to import encumbrance entries from other financial systems.

encumbrance type

An encumbrance category that allows you to track your anticipated expenditures according to your purchase approval process and to more accurately control your planned expenditures. Examples of encumbrance types are commitments (requisition encumbrances) and obligations (purchase order encumbrances).

end-of-day balance

The actual balance of a general ledger account at the end of a day. This balance includes all transactions whose effective date precedes or is the same as the calendar day.

exchange rate

A rate that represents the amount of one currency that you can exchange for another at a particular point in time. Oracle Applications use the daily, periodic, and historical exchange rates you maintain to perform foreign currency conversion, revaluation, and translation.

exchange rate type

A specification of the source of an exchange rate. For example, a user exchange rate or a corporate exchange rate. See also corporate exchange rate, spot exchange rate.

expenditures

Activities that represent payments, repayments, or receipts for goods or services furnished. For some governments, expenditures include anticipated expenses, such as encumbrances, in addition to activity that directly leads to an outlay of cash, such as an invoice. In Oracle Government Financials, term expendituresincludes actual expenses and accrued liabilities; expenditures do not include anticipated expenses, such as encumbrances.

export

A utility that enables you to copy data from an Oracle7 table to a file in your current directory. The export utility is part of the Oracle7 Relational Database Management System.

export file

The file the export utility creates in your directory. Export files must have the extension .dmp. It is wise to name the export file so it identifies the data in the table. For example, if you are saving fiscal year 1994 for your Fremont set of books, you might call your export file FY94FR.dmp.

F

factor

Data upon which you perform some mathematical operation. Fixed amounts, statistical account balances, account balances, and report rows and columns are all data types you can use in formulas.

FASB 52 (U.S.)

See SFAS 52.

FASB 8 (U.S.)

See SFAS 8.

feeder program

A custom program you write to transfer your transaction information from an original system into Oracle Application interface tables. The type of feeder program you write depends on the environment from which you are importing data.

fiduciary funds

A fund type for which the accounting and reporting techniques depend on whether the fund is expendable or nonexpendable. Examples of fiduciary funds include Trust and Agency funds.

financial data item

An Oracle Financial Analyzer database object that is made up of either a variable, or a variable and a formula. For example, a financial data item called "Actuals" would be a variable, while a financial data item called "Actuals Variance" would be made up of a variable (Actuals) and a formula that calculates a variance.

Financial Statement Generator

A powerful and flexible tool you can use to build your own custom reports without programming. You can define reports online with complete control over the rows, columns and contents of your report.

fiscal year

Any yearly accounting period without regard to its relationship to a calendar year.

FlexBudgeting

An General Ledger feature that uses budget formulas and statistics to create a flexible budget. For example, a manufacturing organization may want to maintain a flexible budget based on actual units of production to eliminate volume variances during an analysis of actual versus budgeted operating results.

flexfield

An Oracle Applications field made up of segments. Each segment has an assigned name and a set of valid values. Oracle Applications uses flexfields to capture information about your organization. There are two types of flexfields: key flexfields and descriptive flexfields.

folder

A flexible entry and display window in which you can choose the fields you want to see and where each appears in the window. Read: About folders

foreign currency

A currency that you define for your set of books for recording and conducting accounting transactions in a currency other than your functional currency. See also exchange rate, functional currency.

foreign currency conversion

A process that allows you to convert a foreign currency journal entry into your functional currency. General Ledger automatically converts currency whenever you enter a journal entry in a currency other than your functional currency. General Ledger multiplies the daily exchange rate you define or the exchange rate you enter to convert amounts for your functional currency. You can view the results of foreign currency conversion in the Enter Journals form.

foreign currency journal entry

A journal entry in which you record transactions in a foreign currency. General Ledger automatically converts foreign currency amounts into your functional currency using an exchange rate you specify. See also foreign currency, functional currency.

foreign currency revaluation

A process that allows you to revalue assets and liabilities denominated in a foreign currency using a period-end (usually a balance sheet date) exchange rate. General Ledger automatically revalues your foreign assets and liabilities using the period-end exchange rate you specify. Revaluation gains and losses result from fluctuations in an exchange rate between a transaction date and a balance sheet date. General Ledger automatically creates a journal entry in accordance with FASB 52 (U.S.) to adjust your unrealized gain/loss account when you run revaluation.

foreign currency translation

A process that allows you to restate your functional currency account balances into a reporting currency. General Ledger multiplies the average, periodic, or historical rate you define by your functional currency account balances to perform foreign currency translation. General Ledger translates foreign currency in accordance with FASB 52 (U.S.). General Ledger also remeasures foreign currencies for companies in highly inflationary economies, in accordance with FASB 8 (U.S.).

formula entry

A recurring journal entry that uses formulas to calculate journal entry lines. Instead of specifying amounts, as you would for a standard entry, you use formulas, and General Ledger calculates the amounts for you. For example, you might use recurring journal entries to do complex allocations or accruals that are computed using statistics or multiple accounts.

functional currency

The principal currency you use to record transactions and maintain your accounting data within General Ledger. The functional currency is usually the currency in which you perform most of your business transactions. You specify the functional currency for each set of books in the Define Set of Books form.

fund

A fiscal and accounting entity with a self-balancing set of accounts in which cash and other financial resources, all related liabilities and residual equities or balances and changes to these balances are recorded. A fund is segregated to carry on specific activities or attain certain objectives in accordance with special regulations, restrictions, or limitations. When you implement Oracle Government Financials, Fund is typically a segment of your Accounting Flexfield, usually your balancing segment.

fund balance

Fund balance is the equity portion of a fund balance sheet. Fund balance may contain one or more of the following subdivisions: reserved - A portion of the fund balance not available for expenditure or legally segregated for a specific future use. For example, Reserve for Encumbrances and Reserve for Inventory are reserved portions of fund balance. Unreserved, designated - A portion of the fund balance established to indicate tentative plans for the future use of current resources. unreserved, undesignated - Fund balance available for use without predefined restrictions.

fund group

A general category of funds, for which you report fund activity as a whole. Plant funds, restricted funds, and general operating funds are examples of fund groups. Each fund group can have one or more funds associated with it. In Oracle Government Financials, you can summarize funds into fund groups using rollup groups.

fund segment

The segment of your Accounting Flexfield you use to record fund, appropriation, or other information relating to a fiscal entity. In Oracle Government Financials, fund segment is a generic term for the balancing segment you specify when you implement Oracle Government Financials.

fund type

A classification of funds for specifying accounting attributes. GAAP and other accounting authorities specify the fund types in general use and the appropriate accounting method, use of encumbrance, use of budgetary or proprietary accounts, and other attributes. For example, governmental units typically use the following fund types: General, Special Revenue, Capital Projects, Debt Service, Internal Service, Enterprise, and Trust & Agency.

funding budget

A budget against which accounting transactions are checked for available funds when budgetary control is enabled for your set of books.

funds available

The difference between budgeted amounts and all actual and anticipated expenditures. Oracle Government Financials allows you to check funds available online for requisitions, purchase orders, and invoices.

funds checking

The process of certifying funds available.

You can check funds when you enter actual, budget, or encumbrance journals.

When you check funds, Oracle Government Financials compares the amount of your transaction against your funds available and notifies you online whether funds are available for your transaction. Oracle Government Financials does not reserve funds for your transaction when you check funds.

funds reservation

The process of reserving funds available. You can reserve funds when you enter actual, budget, or encumbrance journals. When you reserve funds, Oracle Government Financials compares the amount of your transaction against your funds available and notifies you online whether funds are available for your transaction.

G

governmental funds

A type of fund whose objective is to provide services to the public. Governmental funds are concerned with the availability of resources to provide services. Examples of governmental funds are General, Special Revenue, Capital Projects, and Debt Service.

grant

Assistance awards in which a government agency provides funding to another government agency or other recipient, and in which the granting agency does not have substantial involvement with the receiving agency or recipient during the performance of the grant activity. For example,a state government might give grants to regional and local governments for various purposes. The regional and local governments administer the grant for the state government.

I

import

A utility that enables you to bring data from an export file into an Oracle7 table. The import utility is part of the Oracle7 Relational Database Management System. This utility is used to restore archived data.

import journal entry

A journal entry from a non-Oracle application, such as accounts payable, accounts receivable, and fixed assets. You use Journal Import to import these journal entries from your feeder systems.

interfund account

A general ledger account you define in an Accounting Flexfield to balance interfund transactions. You can define multiple interfund accounts for use with different types of journal entries. You can define multiple interfund accounts and link them with balancing segment values, so each fund can have multiple interfund accounts. For example, fund A can have an interfund payable account for fund B and an interfund receivable account for fund B. Fund A can have an interfund payable account for fund C and an interfund receivable account for fund C.

interfund entry

A transaction between two or more funds. For example, an activity funded out of the General Fund that is to be reimbursed by the Plant Fund is an interfund transaction. Oracle Government Financials can automatically create basic interfund entries when you post a journal entry that does not balance by balancing segment value, or fund.

interfund journal entry

A journal entry that records transactions between affiliates. General Ledger keeps your accounting records in balance for each fund by automatically creating offsetting entries to an interfund account you define.

interfund transfer

All interfund transactions except for loans, advances, quasi-external transactions and reimbursements.

Item Validation Organization

The organization that contains your master list of items. You define it by setting the OE: Item Validation Organization profile option. See also organization.

J

journal details tables

Journal details are stored in the database tables GL_JE_BATCHES, GL_JE_HEADERS, and GL_JE_LINES.

journal entry

A debit or credit to a general ledger account. See also manual journal entry.

journal entry category

A category in which General Ledger describes the purpose or type of journal entry. Standard journal entry categories include accruals, payments, and vouchers.

journal entry source

The source by which General Ledger identifies and differentiates the origin of journal entries. Standard journal entry sources include payables, payroll, personnel, and receivables.

Journal Import

An General Ledger program that creates journal entries from transaction data stored in the General Ledger GL_INTERFACE table. Journal entries are created and stored in GL_BATCHES, GL_HEADERS and GL_LINES.

jurisdiction code

An abbreviated address that is specific to a Tax Supplier and more accurate than a simple five digit zip code.

K

key flexfield

An Oracle Applications feature you use to build custom fields in which to enter and display information relating to your business. The General Ledger Accounting Flexfield is a key flexfield.

M

manual journal entry

A journal entry you create online using the Enter Journals form. Manual journal entries include regular, statistical, interfund, and foreign currency journal entries.

Many-to-Many attribute

In Oracle Financial Analyzer, a relationship between one or more values of one base dimension with one or more values of a second base dimension. For example, if you have a Many-to-Many attribute definition where the first base dimension is Organization and the second base dimension is Line Item, then a single organization can be related to several line items, and a single line item can be related to several organizations.

MassBudgeting

A feature that allows you to build a complete budget using simple formulas based on actual results, other budget amounts, and statistics. For example, you may want to draft next year's budget using last year's actual results plus 10 percent or some other growth factor. With MassBudgeting, you can apply one rule to a range of accounts.

master budget

A budget that controls the authority of other budgets.

message distribution

A line on the bottom of your form that displays helpful hints, warning message, and basic entry errors.

message line

A line on the bottom of your form that displays helpful hints or warning messages when you encounter an error.

meta data

Data you enter in Oracle General Ledger to represent structures in Oracle Financial Analyzer. Meta data consists of the dimensions, segment range sets, hierarchies, financial data items, and financial data sets you define in Oracle General Ledger. When you load financial data from Oracle General Ledger, Oracle Financial Analyzer creates dimensions, dimension values, hierarchies, and variables based on the meta data.

model

A set of interrelated equations for calculating data in Oracle Financial Analyzer.

N

natural account segment

In Oracle General Ledger, the segment that determines whether an account is an asset, liability, owners' equity, revenue, or expense account. When you define your chart of accounts, you must define one segment as the natural account segment. Each value for this segment is assigned one of the five account types.

nesting

The act of grouping calculations to express the sequence of routines in a formula. Traditional mathematical nesting uses parenthesis and brackets. General Ledger EasyCalc uses a straightforward and logical nesting method that eliminates the need for parenthetical expressions.

net allocation

Allocation in which you post the net of all allocations to an allocated-out account.

O

object or object classification

A means of identifying transactions by the nature of the goods or services purchased, such as personnel compensation, supplies and material, or equipment. Typically, Object is a segment of your Accounting Flexfield when you implement Oracle Government Financials. Many agencies have standard object classification codes. Objects are also known as "Detail" in some governments.

obligation

A transaction representing a legally binding purchase. See also commitment, purchase order encumbrance, encumbrance.

One-to-Many attribute

A relationship in Oracle Financial Analyzer where one or more values of a base dimension are related to a single value of an aggregate dimension. For example, if you have a One-to-Many attribute definition where the base dimension is Organization and the aggregate dimension is Level, each organization can be related to only a single level.

operator

A mathematical symbol you use to indicate the mathematical operation in your calculation.

organization

A business unit such as a plant, warehouse, division, department, and so on. Oracle Order Entry refers to organizations as warehouses on all Order Entry forms and reports.

A government or public sector entity or sub-entity. Organization can refer to an entire agency or to divisions within an agency. For example, an agency might be composed of several bureaus, each of which has several departments. Each department is an organization, as is each bureau and the agency itself. A state university system is an organization, as is each campus within the university system, and each department within each campus. Typically, you define organization or a similar term as part of your Accounting Flexfield when you implement Oracle Government Financials.

P

parameter

See report parameter.

parent segment value

An account segment value that references a number of other segment values, called child segment values. General Ledger uses parent segment values for creating summary accounts, for reporting on summary balances, and in MassAllocations and MassBudgeting. You can create parent segment values for independent segments, but not for dependent segments.

Oracle Financial Analyzer uses parent and child segment values to create hierarchies.

Q

quarter average-to-date

The average of the end-of-day balances for a related range of days within a quarter.

query

A search for applications information that you initiate using an Oracle Applications form.

R

recurring formula

See recurring journal entry.

recurring journal entry

A journal entry you define once; then, at your request, General Ledger repeats the journal entry for you each accounting period. You use recurring journal entries to define automatic consolidating and eliminating entries. Also known as recurring formula.

reimbursement

A transaction you reflect once for the government as a whole, such as expenditures you make from a fund that are properly applicable to another fund. For example, if you charge an expenditure to the special revenue fund that is properly chargeable to the general fund, you reimburse the special revenue fund by recording the expenditure in the general fund and reducing the expenditure in the special revenue fund to be reimbursed.

report

A combination of at least a row set and column set, and optionally a content set, display group, row order, and runtime options, such as currency and override segment name, that you can define and name. When you request financial statements, you can enter this name, and General Ledger automatically enters the report components and runtime options for you. You simply specify the accounting period. General Ledger automatically enters the rest.

report component

An element of a Financial Statement Generator report that defines the format and content of your report. Report components include row sets, column sets, content sets, row orders, and display sets. You can group report components together in different ways to create custom reports.

report headings

A descriptive section found at the top of each report giving general information about the contents of the report.

report option

See report parameter.

report parameter

Most General Ledger reports offer options for sorting, formatting, selecting, and summarizing the information in your report.

report set

A group of reports that you submit at the same time to run as one transaction. A report set allows you to submit the same set of reports regularly without having to specify each report individually. For example, you can define a report set that prints all of your regular month-end management reports.

reporting currency

The currency you use for financial reporting. If your reporting currency is not the same as your functional currency, you can use foreign currency translation to restate your account balances in your reporting currency.

reporting entity

The oversight unit and all related component units that combine to form a governmental reporting entity.

reporting hierarchies

Summary relationships within an account segment that let you group detailed values of that segment to prepare summary reports. You define summary (parent) values that reference the detailed (children) values of that segment.

requisition encumbrance

A transaction representing an intent to purchase goods and services as indicated by the completion and approval of a requisition. Purchasing subtracts requisition encumbrances from funds available when you reserve funds for a requisition. If you cancel a requisition, Purchasing creates appropriate reversing entries in your general ledger. Also known as commitment, pre-encumbrance or pre-lien.

Reserve for Encumbrance

A portion of fund balance you use to record anticipated expenditures. In Oracle Government Financials, you define your Reserve for Encumbrance account when you define your set of books. Oracle Government Financials uses your Reserve for Encumbrance account to create offsets for unbalanced encumbrance entries you create in Purchasing, Payables, and General Ledger.

Reserve for Encumbrance account

The account you use to record your encumbrance liability. You define a Reserve for Encumbrance account when you define your set of books. When you create encumbrances automatically in Purchasing or General Ledger, General Ledger automatically creates a balancing entry to your Reserve for Encumbrance account as you post your encumbrance journal entries. General Ledger overwrites the balancing segment for your Reserve for Encumbrance account, so you automatically create the reserve for encumbrance journal entry to the correct fund.

responsibility

A level of authority within General Ledger. Each responsibility provides a user with access to a menu and a set of books. You can assign one or more responsibilities to each user. Responsibilities let you control security in General Ledger.

responsibility report

A financial statement containing information organized by management responsibility. For example, a responsibility report for an organization contains information for that organization, a responsibility report for a division manager contains information for all organizational units within that division, and so on. A manager typically receives reports for the organizational units (such as division, department, group, and so on) for which he or she is responsible.

revaluation

See foreign currency revaluation.

revaluation gain/loss account

An income statement account you specify in which General Ledger records net revaluation gains and losses, in accordance with FASB 52 (U.S.). You specify the account you want to use for unrealized revaluation gains and losses in the Run Revaluation form. You can change your revaluation gain/loss account as often as you want. When you run revaluation, General Ledger creates a batch of revaluation journal entries that adjust your revaluation gain/loss account. General Ledger also marks the journal entries for reversal in the next accounting period.

revaluation journal entry

A journal entry that is automatically created when you run revaluation for a range of accounts denominated in a foreign currency. General Ledger creates a batch of revaluation journal entries when the exchange rate used for conversion on your transaction date differs from the exchange rate on your balance sheet date. General Ledger creates a journal entry to adjust an income statement gain and loss account for exchange rate fluctuations, in accordance with FASB 52 (U.S.).

revaluation status report

A report that summarizes the results of your revaluation. General Ledger automatically generates this report whenever you revalue foreign asset and liability account balances for an accounting period in your calendar. You can review this report to identify accounts that were revalued in General Ledger and journal batches and entries that were created because of the revaluation.

reversing journal entry

A journal entry General Ledger creates by reversing an existing journal entry. You can reverse any journal entry and post it to any open accounting period.

rollup group

A collection of parent segment values for a given segment. You use rollup groups to define summary accounts based on parents in the group. You can use letters as well as numbers to name your rollup groups.

root node

A parent segment value in Oracle General Ledger which is the topmost node of a hierarchy. When you define a hierarchy using the Hierarchy window, you specify a root node for each segment. Oracle Financial Analyzer creates a hierarchy by starting at the root node and drilling down through all of the parent and child segment values. See also parent segment value

row order

A report component you use to modify the current order of rows and Accounting Flexfield segments in your report. You can rank rows in ascending or descending order based on a selected column and rearrange the sequence of segments in your Accounting Flexfield. For example, to review Total Expenditures in descending order by project, you can rank rows in descending order by the Total Expenditures column and rearrange your segments so the project row appears first on the report.

row set

A report component you build within General Ledger by defining all of the rows in your report. For each row, you control the format and content, including line descriptions, indentations, spacing, page breaks, calculations, units of measure, precision, and so on.

rule numbers

A sequential step in a calculation. You use rule numbers to specify the order in which you want General Ledger to process the factors you use in your budget and actual formulas.

S

segments

The building blocks of your chart of accounts in Oracle General Ledger. Each account is comprised of multiple segments. Users choose which segments will make up their accounts; commonly-used segments include company, cost center, and product.

segment values

The possible values for each segment of the account. For example, the Cost Center segment could have the values 100, which might represent Finance, and 200, which might represent Marketing.

selection tools

A set of tools in Oracle Financial Analyzer that provide shortcut methods for selecting the values that you want to work with in a report, graph, or worksheet.

sales tax

A tax collected by a tax authority on purchases of goods and services. The supplier of the good or service collects sales taxes from its customers (tax is usually included in the invoice amount), and remits them to a tax authority. Tax is usually charged as a percentage of the price of the good or service. The percentage rate usually varies by authority and sometimes by category of product. Sales taxes are expenses to the buyer of goods and services.

sales tax structure

The collection of taxing bodies that you will use to determine your tax authority. 'State.County.City' is an example of a Sales Tax Structure. General Ledger adds together the tax rates for all of these components to determine a customer's total tax liability for

set of books

An organization or group of organizations within General Ledger that shares a common account structure, calendar, and functional currency.

SFAS 52 (U.S.)

Statement of Financial Accounting Standards number 52, issued by the Financial Accounting Standards Board (FASB), which dictates accounting and reporting standards for translating foreign currency transactions in the United States. General Ledger translates and revaluates such transactions according to SFAS 52 (U.S.) standards. Usually, SFAS 52 (U.S.) mandates the use of a period-end exchange rate to translate asset and liability accounts, and an average exchange rate to translate revenue and expense accounts. Foreign currency denominated assets and liabilities are revalued using a period-end rate on each balance sheet date, to reflect the period-end exchange rate in accordance with SFAS 52 (U.S.). You specify the account used for revaluation gains and losses in the Run Revaluation form. You maintain the rates used for translation and revaluation in the Define Period Rates and Define Historical Rates forms. SFAS 52 (U.S.) also mandates that you post any out-of-balance amounts arising from translation to a Cumulative Translation Adjustment account included in stockholders equity. You define the Cumulative Translation Adjustment account in the Define Set of Books form.

SFAS 8 (U.S.)

Statement of Financial Accounting Standards number 8, issued by the Financial Accounting Standards Board (FASB), which mandates that you use a historical exchange rate for all accounts based on past purchase exchanges, and that you use a current exchange rate for all accounts based on current purchase, current sale, and future exchanges. General Ledger remeasures specific account balances using historical rates you specify for companies in highly inflationary economies according to the standards of SFAS 8 (U.S.). SFAS 8 (U.S.) also mandates that you record any out-of-balance amounts arising from translation to an income/expense account included in your income statement.

shortdecimal data type

Oracle Financial Analyzer variables with a shortdecimal data type contain decimal numbers with up to 7 significant digits.

shortinteger data type

Oracle Financial Analyzer variables with a shortinteger data type contain whole numbers with values between -32768 and +32768.

shorthand flexfield entry

A quick way to enter key flexfield data using shorthand aliases (names) that represent valid flexfield combinations or patterns of valid segment values. Your organization can specify flexfields that will use shorthand flexfield entry and define shorthand aliases for these flexfields that represent complete or partial sets of key flexfield segment values.

skeleton entry

A recurring journal entry the amounts of which change each accounting period. You simply define a recurring journal entry without amounts, then enter the appropriate amounts each accounting period. For example, you might define a skeleton entry to record depreciation in the same accounts every month, but with different amounts due to additions and retirements.

spot exchange rate

A daily exchange rate you use to perform foreign currency conversion. The spot exchange rate is usually a quoted market rate that applies to the immediate delivery of one currency for another.

spreadsheet interface

A program that uploads your actual or budget data from a spreadsheet into General Ledger.

standard balance

The usual and customary period-to-date, quarter-to-date, or year-to-date balance for an account. The standard balance is the sum of an account's opening balance, plus all activity for a specified period, quarter, or year. Unlike an average balance, no additional computations are needed to arrive at the standard balance.

standard entry

A recurring journal entry whose amount is the same each accounting period. For example, you might define a standard entry for fixed accruals, such as rent, interest, and audit fees.

Standard Request Submission

A standard interface in Oracle Applications in which you run and monitor your application's reports and other processes.

STAT

The statistical currency Oracle General Ledger uses for maintaining statistical balances. If you enter a statistical transaction using the STAT currency, Oracle General Ledger will not convert your transaction amounts.

statistical journal entry

A journal entry in which you enter nonfinancial information such as headcount, production units, and sales units.

statistics

Accounting information (other than currency amounts) you use to manage your business operations. With General Ledger, you can maintain budget and actual statistics and use these statistics with budget rules and formulas.

status line

A status line appearing below the message line of a root window that displays status information about the current window or field. A status line can contain the following: ^ or v symbols indicate previous records before or additional records following the current record in the current block; Enter Query indicates that the current block is in Enter Query mode, so you can specify search criteria for a query; Count indicates how many records were retrieved or displayed by a query (this number increases with each new record you access but does not decrease when you return to a prior record); the <Insert> indicator or lamp informs you that the current window is in insert character mode; and the <List> lamp appears when a list of values is available for the current field.

step-down allocation

An allocation upon which you run another allocation. For example, you might allocate parent fund overhead to operating funds based on revenues. You can then use a step-down allocation to allocate overhead to organizations within the operating funds based on headcount.

summary account

An account whose balance represents the sum of other account balances. You can use summary accounts for faster reporting and inquiry as well as in formulas and allocations.

T

tablespace

The area in which an Oracle7 database is divided to hold tables.

tax authority

A governmental entity which collects taxes on goods and services purchased by a customer from a supplier. In some countries, there are many authorities (e.g. state, local and federal governments in the U.S.), while in others there may be only one. Each authority may charge a different tax rate. Within General Ledger tax authority consists of all components of your tax structure. For example: (California.San Mateo.Redwood Shores) for (State.County.City) General Ledger adds together the tax rates for all of these locations to determine a customer's total tax liability.

tax codes

Codes to which you assign sales tax or value-added tax rates. Oracle Receivables lets you choose state codes as the tax code when you define sales tax rates for the United States. (Receivables QuickCode)

tax engine

A collection of programs, user defined system parameters, and hierarchical flows used by General Ledger to calculate tax.

tax exempt

A customer, business purpose, or item free from tax charges.

Tax Identification Number

In the United States, the number used to identify 1099 suppliers. If a 1099 supplier is an individual, the Tax Identification Number is the supplier's social security number. If a 1099 supplier is a corporation, the Tax Identification Number is also known as the Federal Identification Number.

tax location

A specific tax location within your tax authority. For example 'Redwood Shores' is a tax location in the Tax Authority (California.San Mateo.Redwood Shores).

tax type

An General Ledger feature you use to indicate the type of tax charged by a tax authority when you define tax name. General Ledger uses the tax type during invoice entry to determine the financial impact of the tax. When you enter a tax of type Sales, General Ledger creates a separate invoice distribution line for the tax amount. When you enter a tax of type Use, General Ledger does not create the invoice distribution line.

template

A pattern that General Ledger uses to create and maintain summary accounts. For each template you specify, General Ledger automatically creates the appropriate summary accounts.

Time dimension

An Oracle Financial Analyzer dimension whose values represent time periods. A time period can be a month, quarter, or year. The length of the Time dimension's values is determined by the Width option on the Maintain Dimension window.

translation

See revaluation.

foreign currency translation.

U

use tax

A tax which you pay directly to a tax authority instead of to the supplier. Suppliers do not include use tax on their invoices. You sometimes owe use tax for goods or services you purchased outside of, but consumed (used) within the territory of a tax authority. Use taxes are liabilities to the buyer of goods and services. You can define a tax name for use taxes. When you enter a use tax name on an invoice, General Ledger does not create an invoice distribution or general ledger journal entry for the tax.

V

value

Data you enter in a parameter. A value can be a date, a name, or a code, depending on the parameter.

value set

A group of values and related attributes you assign to an account segment or to a descriptive flexfield segment. Values in each value set have the same maximum length, validation type, alphanumeric option, and so on.

value-added tax (VAT)

A tax on the supply of goods and services paid for by the consumer, but collected at each stage of the production and distribution chain. The collection and payment of value-added tax amounts is usually reported to tax authorities on a quarterly basis and is not included in the revenue or expense of a company. With General Ledger you control the tax names on which you report and the reference information you want to record. You can also request period-to-date value-added tax reports.

variable

An Oracle Financial Analyzer database object that holds raw data. Data can be numerical, such as sales or expense data, or textual, such as descriptive labels for products.

variable text

Variable text is used when dialog boxes or their components are unlabeled or have labels that change dynamically based on their current context. The wording of variable text does not exactly match what you see on your screen.

voucher number

A number used as a record of a business transaction. A voucher number may be used to review invoice information, in which case it serves as a unique reference to a single invoice.

W

warrant

An order drawn by a legislative body or an officer of the government upon its treasurer, directing the treasurer to pay a specified amount of money to the person named or to the bearer. A warrant may be payable upon demand, in which case it circulates the same as a bank check, or it may be payable only out of certain revenues when and if received, in which case it does not circulate as freely.

weighted-average exchange rate

An exchange rate that General Ledger automatically calculates by multiplying journal amounts for an account by the translation rate that applies to each journal amount. You choose whether the rate that applies to each journal amount is based on the inverse of the daily conversation rate or on an exception rate you enter manually. General Ledger uses the weighted-average rate, instead of the period-end, average, or historical rates, to translate balances for accounts assigned a weighted-average rate type.

add

About Me

Monday, March 18

Oracle Application Key words

A

B

C

D

E

F

G

I

J

K

M

N

O

P

Q

R

S

T

U

V

W

No comments:

Topics

Page Rank

Restricted to Copy