oracle r12 gl interview quetions

8/11/2019 Oracle r12 GL Interview Quetions

1/24

Sep

6

General ledger R12 interview question

General Ledger

1. What are the key functions provided by GL?

General Accounting Budgeting

Multiple Currencies Inter-company Accounting

Cost Accounting Consolidation

Financial Reporting

2. What are the three types tables available in Oracle Applictions?

Master Table: Store Static data,. This is shared with in each module as well as across all

of the Oracle financial application modules ex. ACCOUNTS, SUPPLIER, CUSTOMER etc.

Setup Table: it store setup data. That is never shared between applications such

as application parameters and LOOK UP tables.

Transaction Tables: these tables stores day-to-day transaction data such as payables invoices,

journal entries etc.

3. What are the Oracle General Ledger Setups?

1. Chart of Accounts

2. Account combinations (o)3. Period types

4. Accounting Calendar

5. Transaction Calendar (o)

6. Currencies

7. Set of Books

8. Assign set of books

9. Currency exchange rate types

10. Currency exchange rates

11. Journal Sources (o)

12. Journal Categories (o)

13. Suspense Accounts (o)

14. Inter-Company Accounts (o)

15. Summary Accounts

16. Statistical Units measures (o)

17. Historical Currency Exchange Rates

18. Document sequences (o)

19. Automatic Posting (o)

20. Encumbrance Types (o)

21. Concurrent program Controls (o)

22. Storage Parameters (o)

23. Budgetary Control Groups

24. Profile options

25. Descriptive Flexfileds

26. Open and Close Accting periods

4. Chart Of accounts: A Chart of Accounts is the account structure we use to record accounting transactions and maintain accounting balances. It is a key flex

field.

5. Flex Fied: A Flex Field is a combination of one or more data segments defined by the user. For Chart of accounts, we configure up to 30 segments in a flexfield

and min is 2.

Descriptive Flexfield: We can store the additional Information in customized form or existing form.

6. Value Set: value set defines the valid values for each segment of our Chart of Accounts. There are 6 validations types 1. Dependent 2. Independent 3.none 4.

Pair 5 special 6. Table

INDEPENDENT: An independent value set provides a pre-defined list of values for a segment.

DEPENDENT: A dependent value set is similer to independent value set, or dependent value set depends on any independent or dependent value set.

TABLE: Table provides list of values like an independent set. But values will stored in application table.

NONE: No restrictions.

7.Transactions: Exchange of goods and services with the intension of earning
http://oraclefunctionalsurendra.blogspot.com/2012/09/general-ledger-r12-interview-question.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/general-ledger-r12-interview-question.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/general-ledger-r12-interview-question.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/general-ledger-r12-interview-question.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/general-ledger-r12-interview-question.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/general-ledger-r12-interview-question.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/general-ledger-r12-interview-question.html


2/24

8.What is a Qualifier?

Qualifier is a behavior of a segment.

9. Flex field Qualifiers

Companies ---------- Balancing segment

Departments ----------Cost Centers Segment

Accounts ----------Natural Accounts Segment.

10. What are the format types available in Values sets? Character, date, date time, number, std date, std date time,. Time.

11. What are Accounting Qualifiers?

Allow budgeting

Allow positing

Account type

Control Account

Reconsiliation flag

12. Security Rules:

These are used to limit access to certain segment values for a particular segment.

13. Cross Validation Rules:

These rules validate data across segments of a flex field.

14. Types of Calender:

Normal: January to Dec.

Fiscal: April to march.

15. Period Types:

Daily, Month, Quarter, Year.

16. Accounting Calender:

It is used to define the no. Of periods in the calendar year. Our calendar can contain both adjusting and non-adjusting accounting periods.

17. Transaction Calender:

It is used to define the business days of an organanization.

18. Types of Currency:

Functional currency: The currency we define in our SOB.

Foreign currency

19. S.O.B:

Put together information is called as Sets Of Books. It consists of Cart of Accounts, Currency, Calender and Six mandatory Accounts.

20. What are Mandatory Accounts:

Mandatory Account

Usage

Acct Type

Retained EarningsLast Year closing balances C/F (carry forward) to current year balance

Ownership

Translation Adj Acct

When the currency conversion takes place the difference amt is stored in this acct

Asset/liability

Suspense Account

The variation of credit and debit amounts is suspense acct

Asset/liability

Rounding Difference Acct

The difference amt after rounding the amount is posted to this account.

Expense/Revenue

Net Income Acct

Surplus of profit and loss account.

Ownership

No budget and No posting

Reserve for Encumbrance

Planning for reserving some amount(budget)

ownership

21. States of Periods.

Open, Close, Future Entry, Permanently closed.

22. What is Journal?

A journal is a form in which we enter the business transactions.

23. What are the Balance Types?

Acutal, Budget, Encumbrance.

24. Categories of Journals.

Batch Journal.


3/24

Source Journal

Statistical Journal

Suspense Journal

Encumbrance Journal

Reverse Journal

Tax Journal

Recurring Journal

Standard Recurring Journal.

Formula Recurring Journal. Skelton Recurring Journal.

25. Batch Journal:

A group of common journals is called as a Batch

26. Source Journal:

A source journal is a journal where we can get the journal information from other modules.

27. Statistical Journal:

Statistical journal entries do not require balanced debit and credits. Here we use ratios to calculate amounts.

28. Suspense Journal:

When the debit amount and credit amount are not equal in the journal entry then the deficit amount is added to suspense account and such types of

journals are called as suspense journals.

29 Encumbrance Journal:

For funding budgets we have to enter the encumberance journals. Using this amount we can perform the actual expenses. The part of the budget we

reserve is called as reserve for encumberance. The journals involving this budget are called as encumbrance journals.

30. Reverse Journal:

We cannot alter the posted journals. We can only post additional journals which contain reverse to that of credit and debit amounts of the original journal.

This types of method is called as reverse journal.

31. Tax Journal:

The tax journals will calculate the tax on the credit and debit amounts in the journal depending on the tax information.

32. Inter-company Journal:

If multiple companies in our enterprise share the same SOB then we can automatically balance inter-company journals. Here we define intercompnay

accounts for different combinations of sources, category and balancing segment value.

32. Recurring Journals:

Journals which will be repeated automatically are called as Recurring journals.

The advantage of recurring journal is one journal can be posted in each and every month without creating each and every time.

There are three types of recurring journals.

Standard R.J: Where we know the fixed amount and account information.

Formula R.J: Here we may or may not know the actual information. We calculate the amounts depending on a formula. In formula block first field should be enter

Skelton Journal: It is raised when we know only account information but not amount information.

Control Total:

This is used to raise the journal with a fixed amount. The error message is not displayed at the saving time but it is displayed while posting the journal.

33. Mass Allocation (Allocation journal):

Mass allocation is used to avoid the repeating entry of journals for different departments and it considers only actual accounts.

(Or) When we are trying to allocate an amount for a period for a combination of segment values is called as Mass Allocation.

Mass allocation formula:

Cost pool * usage factor/total usage factor

Summary Accounts:

Summary accounts store balances of multiple accounts. We need summary template to define a summary account.

Roll up groups:

A roll up group is a collection of parent values for a given segment. This is used to provide a condition to the template.

Amount types:

PTD (period-to-date) YTD (year-to-date)

PJTD (project-to-date) QTD (Quarter-to-Date)

Financial Statement Generator A powerful and flexible report building tool for Oracle General Ledger. You can design and generate fiancial reports, apply security

rules to control access to data via reports, and use specific features to improve reporting productivity.

Budget

It is one of the management tool by using which we can estimate the amounts for a specific range of periods for an organization.

Each budget can have maximum of 60 periods.

Budget can have any one of the following states

Current (the first budget we define in our sob)

Open (To activate a budget)

Frozen (to deactivate or close a budget)

