Oracle R12 Payables/GL Fundamentals FAQs

1) Which two actions would perform by using the column set builder function? Choose Two?

a) Assigning accounts.
b) Creating the format mask.
c) Defining calculations in the new column.
d) Sorting rows based on values in a column.

Answer: bc

2) Select two steps that NOT elements of creating a Financial Statement Generator (FSG) report in Oracle General Ledger? Choose Two?

a) Attach the fiscal calendar.
b) Define rows and columns.
c) Build a report by using rows and columns
d) Specify the default ledger for ledger sets.
e) Determine which rows and columns make up your report.

Answer: ad

3) XYZ company is getting ready to complete its month end process. It needs to create a profit and loss statement and wants to use the Financial Statement Generator feature to create the report. Which two elements are required to create the report (Choose Two).

a) Row set.
b) Report set.
c) Workbook
d) Column Set.
e) Content Set.

Answer: ad

4) In the course of implementing Oracle General Ledger, you and your customer have created a number of Financial Statement Generator reports in a test environment. These reports have been tested you and now ready to create them in your production environment. You are ready to run the FSG transfer program.
What two requirements are necessary to run this program (Choose Two).

a) Database links must be defined.
b) The same ledgers must be defined in both instances.
c) Enable the FSG: AutoCopy profile option in the production environment.
d) The same row and column sets must exist in the production environment.

Answer: ab.




5) ABC Corporation has five segments in its accounting flexfield. For a special profit and loss report, they want to sort by the forth segment, which is product. Select element that would meet this need.

a) Row set.
b) Row Order.
c) Content Set.
d) Column Set.

Answer: b.