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.
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.
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.
Identify 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.
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.
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.
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.
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?
Drill Through in Grid Properties Nothing. All report balances are drillable in all FR Studio reports Allow Expansion Report Functions.
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).
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 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.
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.
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.
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.
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 Dashboard.
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.
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.
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.
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.
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.
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 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.
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) RuleSets.
You create an invoice for USD 100 that is matched to a purchase order of USD 100. 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 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.
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.
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.
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).
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.)
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 Define Ledger balancing options to balance by second and third balancing segments 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.
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.
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).
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 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.
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 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.
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.
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.
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.
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.
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 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 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.
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.
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.
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.
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.
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.
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 matched to the purchase order for $2,100 USD. 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 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. 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.
You want to specify Intercompany System Options. Which three factors should you consider? (Choose three.) the approvers who will approve intercompany transactions whether to allow receivers to reject intercompany transactions whether to enforce an enterprise-wide currency or allow intercompany transactions in local currencies automatic or manual batch numbering and the maximum transaction amount automatic or manual batch numbering and the minimum transaction amount.
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.
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 unreceived 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.
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 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 Smartview 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.
Which tool can you use to create a Financial Income Statement?
One View Reporting PS/n Vision 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 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.
The expense account of airfare was erroneously assigned to the 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.
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 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.
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.
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.
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 feauture 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.
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 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 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.
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.
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 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.
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.
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.
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.
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.
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. A Fund of $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.
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.
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 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.
How do you hide accounts with no balances showing Missing in Smart view? Choose the Suppress Zeros option under Data options This indicates a database connection issue. Try to reconnect to Fusion Applications Select the Data/Missing check box in the Data Options tab Use Excel functions to hide rows with #Missing assigned.
Which report show you differences between your subledger balances and General Ledger balances? Payables to Ledger Reconciliation Report and the Receivables to Ledger Reconciliation Report Payables Aging reports with the General Ledger Trial Balance report General Ledger Financial Statements and the Accounts Payable and Invoice Registers Payables Trial Balance and General Ledger Trial Balance reports.
What type of user must be defined before you can create an Implementation Project? None.The Fusion Application Superuser,FAADMIN, has full access to create an implementation project. all roles that will be used throughout the implementation Implementation Users None. The OIM system administrator user ID, XELSYSADM, which is assigned by the person provisioning the system, has full access. a full-time employee that has the FSM Superuser role assigned.
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? Purge all translated balances, change the CTA account in the Ledger page, and rerun Translation for all periods required. Open the Ledgers page and update the CTA account and then rerun Translation for all periods required. The system will automatically update the translated balances. Query the Translation journals and delete all of them, then change the CTA account in the Ledger page,and rerun Translation for all periods required. Define a new ledger and accounting configuration. The CTA account cannot be updated after the ledger has been in use.
You need to integrate Fusion Accounting Hub with external source systems used for Billing. Identity the step that is not correct when implementing this integration. Analyze external system transactions. Capture accounting events Determine the accounting impact of transactions. Create the accounting in the source system and then import the journal entries into Subledger accounting.
Which statement is true when creating an Implementation Project for Financials Cloud? The Implementation Project is preconfigured and cannot be deleted or changed. Plan your implementation project carefully because you cannot delete it or make changes later. You must select the Offering "Financials," and each individual product or option to perform the setup for each product in Financials Cloud Selecting the Offering “Financials,” automatically allows you to perform the setup for all Financials Cloud products. You only need to make the project name unique, then you can perform the setup for any product family, such as Financials, Procurement, Human.
You want to display OTBI reports and graphs in PowerPoint to show general ledger or subledger data. How do you accomplish this? Download OTBI reports and charts to a spreadsheet and then copy and paste the spreadsheet to PowerPoint Use SmartView to create reports and charts using general ledger and subledger subject areas embed the charts/reports into PowerPoint Use Smart View and Oracle BI EE View Designer to create reports in PowerPoint, Word, and Excel. Use Account Inspector and then export to Excel and copy and paste into PowerPoint.
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? Oracle Identity Manager Roles Assignment Access Policy Manager's Role Generation Role Mappings Data Roles You cannot reassign contingent workers. .
Your customer is closing their period and they are using Fusion Intercompany to create physical invoices in Fusion Payables and Receivables. What is the correct order of steps to close Fusion sub ledgers, Fusion Intercompany, and Fusion General Ledger? Close Fusion Payables and Receivables periods, close the related intercompany period, and then close the Fusion General Ledger’s period. Close FusionPayables and Receivablesperiods, close Fusion General Ledger, and then close therelated intercompany period Close the related intercompany period, close Fusion Payables and Receivables periods, and then Fusion General Ledger. You only needto close Fusion Payables and Receivables periods followed by the Fusion GeneralLedger’s period.
You need to distribute departmental expense reports to 100 department managers in your organization. The report format is the same, but the department values differ. What in the most efficient way to achieve this? Set the Department segment as a User Point of View (POV) and submit a report batch and schedule it: to run for every department. Send the different batch outputs as PDF attachments via email to different users. Create a single report for all departments. When department managers log in to Financial Reporting Center, they will only be able to view their department’s data based on Segment Value Security Rules. Set up Bursting Options for your batch to prepare multiple versions of a report from a single process. When defining the report, make the Department Segment a prompt and when users view the report, they can change the prompt to their department.
Invoices received from a source system need to use a specific account based on 30 different expense types. However, if the invoice is from a specific supplier type, it needs to go to a default account regardless of the account type. What is the solution? Create two journal line rules with a condition of supplier type. Create an Account Rule with 31rule elements using one condition for each expense type and another for supplier type. Create an Account Rule with three rule elements using one for expense type mapping, one for condition of supplier type, and the other without any conditions.
Your customer is expanding its operations. You defined a new ledger and several business units. However, you are unable to assign the newly generated data roles to existing Accounts Payables and Accounts Receivables users in the shared service center. What should you do to correct the problem? Open the Oracle Identity Management (OIM) and make sure the data roles were created Open the Manage Users page and make sure the employees at …. Open Access Policy Manager (APM) and assign the roles manually. Make sure you run the Retrieve Latest LDAP Changes program to regenerate the data roles.
Alter submitting the journal for approval, you realize that the department value in the journal incorrect. How do you correct the value? Click the Withdraw Approval button in the Edit Journals page and edit the journal. Delete the journal and create a new journal. Update the journal through workflow. Reverse the journal and create a new one.
You are implementing Fusion Accounting Hub for your external Accounts Receivables system. The external system sends invoices billed and cash receipts in a flat file, along with the customer classification information. You want the accounting amounts to be tracked by customers too but you do not want to add a Customer segment to your chart of accounts. What is the solution? Use the Open Account Balances Listing report that has the balances by customer Use the Third Party Control Account feature Use Supporting References to capture customer classification information Capture customer information as the source and develop a custom report using Online Transactional Business Intelligence (OTBI).
What process must be followed to propagate a chart of accounts hierarchy to the Essbase cube? Define the hierarchy, make sure the tree version is active, and then run the publish account hierarchies program or the Publish Chart of Account Dimension Members and Hierarchies. nooDefine the hierarchy and make sure the tree is active. The hierarchy will be system generated for Define the hierarchy, then deploy the chart of accounts. The chart of accounts hierarchies will be generated automatically. Define the hierarchy, make sure the tree is active, and the Publish check box is selected for the hierarchy.
Your customer has only licensed Fusion Financials and wants to use approval workflows. Using which page to enter users and assign roles does Oracle consider best practice? Financials Cloud not a stand-alone product Oracle Identity Management (OIM) Manage Users Hire a New Employee Access Policy Manager (AРМ).
What are the tables or views from which the Create Accounting program takes source data that is used in rules to create journal entries? Accounting attributes Event Entities Transaction Objects Mapping Sets Event Classes.
|