For using budgets we have to define a budget and a budget organization.

Budget Types:

Planning Budget:

We can just plan but we cannot raise journal entries.


4/24

We can convert it into funding budget by enabling Required Budget Journal option.

Fund check levels are: none, advisory, absolute.

Funding Budget:

This is the actual budget. Once the budget is approved, the organization can start spending the budget amount for various expenses.

Budget Journals:

It is a combination of budget organization and budget. These offer an alternative way to enter budget amounts, and they assist in maintaining audit trials.

Budget Formulas

We can also enter budget amounts by using budget formulas. Budget formulas similar to recurring formulas for actual amounts. To use budget

formulas we must first define the budget formula and generate it

ALLOCATED AMOUNT=COSTPOOL * USAGE FACTOR/TOTAL USAGE

Cost pool: the total budget amount that has to be allocated to the child values in organizations

Usage Factor: to allocate the budget amount to the child values the ratio by which you are going to distribute the cost pool amount.

TOTAL USAGE: the total ratio of usage factor would be the total usage.

Currency Translations:

Types of Rates:

Period rates, Liability rate, Historical Rate.

Foreign to functional:

Revaluation: Within the company.

Consolidation: Multiple companies

Functional to Foreign:

Translation: within the company

Mrc: Multiple companies.

Translation amd MRC will not affect the actual balances but revaluation and consolidation affects the actual balances.

Translation:

1. This is only for reporting purpose. It does not effect the actual balances

2. It is used for converting functional currency to foreign within the single company.

3. This is used for subsidiary corporations and we cannot perform for the first period of a calendar.

Revaluation:

1. This effects on the actual balances.2. Before and after periods should be open.

Consolidation:

1. This is used when the chart of accts differs between each other.

2. This will effect the actual balances.

3. The chart of accts and currency may be same or different but the period(calendar) must be same.

4. Two typs of consolidation: Global Consolidation, Normal consolidation.

MRC

1. This is used for converting functional transactions to foreign currency for reporting purpose.

2. The CoA and calendar can be same but the currencies should be different.

3. This allows us to maintain accounting transactions in more than one functional currency.

Multi-Org:

Single installation of multiple operating units is called Multi-Org.

Flow of Multi-Org:

Business Group.

Set of Books.

Location.

Hr Organization.

Legal Entity

Operating Unit.

Inventory.

Posted 6th September 2012 bySurendra Patel

0

Add a comment

Add a comment

Load more
http://www.blogger.com/profile/14269676533824440126http://www.blogger.com/profile/14269676533824440126http://www.blogger.com/profile/14269676533824440126http://www.blogger.com/profile/14269676533824440126


5/24

Oracle Functional by Surendra

Classic

Classic

Flipcard

Magazine

Mosaic

Sidebar

Snapshot

Timeslide

Home

1.

Sep28

Oracle Payables (AP) Functional Interview Questions

Oracle Payables (AP) Functional Interview Questions

Still in progress.....

1) Invoices vs Invoice Batches

2) Type of Invoices supported by Oracle Payables

3) Number of Tabs in Invoice Entry screen and what are they?

There are 5 Tabs

4) Where is the method of Supplier Number set? At what level is the supplier numbering controlled?

5) What are the various statuses of invoices?

6) How many key flexfileds are there in Payables

Payables doesn't have any key flexfield

7) What are AP Accounting periods? How are they different from GL periods? Are there adjusting periods in AP?

8) Can a partial payment of Prepayment be done?

9) Can you hold partial payments? And how can that be achieved?

10) How can the Invoice distributions' which can be transferred to Fixed Assets be identified in AP? Is there is any field explains/indicates the same?

11) When you return goods to supplier (RTS) whether system created Debit Memo or Credit Memo? And what is the set-up required for the system to

create the relevant document automatically?

12) What does Accrual mean?

13) An invoice is entered, validated and accounted. And thereafter, the invoice is cancelled; what will be the accounting status?

14) What is the Debit Memo and Credit Memo?

15) What are the invoice interface tables in AP?

16) Can you explain 2-way, 3-way and 4-way matching?

17) What is a Payable document?
http://oraclefunctionalsurendra.blogspot.in/http://oraclefunctionalsurendra.blogspot.in/?view=classichttp://oraclefunctionalsurendra.blogspot.in/?view=flipcardhttp://oraclefunctionalsurendra.blogspot.in/?view=magazinehttp://oraclefunctionalsurendra.blogspot.in/?view=mosaichttp://oraclefunctionalsurendra.blogspot.in/?view=sidebarhttp://oraclefunctionalsurendra.blogspot.in/?view=snapshothttp://oraclefunctionalsurendra.blogspot.in/?view=timeslidehttp://oraclefunctionalsurendra.blogspot.in/http://oraclefunctionalsurendra.blogspot.com/2012/09/oracle-payables-ap-functional-interview.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/oracle-payables-ap-functional-interview.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/oracle-payables-ap-functional-interview.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/oracle-payables-ap-functional-interview.htmlhttp://oraclefunctionalsurendra.blogspot.in/http://oraclefunctionalsurendra.blogspot.in/?view=classichttp://oraclefunctionalsurendra.blogspot.in/?view=flipcardhttp://oraclefunctionalsurendra.blogspot.in/?view=magazinehttp://oraclefunctionalsurendra.blogspot.in/?view=mosaichttp://oraclefunctionalsurendra.blogspot.in/?view=sidebarhttp://oraclefunctionalsurendra.blogspot.in/?view=snapshothttp://oraclefunctionalsurendra.blogspot.in/?view=timeslidehttp://oraclefunctionalsurendra.blogspot.in/http://oraclefunctionalsurendra.blogspot.com/2012/09/oracle-payables-ap-functional-interview.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/oracle-payables-ap-functional-interview.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/oracle-payables-ap-functional-interview.html


6/24

18) How can we link an Employee to Supplier?

19) Can you explain the concept of Automatic Offset in Payables? And how is this different from Autoaccounting in AR?

20) How can a range of Document numbers be voided in one go ?

21) Can two users use same payable document simultaneously? If yes, which user will get the document number assigned first?

22) What are the various statuses of payment batch?

25) Explain the concept of the ERS. Also give relevant set-ups and programs related to it.

Answer Evaluated Receipt Settlement (ERS) also referred to as 'Pay on Receipt'. While defining supplier site in Purchasing tab, the "Pay on" field

should be 'Receipt'.

26) Can the payment date be before invoice date?

27) Can accounting of Payment be done before accounting invoice?

28) Explain the concept of Proxima payment terms.

29) What are the various type of Distribution sets? And what is thier purpose?

30) Can an invoice be accounted if there are holds applicable to the invoice?

Answer Yes! An invoice can be accounted even if the holds are applied against it provided, Accounting Allowed check-box is enabled while defining

the Invoice Hold.

31) Can an Invoice in INR be paid in USD currency? What are the alternatives available?

32) Can multiple currency payments be done using same bank account? If yes, what are the relevant set-ups required?

33) Can PO level DFF be transferred to AP Invoice? Any set-ups are required for the same?

34) What is the name of program which is used to transfer accounting entries from AP to GL and what are the options available during submitting the

program?

35) Explain the concept of withholding tax along with relevant set-ups.

36) Which expense report templates are available in iExpense Modules?

Answer All those Expense Report Templates are available in iExpenses modules for raising Expense Reports for which "Enable for Internet Expenses"

is enabled.

37) What is the name of the program used to import expense reports into AP? And what are the tables from where the expense reports are imported?

Answer The name of the concurrent program is "Expense Report Import". The tables where expense reports are maintained areAP_EXPENSE_REPORT_HEADERS and AP_EXPENSE_REPORT_LINES

38) Can the same Invoice Number be entered for two different suppliers in Payables?

Answer The invoice number should be unique for a given supplier; hence, the same Invoice Number can be used by multiple suppliers

