Oracle Financial Apps

1.

A new Sheet tab in Excel is copied from an existing tab that contains a Smart View query, but clicking Refresh does not refresh the data and the Smart View (Point of View) POV bar does not display. Which additional step is required to pull data in the new tab and change the POV?

Disconnect from the Smart View connection, and relog in. Activate the Connection. Close out of Excel, and relog in to Smart View. Change one of the Row or Column dimension members and click Refresh.

2.

P, Q, and R are children of a mid-level parent entity, AceCo. In February each entity has cash in the amounts of 10, 20, and 30, respectively, and AceCo has been consolidated and has cash of 60. A prior period adjustment to Q adjusts cash with a debit of 5. Which statement regarding consolidation is correct?

There is no way to do a prior period entry like this. January and February should be consolidated. February should be consolidated, after which the cash at AceCo is now 65. January should be consolidated for the change and nothing needs to happen for February.

3.

Which statement correctly describes the Consolidation dimension?

The dimension contains members to store non-controlling interest and joint venture data. The dimension uses a separate member to store data from an entity The dimension allows users to see input versus journal adjustment data. The dimension aggregates input, consolidated, and elimination data together.

4.

On what days during the month does Oracle apply patch updates to fix bugs, apply code optimizations, and add new features?

the third Friday of each month to apply to both TEST and PROD simultaneously the first and third Monday of each month; first Monday for TEST and third Monday for PROD the second and fourth Friday of each month; second Friday for TEST and fourth Friday for PROD the first and third Friday of each month; first Friday for TEST and third Friday for PROD

5.

Which components are pre-built into Financial Consolidation and Close Cloud Service to provide a configurable and scalable consolidation solution?

pre-built integrations to combine narrative and data to produce both internal and external reporting packages calculations, dashboards and reports to provide analysis for cash flow modeling calculations, dashboards and reports as well as detailed data source tracking and an automated cash flow calculations, dashboards and reports built on planning frameworks to provide cash flow planning

6.

When setting an account property to a data storage type of

Member Formulas cannot be created load data to this account and make member formulas load data to this account create Member Formulas

7.

To show the Intercompany account and matching account balances on the Intercompany Matching Report, you make which selection?

Intercompany Accounts Intercompany Partners Intercompany Plug Accounts Elimination Consolidation Dimension member

8.

Changes in the balance of Accounts Payable are captured on a company

FCCS_Accounts Payable account member FCCS_CashFlow_Operating movement member FCCS_CashFlow_Accounts Payable account member FCCS_Total Balance Sheet FCCS_CashChange movement member

9.

Entity PQR, Consolidation FCCS_Elimination, Intercompany FCCS_No Intercompany Entity Paducah, Consolidation FCCS_Elimination, Intercompany FCCS_No Intercompany Entity P_2, Consolidation FCCS_Contribution, Intercompany ICP_H_1 Entity Paducah, Consolidation FCCS_Elimination, Intercompany ICP_H_1 Entity P_2, Consolidation FCCS_Contribution, Intercompany H_1

10.

What member of the Consolidation dimension aggregates the Proportion member and the Elimination members?

FCCS_Entity Total FCCS_Parent Currency FCCS_Contribution FCCS_Entity Consolidation

Oracle Financial Apps

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Oracle Financial Apps

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner