Oracle Oracle Certifications 1Z0-517 Questions & Answers

• Question 351:

  John has created two ledgers: one primary and one secondary. The primary ledger stores transactional data and the secondary ledger stores only adjustments. The secondary ledger shares the same chart of accounts, accounting calendar or period-type combination, and currency as the associated primary ledger. John wants to obtain a complete accounting representation that includes both transactional data and adjustments while running reports. Identify the best option.

  A. Merge the primary ledger and the secondary ledger, and run reports.

  B. Transfer adjustment data from the secondary ledger to the primary ledger while running reports.

  C. Transfer transactional data from the primary ledger to the secondary ledger while running reports.

  D. Use ledger sets to combine the adjustments-only secondary ledger with the primary ledger when running reports.

  Correct Answer: D

• Question 352:

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

  A. row set

  B. row order

  C. content set

  D. column set

  Correct Answer: B

• Question 353:

  Which two actions would you 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

  Correct Answer: BC

• Question 354:

  Select two steps that are 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.

  Correct Answer: AD

• Question 355:

  Treeline 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

  Correct Answer: AD

• Question 356:

  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 and you are 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.

  Correct Answer: AB

• Question 357:

  Identify what three considerations must be executed before creating a report by using the financial statement generator. (Choose three.)

  A. Download Web ADI.

  B. Create the database link.

  C. Determine the data to be reported.

  D. Define attributes for rows and columns.

  E. Decide which rows and columns will make up the report.

  Correct Answer: CDE

• Question 358:

  ABC Company wants to compare consolidated actuals against consolidated budgeted amounts. Identify

  the two steps that must be performed to provide ABC Company with this information.

  (Choose two.)

  A. Run the Trial Balance report.

  B. Execute an online budget inquiry.

  C. Execute an online account inquiry.

  D. Review the Account Analysis report.

  E. Run financial statement generator reports.

  Correct Answer: CE

• Question 359:

  Identify the three reports that can be processed using the State Controller window. (Choose three.)

  A. Consolidation Audit

  B. Consolidations Journal

  C. Consolidation Financial

  D. Consolidation Exceptions

  E. Consolidation Balance Inquiry

  Correct Answer: ABD

• Question 360:

  Your client is closing its first period. The client completed the accounting cycle for each of the subsidiary books. Its staff has called you to troubleshoot its process because the consolidation did not produce any data. Select two steps that you would perform to identify the error. (Choose two.)

  A. Review the workflow process.

  B. Evaluate the mapping settings.

  C. Review the GL_Interface tables.

  D. Confirm the account hierarchy setups.

  E. Run the period close by using a different amount type.

  Correct Answer: BC