39) Control of Payables (AP) periods is at what level? At Operating Unit?

Answer Though Payables (AP) operates at Operating Unit level, the control of period is at set of books level.

40) Can the same bank account be assigned to multiple suppliers? What is the alternative if same bank account is to be shared across multiple

suppliers (e.g. part of same group)?

Answer While defining Internal bank accounts, "Allow Assignment to Multiple Suppliers" check-box should be enabled.

41) What is "Zero Payment"? And what are the set-ups required to make a Zero Payment? Is it possible to ensure that only zero payments are allowed

using a payable document?

Answer While defining Bank Accounts, in Payable Options tab "Allow Zero Payments" check-box to be enabled. To ensure that only zero payments are

allowed using a payable document, attach a payment format to the same which has "Zero Amount Payments Only" check-box enabled.

42) A supplier is available in Invoice Inquiry; however, the supplier is not available while entering Invoices. What are the possible reasons for the

same?

Answer The possible for the unavailability of supplier are

- The 'Pay' check-box at supplier site (General tab) is disabled

- 'Inactive On' date is entered at the supplier site level i.e. supplier site is end-dated.

43) While doing future dated payments, is the future dated payment account at the supplier site used?

Answer It depends on the Payable Options's Accounting tab. There we have option to select whether the future dated payments account should be

selected either from Supplier site or Payable documents.


7/24

44) When the 'Payment Method' at invoice level is given as 'Electronic', sytem requires some additional details? What are they?

Answer When the 'Payment Method' is selected as 'Electronic' system additionally requires a Bank account in the invoice currency to be assigned to

the supplier.

45) If there is a requirement that for specific supplier, each invoice should be paid by a separate check? Can that be achieved? If yes, how?

Answer While defining supplier site in the Payments tab, the "Pay Alone" need to be checked so that each invoice is paid by a separate check.

46) Let us assume that a check issued to supplier has become time-barred. And supplier returns it requesting for a new check. Can the existing checkbe voided and a new check be issued simultaneously?

Answer

47) Can the payment date be before the system date i.e, is it possible to issue back-dated checks?

Answer

48) While defining payable documents, document number is given as 1 to 4999. And an user has issued checks till 4999. What happens when 5000th

check is being created using the same payable document?

Answer

49) Can you create an Invoice in USD, while the Standard PO has been created in EUR?


0

Add a comment

2.

Sep21

GL Profile Options

GL Profile Options.

Budgetary Control Group

Assign budgetary control groups when you enable budgetary control for your ledger. Budgetary control groups include a set of options which are used

to enforce budgetary control based on combinations of journal entry source and category. You can also define budgetary control options for the detail

and summary accounts for which you want to enforce budgetary control.

You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility or

user level.

Daily Rates Window: Enforce Inverse Relationship During EntryUse this profile option to specify whether to enforce the automatic calculation of inverse exchange rates in the Daily Rates window. When the profile

option is set to Yes and you enter a daily rate to convert currency A to currency B, General Ledger automatically calculates the inverse rate (currency

B to A) and enters it in the adjacent column. If either rate is changed General Ledger automatically recalculates the other.

You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application or responsibility

level.

Enter Journals: Validate Reference Date

This profile option controls whether the reference date is validated using Italian Libro Giornale rules. If this profile option is set to Yes, the value

entered in the Reference Date field will be validated to ensure the date falls into an open or future enterable period.

The following values are available:

Yes: Reference date is validated.

No: Reference date is not validated.

The default value for this profile option is No.

You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility level,

or user level.

FSG: Accounting Flexfield

Choose the General Ledger application reporting flexfield. For your General Ledger application, select the natural account as your reporting flexfield.

The default value for this profile option is account.

You cannot view this profile option at the user level. Your System Administrator must set this profile option at the site or application level.

FSG: Allow Portrait Print Style

Control the print orientation of your Financial Statement Generator reports that are less than or equal to 80 characters wide. You can print these

reports in either portrait style (80 character wide) or landscape style (132 character wide). The following values are available to you:

Yes: Your General Ledger application prints reports that are less than or equal to 80 characters wide in portrait (80 character wide).

No: Your General Ledger application prints reports that are less than or equal to 80 characters wide in landscape (132 character wide).

If this profile option is not enabled, or your reports are more than 80 characters wide, your General Ledger application produces landscape style (132
http://www.blogger.com/profile/14269676533824440126http://www.blogger.com/profile/14269676533824440126http://www.blogger.com/profile/14269676533824440126http://oraclefunctionalsurendra.blogspot.com/2012/09/gl-profile-options.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/gl-profile-options.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/gl-profile-options.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/gl-profile-options.htmlhttp://www.blogger.com/profile/14269676533824440126http://oraclefunctionalsurendra.blogspot.com/2012/09/gl-profile-options.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/gl-profile-options.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/gl-profile-options.html


8/24

character wide) or landwide style (180 character wide) reports, depending on the report character width.

You can set this profile option at the user level. Or, your System Administrator can set this profile option at the site, application, responsibility or user

level.

FSG: Enable Search Optimization

Enable this profile option to enhance the performance of FSG reports that include a large number of parent values, where each parent value contains

a large number of child values. This profile option optimizes the search process for detail child values associated with each parent account value to

allow the FSG reports to run faster.

The following values are available to you:Yes: The FSG Performance Enhancement is applied.

No: The FSG Performance Enhancement is not applied.

You can set this profile option at the Site, Application, Responsibility, and User levels.

FSG: Enforce Segment Value Security

Control whether your defined security rules will apply to reports produced using FSG. The following values are available to you:

Yes: If security rules are defined that prevent you from accessing specific account segment values, then you cannot produce financial information for

those same segment values when you run FSG reports. For example, if you are excluded from using any accounts for cost centers 100 and 200, then

any balances for those same accounts will not appear on any FSG reports you run.

Note: If the profile option is set to Yes and the segment is independent, the security rule applies. If the profile option is set to Yes and the segment is

dependent, the security rule does not apply.

No: Defined security rules are not used for FSG reporting purposes.

You cannot view this profile option. Your System Administrator can set this profile option at the site, application, responsibility, or user level.

FSG: Expand Parent Value

Control the expansion of parent values when requesting summary balances. The following values are available to you:

Yes: FSG uses the rollup group to determine whether to expand a parent value into its child ranges. If the parent value belongs to a rollup group, FSG

does not expand the parent value into its child ranges. If the parent value does not belong to a rollup group, FSG expands the parent value into its

child ranges.

No: FSG uses the summary flag associated with the flexfield assignment to determine whether to expand a parent value into its child ranges. If the

summary flag is set to Yes, FSG does not expand the parent value into its child ranges. If the summary flag is set to No, FSG expands the parent

value into its child ranges.



level.

FSG: Message Detail

Specify the level of detail in your error message log file when you request your Financial Statement Generator reports. Your General Ledger

application divides error messages into the following three catalogs:

Catalog I: contains all detail memory figures, detail timings, and SQL statements which are useful for program debugging.

Catalog II: contains all file and function names, and all messages which give process information. This is useful for finding out where a process failed.

Catalog III: contains only error messages and other important messages, and therefore gives the least amount of information for program debugging.

You specify the level of detail for your error message log file by setting this profile option to one of the following values:None: No messages.

Minimal: Catalog III messages.

Normal: Catalog II and III messages.

Full: Catalog I, II, and III messages.

The default value for this profile option is Minimal.


level.

GL Account Analysis Report: Enable Segment Value Security on Beginning/Ending Balances

This profile option applies segment value security rules to the beginning and ending balances of the following Account Analysis reports:

Account Analysis - (132 Char)

Account Analysis (180 Char)

Account Analysis - Foreign Currency (132 Char)

Account Analysis - Foreign Currency (180 Char)

The following values are available:

