960-21 Oracle Cloud GL 01

How do Cross Validation Rules (CVRs) handle existing violations in the Code Combinations Identification (CCID) table?. Nothing has changed. If you have an invalid account combination existing in the table, you must deactivate it to prevent further usage. CVRs are assigned to the end user role; therefore controlling what account code combination individuals can leverage in the General Ledger and the subledgers. CVRs only test new account combinations being inserted into the table. They ignore any invalid account combinations already existing in the table. If CVR determines that an invalid combination exists in the CCID table, it will automatically disable that account code combination.

Which two methods can your General Ledger accountants use to more easily view large amounts of data contained in the tables in their work areas? (Choose two.). Use the Freeze feature on the tables to scroll through large amounts of data. Run a Business Intelligence Publisher report with Excel as the output format. Export the table to Excel. Detach the table to resize it to the maximum size of the monitor.

You set up a secondary ledger using the Manage Secondary Ledger task and selected a data conversion level of subledger. Which two actions should you now perform? (Choose two.). Ensure that the Accounting Calendar and Currency are the same as the Primary Ledger. Define Journal Conversion Rules that include subledgers in order to transfer subledger transactions. Define Journal Conversion Rules that exclude subledgers. Assign a Subledger Accounting Method to the secondary ledger. Define Supporting References with balances.

Your enterprise structure has one ledger and two business units. Business unit one wants to enable budgetary control for Requisitioning only on Procure-to-Pay Business Functions and business unit two wants to enable budgetary control for Payable Invoicing only in Procure-to-Pay Business Functions. Which two statements are correct? (Choose two). While defining control for business unit two, enable control at Requisitioning and define the exceptions to only include invoicing. While defining control for business unit one, enable control at purchasing and define the exceptions to only include requisitioning. Define budgetary control at ledger level with Budgetary Control Exceptions for each business unit. While defining control for business unit one, disable control for Purchasing, Payable Invoicing, and Receiving. Define budgetary control at ledger level and only encumbrance control at the business units. Define control for business unit two to disable control for Requisitioning, Purchasing, and Receiving.

What are the two benefits of having the Essbase cube embedded in General Ledger Cloud? (Choose two.). Posting performance is much faster. Integrating with third-party systems is easier because the Essbase cube provides chart of accounts mapping rules. General ledger balances are multidimensional, allowing you to perform robust reporting and analysis. You can access real-time results for reporting and analysis because every time a transaction is posted in General Ledger, multidimensional balances are also updated simultaneously. You no longer need to create and maintain hierarchies because the Essbase cubes are created when you create your chart of accounts.

Which tool can you use to create a Financial Income Statement?. One View Reporting. PS/nVision. Account Inspector. Rapid Implementation Enterprise Structures setup.

Which feature outside of reporting and analysis leverages the Essbase cube?. revaluations and translation to revalue and translate currencies stored in the Essbase cube. calculation manager to perform allocations based on multidimensional balances and budgets. period closing and opening of ledgers to keep General Ledger Cloud and the Essbase cubes in sync. journal entries and journal approval to create journals that update balances to the cube directly.

Your customer has enabled budgetary control for purchase orders. They have a purchase order for $1,000 USD which is fully reserved. An invoice for $600 is entered and matched to the purchase order, and the purchase order is closed for further invoicing. What happens to the remaining $400 USD?. Invoice type will have less funds available by $400 USD. $400 USD will be expired and not available for use. $400 USD will be added back to available funds. Only obligation type will have $400 USD funds available. Manual encumbrance journal needs to be entered in General Ledger to release the budget amount of $400 USD.

Your customer has three legal entities, 50 departments, and 10,000 natural accounts. They use intercompany entries. What is Oracle's recommended practice when implementing a new chart of accounts?. Define three segments for the company, department, and natural account. The qualifiers for the first segment should be primary balancing segment and intercompany segment, cost center segment, and natural account segment, respectively. Define four segments for the company, department, natural account, and intercompany segment. The qualifiers should be primary balancing segment, cost center segment, and natural account segment, and intercompany segment, respectively. Define three segments for the company, department, and natural account. The qualifiers should be primary balancing segment, cost center segment, and natural account segment, respectively. Define five segments for the company, department, natural account, intercompany, and future use segment. The qualifiers should be primary balancing segment, cost center segment, natural account segment, intercompany segment, and no qualifier, respectively.

