Examen GL Oracle cloud 2023

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?. 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 monitor the close process of all your financial subledgers and ledgers. How can you quickly obtain this information?. 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.

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? How many segments and what segment qualifiers should be used?. 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 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.

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.

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?. Application Development Framework Desktop Integration Budget Balances Report. Account Monitor. Smart View. Account Inspector.

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.). The control budget structure has all the chart of account segments as budget segments. Control budgets are always absolute to generate encumbrance accounting. A control budget is associated to a ledger and creates three control budgets for Australia, New Zealand, and Singapore. 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.

You need to define multiple allocation rules as efficiency as possible. Which three components can be reused across allocation rules? (Choose three.). Point of View (POV). Formulas. Run Time Prompts (RTP). 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 Controller. Budget Group. Account Group. Budget Account Group. Application Development Framework Desktop Integration (ADFdi).

What are the two possible reasons for encumbrance created on the purchase order to go back to the budget or funds availability? (Choose two.). The purchase order is canceled or finally closed or rejected without performing any receipt or invoice. When the purchase order is set to accrue at receipt and partially received, then canceled or finally closed, encumbrance goes back to the extent of the un received amount. The requisition reserved successfully undergoes amendment and is rejected in the reapproval. When the requisition is set to accrue at period end and partially billed and then canceled or finally closed, encumbrance goes back to the budget to the extent of the unbilled amount.

Your customer has many eliminating entries to eliminate intercompany balances. The General Ledger does not include a purpose-built Consolidation feature. How would you automate the process of creating eliminating entries, assuming your customer is not using Oracle Hyperion Financial Close Management?. Use the General Ledger’s Calculation Manager to define an allocation definition to eliminate entries that you can generate every period. Use the spreadsheet template that is accessed from the “Create Journal in Spreadsheet” task and import the spreadsheet with the eliminating entries every period. There is no way to automate this process if the customer is not using Oracle Hyperion Financial Close Management. Create a manual journal that includes the eliminating entries, and then create a copy of the journal batch every period.

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.

You are implementing Segment Value Security rules. Which two statements are true? (Choose two.). 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 redeploy your chart of accounts. The Segment Value Security rules do not take effect until you assign the rules to users and products.

You want to specify Intercompany System Options. Which three factors should you consider? (Choose three.). whether to enforce an enterprise-wide currency or allow intercompany transactions in local currencies. whether to allow receivers to reject intercompany transactions. automatic or manual batch numbering and the minimum transaction amount. automatic or manual batch numbering and the maximum transaction amount. the approvers who will approve intercompany transactions.

The Accounting Manager requests that a schedule be created to automatically post journals from subledgers at different times. Which journal attribute should you use to set the automatic posting criteria?. Journal Source. Journal Category. Journal Batch. Journal Description.

Encumbrance accounting is enabled for your ledger. An encumbrance journal dated 3/15/19 was recorded for a purchase order. The invoice was entered on 5/5/19, but the invoice accounting date was 4/20/19. The encumbrance journal for liquidating the purchase order encumbrance is dated 5/5/19. 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.

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. 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. Submit the Import Account Combinations process, then insert rows into the GL_BULK_COMBINATIONS_INT table using the FBDI template.

You are defining an income statement report. You want to allow viewers of the report to be able to drilldown from report balances to the under lying transactions. What so you need to enable?. Drill Through in Grid Properties. Nothing. All report balances are drillable in all FR Studio reports. Allow Expansion. Report Functions.

Which three objectives must be considered when designing the chart of accounts? (Choose three.). Anticipate growth and maintenance needs as organizational changes occur. Effectively manage an organization’s financial business. Try to use all 30 segments and 25 characters per segment because you cannot change it later. Consider implementing a single, global chart of accounts. Limit the number of segments to those you need today to reduce data entry.

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.