No: Segment Value Security rules will only apply to the period activity, not the beginning and ending balances of the reports listed above. Thus, the

above reports will display the beginning and ending balances for any secured segment values, but hide the period activity from view.

YES: Segment Value Security rules will be applied to both the period activity and the beginning and ending balances of the reports listed above.


The System Administrator must enable the user view of this profile option and set this profile option at the site, application, or responsibility level.

GL AHM: Allow User to Modify Hierarchy

Specify whether users can use the Account Hierarchy Manager to modify and save account hierarchies.

Yes: Users can modify and save account hierarchies.

No: Users cannot modify and save account hierarchies. Users will have read-only access to view account hierarchies.


You can view this profile option at the site, application, responsibility, and user levels. This profile option can be set at the site, application,


9/24

responsibility, and user levels.

GL AutoAllocation: Continue to Next Step if No Journal Created

Specify whether a Step-Down AutoAllocation process stops or continues to the next step if a journal batch is not generated by the previous step in the

AutoAllocation set.

For example, assume a journal batch is not created because a step in a Step-Down AutoAllocation Set processes an account with no activity. In this

case, the Step-Down AutoAllocation process stops when the profile option is set to No, or continues to the next step when set to Yes.

The following options are available:

Yes: The Step-Down AutoAllocation process will continue to the next step.No: The Step-Down AutoAllocation process will not continue to the next step.


This profile option can be set at the site, application, responsibility, and user levels.

GL Consolidation: Cross Instance Workflow Notification Contact

When a cross instance data transfer is complete, this profile option allows you to activate a workflow process that sends an e-mail containing transfer

results to a designated user on the target instance.

In the System Profile Values window in the source instance, query this profile option then enter a user name in the Responsibility, Application, or Site

fields.

Ensure the user you defined has an e-mail address entered in the Users window on the target instance.

The default value for this profile option has no user defined.

You can set this profile option at the responsibility, application, or site level.

GL Consolidation: Preserve Journal Batching

Background: This profile option complements the Global Accounting Dual Posting solution by allowing you to preserve journal details transferred from

the source ledger to the target ledger during consolidation.

This profile option can also work in conjunction with the profile options GL Consolidation: Exclude Journal Category During Transfer and GL

Consolidation: Preserve Journal Effective Date.

Set this profile option to Yes to:

Retain originating journal and batch groupings from the source ledger to the target ledger.

Preserve up to 50 characters of the original batch name plus batch ID in the source ledger to the target ledger.

Preserve up to 25 characters of the original journal name and journal ID from the source ledger to the target ledger.

Retain the batch and journal header descriptions from the source ledger to the target ledger.

Preserve the category name of the journal in the source ledger to the journal in the target ledger.

Preserve the Reference Date entered in the Journals window.


The System Administrator must set this profile option at the Site or Responsibility level. If you set the profile option at the responsibility level to

preserve the journal batches and header details, that responsibility must be the same responsibility from which you initiate the consolidation transfer.

GL Consolidation: Preserve Journal Effective Date

This profile option instructs General Ledger how to handle the effective date of the consolidation journal generated under the Transaction method of

consolidation.

The following options are available:Yes: The effective date of the individual journal being consolidated will be preserved in the generated consolidation journal. This profile option setting

has to be used in conjunction with the profile option GL Consolidation: Preserve Journal Batching. This second profile must also be set to Yes to

preserve the consolidation journal effective date.

No: The effective date of the generated consolidation journal is based on the target consolidation period for the parent ledger.


The System Administrator must set this profile option at the Site or Responsibility level. If you set the profile option at the responsibility level to

preserve the journal batches and header details, that responsibility must be the same responsibility from which you initiate the consolidation transfer.

GL Consolidation: Separate Rows for Debit and Credit Account Balances in Consolidation Journal

This profile option controls whether a consolidation or elimination journal is created with the debit and credit account balances in separate journal

lines, or with the debit and credit account balances in a single journal line.

Consolidation program and Elimination program will generate journals with separate lines for debit and credit account balances if the profile option is

set to Yes. When the profile option has no value, or if the value is set to No, then the journals that are generated by the respective programs may

contain lines that have both debit and credit balances.


Your System Administrator must set this profile option at the site or responsibility level.

GL Daily Rates: Cross Rates Override

The GL Daily Rates: Cross Rates Override profile option governs the behavior of generated cross rates according to the table below.

GL Daily Rates: Cross Rates Override profile option

Value

Insert/Update

Delete

User Entered Rate Overrides

A user-entered rate can override a system generated rate, if one already exists.

System generated cross rates can be deleted by the user.


10/24

System Generated Rate Overrides

System generated rate can override a user entered rate, if one already exists.

User defined rates that fall within the cross rate definition set may be deleted by the cross rate generation program. System generated rates cannot be

deleted by the user.

No Overrides

The first defined rate, whether it be user entered or system generated, remains.

System generated cross rates are never deleted but overwritten by the same method used to create the cross rates. User can delete user created

rates.

The default value for this profile option is User Entered Rate Overrides.The system administrator must set this profile option at the site, application, responsibility, or user levels.

GL Journal Import: Separate Journals by Accounting Date

Specify how Journal Import will group journal lines by accounting date. The following values are available to you:

Yes: Journal Import will always place journal lines with different accounting dates into separate journals.

No: Journals Import will group all journal lines with different accounting dates that fall into the same period into the same journal, unless average

balancing processing is enabled for the ledger.


You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility, or

user level.

GL Ledger ID

This profile option displays the current Ledger ID of the ledger that is assigned to the GL Ledger Name profile option when you are in the System

Administrator responsibility.

You cannot change the value of this profile option. Instead, you set the profile option GL Ledger Name and the system automatically determines and

displays the value for GL Ledger ID.

GL Ledger Name

If using Oracle Subledgers whose menus contain General Ledger windows that require data access set information, you must assign the appropriate

ledger to this profile option for each subledger application or responsibility. This profile option controls the ledger that each subledger will use for

transaction processing.

The ledger assigned to the GL Ledger Name profile option will automatically be assigned to the GL: Data Access Set profile option. You can change

the default assignment made to the GL: Data Access Set profile option if you want to access more ledgers in General Ledger. However, any changes

made to the GL Ledger Name profile option will automatically be applied to the GL: Data Access Set profile option.

You cannot view this profile option at the user level. Your System Administrator can set this profile option at the site, application or responsibility level.

GL Revaluation: Days to Roll Forward Daily Rates

If a revaluation rate is not defined for a specified revaluation rate date, the revaluation program will search prior days to find a rate, up to the value set

for this profile option. The revaluation process completes with a warning and the rate used is listed on the Revaluation Execution report. This setting

affects all currencies.

The default value for this profile option is 0. If, for example, you want the revaluation program to search up to 5 days prior to find a revaluation rate, set

this profile option to 5. There is no maximum value.

You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, or responsibilitylevel.

GL Revaluation: Tracking by Cost Center

This profile option determines whether the Revaluation process balances unrealized gain/loss using the balancing segment only, or using both the

balancing and cost center segments.

If you set this profile option to Yes, you must assign the cost center segment qualifier to an accounting segment.


You can view this profile option at the User level. Your System Administrator can set this profile option at the site, application, or responsibility level.

GL Revaluation: Use Primary Currency from Source Ledger to Create Entries in Reporting Currency

Specify the method of revaluation for the reporting currency. The following values are available to you:

Yes: The Revaluation program will use the source ledger currency balances to create revaluation entries for the reporting currency.

No: The Revaluation program will use the source ledger's entered currency balances to create the revaluation entries for the reporting currency.


You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, or responsibility

level.

GL Summarization: Accounts Processed at a Time per Delete Worker

This profile option allows you to specify the number of accounts that should be processed by each worker process when you delete summary

templates. For more information on setting the number of delete workers, see GL Summarization: Number of Delete Workers Required.