Which reporting tool is best suited for submitting high-volume transactional reports, such as Invoice Registers or Trial Balance reports, that can be configured to extract the data in Rich Text Format or xml?. Oracle Transactional Business Intelligence (OTBI). Business Intelligence Publisher (BI Publisher). Financial Reporting Center. Smart View. Oracle Data Visualization Cloud Service.

Your company has complex consolidation requirements with multiple general ledger instances. You are using Oracle Hyperion Financial Management to consolidate the disparate General Ledgers. You can typically map segments between your general ledger segment to a Hyperion Financial Management segment, such as Company to Entity, Department to Department, and Account to Account. What happens to segments in your source general ledger, such as Program, that cannot be mapped to Hyperion Financial Management. (Examen). Data is summarized across segments that are not mapped to Hyperion Financial Management. The unmapped segments default to future use segments in Hyperion Financial Management. No data is transferred. Errors occur for unmapped segments. You must map multiple segments from source general ledgers to the target segment in Hyperion Financial Management.

You want to define an allocation rule where segment values are constants for rules and formulas. What should you do?. Never use the Outer Point of View (POV). Always use the Outer Point of View (POV). Specify Run Time Prompts (RTP). Only specify segment values in formulas.

You want to process multiple allocations at the same time. What feature do you use?. RuleSets. Formulas. General Ledger journal entries. Point of View (POV).

You are creating financial statements and want to have charts, such as a bar graph, automatically inserted to improve the understanding financial results. How would you achieve this?. Use Smart View, which is an Excel Add-on. Use Account Inspector that automatically creates graphs on financial balances. When viewing the report, download to Excel and use Excel's Charting features to create your bar graph. When designing your financial statement using Financial Report (FR), embed a chart into your report.

Identify three roles that get access to the reports in the Fusion Accounting Hub Reporting Cloud Service (FAHRCS). (Choose three.). Controller. General Accountant. General Accountant Manager. Business Intelligence Administrator (BI Admin). Financial Analyst.

You want to monitor the close process of all your financial subledgers and ledgers. How can you quickly obtain this information? (Examen). Use the Manage Accounting Periods page to view the status of all subledgers and ledgers. Access each subledgers' calendar and General Ledger's Manage Accounting Periods page to view the status of each period. Run Closing Status reports. Use Close Monitor in General Accounting Dashboard.

Encumbrance accounting is enabled for your ledger. An encumbrance journal dated 3/15/16 was recorded for a purchase order. The invoice was entered on 5/5/16, but the invoice accounting date was 4/20/16. The encumbrance journal for liquidating the purchase order encumbrance is dated 5/5/16. What is causing this?. The actual accounting date was set up under the encumbrance accounting Default Date Rule. The current transaction accounting date was set up under the encumbrance accounting Default Date Rule. The subledger accounting option is set to system date. The system date was set up under the encumbrance accounting Default Date Rule. The prior related transaction accounting date was set up under the encumbrance accounting Default Date Rule.

In Financial Cloud, which three reporting tools can be used to access General Ledger balances? (Choose three.). Application Composer. Oracle Enterprise Repository. Oracle Transactions Business Intelligence. Financial Reporting Studio. Smart View.

Your user forgot the password. How do you resolve this?. Use the Manage Users page to update the user's information and change the password. Use Oracle Identity Management (OIM) to reset the user's password. Log in to the user's machine as an Administrator and change the password from the login password. Use Access Policy Manager (APM) to reset the user's password. Create a new user ID and password for the user.

How do you hide accounts with no balances showing #Missing in Smart view?. Select the Data/Missing check box in the Data Options tab. Use Excel functions to hide rows with #Missing assigned. Choose the Suppress Zeros option under Data options. This indicates a database connection issue. Try to reconnect to Fusion Applications.