Budgetary control for accounts 5020 and 5021 has a budget of $90,000USD each for the year 2012. The accounts also have balances on obligation of $10,000 USD for each and an expenditure of $20,000 USD for each. AFundof$50,000 USD is available for account 5010 only. You have run the Encumbrance Year End Carry Forward process for obligation from the last period of the year 2012 to the first period of year 2013. Which statement is true?. If you have included 5020 and 5021 in the encumbrance rule, then budget balances $90,000 USD, obligation $10,000 USD, and expenditure $20,000 USD, and the funds available $50,000 USD will be carried forward. The Encumbrance Year End Carry Forward process will run for all the accounts to carry forward the general ledger balances. If you have included 5020 and 5021 in the encumbrance rule, then obligation $10,000 USD and expenditure $20,000 USD only will be carried forward. If you have included 5020 and 5021 in the encumbrance rule, the budget balances $90,000 USD, obligation $10,000 USD and expenditure $20,000 USD only will be carried forward. If you have included 5020 and 5021 in the encumbrance rule, then only the obligation of $10,000 USD will be carried forward.

Your customer wants to create fully balanced balance sheets for the Company, Line of Business, and Product segments for both financial and management reporting. What is Oracle’s recommended method for doing this?. Create a segment that acts as the primary balancing segment and create values that represent a concatenation of all three business dimensions. Use account hierarchies to create different hierarchies for different purposes and use those hierarchies for reporting. Create three segments for the Company, Line of Business, and Product segments and qualify them as primary balancing segment, second, and third balancing segments, respectively. Create two segments where the first segment represents the concatenation of Company and Line of Business, and then enable secondary tracking for the Product segment.

Your customer uses Financials Cloud, Projects, Inventory and Procurement. Which two statements are true regarding intercompany accounting for these products? (Choose two.). Each product has its own Intercompany Accounting feature that needs to be set up separately. Within Financials Cloud, Intercompany Balancing Rules are used to balance both cross-ledger intercompany transactions and single-ledger Intercompany journals. 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.

Your new accountants have been making mistakes in reconciling accounts assigned to them. Your account balances have either spiked or dropped 30-40% every period due to human error. This causes delays in reconciliation. What feature can you use to be proactively notified of account anomalies in a more timely manner?. Account Monitor. Financial Reports with Embedded charts. Smart View. Account Inspector and its charts.

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.

You have enabled budgetary control and have a control budget set to Advisory control level. For September 2016, your budget for a given account combination is $5,000 USD. In the same month, there is an approved requisition for that account of $900 and an approved purchase order for that account of $2,500 USD. There is also a General Ledger adjustment journal entry for that account of $1,600 USD. An approved purchase order line of $400 USD is then cancelled. And an invoice is matchedtothepurchaseorderfor$2,100USD. Which two statements are true?(Choose two.). No change. Purchase order encumbrance will be released for $2,100 USD. Funds reservation only happens for non-matched invoices, so the system will not reserve funds. As there are cancellations for $400 USD, the system will partially reserve the funds in September 2016 and fully reserve it in October 2016. The system always consumes budget of future periods if the limit for the current period is expired, so October 2016 budget will be considered for reservation.

You are reconciling your subledger balances and you need a report that includes beginning and ending account balances and all transactions that constitute the account’s activities. What type of report will provide this type of information?. Account Analysis Reports. Aging Reports. an Online Transactional Business Intelligence (OTBI) report to create ad hoc queries on transactions and balances. Journals Reports.

You are defining intercompany balancing rules that are applied to a specific source and category, such as payable and invoices, or a specific intercompany transaction type, such as Intercompany Sales. Which two statements are correct? (Choose two.). You can create a rule for all sources and categories by selecting the source “Other” and the category “Other”. 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. Setup 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.

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 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.

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

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

You entered a journal and the client is asking for the following information:  The current account balance  What the future account balance will be if the journal is approved and posted How will you get this information?. Query the account balance online. Use Oracle Transactional Business Intelligence (OTBI) to query General Ledger balances. View the Projected Balances region in the Create Journals page. Run a Trial Balance before and after posting.

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).

Most of the accounting entries for transactions form your source system use TRANSACTION_AMOUNT as a source of the entered amount accounting attribute. For some events, you need to use TAX_AMOUNT as the source. At what level can you override the default accounting attribute assignment?. Journal Entry Rule Set. Event Type. Journal Line Rule. Journal Entry. Event Class.

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

Your customer requires physical invoices to be generated in Payables Cloud and Receivables Cloud for the Intercompany payables and receivables transactions. Which two statements are correct with regards to setting this up? (Choose two.). You only need to assign the Legal Entity and Organization Contact. You can only associate one Intercompany Organization per Legal Entity. You must have implemented Payables Cloud and Receivables Cloud. You must assign the corresponding Receivables and Payables Business Units.