Example: you define 3 delete workers and specify 5,000 to have 5,000 accounts processed per delete worker. You then delete a summary template

involving 20,000 accounts. Each worker will process 5,000 accounts in parallel. The first worker to complete processing will process the last group of

5,000 accounts.

The default value for this profile option is 5,000.


GL Summarization: Number of Delete Workers Required


11/24

This profile option improves system performance when deleting summary templates. Rather than process records sequentially, this profile option

enables General Ledger to process summary templates in parallel. Specify the number of parallel processes you want by specifying a value from 1 to

30.

The default value for this profile option is 3.


GL Summarization: Rows Deleted Per Commit

This profile option allows you to control how many rows are deleted in a balance table per worker when you delete a summary template. This setting

impacts your ability to rollback the affected data should the delete process fail.Example: You specify 3 workers to delete a summary template involving 60,000 rows. You specify each worker to process 5,000 accounts at a time

and 2,500 rows deleted per commit. Should your delete process fail, these rows are not deleted.


GL Translation: Revenue/Expense Translation Rule

This profile option lets you specify the translation method you want to use when translating revenue and expense accounts. The default setting is PTD.

For more information, see: Translating Balances.

PTD: The Period-to-Date translation method is used.

YTD: The Year-to-Date translation method is used.


level.

GL: Archive Journal Import Data

Specify whether you want Journal Import to save your journal import data from the GL INTERFACE table to the GL INTERFACE HISTORY table at the

end of each Journal Import run.

The following values are available to you:

Yes:Journal Import will save your journal import data to the GL INTERFACE HISTORY table.

No:Journal Import will not save your journal import data to the GL INTERFACE HISTORY table at the end of each successful journal import run.

Note:If you choose Yes, Journal Import will run slower.


You can view this profile option at the User level. Your System Administrator must set this profile option at the Site, Application, Responsibility, or User

level.

GL: AutoAllocation Rollback Allowed

Specify whether to allow the rollback of an AutoAllocation set. You can only use rollback for GL batches. You cannot use rollback for AutoAllocation

sets that contain Projects batches. The following values are available:

Yes: You can rollback AutoAllocation batches.

No: You cannot rollback AutoAllocation batches.

The default value for this profile option is Yes.

You can view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility, or user

level.

GL: Data Access SetAssign a data access set to a General Ledger responsibility. Data access sets control the ledgers, ledger sets and balancing segment values or

management segment values that can be accessed by a responsibility for general ledger processing.

If you are using Oracle Subledgers, the data access set should include the ledger that is assigned to the GL Ledger Name profile option that controls

ledgers used by subledger applications.

You can view this profile option at the User level. Your System Administrator can set this profile option at the Site, Application, or Responsibility level.

GL: Debug Mode

Allow features in General Ledger to run in Debug Mode where additional messages are detailed in the log file. Debug Mode operates for many

General Ledger features, such as Journal Import, Posting, Translation, Revaluation, Consolidation, Recurring Journals, and Mass Allocation. The

following values are available:

Yes: General Ledger will run in Debug Mode.

No: General Ledger will not run in Debug Mode.


You can view and set this profile option at the Site, Application, Responsibility, or User level.

GL: Income Statement Accounts Revaluation Rule

Use this profile option to select either period-to-date (PTD) or year-to-date (YTD) income statement account balances for revaluation. The following

values are available:

PTD: Only PTD balances will be revalued for income statement accounts.

YTD: Only YTD balances will be revalued for income statement accounts.

The default value for this profile option is YTD.

You can only review this profile option at the user level. Your System Administrator can set this profile option at the site, application, or responsibility

level.

GL: Journal Review Required

Specify whether a Generated Journal Batch within an AutoAllocation set needs to be reviewed (via Oracle Workflow) before posting. The following

values are available:


12/24

Yes: A generated journal batch within an AutoAllocation set must be reviewed before posting.

No: A generated journal batch within an AutoAllocation set does not require review before posting.


You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, or responsibility, or

user level.

GL: Launch AutoReverse After Open Period

This profile option instructs General Ledger to launch the AutoReversal Program when a period is opened. AutoReversal will generate and post (if

selected) all journals assigned a specific category. If you set this profile option to no, you can launch AutoReversal from the Submit Requests window.The following values are available:

Yes:General Ledger launches AutoReversal when a period is open.

No:General Ledger does not launch AutoReversal when a period is opened.

The default value for this profile option is Yes.


level.

GL: Number of Accounts in Memory

This profile option allows you to set the concurrent program controls to improve the performance of the MassAllocation and MassBudget programs.

The more accounts MassAllocations/MassBudgets can hold in memory, the faster the programs will run.

To use this profile option, you should do the following:

1. Run the Optimizer program to create indexes on segments of your account

2. Determine the total amount of main memory that you want to allocate to the programs using the following formula: Size of program (Journal Import

or MassAllocation/MassBudgeting) + Memory used for journal lines held in memory (Journal Import or MassAllocation/MassBudgeting) + Memory

used for accounts held in memory (MassAllocation/MassBudgeting only)

If you do not enter a value for this profile option, the MassAllocation and MassBudget programs will process 2500 accounts at once. You can set this

profile option at the user level. Or, your System Administrator can set this profile option at the site, application, responsibility or user level.

GL: Number of Formulas to Validate for each MassAllocation Batch

This profile option only pertains to ledgers with average balance processing enabled. Use this profile option to specify the number of MassAllocation

formulas that will be pre-validated in the Generate MassAllocation Journals form before the Run MassAllocations program is generated. The number

you set for this profile option controls the number of formulas that will be randomly selected and checked for average balance processing violations,

such as the calculation effective date and average balance usage parameters.

Example: You define a MassAllocation batch that includes six formulas and you specify five for this profile option. When you generate the

MassAllocation batch, five of the six formulas are validated in the Generate form. If violations are found, an error message will appear and the

generation program will not proceed with processing until the violations have been resolved. If they pass validation, then General Ledger will proceed

to generate all of your MassAllocation journals and check for additional invalidations.

The default value for this profile option is 5. Your System Administrator can set this profile option at the site, application, or responsibility level.

GL: Number of Formulas to Validate for each Recurring Journal Batch

This profile option only pertains to ledgers with average balance processing enabled. Use this profile option to specify the number of Recurring Journal

formulas that will be pre-validated in the Generate Recurring Journals form before the Recurring Journal Entry program is generated. The number you

set for this profile option controls the number of formulas that will be randomly selected and checked for average balance processing violations, suchas the calculation effective date and average balance usage parameters.

Example: You define a Recurring Journal batch that includes six formulas and you specify five for this profile option. When you generate the Recurring

Journal batch, five of the six formulas are validated in the Generate form. If violations are found, an error message will appear and the Recurring

Journal Entry program will not be generated until the violations have been resolved. If they pass validation, then General Ledger will proceed to

generate your recurring journals and check for additional invalidations.

The default value for this profile option is 5. Your System Administrator can set this profile option at the site, application, or responsibility level.

GL: Number of Purge Workers

This profile option allows multiple purge processes to run in parallel to speed processing when you have large volumes of journals to purge. If one

parallel purge process fails due to an error, the other processes will continue. You only repeat the purge operation for those processes that failed.

The default value for this profile option is 1.

Set this profile option equal to the number of processes you want to be able to run at the same time.

You can set this profile option at the user level. Or, your System Administrator can set this profile option at the site, application, responsibility, or user

level.

GL: Number of Records to Process at Once

This profile option allows you to set the concurrent program controls to improve the performance of Journal Import, MassAllocations and

MassBudgets. For example, you can speed Journal Import by increasing the number of records (journal lines) it holds in memory. By increasing

concurrent program control values, you increase the amount of memory the Journal Import or MassAllocation/MassBudgeting programs can use,

thereby increasing their throughput.

To use this profile option, you should do the following:

1. Run the Optimizer program to create indexes on segments of your account.

2. Determine the total amount of main memory that you want to allocate to the programs using the following formula: Size of program (Journal Import

or MassAllocation/MassBudgeting) + Memory used for journal lines held in memory (Journal Import or MassAllocation/MassBudgeting) + Memory

used for accounts held in memory (MassAllocation/MassBudgeting only).

If you do not enter a value for this profile option, the Journal Import, MassAllocation and MassBudget programs will process 1000 records at once. You

can set this profile option at the user level. Or, your System Administrator can set this profile option at the site, application, responsibility or user level.


13/24

GL: Owners Equity Translation Rule

Specify the rule General Ledger follows to translate owners' equity accounts when you have not entered specific historical rates or amounts. The

following values are available:

PTD: The Period-to-Date rule is used to translate owners' equity accounts. For each period for which you translate owners' equity accounts, the

historical rate is set to the period-average rate.

YTD: The Year-to-Date rule is used to translate owners' equity accounts. For each period for which you translate owners' equity accounts, the

historical rate is set to the period-end rate.

The default value for this profile option is PTD.You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, or responsibility

level.

Journals: Allow Multiple Exchange Rates

Specify whether you want to allow multiple conversion rates within a journal entry. The following values are available to you:

Yes: You can override the converted amount when you enter journals.

No: You cannot override the converted amount when you enter journals.



level.

Journals: Allow Non-Business Day Transactions

Specify whether you want to allow posting on non-business days. Business and non-business days are defined on the Transaction Calendar. The

following values are available to you:

Yes: You can post transactions on non-business days.

No: You cannot post transactions on non-business days.


user level.

Journals: Allow Preparer Approval

Specify whether preparers can approve their own journal batches. The following values are available to you:

Yes: Preparers are allowed to approve journal batches that fall within their authorization limit.

No: Preparers cannot approve their own journal batches.


You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility or

user level.

Journals: Default Category

Specify the default journal entry category. When you enter manual journal entries, the category will default to the category you specify here.

You can set this profile option at the user level. Your System Administrator can set this profile option at the site, application, responsibility or user level.

Journals: Display Inverse Rate

Specify how you enter and display conversion rates in the Enter Journals window. The following values are available to you:Yes: You can enter and display conversion rates in the ledger currency-to-foreign currency format, that is, the rate by which you multiply a ledger

currency amount to determine the foreign amount.

No: You can enter and display conversion rates in the foreign currency-to-ledger currency format, that is, the rate by which you multiply a foreign

amount to determine the ledger currency amount.



level.

Journals: Enable Prior Period Notification

Specify whether General Ledger should notify you when you are entering a journal for a prior period. The following values are available to you:

Yes: General Ledger will display a message when you are entering a journal for a prior period. You have to confirm that this is what you want to do.

No: General Ledger will not notify you when you enter a prior period journal.


user level.

Journals: Find Approver Method

Specify the default approval method for the Journal Approval process. The following values are available to you:

Go Up Management Chain: The journal batch moves up the approval hierarchy until it has been approved by an approver whose authorization limit is

sufficient to allow approval. The journal batch must be approved by all intermediate approvers as well.

Go Direct: The journal batch is sent directly to the first approver in the approval hierarchy who has an authorization limit high enough to allow approval.

The preparer's direct manager receives a courtesy notice.

One Stop Then Go Direct: The journal batch is first sent to the preparer's manager for approval. If further approvals are required, the journal batch is

sent directly to the first approver in the approval hierarchy who has an authorization limit high enough to allow approval.

The default value for this profile option is Go Up Management Chain.

You cannot view this profile option at the user level. Your System Administrator must set this profile option at the site, application, or responsibility

level.


14/24

Journals: Mix Statistical and Monetary

Choose whether to enable users to enter statistical amounts along with monetary amounts in the Enter Journals window. The following values are

available to you:

Yes: You can enter statistical amounts along with monetary amounts when you enter journals. The window appears only for those accounts for which

you define a statistical unit of measure.

No: You are not able to enter statistical amounts along with monetary amounts in the Enter Journals window.



level.

Journals: Override Reversal Method

Specify whether users can override the default reversal method when they reverse a journal. The default reversal method is specified when you define

journal categories. The following values are available to you:

Yes: Users can change the default reversal method when they are reversing journals.

No: Users cannot change the default reversal method when they are reversing journals.


user level.

Use Performance Module

Specify whether General Ledger concurrent programs will make use of the statistical data collected by the General Ledger Optimizer program to

enhance the performance of some concurrent programs. The concurrent programs affected include Posting, Summarization, MassAllocations,

Consolidation, Year End Carry Forward, Budget Range Assignments and Historical Rates Assignment.

The default value for this profile option is Yes, and we strongly advise you NOT change it unless specifically told by Oracle Customer Support.

Posted 21st September 2012 bySurendra Patel0

Add a comment

3.Sep

13

Oracle Apps Functional Setups General Ledger

Oracle Apps Functional Setups General Ledger

Setup Steps [38]

1. Define Value Sets

2. Define Key Flexfield Segments

3. Define Rollup Groups

4. Define Accounting Flexfield Values

5. Define Cross Validation Rule6. Define Key Flexfield Security Rule and Define Security Rule

7. Define Shorthand Aliases

8. Define Descriptive Flexfields

9. Define Calendar Types

10. Define Calendar

11. Define Currencies

12. Define Set Of Books

13. Multi-Org Setups

14. Assign Key Flexfield Security Rule and Assign Security Rule

15. Define Accounting Flexfield Combinations

16. Define Journal Entry Sources

17. Define Journal Entry Categories

18. Define Suspense Accounts (ONE defined for each SOB, other, other)

19. Define Intercompany Accounts

20. Define Conversion Rate Types

21. Define Daily Exchange Rates22. Define Period Exchange Rates

23. Define Historical Exchange Rates

24. Translate Balances

25. Define Summary Accounts

26. Define Statistical Units of Measure

27. Define Automatic Posting Options

28. Define Concurrent Program Controls

29. Generate Optimizer

30. Update Storage Parameters

31. Define Document Sequences

32. Assign Document Sequences
http://www.blogger.com/profile/14269676533824440126http://www.blogger.com/profile/14269676533824440126http://oraclefunctionalsurendra.blogspot.com/2012/09/oracle-apps-functional-setups-general.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/oracle-apps-functional-setups-general.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/oracle-apps-functional-setups-general.htmlhttp://www.blogger.com/profile/14269676533824440126http://oraclefunctionalsurendra.blogspot.com/2012/09/oracle-apps-functional-setups-general.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/oracle-apps-functional-setups-general.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/oracle-apps-functional-setups-general.html


15/24

33. Update System Profile Options

34. Define Database Links

35. Define Consolidation Mapping

36. Define Consolidation Mapping Sets

37. Open/Close Periods

38. Journal Reversal Criteria

Step 1 [Oracle Required/ERP Required]

Define Value Sets

Level: Enterprise

Change responsibility to General Ledger Super User

Navigator: Setup > Financials > Flexfields > Validation > Sets

Purpose: Define a value set. Value Sets are set up for each segment of the Accounting Flexfield.

Step 2 [ Oracle Required/ERP Required]

Define Key Flexfield Segments

Level: Enterprise

Change Responsibility to Application Developer

Navigator: Flexfields->Key->Segments

Purpose: Defines the key flexfield segments that make up the flexfield structure. This form uses the information about the Segments from Step 1,

defines rules for each, and enables each segments.

Step 3 [Oracle Optional / ERP Optional]

Define Rollup Groups

Navigator: Setup> Financial > Flexfields >Key >Groups

Purpose: Define Rollup Groups to create summary accounts whose summary balances you can review. You assign parent segment values to rollup

groups.

Step 4 [Oracle Required / ERP Required]

Define Accounting Flexfield Values

