Total Pageviews

September 18, 2016

9/18/2016 03:38:00 AM
Oracle eBusiness Suite Finance  Certification Questions


.List of (any five) Standard reports of G/L.

a) Budget Summary/ Detail.
b) Consolidation Rule.
c) Chart of Accounts Detail list.
d) Inter company transaction Details.
e) FSG- Column set detail listing.
f) FSG- Row set summary listing.
g) Trail Balance- Encumbrances.

2. What you mean by “FSG”? What are the mandatory sets for FSG?

Financial Statement Generator (FSG) is a powerful reporting building tool for Oracle General Ledger. FSG Generate financial reports, such as trial balances, income statements and balance sheets, based upon data in your general ledger.

Three mandatory sets for FSG:
a) Row Set: A Row Set defines the format and content of the rows in an FSG report. In FSG, the commonly assumed attribute for a row definition is an account assignment,

b) Column Set: Column Set defines the attribute for a column definition is a time period (amount type).

C) Report Set: Report Set, define formulas to calculate row or column amounts. For example, you can define a row calculation, which sums all of the rows above it in the report. After Calculation we are going to RUN the report.

3. What does Rollup Group mean?

Rollup groups are which you can assign key flex field values. You can use a rollup group to identify a group of parent values for reporting or other application purposes. You assign key flex field segment values to rollup groups using the Segment Values window.

4.Whether rollup groups are specific to set of books?

No, it is specific to Chart of Accounts. (Accounting Flex field)

5. What type of the Value sets will support Rollup groups?

Independent, Table.

6. What is the use of Summary templates in G/L?

To perform online summary inquire as well as speed the processing of financial reports, mass allocation and recurring journal formulas.

7.   Can I define summary account template using only “D” template value?

 No, you can’t define summary account template using only “D” it will not accept.

8. What are different statuses of summary template?

 Adding, Current & Delete.

9. What does “unfreezing Rollup Groups” do?

If you enable the check box of “Freeze Rollup Groups” then you not able to define Rollup Groups at flexfield level.

10.Is there a limit on the number of summary template?

 No, there is on limit for summary template, as many as you can give.

11. What do you mean by “Profile Option”?

A user profile is a collection of changeable options that effect the way your application.

12. What are the various levels, where we can assign profile values?

Site, Applications, Responsibility and User.

13. List some of the Mandatory fields required for defining responsibility?

Responsibility name, Responsibility key, menu, Application, data group and request group.

14. What are different types of Set of Books?

 Primary SOB and Reporting SOB.

15. What is the different between Application and Responsibility?

Application: This field displays the current value, if set, for all users working under responsibilities owned by the application identified in the Find Profile Values block.

Responsibility: This field displays the current value, if set, for all users working under the responsibility identified in the Find Profile Values block

16.Is it possible to change the source of a journal Entry in G/L?

 No, it is not possible to change source of the journal entry in G/L because while creating JV the Source field is grayed out.

17. Can I define a ‘Column’ with Account Assignments?

Yes, we can define account assignment in Columns.





18. What is the relevance of “Offset” in FSG?

Offset is to reporting on a period or effective date before or after your runtime period or effective date. If you are specified current period, such as January, then the Offset will be in number of periods, you are going to give in another column set (Sequence to it) in Offset box whether in negative numbers that is previous periods Or Positive numbers that is future periods.
           FSG determines the amounts to display based on the offset and the period or effective date you enter at runtime.
For example: Enter 0 (zero) to display amounts for the current period runtime effective date and enter –1 to be display previous period amounts with another column adding to it.

19. What is the difference between ‘parent segment value’ and ‘Rollup group’?

Parent segment values are contains the child values of the segment values.

Rollup group values are contains the parent values as well as child values of                   parent values. We can use to view the reports in summery templet.

20. How many Standard reports are available in General Ledger?

122, standard reports are available in General Ledger.

21. What are different balance types?

Actual, Budget and Encumbrance.

22. What are the different ‘display type’ of account ranges in FSG?

Bà Both
Eà Expand

Tà Total.