What are the two purposes of a secondary ledger? (Choose two.). It can differ from its primary ledger by the accounting method, chart of accounts, accounting calendar, currency, and/or journal processing options. It should not be used when trying to meet local accounting requirements. 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 should only be used to main balances for processing performance.

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. 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.

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

Which subject area has been enhanced to allow you to drill down from OTBI General Ledger Reports to a General Ledger journal?. General Ledger - Journal Transaction Balances Real Time. General Ledger – Journal Balances Real Time. General Ledger – Summary Journals Real Time. General Ledger – Journals Real Time.

You need to create a month-end reporting package for an upcoming Audit Committee meeting, you have 10 financial reports that you want to share with executives and auditors that are nicely formatted. Identify the two Oracle recommended ways to accomplish this. (Choose two.). Use BI Publisher to configure the reports and then use bursting to email the reports to the executives and Audit Committee. Use a report batch to run reports at a specific time to create a set of snapshot reports. Using Workspace, assemble multiple reports into a book that can be printed and viewed individually as an entire book. Create a Smart view report, where the various sheets represent the different Financial Statements and send them the spreadsheet. Use OTBI to create multiple reports that you save to a folder that only the users can access.

The expense account of airfare was erroneously assigned tothe account type “Liability”. Which method should you choose to fix the problem?. Deactivate the value. Run the “Segment Value Inheritance” program. Run the “Correct Misclassified Account” program. Run the “Update Balance Cube Chart of the Accounting Dimension” program.

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?. Translate only the adjusting journal entry. Rerun Translation and then reconsolidate your results. Rerun Revaluation and then rerun Translation. Enter another adjusting journal entry in the target currency to true up the balances.

Which AMX builder method is most effective in routing the journals to the Accounting Manager when his subordinate, The General Accountant, enters a journal?. Supervisory level approval. Cost center based approval. Dynamic Approval Groups. Management Chain approval. Approval Groups.

You are using budgetary control. You have an open purchase order for $500 USD, and an invoice for $300 is matched to the purchase order. What will be the funds status of the purchase order and the invoice?. Both are Partially Reserved. The purchase order is Liquidated and the invoice is Partially Reserved. The purchase order is Partially Liquidated and the invoice is Partially Reserved. The purchase order is Partially Liquidated and the invoice will be Reserved. Both are reserved. The purchase order is Open and the invoice is Validated.

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.

You want to prevent intercompany transactions from being entered during the last day of the close. What should you do?. Freeze the Intercompany journal source in General Ledger. Close all subledger periods. Close the General Ledger period in the Manager Accounting Periods page. Close Intercompany periods in Fusion Intercompany.

On which three occasions are Essbase balances updated? (Choose three.). every time the tree version is published. every time you run the batch program called “Update Essbase Balances”. every time you open a new period. every time journals are posted to the general ledger. at report run-time.

You just submitted the Accounting Configuration. What two things must happen before you can enter journals? (Choose two.). You must re-deploy the chart of accounts. A Data Access Set with full read/write access to the ledger is automatically created. You must define a Data Access Set to obtain full read/write access to ledgers in the Accounting Configuration. You must assign the job role and data security context to each user.

In which two ways can your users customize the Springboards and Work Areas to suit their individual working styles? (Choose two.). Users have very little control their Springboards and Work Areas; they can only resize columns. They can use Personalization to move and remove regions from those pages. They can have the System Administration customize pages for them using Page Composer. They can format each table by hiding and showing columns, moving columns, and resizing columns.

All of your subsidiaries can share the same ledger with their parent company and all reside on the same application instance. They do perform intercompany accounting. What is Oracle’s recommended approach to performing consolidations?. Use General Ledger’s Financial Reporting functionality to produce consolidated reports by balancing segment where each report represents a different subsidiary. Any eliminating entries can be entered in yet another separate balancing segment. Use Oracle Hyperion Financial Management for this type of complex consolidation. Use General Ledger’s Balance Transfer programs to transfer subsidiary ledger balances to the parent ledger, and then enter eliminating entries as a separate balancing segment in the parent ledger. Define multiple ledgers for consolidation and report on ledger set.

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.

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

You want to be notified of anomalies in certain account balances in real time. What is the most efficient way to do this?. Create an Account Group using Account Monitor. Use Account Inspector. Open a Smart View file saved on your desktop. Perform an account analysis online.

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.