Which report show you differences between your subledger balances and General Ledger balances? (Examen). Payables Trial Balance, Receivables Trial Balance, and General Ledger Trial Balance reports. Payables and Receivables Aging Reports with the General Ledger Trial Balance report. Payables to Ledger Reconciliation Report and the Receivables to Ledger Reconciliation Report. General Ledger Financial Statements and the Accounts Payable and Accounts Receivables Invoice Registers.

You need to define multiple allocation rules as efficiently as possible. Which three components can be reused across allocation rules?. Point of View (POV). Run Time Prompts (RTP). Formulas. Rule Sets.

The budget managers specify the budget accounts they want to monitor and decide on percentage threshold of funds availability. Where must you define the details while analyzing budget balances in the Budget Account Monitor page?. Budget Group. Application Development framework Desktop Integral ion (ADFdi). Account Group. Budget Controller. Budget Account Group.

Your company wants to change the Cumulative Translation Adjustment (CTA) account to record gains/losses from varying currency rates. What steps must you perform to achieve this objective without causing data corruption?. Define a new ledger and accounting configuration. The СТА account cannot be updated after the ledger has been in use. Query the Translation journals and delete all of them, then change the СТА account in the Ledger page, and rerun Translation for all periods required. Open the Ledgers page and update the СТА account and then rerun Translation for all periods required. The system will automatically update the translated balances. Purge all translated balances, change the СТА account in the Ledger page, and rerun Translation for all periods required.

You operate in a country whose unstable currency makes it unsuitable for managing your day-to-day business. As a consequence, you need to manage your business in a more stable currency while retaining the ability to report in the unstable local currency. what would be your recommendation when defining ledgers?. Create a secondary ledger that uses a different chart of accounts that is denominated in the more stable currency. User Journal-Level or Subledger-Level Reporting Currencies denominated in the more stable currency. Run Revaluation as often as you need to the more stable currency and report on the more stable currency's balances. Define Balance-level Reporting currencies in the more stable currency and run Translation as often as you need.

Which three reporting tools are based on real-time data or balances?. Smart view. Oracle Financial Reporting (FR). Oracle Business Intelligence Applications (OBIA). Business Intelligence Publisher (BI Publisher). Oracle Transactional Business Intelligence (OTBI).

You already ran Translation, but a last-minute adjusting journal entry in your ledger currency was entered after you consolidated your results. What is Oracle's recommended practice when this occurs? (Examen). Rerun Translation and then reconsolidate your results. Rerun Revaluation and then rerun Translation. Translate only the adjusting journal entry. Enter another adjusting journal entry in the target currency to true up the balances.

You entered users who are both employees and contingent workers. You want an automated way to assign, reassign, and remove roles from users. What feature do you use?. ACCESS POLICY MANAGER'S ROLE GENERATION. ORACLE IDENTITY MANAGER ROLES ASSIGNMENT. DATA ROLES. YOU CANNOT REASSIGN CONTINGENT WORKERS. ROLE MAPPINGS.

Your customer wants to secure their primary balancing segment values to prevent employees of one company from entering or viewing data of another company. You only need this for General Ledger balances and reporting. What two security features should you use?. Balancing Segment Value Assignment to Legal Entities. Segment Value Security. Cross-Validation Rules. Data Access Sets using an Access Set Type of Primary Balancing Segment.

Your customer wants to control spending against an annual budget but report balances on a monthly year-to-date basis. Encumbrance accounting is also in use. What setup is required to achieve this requirement. Create two detail control budgets: annually with absolute control and monthly with advisory or track control. Create a Summary budget annually with absolute* control and monthly control budget with advisory or track control. Create a summary budget annually with advisory control and control budget monthly with absolute control. Create an annual budget with absolute control and so encumbrance accounting will work. Create two detail control budgets: annually with advisory/track control and monthly with absolute control.

You need to define a chart of accounts includes a intercompany segment. Your customer plans to use segment value security rules for the company segment. What is Oracle's recommended method to define this chart of accounts?. Use two different value sets for the company and intercompany segment because segment value security rules are at the value set level. Define Two Different Chart of Accounts. Define the company segment only and qualify it as both primary balancing segment and intercompany segment. Share the same value set for the company and intercompany segments to reduce chart of accounts maintenance.

