study 2
|
|
Título del Test:
![]() study 2 Descripción: Study Sheet |



| Comentarios |
|---|
NO HAY REGISTROS |
|
1.- Task Manager provides a framework where you can define the required components for a business process. What are two important steps when initializing Task Manager?. Assign tasks to users. Create a schedule and set it to Open status. Define system settings, such as organization units, holiday rules, and task attachment size. Set up users. 2.- When you create an application, the Movement dimension is created by default with seeded members and system members are added based on the optional features that you enable. Which two tasks are you able to perform using the Movement dimension?. Create cash flow members and hierarchies for Cash Flow Reporting in the Entity and Product dimensions. Automatically generate the Cash Flow due to the segregation of movements based on cash flow categories. Create member formulas for Movement dimension members to improve consolidation performance. View details of the cash flow movements when viewing the Balance Sheet. 3.- You want to import descriptive flexfields as a part of the import journals scheduled process when Direct integration is enabled. Which two statements are true about importing descriptive flexfields?. Descriptive flexfields are used for customized data capture and usage. You can select "Import Descriptive Flexfields with Validation" when creating sources for Enterprise Journals. Before importing descriptive flexfields, they must be configured in the Oracle Cloud Financials application. Descriptive flexfields can only be of plain text type. 4.- You want to use Enterprise Journals to provide a single point of entry for manual journals. Which two statements are true about Enterprise Journals?. Before you work with Enterprise Journals, you need to create the targets that contain the definition and properties of the target application. If you select Cloud Financials as the target type, you cannot select Direct Consolidation, which is a dedicated posting process. You must enable Enterprise Journals during the application creation. A connection must be created to the target ERP system. 5.- You routinely create a backup snapshot file of application artifacts and data as part of system maintenance. Which navigation path would you use to create a snapshot file to back up a form?. From the Home page, select Tools, and then Clone Snapshot. Open the form, select Actions, and then Export. From the Home page, select Tools, and then Migration. From the Navigator menu, select Forms. 6.- Company 123 is a public company that reports in US Dollars. Company 123 owns Company XYZ, a European company that consolidates in Euro. Company IOU is headquartered in Switzerland with a functional currency of the Swiss Franc. Which process produces USD balances for Company IOU?. Running the Translate business rule for Company 123 and selecting company IOU as the translation partner. A consolidation of Company IOU. Running the Translated rule for Company IOU and selecting USD_Reporting as the currency. A consolidation of Company 123. 7.- The data type determines how values are stored in account members and how exchange rates are used to calculate values. Which two statements are true about exchange rates?. If no exchange rate is entered for translating from Currency A to Currency B, an exchange rate of 1 is assumed. In order to enter historical override rates for an account, the Exchange Rate Type property for the account must be set to Historical Rate Override. Triangulated currency rates are not supported. When you enter a direct rate to translate from Currency A to Currency B, an indirect rate for translating from Currency B to Currency A is automatically calculated as well. 8.- As an administrator, you want to define security for dimensions. Which two statements are true about enabling security for dimensions?. The default dimension security access for all users is Read. You can disable security for any dimension, but security is mandatory for at least one dimension. Security is enabled by default for most dimensions, including Account, Entity, Data Source, and Movement. You cannot assign data security at the parent level for all descendants; you must assign security to each dimension member independently. 9.- Data is secured by giving user access to dimension members, which prevents unauthorized users from changing data. As an administrator, you define... Which statement is FALSE about establishing data security for Financial Consolidation and Close?. Security is mandatory for one dimension. Security can be assigned at the parent level. Security can be disabled for any dimension. Security must be assigned to each dimension member independently. 10.- Ownership Management consists of managing global consolidation settings and applying those settings to each entity hierarchy on a scenario-by-scenario, year-by-year, and period-by-period basis. Which two can be manually edited on the Manage Ownership page in a Financial Consolidation and Close business process with Ownership Management enabled?. Consolidation Percentage. Ownership Percentage. Minority Interest Percentage. Control. 11.- You want to copy data from a source POV to a target POV to assist with your business planning and analysis. Which dimension member is fixed and not available for selection in the Copy Data process?. Periodic member in the View dimension. Data Input member in the Data Source dimension. Closing Balance member in the Movement dimension. System Account member in the Account dimension. 12.- As an administrator, you have defined an approval unit hierarchy and started the approval process. After two passes is started, one is complete. The approval unit has the status Under Review. Who can modify data for the approval unit?. The current owner. The current owner, Service Administrator, or Power User. Any user with Write access to the dimension members in the approval unit. Only the administrator. The current owner or Service Administrator. 13.- The Intercompany Entities Aggregation option for your business process is set to Ignore What is the result of this?. Data for intercompany entities is not aggregated to the Intercompany Top member. Data for intercompany entities is not aggregated to the Intercompany Entities member. Data for intercompany entities is not eliminated during consolidation. Elimination data for intercompany entities is not written to the plug account. 14.- You are required to create a form that allows users to input data. Which two actions are consistent with this?. In the member selection for Entity, do not include shared entities; include only primary instances of entities. Select level 0 dimension members for POV, rows, and columns. Set the currency on the form to Parent Currency. Grant users who input data Write access to the dimension members used on the form. 15.- When setting up data integrations, you can set options for data loads on the Target Option tab of the Application Details dialog box. Which two options are available for Financial Consolidation and Close applications?. Create Drill Region: Specifies whether users can drill from cells in forms to source data. Load Type: Identifies whether you are loading regular data or journals. Staging Table Mode: Specifies how to load data to staging tables for Workbench. Enable Minus Loading: Specifies whether to allow negative values to be loaded. 16.- Security is enabled for the Account dimension, but you have not assigned member access rights to any users or groups. What will be users’ default access to members in the Account dimension?. Write. None. Comment. Read. 17.- You are setting up a Supplemental Data collection interval to customize your data collections by customizing the POV to your specific collection needs. Which two can be selected as Workflow dimensions for a collection interval in Supplemental Data Manager?. Period. Entity. Scenario. Year. 18.- You created a navigation flow named Analysts that should be the default navigation for users in the Analysts user group. How can the Analysts navigation flow be made the default for the Analysts user group?. In their User Preferences settings, members of the Analysts user group should select Analysts in the Navigation Flow list. In the Analysts navigation flow, select the Analysts user group in the Assign To field. In Application Settings, assign analysts to the Analysts user group in the System Settings section. Because the navigation flow was given exactly the same name as the user group, it is assigned automatically to the group. 19.- In a data integration, you need to map records with the label AcctRec in the Account field of the source file to the member name Short Term Rec in the target. Which map type would you use on the Map Members tab?. Is Like. Between. Explicit. In. 20.- To run a data integration, you click Run on the Data Integration page to open the Run Integration dialog box, where you can select Run Integration options. Which three options can you select?. Category, Location, and Import Mode. File, Import Mode, and Export Mode. Import Mode, Export Mode, and Category. Location, Import Mode, and Export Mode. 21.- You create and run integrations from the Data Integration page. Where can you set the default member for the Currency dimension in a data integration?. Location Attributes in the Create Integration dialog box. Run Integration dialog box. Map Members tab in the Create Integration dialog box. Options tab of the Application Details dialog box. 22.- A company based in the United Kingdom has their currency set to GBP. The company collects data from a subsidiary based in the United States. The subsidiary’s functional currency is USD. Which two items facilitate the reporting of the subsidiary’s Common Stock balance at a historical rate in the GBP reporting currency?. Rate data for Common Stock must be loaded or entered in the Override Rates form. USD must be added as a reporting currency. Common Stock must have Exchange Rate Type set to Historical Rate Override. Common Stock must have the Data Storage property set to Never Share. The subsidiary must have a parent entity with a GBP currency. 23.- You can use Groovy script to add custom rules to your application, either to the consolidation process or as on-demand rules. Which two statements about Groovy rules are true?. You cannot run EPM Automate commands from Groovy rules. You can include both Groovy rules and calc-script rules in the same rule set. You can create Groovy rules in Calculation Manager. You cannot schedule Groovy rules to run in the Job scheduler. 24.- You need a report that displays all adjustments to account balances of child entities for a parent, including journal adjustments, intercompany eliminations, and adjustments from consolidation rules. Which type of report can you run to accomplish this?. Intercompany. Consolidation. Financial. Journal. 25.- A change has occurred that may affect the data for specified dimensions. For example, a new rules file or metadata file has been loaded, or the currency rate has changed. Which calculation status will be displayed?. System Change. Needs Translation. Impacted. Ok. 26.- As an administrator, you set up an approval process and organize data into approval units for review. To which three dimensions do you assign approval unit hierarchies?. Entity, Year, Scenario. Account, Year, Period. Scenario, Year, Period. Year, Period, Account. 27.- You configured your application to track intercompany eliminations. Which statement is correct regarding intercompany eliminations?. Intercompany elimination takes place at the first common ancestor of the intercompany entities. Identifying a plug account is optional for eliminations. Intercompany eliminations are optional in Financial Consolidation and Close and use one of the custom dimensions when enabled. Intercompany partner entities must have the same parent in order to eliminate. 28.- When you run a consolidation, the process gathers data from descendant entities and aggregates the data to parent entities. Which statement correctly describes what happens to parent entities during consolidation?. The changes in the relational database are synced to the underlying Essbase cube. Because parent entities are tagged as Dynamic Calc, the consolidation has no effect on the Entity dimension. Data from the FCCS_Contribution Consolidation dimension member of the child entities is aggregated and stored in the FCCS_Entity Consolidation member of the parent entities. For each child entity, the period Opening Balance is subtracted from the period Closing Balance to determine the current period change value, and the values are aggregated to the FCCS_Entity Consolidation member of the parent. 29.- During application creation, you select the Intercompany Data option because your business process includes intercompany data. When you select this option, the system creates an Intercompany dimension containing system members. Which statement about the Intercompany dimension is correct?. All members in the Entity dimension for which ICP_Entity_Yes is selected are automatically included in the Intercompany dimension. All level-zero members of the Entity dimension are automatically included in the Intercompany dimension. You can add base members that do not exist as members in the Entity dimension. Deleting a member from the Entity dimension that is tagged as Intercompany does not remove the member from the ICP dimension. 30.- You want to set up valid intersections to define rules, which act as filters when users enter data or select runtime prompts. Which two statements are true regarding shared members and valid intersection rules?. Shared members are not supported in valid intersection rules. If a shared member is selected for a valid intersection rule, then the base member is not included in the rule. If a base member is included in a valid intersection rule, then any shared member is included in the rule. Shared members are supported in valid intersection rules. 31.- You want to approve your data using approval groups. Which statement best describes an approval group?. The users authorized to approve a task in Task Manager. A phased approval process with approval units that submit a portion of an entity’s data for review. The entities included in an approval unit. A group of users authorized to approve data for an entity. 32.- When configuring a new application, you can set currency options on the Details page. Which two statements are true about configuring currency options for an application?. You can select the main currency. If you enable the multi-currency option, then a Currency dimension will be created. You can select translation methods for Flow and Balance accounts. You can change or enable currency options after you create an application. 33.- As an administrator, you can assign user access to individual forms. Which two statements are true about assigning security access to forms?. Power Users have Write access to all dimension members and to all forms. Power Users cannot access forms created by a Service Administrator. Service Administrators and Power Users can design forms. Users and Power Users can view or enter data only into forms to which they have access. 34.- The Entity dimension displays a property for members that specifies if the member should be included in the Intercompany dimension. If the property is selected, a member with the same name is created in the Intercompany dimension. Which two statements are true about the Intercompany Data with Tracking option selected during application creation?. It reduces the amount of custom dimensions available by one. It is required if you want to use Supplemental Data Collection. It is required if you want to use Ownership Management. It enables you to track your intercompany elimination data separately by data source. 35.- Do you want to use the EPM Automate utility to automate frequently used day-to-day tasks from the command line. Which statement about EPM Automate is true?. You can run business rules using EPM Automate. You must be a Service Administrator to execute tasks using EPM Automate. Files are exported to the server’s Outbox folder by default. You use your EPM Cloud Identity Domain credentials to log in to EPM Automate. 36.- You want to set up approval groups to allow for a phased approval process by creating approval units that submit a portion of an entity’s reviewed later. When do you enable submission phases for your approval process?. When you assign the approval unit hierarchy to a scenario, period, and year. When you start the approval process for an approval unit on the Manage Approvals page. When you set the member properties for the entity. When you set up the approval unit hierarchy. 37.- You can view the calculation status to determine whether data needs to be translated or consolídate. Which two calculation statuses indicate that you can consolidate?. Impacted. System Change. Approved. Not Started. OK. 38.- In the Account Dimension, the structure of the Balance Sheet is created with Dynamic Calc parent members. Which two formats are available?. Traditional (Assets = Liabilities + Owner’s Equity). Liabilities (Assets = Traditional + Owner’s Equity). Net Equity (Assets + Liabilities = Owner’s Assets). Net Assets (Assets + Liabilities = Owner’s Equity). 39.- When configuring your Financial Consolidation and Close business process, you enable Intercompany Data. Which statement is true?. The Entity dimension displays a property for members that specifies if the member should be included in the intercompany process. Tracking intercompany eliminations is optional. The Ownership Management option is available for selection only when you have enabled Intercompany Data without Tracking Intercompany Eliminations. If Intercompany Data is enabled, the system creates an Intercompany dimension containing system members. 40.- Which dimension includes the FCCS_Global Assumptions member that is used to store common information?. Data Source. Entity. Account. Movement. 41.- The Consolidation journal status indicates the current state of a consolidation journal. As the creator of a consolidation journal, which status should you select when a consolidation journal is ready to be submitted?. Posted. Completed. Submitted. Working. 42.- You need to create a journal that allows you to enter line item values in a single currency for all entities in the journal, even if the entities have different local currencies. Which action would you perform?. Create a Journals group, select a currency for the group, and then add the journal to the group. Click the Currency dimension in the Journal Point of View and select a currency. Create a member in the Data Source dimension with Journal for Source Data Type, and assign it a currency, and then select the currency. Enable the Currency dimension in the journal line items, and select the currency for each line item. 43.- All Movement dimension base members are translated at the selected translation settings except for the Opening Balance Adjustment member. Which exchange rate is used to translate data for the Opening Balance Adjustment member for nonhistorical accounts?. Current period Ending rate. Current period Average rate. Prior period Ending rate. Current period Opening rate. 44.- When you run a consolidation job, you want to view the real-time status of consolidation jobs in the jobs console. Which two real-time statuses are available to view?. Total number of accounts processed relative to the total number of entities for the period. Force Consolidate option running on selected cells. Level that is being processed. Period that is being consolidated. 45.- You want to create a snapshot that can be used to clone an environment to migrate an application from a production instance to a test instance for troubleshooting and additional development work. Which statement is FALSE when you are cloning a Financial Consolidation and Close environment?. You can include Data Management artifacts in the clone. You can include inbox and outbox contents in the clone. The most recent Artifact Snapshot created by daily maintenance is used for the snapshot. You must have both the Service Administrator and Identity Domain Administrator roles to execute the clone. 46.- You can migrate an existing application to one with the period and Movement dimensions as the dense dimensions. After you run the migration utility, which is true for members in the Movement dimension?. Data Storage Dynamic Calc — The Data Storage option for parent members must be set to Dynamic Calc. Data Storage Store — The Data Storage option for parent members must be set to Store. Consolidation Operator Ignore — The Consolidation Operator for Movement members must be set to Ignore. Data Storage Never Share — The Data Storage option for parent members must be set to Never Share. 47.- When using Data Integration to extract data to a target Cloud EPM application, you establish the mapping relationship by defining a period mapping between the source system periods and the target Cloud EPM application periods. When creating a Global Mapping, which target period is not an available option?. Quater. Month. Week. Year. 48.- You want to use Equity Pickup as a method of re-evaluating the investments owned by holding company, allowing the parent to realize changes in equity. Which statement is FALSE about the Equity Pickup method?. Equity Pickup rules run as part of the consolidation process. Seeded rule sets are provided for Equity Pickup. Equity Pickup rules are run on demand from the Rules card by users with launch permission. Equity Pickup requires Ownership Management with the Equity Pickup feature to be enabled. 49.- You want to configure the Audit Information feature to view the tasks performed by users. For which task group is Audit enabled by default?. Journals. No task categories. Data only. All task categories. 50.- Administrators can create and assign approval groups to dimension members. An approval group is defined as a combination of members from which dimensions?. Account, Movement, Intercompany, Data Source, Multi-GAAP, Custom, and Consolidation. Account, Movement, Intercompany, Entity, Multi-GAAP, Scenario, and Consolidation. Account, Movement, Intercompany, Entity, Multi-GAAP, Scenario, and Custom. Account, Movement, Intercompany, Entity, Multi-GAAP, Scenario, and Data Source. 51.- You need to define a form where users should select an entity from a list comprising USA, Canada, and South America, but no other entities. Where on the form do you place the Entity dimension?. The Point of View. The Page Axis. Columns. Rows. 52.- When you create a currency for an application, you can enable it for reporting purposes. Which statement is true about reporting currencies?. All reporting currency members have the suffix _Reporting. When you run the Consolidate business rule, you can select one or more reporting currencies to translate to. All input currencies that you add are automatically added as reporting currencies as well. During consolidation, rates for translating to reporting currencies are calculated by triangulation through the rate for translating to the parent currency. 53.- When you configure an application, you can select the Multi-GAAP option if you need to report your financial statements in both local GAAP and IFRS or other GAAP. Which two statements are true about the Multi-GAAP feature?. You must specify a prefix for entities that use the alternate GAAP standard. Enabling Multi-GAAP reduces the number of custom dimensions you can have. When you enable the Multi-GAAP feature, you can select manual adjustments or calculated adjustments. Select this option if you need to report your financial statements only in IFRS. 54.- You have an application with Account as the dense dimension. Which two actions must you complete before you convert an application with Account as dense to an application with Period and Movement as dense?. Verify that the Data Storage option for parent members is set to Never Share. Disable the automatic maintenance window. Ensure there are no metadata validation errors. Make a backup of the application. 55.- You are defining a file-based integration. When selecting general integration options, you can add or edit the attributes or properties assigned to the location. Which two are location attributes you can define?. Parent Location. Functional Currency. Logic Rule Entity Group. Consolidation Rule Group. 56.- The Consolidation dimension enables you to report on the details used to perform different stages of the consolidation process. The dimension allows users to view data in the parent currency. The dimension allows users to see input versus journal adjustments. The dimension contains members to store noncontrolling interest and controlling interest data. The dimension uses a separate member for data from an entity and its base-level descendants. 57.- During application creation, you do not select the Intercompany Data option because your business process does not include intercompany data. Which statement is true if the Intercompany Data feature is not enabled when the Financial Consolidation and Close business process is created?. The Intercompany dimension will not be displayed. The FCCS_No Intercompany member of the ICP dimension is used for all data. Data can be stored by the intercompany partner, but no eliminations occur. An extra custom dimension is available. 58.- 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. An adjustment to January by Q adjusts cash with a debit of 5. Which two statements regarding this consolidation is correct?. January and February should be consolidated for AceCo. January and February should be consolidated for Q, and the change will aggregate automatically to AceCo. Calculation Status for Q for January and February changes to Impacted. Calculation Status for both Q and AceCo for January and February changes to Impacted. 59.- Depending on the functionality you require for your FCC business process, the system enables only the dimensions that are needed. When you create an application, the system creates the Consolidation dimension with a hierarchy of seeded members. Which seeded member of the Consolidation dimension represents the dynamic aggregation of Entity Input and Entity Consolidation?. FCCS_Entity Total. FCCS_TotalInputAndAdjusted. FCCS_Entity Consolidation. FCCS_Contribution. 60.- An approval unit hierarchy identifies entities that are part of the review or approval process. You want to set up an approval process. Which two statements are true about setting up approval unit hierarchies?. Approval unit hierarchies are assigned to a scenario, year, and period combination to be used for review purposes. The first owner defined in the promotional path can assign approvers and reviewers. When an application is created, the system automatically creates an approval unit hierarchy named Total Entity Hierarchy. An approval unit hierarchy can be only created, modified, or deleted by a Service Administrator. 61.- As an administrator, you want to automate tasks and perform them remotely using the EPM Automate tool. Which two are Financial Consolidation and Close tasks that you can perform using EPM Automate?. Export journals. Load a data file. Import journals. Run a business rule. 62.- You need to translate currencies during the consolidation process. Which two conditions must be met for foreign currency translation to take place during the default consolidation process?. To specify exchange rates, you must set up multiple currencies when creating an application. The default currency of the child is different from the default currency of the parent. Reporting currencies have been defined in the Currency dimension. The child entity is NOT a shared entity. 63.- After you define an approval group, you assign it to an approval unit hierarchy. You can create as many approval groups as you want for an application. How many approval groups can you assign to an approval unit hierarchy?. 20. 50. No limit. 5. 64.- You are specifying the workflow parameters for an Enterprise Journals template. You want journals created based on this template to be posted as soon as the preparation is done. Which option should you choose in the Workflow section?. Prepare and then Approve” as the Workflow option, and then “Prepare and then Post. Post after Preparation” as the Workflow option, and then “Prepare and then Post. Prepare and then Post” as the Workflow option, and then “Post. Prepare and then Approve” as the Workflow option, and then “Post after Preparation. 65.- When you create an approval unit hierarchy, the system includes a default FCCS_DefaultGroup. Which two statements are true about this group?. It includes all accounts not included in any other approval group. It is always the last submission phase in the approval unit hierarchy. It is always the first submission phase in the approval unit hierarchy. You can delete it if you are defining your own approval groups. 66.- After all supplemental data approvals are done and the workflow option is Post, which Supplemental Data workflow role is required to Post to General Ledger in Financial Consolidation and Close?. Preparer. Approver. Integrator. Administrator. 67.- You have added a new task to a close schedule with a task due date past the defined end date of the schedule. What is the result of the change?. The task will not run. It results in an error, because you cannot add a new task past the due date. The schedule end date changes to match the end date of the task. The new task will run outside of the schedule end date. 68.- You need to create a journal that allows you to enter line item values in a single currency for all entries in the journal, even if the application has multiple currencies enabled. Which action would you perform?. Click the Currency dimension in the Journal Point of View and select a currency. Enable the Currency dimension in the journal line items, and select the same currency for all line items. Create a member in the Data Source dimension with Journal for Specific Currency and assign a currency, and then select it. Create a Journals group, select a currency for the group, and then add the journal to the group. 69.- You want to create a journal template to post adjustments that have common information such as vendor or account. Which two statements are true about recurring journal templates?. Recurring templates contain complete information for identical journal entries needed for more than one period. A user with only the Viewer role can perform all actions for recurring journal templates. You must have the System Administrator role to create and manage journal entry templates. Recurring journals are automatically created with a Working status when the period is opened. 70.- You want to export data to analyze the values in Excel or import the file into another environment. Which delimiter options are available for Financial Consolidation and Close export files?. Comma, Tab, and Fixed Width. Fixed Width, Comma, and User-defined. Tab, Comma, and User-defined. Tab, Comma, and User-defined. 71.- You want to use Access Control to assign a consolidation journal application role to a user to allow the user to create, modify, and delete consolidation journals. Which application role do you assign?. Consolidation Journals – Delete. Consolidation Journals – Create. Consolidation Journals – Manage. Consolidation Journals – Modify. 72.- When you create an FCC business process, the system creates the Currency dimension. However, it is only displayed if the application is a Multi-Currency application. Which four members are included in the Currency dimension?. Input Currencies, Journal Currency, Entity Currency, and Parent Currency. Input Currencies, Default Currency, Entity Currency, and Parent Currency. Default Currency, Entity Currency, Parent Currency, and Journal Input Currencies. Reporting Currencies, Input Currencies, Entity Currency, and Parent Currency. 73.- When you create an application, the Movement dimension is created by default with seeded members and system members are added based on the optional features that you enable. Which two tasks are you able to perform using the Movement dimension?. Create cash flow members and hierarchies for Cash Flow Reporting in the Entity and Product dimensions. Automatically generate the Cash Flow due to the segregation of movements based on cash flow categories. Create member formulas for Movement dimension members to improve consolidation performance. View details of the cash flow movements when viewing the Balance Sheet. 74.- Multiple consolidation methods are established to facilitate consolidation and elimination rules. Which statement is FALSE about the Holding consolidation method?. The Control setting for the Holding method is Yes. The immediate parent of the legal entity with the Holding consolidation method represents that entity’s consolidated results. The ownership percentage for entities with the Holding consolidation method must be 90% or greater. The Holding consolidation method can be applied to only one child entity per parent. 75.- You want to create an integration in Data Integration to import data into the Forecast scenario in Financial Consolidation and Close. Which is a required action to accomplish this?. In the Map Dimensions tab in the integration, map the column for Scenario in the source to the Scenario dimension in the target. In Category Mapping, map a source category to the Forecast member in the target. In Application Options, enter Forecast as the default member for the Scenario dimension. In the Map Members tab in the integration, use an Is Like map type to map all source records to the Forecast member in the Target. 76.- When you create an application, you can enable the Ownership Management feature, which allows you to assign ownership percentages and consolidation methods. Ownership Management can be enabled with or without Equity Pick-up. Which statement is true about Equity Pick-up?. The Equity Pick-up option writes data to the Elimination consolidation member of a sibling of the entity being processed. Selecting the Equity Pick-up option allows you to enable rules to write data to a partner member. It is a method of re-evaluating the ownership percentages owned by a subsidiary company, allowing the parent to automatically modify its consolidation methods. It is a method of re-evaluating the investments owned by a holding company, allowing the parent to realize changes in equity. 77.- You want to use the EPM Automate utility to automate frequently used day-to-day tasks from the command line. Which statement about EPM Automate is FALSE?. You use your EPM Cloud Identity Domain credentials to log in to EPM Automate. You must be a Service Administrator to execute tasks using EPM Automate. Files are exported to the server’s Outbox folder by default. You can run business rules using EPM Automate. 78.- Financial Consolidation and Close implements several security layers. For which two artifacts in an application can a Service Administrator or creator of an artifact assign access permissions to users and groups?. Smart Lists. Report Lists. Forms. Journals. 79.- You can refresh the database on the Application page. You must refresh it whenever you change the structure. Which action requires refreshing the database?. You change the ownership percentage for an entity. You edit the alias for a member in the Entity dimension. You edit the Consolidation Operator for a member in the Account dimension. You deploy a new Configurable Calculation rule in Calculation Manager. 80.- You are assigned to a role that allows you to run a consolidation. You also have Write access to the parent entity to be consolidated. Which statement is FALSE about running consolidations?. When you consolidate an entity for a period, prior periods with the Impacted calculation status are also consolidated. When you run consolidation for a child with the Impacted calculation status, the parent entity is also re-consolidated. Running consolidation using the Force Consolidate option consolidates entities with any calculation status other than OK or NO DATA. When you consolidate a parent, children with the Impacted calculation status are also consolidated. 81.- You can set up a schedule to define a chronologically-ordered set of tasks for a business process. Which two statements are true about Task Manager schedules?. You can change the status of a schedule from Pending to Open, or from Open to Closed or Locked. You can change the status of a schedule that has been locked to Open or Closed. After a schedule is set to Open, it cannot be reset to Pending. You must use a template to create a schedule. 82.- You can view the calculation status in forms and grids and then take action as necessary. For which four dimensions does Financial Consolidation and Close maintain the calculation status?. Scenario, Entity, Year, and Period. Entity, Consolidation, Year, and Period. Consolidation, Entity, Year, and Period. Year, Consolidation, Entity, and Data Source. 83.- You are creating a data integration between Financial Consolidation and Close and another data source. Which two tasks must you perform before you can begin creating a data integration?. Map data management scenarios to Financial Consolidation and Close properties. Specify that certain products are valid only for some entities and accounts. Map data management periods to years and periods in Financial Consolidation and Close. Register your Financial Consolidation and Close application and configure consolidation options. 84.- As an administrator, you define which dimensions have security. Once security is enabled for a dimension, users and groups can be given access to the members in the dimension. Which two statements are true about assigning security access to dimension members?. When you assign access to a parent member, you can specify that the access will include its descendants. If a user has Read access to the Account member and Write access to the Scenario member of a cell in a data form, the user receives Write access to the cell. If a user has Read access to the Account member and Write access to the Scenario member for a cell in a data form, the user receives Read access to the cell. The default access to members in a dimension for which security is enabled is Write. 85.- As an administrator, you can set up the approval process to transfer the ownership of data, make sure that review control is in place, and ensure that data privacy is maintained. Approval units are part of the approval process and represent blocks of data. Which four dimensions constitute an approval unit?. Year, Account, Entity, and Scenario. Period, Year, Entity, and Scenario. Account, Year, Data Source, and Entity. Data Source, Year, Entity, and Scenario. 86.- You want to assign an approval template to an approval unit hierarchy to determine the actions and approval path taken when the approval unit is started. You have the option to choose between two approval template types: Consolidation or Consolidation Bottom Up. Which two statements best describe the Consolidation approval template type?. If the Consolidation approval template is assigned, the Exclude action removes the approval history and changes the status back to Locked. Assign the Consolidation approval template if you want users to be able to take actions, such as moving the approval unit to the next reviewer. If the Consolidation approval template is assigned, when an administrator starts the approval process by performing the Start action, the status changes to Unlocked. Assign the Consolidation approval template if you just want to use the approval for locking purposes only. 87.- When configuring the Financial Consolidation and Close business process, you can select the applicable ratio calculations that you want to include. Which four sample ratios can be added during business process creation?. Earnings per Share, Days Sales in Receivables, Gross Margin, and Inventory Ratios. Contribution Margin, Debt Ratio, Inventory Ratios, and Days Sales in Receivables. Debt Ratio, Inventory Ratios, Days Sales in Receivables, and Gross Margin. Inventory Ratios, Contribution Margin, Earnings per Share, and Gross Margin. 88.- The accounts Sales and Cost of Sales aggregate to the parent account Total Revenue How can you configure the accounts so that Sales increases Total Revenue and Cost of Sales decreases Total Revenue?. Load negative values to the Cost of Sales account. Set the Account Type property for Sales to Revenue and Cost of Sales to Expense. Set the Consolidation Operator for Sales to Addition and Cost of Sales to Subtraction. Add a member formula to Cost of Sales to reverse the sign. 89.- A company has two subsidiaries with 1000 EURO each in the Cash account. If the consolidation percentage is 100% for the subsidiaries, which four Consolidation dimension members of the parent company will have a value of 2000 EURO?. FCCS_Entity Total, FCCS_Entity Consolidation, FCCS_Proportion, FCCS_Contribution. FCCS_Entity Input, FCCS_Elimination, FCCS_Amount Override, FCCS_Proportion. FCCS_Proportion, FCCS_Elimination, FCCS_Entity Total, FCCS_Entity Consolidation. FCCS_Entity Consolidation, FCCS_Entity Input, FCCS_Proportion, FCCS_Contribution. 90.- You can migrate an existing application to one with the Period and Movement dimensions as the dense dimensions. After you run the migration utility, which is true for members in the Movement dimension?. The Data Storage option for parent members must be set to Never Share. The Data Storage option for parent members must be set to Dynamic Calc. The Consolidation Operator for Movement members must be set to Ignore. The Data Storage option for parent members must be set to Store. 91.- When importing data, you apply target expressions instead of member mappings to perform simple data transformations. Which two statements are true about using target expressions?. If you do not define target expressions, you must add a mapping for each dimension. If your data transformations can be achieved using target expression, Oracle recommends using target expressions instead of mapping members. Transformations using member mappings perform significantly better than target expressions for large data sets. If you have defined target expressions to derive the target members for a given dimension, then you have to define member mappings. 92.- The company PQR has an ownership structure as shown above. H_1 has an intercompany transaction with P_2. For which entity or entities does consolidation need to be run in order for the transaction to be eliminated?. Hickory and Paducah. PQR. No elimination is performed, because H_1 and P_1 do not have the same parent. H_1 and P_2. |