Journal Description Rules are assigned to Subledger Journal Entry Rule Sets. What are the other three subcomponents of a Subledger Journal Entry Rule Set? (Choose three.). Accounting Date. Chart of Accounts. Journal Line Rules. Account Rules. Supporting References (Description rules).

You need to define a chart of accounts that includes an 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?. Define the company segment only and qualify it as both the primary balancing segment and intercompany segment. Define two different charts of accounts. Share the same value set for the company and intercompany segments to reduce chart of accounts maintenance. Use two different value sets for the company and intercompany segment because segment value security rules are at the value set level.

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?. 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.

Management wants to use the budget transfer function available on the Review Budgetary Control Balances page. Which privilege is required to perform the budget transfer?. Import Budget Amounts from Spreadsheet (XCC_IMPORT_BUDGET_FROM_SPREADSHEETS_PRIV). Import Budget Amounts(XCC_IMPORT_BUDGET_PRIV). Manage Control Budgets(XCC_MANAGE_CONTROL_BUDGETS_PRIV). Budget Loading (XCC_BUDGET_LOADING_DUTY_PRIV).

While creating A Journal Entry Rule Set, you are not able to use an Account Rule recently created. Which two options explain that? (Choose two.). The Account Rule’s conditions are not defined. The Account Rule’s chart of accounts has no account values assigned. The Account Rule is defined with a different chart of accounts form the Journal Entry Rule Set. The Account Rule is using sources assigned to different event classes from that of the associated Journal Entry Rule Set.

Your customer is planning to have three balancing segments for generating balance sheets and income statements at cost center segment and program segment levels. D18912E1457D5D1DDCBD40AB3BF70D5D Which two recommendations would you give your customer? (Choose two.). Additional intercompany rules will need to be defined for the two additional balancing segments. 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. Additional intercompany balancing and clearing options will need to be defined. 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.

Before implementing Financials Cloud, your customer used to manually reconcile their intercompany payables and receivables accounts. What is a more automated approach to do this?. Use Oracle Hyperion Close Manager to automatically reconcile intercompany account balances. In Financials Cloud, you must manually reconcile your intercompany account balances. Run the BI Publisher reports called Intercompany Transaction Summary and Account Details to automatically reconcile intercompany balances. Run the Intercompany Reconciliation report, which shows pairs of intercompany receivables and payables accounts that are out of balance. Create a query using Oracle Transactional Business Intelligence (OTBI) that will match the intercompany payables and receivables balances.

You create an invoice for USD 100 that is matched to a purchase order of USD100. You validate the invoice to consume the budget and reduce funds available. And then later, you cancel the invoice. What happens to funds available when you cancel an invoice that requires budgetary control?. Funds available will change when the invoice is approved. The funds reserved for the purchase order is reinstated while the invoice expenditure is reserved by USD 100. The budget will increase by USD 100 and the funds available will decrease by USD 100. The budget and funds available will increase by USD 100.

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?. Run Revaluation as often as you need to the more stable currency and report on the more stable currency’s balances. Run Revaluation to translate into Statistical Currency. Create a secondary ledger that uses a different chart of accounts that is denominated in the more stable currency. Use Journal-Level or Subledger-Level Reporting Currencies denominated in the more stable currency.

You defined a tree or hierarchy, but you are unable to set its status to Active. What is the reason?. Two tree versions were not defined. An Audit process needs to be successfully performed before a tree version can be set to Active. Accounting Configuration was not submitted. Chart of accounts was not deployed.

Your Financial Analyst needs to interactively analyze General Ledger balances with the ability to drill down to originating transactions. Which three features facilitate this? (Choose three.). Sunburst reports. Online Transactional Business Intelligence. Account Inspector. Account Monitor. Smart View.

You are implementing a multipillar implementation of both HCM Cloud and ERP Cloud. You are implementing ERP first followed by HCM Cloud. You want to ensure your ledgers and chart of accounts are correctly defined. What should you do? (Choose three). Deploy your chart of accounts. Use HCM’s Enterprise Structure Configurator (ESC) first. Create your chart of accounts in the following order: value sets, COA structure, and instance before assigning values to the value sets. Use file-based spreadsheet loaders using UCM to mass load and maintain chart of accounts segment values and hierarchies. Use the Rapid Implementation spreadsheet when creating your enterprise structure.