You are defining intercompany balancing rules that are applied to a specific source and category, such as payables and invoices, or a specific intercompany transaction type, such as intercompany sales. Which two statements are correct? (Choose Two) (Examen). You can create a rule for all sources and categories by selecting the source "Other" and the category "Other". Set up a chart of accounts rule for every chart of accounts structure you have in order to ensure that intercompany balancing will always find a rule to use to generate balancing accounts. If you choose to have rules at various levels, then intercompany balancing evaluates the rules in this order: Ledger, Legal Entity, chart of accounts, and primary balancing segment value. You must define rules for every combination of specific categories and sources. Otherwise, the intercompany balancing will not work.

When working with Essbase, versions of the tree hierarchy as defined in the General Ledger Cloud are not available in the Essbase balances cube. What should you do to correct this situation? (Examen). Make sure to flatten the rows of the tree version. Make sure the tree is active. Make sure the tree version was published successfully. Redeploy the chart of accounts.

You are setting up Close Monitor, which compromises a ledger set hierarchy definition. Which two components of the enterprise structure should the ledgers in the ledger set share? (Choose two.). Accounting Calendar. Legal Entities, Business Units, and Chart of Accounts. Chart of Accounts. Chart of Accounts and Business Units. Chart of Accounts, Currency, Accounting Calendar, and Subledger Accounting Method.

You want to enter budget data in General Ledger Cloud. Which method is not supported?. File – based Data Import. Direct budget balance updates from a Financial Statement in Smart View. Entering budget journals. Application Development Framework Dekstop Integration (ADFdi).

What are the two purposes of a secondary ledger? (Choose two.). It should only be used to main balances for processing performance. It is used to main balances in a different currency only. It is an optional ledger that is linked to a primary ledger for the purpose of tracking alternative accounting. It can differ from its primary ledger by the accounting method, char of accounts, accounting calendar, currency and/or journal processing options.

Your customer uses Financials Cloud, Projects, Inventory and Procurement. Which two statements are true regarding intercompany accounting for these products? (Choose two.) (Examen). Each product hat its own intercompany Accounting feature that need to be set up separately. Intercompany Balancing Rules are defined centrally and applied across Financials and Project Portfolio Management. They need to license a separate stand-alone intercompany product that acts as the intercompany accounting hub. Within Financials Cloud, Intercompany Balancing Rules are used to balance both cross-ledger intercompany transactions ans single-ledger intercompany journals.

What is the most efficient way to add a new year to the accounting calendar?. Import the periods from a spreadsheet. Use the Add Year button. Add the periods manually. The application automatically populates the next year when you open the first period of a new fiscal year.

How can your Accounting Manager expedite journal processing during the time-critical month-end close?. By using the journal region to view journals Requiring Attention, Requiring Approval ans Pending Approval from Other. By using the Close Status monitor to drill down on the close status across ledgers. By running the Journals report using Business Intelligence Publisher. By creating an ad hoc query on journals using Oracle Transactional Business Intelligence (OTBI).

Which two statements are true regarding how Intercompany Balancing Rule are defined? (Choose two.). You can define different rules for different chars of accounts, ledgers, legal entities, and primary balancing segment values. You can only define balancing rules for different journals sources. You cannot define balancing rules for different rules categories. All ledger engaged in an intercompany transaction must share the same chart of accounts in order to define balancing rules. You can define different balancing rules to different combinations of journal sources, journal categories and transaction types. You cannot define balancing rules for different journal categories.

Management has added a requirement to segregate the duties of transferring journals to the General Ledger from the posting function. Which two new features allow this segregation? (Choose two.). For previously schedule automated processes, it is recommended to cancel and rescheduled the process for the option to be effective. Uncheck the Enable Posting from the Manage Subledger Accounting Options task. Must have separate user defined roles using the privilege XLA_CREATE_GENERAL_LEDGER_AND_SUBLEDGER_JPURNALS. Journal entry spreadsheets are not impacted by this new function.