Level: Enterprise


Navigator: Setup > Financials > Flexfields > Key >Values

Purpose: This screen is used to enter values for each of the segments defined in Step 2.


Define Cross Validation Rule

Level: Enterprise

Navigator: Setup > Financials > Flexfields > Key > Rules

Purpose: Define key flexfield cross-validation rules, which check code combinations at journal entry and budget entry.

Step 6 [ Oracle Optional / ERP Required]

Define Key Flexfield Security Rule and Define Security Rule

Level: Enterprise (For each new Set of Books, this will need to be completed)

Navigator: Setup > Financials > Flexfields > Key > Security > Define

Purpose: Define security rules to restrict user access to certain account segment values. These rules also extend security to the standard Trial


16/24

Balance and Account Analysis reports


Define Shorthand Aliases

Level: Enterprise

Navigator: Setup > Financials > Flexfields > Key > Aliases

Purpose: Define and maintain shorthand aliases for key flexfields.


Define Descriptive Flexfields

Level: Enterprise

Navigator: Setup > Financials > Flexfields > Descriptive > Segments

Purpose: Define Descriptive Flexfields


Define Calendar Types

Level: Enterprise

Navigator: Setup > Financials > Calendar > Types

Purpose: Define accounting period types. Oracle provides the following seeded values: Month, Quarter, and Year.


Define Calendar

Level: Enterprise

Navigator: Setup > Financials > Calendars > Accounting

Purpose: Define the financial calendar


Define Currencies

Level: Enterprise (For each new Set of Books, this will need to be completed)

Navigator: Setup > Currencies > Define

Purpose: To enable currencies ISO currencies.

Step 12 [ Oracle Required / ERP Required]

Define Set Of Books

Level: Enterprise (needs to be completed for each Set of Books)

Navigator: Setup > Financials > Books > Define

Purpose: Define a set of books and budgetary control options.


Multi-Org Setups

Level: Enterprise (needs to be completed for each Set of Books)

Step 14 [Oracle Optional / ERP Required]

Assign Key Flexfield Security Rule and Assign Security Rule

Level: Enterprise

Navigator: Setup > Financials > Flexfields > Key > Security > Assign

(Alternatively click on Assign button from Step 5)


17/24

Purpose: Assign flexfield security rules to an application responsibility.


Define Accounting Flexfield Combinations

Level: Enterprise

Navigator: Setup > Accounts > CombinationsPurpose: Define new Accounting Flexfield combinations and to maintain existing Accounting Flexfield combinations.


Define Journal Entry Sources

Level: Enterprise

Navigator: Setup > Journal > Sources

Purpose: Define journal entry sources and specify for a given source the whether to import journal reference information from feeder systems.


Define Journal Entry Categories

Level: Enterprise

Navigator: Setup > Journal > Categories

Purpose: Define journal entry categories.


Define Suspense Accounts (ONE defined for each SOB, other, other)

Level: Set of Books

Navigator: Setup > Accounts > Suspense

Purpose: Define additional suspense accounts based upon the source and category of journal entries.


Define Intercompany Accounts

Level: Set of BooksNavigator: Setup > Accounts > Intercompany

Purpose: Define additional intercompany accounts.


Define Conversion Rate Types

Level: Enterprise


Navigator: Setup > Currencies > Rates > Types

Purpose: Use conversion rate types to automatically assign a rate when you convert foreign currency journal amounts to functional currency

equivalents GL 21.


Define Daily Exchange Rates

Level: Set of Books


Navigator: Setup > Currencies > Rates > Daily

Purpose: To enter daily conversion rates for foreign currencies as defined in Step 10.


18/24


Define Period Exchange Rates

Level: Set of Books

Navigator: Setup > Currencies > Rates > Period

Purpose: To enter period conversion rates for foreign currencies for consolidation.

Step 23 [Oracle Required / ERP Required]Define Historical Exchange Rates

Level: Enterprise

Navigator: Setup > Currencies > Rates > Historical

Purpose: To enter daily conversion rates for foreign currencies as defined in Step 10.


Translate Balances

Level: Set of Books

Navigator: Currency > Translation

Purpose: Translate the journal balance from FJD to NZD for consolidation.


Define Summary Accounts

Level: Enterprise

Navigator: Setup > Accounts > Summary

Purpose: Create and delete summary accounts.


Define Statistical Units of Measure

Level: Enterprise

Navigator: Setup > Accounts > Units

Purpose: Define statistical units of measures and assign them to account segment values. User Profile Option Journals: Mix Statistical and Monetary

must be set to Yes.


Define Automatic Posting Options

Level: Set of Books

Navigator: Setup > Journal > Autopost

Purpose: Specify journal batches for automatic posting.


Define Concurrent Program Controls

Level: Enterprise

Navigator: Setup > System > Control

Purpose: Control the performance of the Journal Import and MassAllocation/MassBudgeting programs by varying the amount of memory usage This

is completed after the Optimizer is run. This screen should be completed by a DBA

Step 29 [ Oracle Required/ ERP Required]

Generate Optimizer

Change responsibility to General Ledger ????

Level: Enterprise

Navigator: Reports > Request > Standard

Purpose: Runs the Oracle GL Optimizer. The Optimizer creates or drops indexes for those segments in the COA that have been marked for indexing.


19/24

This helps journal entry posting and financial reporting processes run faster. It is recommended that the Optimizer is run at least once a period, or any

time a large number of segment values are added, a new COA is defined, summary templates added or deleted.


Update Storage Parameters

Level: Enterprise

Navigator: Setup > System > StoragePurpose: Maintain storage parameters for all interim tables and indexes in General Ledger.


Define Document Sequences

Level: Enterprise

Navigator: Setup > Financials > Sequences > Define

Purpose: Name a new document sequence and define how the sequence numbers each document. See GL Reference Manual for more detail

information.


Assign Document Sequences

Level: Enterprise

Navigator: Setup > Financials > Sequences > Assign

Purpose: Define the documents a document sequence will number and then assign the document sequence to your definition.

Step 33 [Oracle Required/ ERP Required]

Update System Profile Options

Level: Enterprise

Change Responsibility to System Administrator

Navigator: Profile > System

Purpose: To choose which user profile options to include in a particular user profile at the site, application, responsibility, or user level.


Define Database Links

Level: Enterprise

Navigator: Setup >System > Database Links

Purpose: To define links to other General Ledger databases in order to copy FSG report objects from the linked database into your current database.


Define Consolidation Mapping

Level: Enterprise

Navigator: Consolidation > Define> Mapping

Purpose: Mapping Subsidiaries to your parent account


Define Consolidation Mapping Sets

Level: Enterprise

Navigator: Consolidation > Define> Mapping Set

Purpose: Mapping Subsidiaries to your parent account


Open/Close Periods


20/24

Level: SOBP

Navigator: Setup > Open/Close

Purpose: Change the status of the accounting periods in the set of books.


Journal Reversal CriteriaLevel: Set of Books

Navigator: Setup > Journal > AutoReverse


0

Add a comment

4.Sep

6

General ledger R12 interview question

General Ledger

1. What are the key functions provided by GL?

General Accounting Budgeting

Multiple Currencies Inter-company Accounting

Cost Accounting Consolidation

Financial Reporting

2. What are the three types tables available in Oracle Applictions?

Master Table: Store Static data,. This is shared with in each module as well as across all

of the Oracle financial application modules ex. ACCOUNTS, SUPPLIER, CUSTOMER etc.

Setup Table: it store setup data. That is never shared between applications such

as application parameters and LOOK UP tables.

Transaction Tables: these tables stores day-to-day transaction data such as payables invoices,

journal entries etc.

3. What are the Oracle General Ledger Setups?

1. Chart of Accounts

2. Account combinations (o)

3. Period types

4. Accounting Calendar5. Transaction Calendar (o)

6. Currencies

7. Set of Books

8. Assign set of books

9. Currency exchange rate types

10. Currency exchange rates

11. Journal Sources (o)

12. Journal Categories (o)

13. Suspense Accounts (o)

14. Inter-Company Accounts (o)

15. Summary Accounts

16. Statistical Units measures (o)

17. Historical Currency Exchange Rates

18. Document sequences (o)

19. Automatic Posting (o)

20. Encumbrance Types (o)

21. Concurrent program Controls (o)

22. Storage Parameters (o)

23. Budgetary Control Groups

24. Profile options

25. Descriptive Flexfileds

26. Open and Close Accting periods

4. Chart Of accounts: A Chart of Accounts is the account structure we use to record accounting transactions and maintain accounting balances. It is a

key flex field.
http://www.blogger.com/profile/14269676533824440126http://www.blogger.com/profile/14269676533824440126http://www.blogger.com/profile/14269676533824440126http://oraclefunctionalsurendra.blogspot.com/2012/09/general-ledger-r12-interview-question.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/general-ledger-r12-interview-question.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/general-ledger-r12-interview-question.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/general-ledger-r12-interview-question.htmlhttp://www.blogger.com/profile/14269676533824440126http://oraclefunctionalsurendra.blogspot.com/2012/09/general-ledger-r12-interview-question.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/general-ledger-r12-interview-question.htmlhttp://oraclefunctionalsurendra.blogspot.com/2012/09/general-ledger-r12-interview-question.html


21/24

5. Flex Fied: A Flex Field is a combination of one or more data segments defined by the user. For Chart of accounts, we configure up to 30 segments

in a flexfield and min is 2.

Descriptive Flexfield: We can store the additional Information in customized form or existing form.

6. Value Set: value set defines the valid values for each segment of our Chart of Accounts. There are 6 validations types 1. Dependent 2. Independent

3.none 4. Pair 5 special 6. Table

INDEPENDENT: An independent value set provides a pre-defined list of values for a segment.

DEPENDENT: A dependent value set is similer to independent value set, or dependent value set depends on any independent or dependent value set.

TABLE: Table provides list of values like an independent set. But values will stored in application table.

NONE: No restrictions.

7.Transactions: Exchange of goods and services with the intension of earning

8.What is a Qualifier?

Qualifier is a behavior of a segment.

9. Flex field Qualifiers

Companies ---------- Balancing segment

Departments ----------Cost Centers Segment

Accounts ----------Natural Accounts Segment.

10. What are the format types available in Values sets?

Character, date, date time, number, std date, std date time,. Time.

11. What are Accounting Qualifiers?

Allow budgeting

Allow positing

Account type

Control Account

Reconsiliation flag

12. Security Rules:

These are used to limit access to certain segment values for a particular segment.

13. Cross Validation Rules:

These rules validate data across segments of a flex field.

14. Types of Calender:

Normal: January to Dec.

Fiscal: April to march.

15. Period Types:

Daily, Month, Quarter, Year.

16. Accounting Calender: It is used to define the no. Of periods in the calendar year. Our calendar can contain both adjusting and non-adjusting accounting periods.

17. Transaction Calender:

It is used to define the business days of an organanization.

18. Types of Currency:

Functional currency: The currency we define in our SOB.

Foreign currency

19. S.O.B:

Put together information is called as Sets Of Books. It consists of Cart of Accounts, Currency, Calender and Six mandatory Accounts.

20. What are Mandatory Accounts:

Mandatory Account

Usage

Acct Type

Retained Earnings

Last Year closing balances C/F (carry forward) to current year balance

Ownership

Translation Adj Acct

When the currency conversion takes place the difference amt is stored in this acct

Asset/liability

Suspense Account

The variation of credit and debit amounts is suspense acct

Asset/liability

Rounding Difference Acct

The difference amt after rounding the amount is posted to this account.

Expense/Revenue


22/24

Net Income Acct

Surplus of profit and loss account.

Ownership

No budget and No posting

Reserve for Encumbrance

Planning for reserving some amount(budget)

ownership

21. States of Periods. Open, Close, Future Entry, Permanently closed.

22. What is Journal?

A journal is a form in which we enter the business transactions.

23. What are the Balance Types?

Acutal, Budget, Encumbrance.

24. Categories of Journals.

Batch Journal.

Source Journal

Statistical Journal

Suspense Journal

Encumbrance Journal

Reverse Journal

Tax Journal

Recurring Journal

Standard Recurring Journal.

Formula Recurring Journal.

Skelton Recurring Journal.

25. Batch Journal:

A group of common journals is called as a Batch

26. Source Journal:

A source journal is a journal where we can get the journal information from other modules.

27. Statistical Journal:

Statistical journal entries do not require balanced debit and credits. Here we use ratios to calculate amounts.

28. Suspense Journal:

When the debit amount and credit amount are not equal in the journal entry then the deficit amount is added to suspense account and such

types of journals are called as suspense journals.

29 Encumbrance Journal:

For funding budgets we have to enter the encumberance journals. Using this amount we can perform the actual expenses. The part of the

budget we reserve is called as reserve for encumberance. The journals involving this budget are called as encumbrance journals.

30. Reverse Journal:

We cannot alter the posted journals. We can only post additional journals which contain reverse to that of credit and debit amounts of the

original journal. This types of method is called as reverse journal.

31. Tax Journal: The tax journals will calculate the tax on the credit and debit amounts in the journal depending on the tax information.

32. Inter-company Journal:

If multiple companies in our enterprise share the same SOB then we can automatically balance inter-company journals. Here we define

intercompnay accounts for different combinations of sources, category and balancing segment value.

32. Recurring Journals:

Journals which will be repeated automatically are called as Recurring journals.

The advantage of recurring journal is one journal can be posted in each and every month without creating each and every time.

There are three types of recurring journals.

Standard R.J: Where we know the fixed amount and account information.

Formula R.J: Here we may or may not know the actual information. We calculate the amounts depending on a formula. In formula block first field

should be enter

Skelton Journal: It is raised when we know only account information but not amount information.

Control Total:

This is used to raise the journal with a fixed amount. The error message is not displayed at the saving time but it is displayed while posting the journal.

33. Mass Allocation (Allocation journal):

Mass allocation is used to avoid the repeating entry of journals for different departments and it considers only actual accounts.

(Or)

When we are trying to allocate an amount for a period for a combination of segment values is called as Mass Allocation.

Mass allocation formula:

Cost pool * usage factor/total usage factor

Summary Accounts:

Summary accounts store balances of multiple accounts. We need summary template to define a summary account.

Roll up groups:

A roll up group is a collection of parent values for a given segment. This is used to provide a condition to the template.

Amount types:

PTD (period-to-date) YTD (year-to-date)


23/24

PJTD (project-to-date) QTD (Quarter-to-Date)

Financial Statement Generator A powerful and flexible report building tool for Oracle General Ledger. You can design and generate fiancial reports,

apply security rules to control access to data via reports, and use specific features to improve reporting productivity.

Budget

It is one of the management tool by using which we can estimate the amounts for a specific range of periods for an organization.

Each budget can have maximum of 60 periods.

Budget can have any one of the following states Current (the first budget we define in our sob)

Open (To activate a budget)

Frozen (to deactivate or close a budget)

For using budgets we have to define a budget and a budget organization.

Budget Types:

Planning Budget:

We can just plan but we cannot raise journal entries.

We can convert it into funding budget by enabling Required Budget Journal option.

Fund check levels are: none, advisory, absolute.

Funding Budget:

This is the actual budget. Once the budget is approved, the organization can start spending the budget amount for various expenses.

Budget Journals:

It is a combination of budget organization and budget. These offer an alternative way to enter budget amounts, and they assist in maintaining

audit trials.

Budget Formulas

We can also enter

oracle r12 gl interview quetions

Documents