Your customer has a large number of legal entities. The legal entity values are defined in the company segment which represents the primary balancing segment. They want to easily create eliminating entries for their intercompany activity. What would you recommend?. Define an intercompany segment in the chart of accounts. The Intercompany module and the Intercompany balancing feature in general ledger and subledger accounting will automatically populate the intercompany segment which the balancing segment value of the legal entity with which you are trading. There is no need to define an intercompany segment, the Intercompany module keeps track of the trading partners for you based on the intercompany rules to define. Define an intercompany segment and qualify it as the second balancing segment to make sure all entries are balanced for the primary balancing segment and intercompany segment. There is no need to define an intercompany segment. You can track the intercompany trading partner using distinct intercompany receivable/payable natural accounts to identify the trading partner.

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.). You must map legal entities to balancing segment values in order to use a clearing company. If you do not map legal entities to balancing segment values, then a clearing company can be applied to any journal within the ledger. Clearing companies are not supported. If you map legal entities to balancing segment values, then a clearing company can only be applied within a legal entity. If you choose to use a clearing company, you can define a default clearing company value or select the clearing company value directly in the general ledger journal.

You want to automatically post journal batches imported form subledger sources to prevent accidental edits or deletions of the subledger sources journals, which could cause an out-of-balance situation between your subledgers and general ledger. Which two aspects should you consider when defining your AutoPost Criteria? (Choose two.). Use the All option for category and accounting period to reduce maintenance and ensure that all imported journals are included in the posting process. Create your AutoPost criteria using minimal sources and categories. Include all of your subledger sources in the AutoPost Criteria. Divide up criteria sets by subledger source only if you need to schedule different posting times. Schedule your AutoPost Criteria set to run during off-peak hours only.

All of your subsidiaries reside on the same application instance, but some of them require a different chart of accounts and/or accounting calendar and currency. There is no minority interest or partial ownerships. What is Oracle’s recommended approach to performing consolidations?. Translate balances to the corporate currency, create a chart of accounts mapping to the corporate chart of accounts, then transfer balances to the corporate consolidation ledger using the balance transfer program. Translate balances to the corporate currency for ledgers not in the corporate currency, use General Ledger’s Financial Reporting functionality to produce consolidated reports by balancing segment where each report represents a different subsidiary. Create separate ledgers for each subsidiary that shares the same chart of accounts, calendar, currency, and accounting method. Create a separate elimination ledger to enter intercompany eliminations. Then creates a ledger set across all ledgers and report on the ledger set. Use Oracle Hyperion Financial Management for this type of complex consolidation.

During implementation, a consultant accidentally designated the cost center segment as the natural account. Values have already been assigned and journals have been posted. Select the process that allows you to change the qualifier back to cost center qualifier. Create a new chart of accounts. Delete the segment and create a new segment with the correct qualifier. Change and save the segment qualifier. Delete the chart of accounts and create a new one.

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.). Uncheck the Enable Posting from the Manage Subledger Accounting Options task. Journal entry spreadsheets are not impacted by this new function. Must have separate user defined roles using the privilege XLA_CREATE_GENERAL_LEDGER_AND_SUBLEDGER _JOURNALS. For previously scheduled automated processes, it is recommended to cancel and rescheduled the process for the option to be effective.

The general accountant is trying to update the cost center for the Default Suspense Account in the Ledger Options to match the cost center for the Rounding Account. The rounding account is showing as 01-110-7699-00; however, 110 is not appearing in the List of Values for the accountant to select in the Suspense Account. What is the reason for this?. The general accountant does not have the Financials Application administrator role assigned and, therefore, has view-only privileges on this page. The general accountant has a segment value security rule assigned which restricts access to that cost center. There is a primary balancing segment attached to the legal entity of the primary ledger. A cross validation rule is in place to prevent the resulting combination from being created.

Your company has a legal entity in the UK, US, and Canada. They can all share the same chart of accounts but are required to transact and report in their local currency. What is the minimum number of ledgers you need and why?. One, because they can all share the same chart of accounts. Three, because each requires a different currency. Two, because the US and Canada can share the same ledger because they are in North America. Four, because the UK has statutory requirements and you will need a separate ledger for statutory reporting.