Identify three differences between Oracle Transactional Business Intelligence (OTBI) and Oracle Business Intelligence Applications (OBIA). (Choose three.). OBIA works for multiple sources including E-Business Suite, PeopleSoft, JD Edwards, SAP and Cloud Applications. OTBI allows you to create custom reports from real-time transactional data assign the database directly. Both OBIA and OTBI provide a set of predefined reports and dashboards and a library of metrics that help to measure business performance. Cloud customers can use both OTBI and OTBIA. OBIA is based on the universal data warehouse design with different prebuilt adapters that can connect to various source applications.

Your customer is implementing budgetary control with encumbrance accounting. Your customer has businesses in Australia, New Zealand, and Singapore with a ledger in each country with a Corporate chart of account instance that has four segments. Which three statements are true regarding the creation of a control budget? (Choose three.). Control budgets are always absolute to generate encumbrance accounting. A control budget can allow override rules only if the control level is absolute. A control budget can be associated with a different calendar than accounting calendar. The control budget structure has all the chart of account segments as budget segments. A control budget is associated to a ledger and creates three control budgets for Australia, New Zealand, and Singapore.

You are implementing Segment Value Security rules. Which two statements are true? (Choose two.). The segment value security rules do not take effect until you assign the rules to users and products. When you enable segment value security on a segment, users will not be able to access any values until you grant access to users and products. You can use hierarchies to define rules. When you enable or disable segment value security, you do not need to reply your chart of accounts.

Your customer wants to use a clearing company to automatically balance intercompany entries. Which three statements are true regarding the use of a clearing company value? (Choose three.). If you map legal entities to balancing segment values, then a clearing company can only be applied within a legal entity. You must map legal entities to balancing segment values in order to use a clearing company. Clearing companies are not supported. If you do not map legal entities to balancing segment values, then a clearing company can be applied to any journal within the ledger. If you choose to use clearing company, you can define a default clearing company value or select the clearing company value directly in the general ledger journal.

Your customer wants to have balance sheets and income statements for its cost center and program segments. That is, the customer wants to have three balancing segments. Which two recommendations would you give your customer? (Choose two.). When entering journals manually, the customer will need to make sure that debits and credits are equal across all balancing segments because the system will not automatically balance the journal. Every journal where debits do not equal credits across the three balancing segments will result in the system generating extra journal lines to balance the entry. Define Ledger balancing options to balance by second and third balancing segments. Additional intercompany rules will need to be defined for the two additional balancing segments.

The Delete Translated Balances process provides the ability to completely reset translations in the event that significant changes are made to the accounting configuration. Once the deletion process completes, what additional process must you run?. Submit the Update General Ledger Balances Cube process to ensure that the balances cube maintains translated balances that are consistent with future translations. Submit the Create Currency Dimension Members process to ensure that the balances cube maintains translated balances that are consistent with future translations. Submit the Create Scenario Dimension Members process to ensure that the balances cube maintains translated balances that are consistent with future translations. Submit the Create General Ledger Balances Cube process to ensure that the balances cube maintains translated balances that are consistent with future translations.

Account combinations can be created and/or modified using the Import Account Combinations file-based data import (FBDI). Which represents the appropriate upload steps?. Submit the Import Account Combinations process, then insert rows into the GL_MULTI_COMBINATIONS_INT table using the FBDI template. Submit the Import Account Combinations process, then insert rows into the GL_BULK_COMBINATIONS_INT table using the FBDI template. Insert rows into the GL_BULK_COMBINATIONS_INT table using the FBDI template and then submit the Import Account Combinations process. Insert rows into the GL_MULTI_COMBINATIONS_INT table using the FBDI template and then submit the Import Account Combinations process.

You are defining an income statement report. You want to allow viewers of the report to be able to drill down from report balances to the underlying transactions. What so you need to enable? (UPDATED) (Examen). Allow expansion. Report functions. Drill through in grid properties. Nothing, all report balances are drillable in all FR studio reports.

After loading your budget data into General Ledger Cloud, you can view budget balances using these features. Which feature does not belong on the list?. Account inspector. Application development framework desktop integrations budget balances report. Smart view. Account monitor.