When creating financial reports which two tools use data from the General Ledger Balances Cube? (Choose two). Financial Reporting Studio. Smart View. Oracle Financial Statement Generator. Financial Reporting Center.

You need to setup a calendar for fiscal year Apr-XX to March-YY where YY is the following year, and you Would like the periods to be named according to the year they fall in. What Calendar format should you choose?. Calendar. Fiscal. Year. Period.

You entered the following information in the Companies and Legal Entities tab of the Rapid Implementation Spreadsheet: Assuming currency is left blank in the Ledger worksheet, how many Ledgers will the process create?. 6. 3. 4. 5.

You are defining an income statement report using Financial Reporting Studio. Users of the report need to be able to analyze the balances directly from the report. What should you enable to allow this?. Nothing. All report are drillable. Drill Through in Grid Properties. Drill Down in Report Functions. Allow Expansion in Report Functions.

You want to monitor the close process of all financial subledgers and ledgers. How can you quickly obtain this information?. 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.

Your company has two legal entities in the US (Balancing Segment Values [BSV] 101 and 102), one legal entity in France (BSV 401), and one legal entity in the UK (BSV 402). Both US legal entities share the same ledger, where as the UK and France have their own ledgers. Assuming intercompany transactions are not being entered, what is the minimal action you can take and still configure the ledgers correctly?. You should assign a balancing segment value to identify each legal entity in the US Ledger and assign the balancing segment values to the ledger in the UK and France. You should assign a balancing segment value to identify each legal entity in the US ledger. You should assign a balancing segment value to identify each legal entity in each ledger. You should assign the balancing segment value to the ledger in the US and assign a balancing segment value to identify each legal entity in the UK and France ledgers.

You are using Oracle General Ledger(GL), Oracle Payables and Oracle Receivables and would like to prevent the closure of the GL period if the corresponding subledger period is not closed. How will you achieve this?. Opt in to the Prevent Period Close option for the offering. Set the relevant option on the Specify Ledger Options page. Nothing, this option is enabled automatically. Set the ORA_GL_INCLD_STRICT_PRD_CLOSE profile option to yes.

When creating your financial statements, you would like to have a chart, such as a bar graph, included in the report output. Which two reporting tools allow you to achieve this? (Choose two.). Financial Reporting Studio. Account Inspector. Smart View. Financial Statement Generator.

Your customer uses Financials Cloud, Projects, Inventory, and SCM. Which two statements are true regarding intercompany accounting for these products? (Choose two.). Intercompany balancing rules in General Ledger need to be mapped with the intercompany configuration in each product. Intercompany Balancing Rules are defined centrally and applied across Financials and Projects. Each product has its own Intercompany Accounting feature that needs to be configured separately. In Financials Cloud, Intercompany Balancing Rules are used to balance both cross-ledger allocation journals and single-ledger journals.

You have a requirement for the Intercompany Provider and Receiver distribution accounts to be created automatically for all intercompany transactions. What should you configure?. a Provider and Receiver distribution set. Intercompany transaction type default accounts. the Auto Accounting Definition. the Transaction Account Definition.

Your client has been using Budgetary Control for six months. Now, they want to use the Spend Authorization. D18912E1457D5D1DDCBD40AB3BF70D5D After opting in the new feature Spend Authorization with Budgetary Control, what additional three actions need to be accomplished to activate this feature? (Choose three.). Enable Payment Request Subtypes. Rebuild the GL Balances Cube. Create a Payment Process Profile. Rebuild the Budgetary Control Cube. Enable spend authorization.

Which two statements are TRUE regarding the Balances Cubes in General Ledger? (Choose two. They are updated automatically when the General Ledger period is opened. New dimensions can be added to a General Ledger Balances Cube. They are updated automatically when the Revaluation process is run. A new Balances Cube is created for a unique combination of Ledger and Currency. They are updated automatically when the Translation process is run.

You have set up a supporting reference with balances to capture revenue by account manager. Which option should you use to view the supporting reference balances?. an Account Group. an OTBI analysis. a SmartView analysis. General Ledger inquiries and reports.

You have exported data from your budgeting application in to a .csv file. What should you use to load that data into General Ledger?. The budget journal spreadsheet. Enterprise Resource Budget Integrator. File Based Data Import. Application Developer Framework Desktop Integrator.

A subsidiary company, in a highly regulated country, where there is a legal requirement to produce fiscal Reports under local GAAP, is about to configure their General Ledger. Given the following: Subledgers transferring to general ledger must use the local currency. There is a requirement to report to the parent company (not local currency) using International Financial Reporting Standards (IFRS). Which two ledger types should be configured to address this reporting requirement? (Choose two.). a primary ledger with the local accounting convention. a reporting currency with the IFRS accounting convention. a primary ledger with the IFRS accounting convention. a secondary ledger with the IFRS accounting convention. a reporting currency with the local accounting convention.

You entered a cross validation rule to prevent the balance sheet cost center (000) being used with Profit and Loss Accounts (4000-ZZZZ). - The following combinations exist in the Code Combination table: 01-000-4110-00, 01-000-5299-000, 01-000-5105-000 and 01-000-7640-00 Which two statements are true regarding cross-validation rules? (Choose two.). The rules validate and apply to new accounts only D18912E1457D5D1DDCBD40AB3BF70D5D. You need to run the Cross-Validation Rules process to list and optionally disable combinations that violate rules. You need to run the Cross-Validation Rule Violations process to allow rules to apply to existing combinations that violate rules. There is no need to create cross-validation rules if Dynamic Combination Creation Allowed is not enabled for your chart of accounts instance. The rules will validate and apply to new and existing accounts.

The Create Accounting program could not determine the debit side of the journal entry. Which component of Subledger Accounting determines the debit or credit side of a journal entry?. Journal Balances Rule. Journal Entry Rule Set. Journal Line Rule. Journal Accounting Rule. Account Rule.

You need to create a board room ready month-end reporting package for an upcoming Audit Committee meeting. You have 10 Financial Reports that you want to share with executives and auditors that are nicely formatted. What are the two Oracle recommended ways to accomplish this? (Choose two.). Use BI Publisher to configure the reports and then use bursting to email the reports to the executives and Audit Committee. Using Workspace, assemble multiple reports into a book that can be printed and viewed individually as an entire book. Create a Smartview report, where the various sheets represent the different Financial Statements and send them the spreadsheet. Use a report batch to run reports at a specific time to create a set of snapshot reports. Use OTBI to create multiple reports that you save to a folder that only the users can access.

You want to achieve multi-step cascading allocations, which feature do you use?. RuleSets. Formulas. Point of View (POV). General Ledger journal entries.

Which two statements are true regarding the Intercompany Reconciliation Report? (Choose two.). You can only drill down to the general ledger journal and then from there to the subledger journal entry. This report can be run using an additional currency and conversion rate that converts all amounts into a common currency for comparison. This report displays only the reconciled transactions. You need to further process automatic reconciliation to reconcile the unreconciled transactions. This report includes Ledger balancing lines generated when the primary balancing segment value (BSV) is in balance, but either the second or third BSVs are not. This report displays the intercompany receivables and intercompany payables balances in summary for a period.

You are creating values for the chart of account value set that you are planning to use for the account segment within your Chart of Accounts. You are not able to assign an Account Type. What is the reason for this?. You have not set the Allow Budgeting attribute for the value set. The Account Type qualifier has not been enabled when defining the value set. You are creating values before assigning the value set to the structure. You have not set the Allow Posting attribute for the value.

In which two ways can your users personalize the Springboards and Work Areas to suit their individual working styles? (Choose two.). They can format certain tables by hiding and showing columns, moving columns, and resizing columns. Users have very little control configuring their Springboards and Work Areas; they can only resize columns. They can have the System Administrator configuring pages for them using Page Composer. They can use “+” under the Apps section of the News Feed homepage.

1. The General Ledger Implementation Team is using the file-based data import (FBDI) template to load chart of accounts mappings. Because they have created a previous one using the interface they want to change only the existing records. Which mode should they use when importing chart of accounts mapping rules?. Increment. Replace. Update. All.

You redesigned the chart of accounts and need to update your existing cross-validation rules. What is the most efficient way to achieve this? What should you do to allow access to the ledger?. By using Cross-Validation Rules Import file-based data import (FBDI). On the Manage General Ledger Security page. By creating a Cross-Validation Rules desktop-integrated spreadsheet. On the Manage Cross-Validation Rules page.

You want your sales representatives to be able to find points of interest, such as customers, while out on business. What should you enable to achieve this?. HZ_GEO_IDENTIFIER_SUBTYPE lookup. Address Cleansing. Validating. Geocoding.

An Oracle Fusion Cloud customer has a complex enterprise structure that includes multiple legal entities in multiple countries. To match the intercompany balancing requirements with balancing rules defined. In user testing, the business experts are asking which rule will be considered first when balancing an intercompany journal?. Chart of accounts rule. Primary balancing segment rule. Legal entity-level rule. Ledger-level rule.

You want to run a Financial Reporting Web Studio report from the Financial Reporting Center but it is not displayed as a choice. Which two actions must you perform for it to appear?. Download the report to your local drive. Save it in the Shared Folder / Custom / Financials directory. Save it in the MyFolders directory. Upload it to the Financial Reporting Center.

After user acceptance testing of the new Oracle Fusion Cloud systems, the company’s accountants report that they want to be notified of anomalies in certain accounts balances that include an increase or decrease that is above or below a percentage amount threshold. What is the best way to meet this requirement?. Use an Account Inspector. Create an Account Group using Account Monitor. Perform an account analysis online. Open a Smart View file saved on your desktop.

You are using the Create Budgets in a Spreadsheet option to load your budget balances into the General Ledger balances cube. Your FYXXis not appearing in the budget inquiry. What are two reasons for this?. The Create Scenario Dimension Members program has not been run. Transfer Budget Balances to Budget Cubes has not been run. Publish Chart of Accounts Dimension Members and Hierarchies to the Balances Cube has not been run. A value for the budget scenario is not created. Budgeting is not enabled in the Ledger options.

On a primary ledger in the system options close section, the following field has been selected “Prevent General Ledger Period Closure When Open Subledger Period Exist”. For which three sub ledgers can you opt out of the Period Close Checking feature by using the ORA_GL_INCLD_STRICT_PRD_CLOSE lookup?. Order Management. Assets. Revenue Management. Receipt Accounting. Receivables.

For translation purposes, the Financial reporting team has decided to load the monthly historical currency rates by using File-Based Data Interface (FBDI). What happens to the existing historical rate for a specific ledger, currency account combination, and accounting period if they use insert in the spreadsheet?. Historical rates are converted into an average rate (original and new rate). The existing historical rate is deleted. Nothing, existing historical rates are not updated. The historical rate is replaced.

You can run predefined reports to reconcile subledger application balances to General Ledger balances. Which attribute needs to be set up on the Manage Values page for chart of accounts segment values so that you can run the Payables to General Ledger Reconciliation Report or Receivables to General Ledger Reconciliation Report?. Start Date. End Date. Financial Category. Third Party Control Account. Reconcile.

When will Intercompany processing balance a journal using the accounts identified here for the UK Ledger?. when there is a many-to-many journal and you want to use a clearing company. when the journal is not balanced by the primary balancing segment value (BSV). when the journal is balanced by the primary BSV but not by second or third BSV. when the journal is balanced by second balancing segment value.

A company implementing Oracle General Ledger has a business requirement to report under two accounting conventions and is considering setting up a Primary and Secondary ledger. The two accounting standards are very close. Which data conversion level should you recommend to ensure only manual journals will be entered in the secondary ledger?. Adjustment Only Level. Subledger Level. FBDI Level. Balance level. Journal Level.

You are setting up Close Monitor and want to view high-level profit and loss results for each ledger. What should you associate with the ledger set to achieve this?. an Account group. an OTBI report. a Financial Reporting Web Studio report. a Trial Balance report.

You want to create an Ad-Hoc Analysis in Smart View and have entered the following dimensions for the report, and clicked Refresh in the POV. You get #Missing instead of a balance. What is the reason?. You have not specified a Cost Center value. You have not specified an Intercompany value. You have not specified a particular currency. You have not specified a Product value.

Your ledger currency is USD. At month end you have a balance on the Accounts Payable Liability Account of 100,000 Euros which is equivalent to USD 136,550. This balance needs to be revalued. The month end exchange rate for revaluation is 1 Euro = 1.3755 USD What two statements are true for the resulting revaluation run? (Choose two.). The original journal entry in Euros remains the same. The original journal entry in Euros is updated. You have an unrealized exchange loss recorded. You have an unrealized exchange gain recorded. There is no unrealized exchange gain or loss calculated.