ログイン

Mock 1
100問 • 7ヶ月前
  • ユーザ名非公開
  • 通報

    問題一覧

  • 1

    One of your ABC.com co-workers, Tim, is working to define and develop Financial Statement Generator reports where the budget amounts and actual amounts would display on the report per period. Tim comes to you and says that he has defined an FSG report according to the client's requirements; the actual amounts are correctly shown, but the problem is that budget amounts are not showing up on the report. What is your response?

    The budget name needs to be associated with the row set through control values.

  • 2

    Jason, the corporate controller of ABC.com where you are implementing Oracle General Ledger, Accounts Payable, an Accounts Receivable, is very excited about the Global Intercompany System (GIS). He wrote some notes from a conversation with his accounting manager about GIS. He wants you to validate which points he has written down about GIS are true. Identify Jason's three correct points. (Choose three.)

    You can set up GIS so that the sender's transactions do not need to be approved by the receiver., Each company that uses GIS must be set up as a subsidiary that is associated with a balancing segment value., You can optionally send notifications to a defined user or responsibility when an intercompany transaction is initiated.

  • 3

    One of ABC.com's clients wants the ability to report with Financial Statements Generator (FSG) and perform account inquiry at the summary (business unit) level of its Cost Center segment. A business unit is a group of cost centers and a business unit manager typically has several cost centers under his or her responsibility. Which option will meet the client's requirements?

    Define parent cost centers and a hierarchy of parent-child cost centers. Define Rollup Groups for the parent cost centers, and Summary Accounts. Create FSG based on the parent cost center values or Summary Accounts.

  • 4

    Which report would provide information about the processing type (parallel or sequential) that may be defined for reports?

    Content Set Summary Listing

  • 5

    After you determine your needs and organize your summary account structure, which General Ledger tools can you use to define parent-child values and rollup groups?

    Account Hierarchy Manager or Account Hierarchy Editor (provided Applications Desktop Integrator is installed).

  • 6

    The Consolidation Workbench enables you to _____, _____, and _____. (Choose three.)

    access the State Controller., create consolidations sets, which launch multiple consolidations in a single step., create multilevel hierarchies, which you can view using the graphical Consolidation Hierarchy Viewer.

  • 7

    ABC.com wants to define a consolidation process for its enterprise. It has two sets of books: Set of Books A and Set of Books B. Both sets of books will use Oracle General Ledger. Set of Books A has three companies with the same calendar and chart of accounts as Set of Books B. Set of Books A has USD as its currency. Set of Books B has four companies with the same chart of accounts and calendar as Set of Books A. Set of Books B has GPD as its currency.

    Financial Statement Generator

  • 8

    You are implementing Oracle General Ledger at ABC.coms site. ABC.com is based in the US but has a global presence in many countries worldwide, and has transactions in multiple currencies. The implementation team decides that GL multi currency setup will be part of the implementation. The GL accountant approaches you to discuss multiple reporting currencies (MRC); he wants to implement MRC and link the primary set of books with the reporting set of books. Additionally, he says that the primary and reporting sets of books all have different calendars but share the same chart of accounts. What response do you provide?

    The primary and reporting set of books must share the same calendar and chart of accounts.

  • 9

    ABC.com is a $2 million company operating from the U.S., and has one set of books. It is spinning off from its parent company and will be operating as an independent company. It is considering implementing Oracle Financials but wants the product to work exactly in the same way as its legacy systems from its parent company. What considerations should be presented to ABC in order for it to make a well-informed decision? (Choose all that apply.)

    Patching is simplified on a non-customized Oracle implementation., Adding customizations to replicate the legacy system could increase cost of future upgrades., Integration issues between modules are reduced when there are no customizations.

  • 10

    Identify the two setups that control the defaulting of Tax Information on a journal entry. (Choose two.)

    Set of Books , Account

  • 11

    During a period, several preapproved batches of miscellaneous transactions were entered and released. The project manager informs you that he is unable to view the accounting in the expenditure inquiry form. Which process was likely omitted?

    distribute costs

  • 12

    What are the possible posting options in Oracle General Ledger?

    Post Journal batches individually Post multiple batches Use AutoPost

  • 13

    You are implementing Oracle General Ledger at a ABC.com site. ABC.com is based in the US but has a presence in many countries worldwide, and has transactions in multiple currencies. The implementation team decides that GL multi currency setup will be part of the implementation. John, a junior consultant helping you in the implementation effort, comes to you and says that he is testing the system and entering journals in US dollars, yen and euros. He says that he is able to enter the journals in US dollars and euros, but cannot enter the journals in Japanese yen. What possible explanation can you provide to John for this?

    Yen currency has not been enabled.

  • 14

    ABC.com has offices around the world, spread across different legal entities. ABC.com is implementing Oracle General Ledger. Its accounting department wants to know how to reduce the burden of elimination entries. What do you recommend?

    Recurring Journals

  • 15

    ABC.com has many Financial Statement Generator reports created to produce Profit & Loss statements and Balance Sheet reports. Occasionally ABC.com has a need to run a report that is slightly different than the standard ones that are already created. Which two types of changes could XYZ make using the Row Order feature? (Choose two.)

    display segment values and descriptions, sort based on column values

  • 16

    ABC.com has two diverse business operations in retail stores and services. It has five legal entities in Canada and five in the United States for both operations. The fiscal year end is the same for all the legal entities with 12 monthly periods. However, ABC.com wants to use a 4-5-4 accounting calendar for its retail operations and a calendar-month accounting calendar for the services operations. ABC.com also wants to use a single chart of accounts structure. Which five items must ABC.com define to meet the minimum setup steps that are required for the sets of books for all legal entities? (Choose five.)

    two accounting calendars, four sets of books, chart of accounts structure, period types or use seeded ones, one accounting calendar

  • 17

    After creating a number of Financial Statement Generator reports, ABC.com wants a list of the definitions for one specific account. Which report should be run to provide that information?

    FSG: Where Used Report

  • 18

    Exhibit: You work as a DBA for ABC.com. Please study the exhibit carefully. GL Consolidation: Preserve Journal Batching is set to Yes. GL Consolidation: Preserve Journal Effective Date is set to Yes. What would the result be?

    1, 3, 4

  • 19

    ABC.com is a national company with five divisions that share the same set of books. Select the statement that best describes the consolidation process for ABC Corporation.

    Enter eliminating journals and run financial reports.

  • 20

    ABC.com, the GL accountant, comes to you and says that he has defined the budget, and budget amounts have been entered and approved by management. After approval he wants his assistant accountants to NOT be able to update this budget. What is your response?

    If the client wants to do this, then the budget status should be Frozen.

  • 21

    Which two are true statements regarding elimination? (Choose two.)

    You must specify an elimination company in the Elimination Sets window., Currency is an optional component when defining an elimination set.

  • 22

    What is the effect of summary accounts on the efficiency of the posting process?

    should share the same period.

  • 23

    When you enter a journal, the journals in that batch _____.

    should share the same period

  • 24

    To review available Financial Statement Generator elements, which two reports would be helpful? (Choose two.)

    Column Set Summary Listing, Row Set Detail Listing

  • 25

    ABC.com has offices around the world, spread across different legal entities. ABC.com is implementing Oracle General Ledger. Its accounting department wants to know how to reduce the burden of elimination entries. What do you recommend?

    Recurring Journals

  • 26

    Oracle General Ledger provides a variety of ways to get information from reports and queries. What can you do using standard reports that you cannot do using on-line queries? (Choose all that apply.)

    group reports into report sets, view non-financial information

  • 27

    Which statement is correct about the differences between the functionalities of parent accounts and summary accounts?

    Summary accounts balances can be viewed in the Account Inquiry form, whereas parent accounts balances cannot be viewed in that form.

  • 28

    Which two statements correctly describe the translation process? (Choose two.)

    You can rerun the translation process more than once per period., Translation for a subsidiary can be initiated from the parent using the State Controller Translate button.

  • 29

    For each subledger there should be one _____.

    Journal Source

  • 30

    All of the manual journal entries are defaulting to a non current period. Which step was omitted from the accounting cycle?

    Update Period

  • 31

    ABC.com would like a consolidation process to consolidate operations in the UK and US. ABC.com requires a summary of transactions from both companies. Company 01 is located in Chicago; Company 02 is located in London. Both companies share only the same calendar. Which actions should be considered when defining the consolidation process for ABC.com? (Choose all that apply.)

    Define a consolidation process using the Global Consolidation System by defining Parent Company 90 to consolidate data from Company 01 and Company 02., Define an elimination set to include a group of related elimination entries., Define mapping rules to map Company 01 and Company 02 to Company 90

  • 32

    A manager at ABC.com wants to review the cash balance by company. He has asked you to create the summary account template. ABC.coms accounting flexfield has four segments: Company (5 values) Cost Centers (30 values) Region (4 values) Account (180 values) The total number of cash accounts is 5, which are associated with 2 parents: 3 accounts are associated with the parent called Checking. 2 accounts are identified with the parent called Savings. To combine the Cash parents, you created a rollup group named Cash. How many accounts would the summary account template generate?

    10

  • 33

    ABC.com wants to have 16 accounting periods that include an adjusting period for each quarter in its 4-5-4 accounting calendar. Its fiscal year end is March 31. The normal month end is on a Friday, but the last day of each quarter is always on the last day of the quarter's final calendar month. Choose the remaining setup for the calendar to meet the requirement.

    Define 12 monthly periods based on the 4-5-4 calendar ending on the last Friday of each month, except for the last month of each quarter ending on the last day of the month. Define an adjusting period for each of the last day of the quarter.

  • 34

    ABC.com wants to compare actual amounts against their budgeted amounts. Which reporting or query options would provide that detail? (Choose two.)

    On-line Account Inquiry, Financial Statement Generator

  • 35

    Your subledger accountants are attempting to import their journals to the general ledger at the end of the period. The journal import processes are completing with a warning and no journals are being generated. Which three steps would you take to troubleshoot this condition? (Choose three.)

    Confirm that data was sent from the subledger., Verify the output of the Journal Import request, Run journal import with all group IDs.

  • 36

    Which item CANNOT be queried in the Find Consolidation Process window?

    Parent Calendar

  • 37

    ABC.com, the GL accountant, is preparing a PowerPoint presentation for the accounting staff to explain the steps for creating mass allocation journal entries. Which five steps should Tess include in his presentation? (Choose five .)

    validate mass allocation definition, create mass allocation definition, post journal entries, generate mass allocation journals, review journal entries

  • 38

    Which rule has to be applied when using summary accounts to create a Mass Allocation journal?

    Constant (C) must be assigned to each rollup group used in the formula line.

  • 39

    ABC.com wants to use one set of books for its many subsidiary companies in Canada that will share the global chart of accounts structure and the Corporate Accounting Calendar. The controller is concerned about users charging to the wrong company when entering a journal entry. Which setup would address the controller's concern?

    Segment security rules would prevent users from seeing companies that they are not supposed to see.

  • 40

    ABC.com, a Canadian subsidiary of a U.S. company, wants to have an adjusting period in addition to its 12 calendar month accounting periods. Its fiscal year end is March 31. It will use foreign currency translations for its financial reports to the U.S. parent company, beginning April 2006. The company wants to use accounting period names that show the calendar year, not fiscal year. It plans to go live beginning April 1, 2006 with conversion of 1 year historical GL balances (fiscal year ending March 31, 2006). Choose the most appropriate accounting calendar setup.

    Period Type: Calendar. Accounting periods named: Apr-05 through Mar-07, with two adjusting periods named Adj-06 and Adj-07.

  • 41

    What are three benefits of using the Journals Import: Group By Effective Date profile option? (Choose three.)

    Make daily updates to daily business intelligence., Account for business transactions by effective date or by accounting date., facilitates financial auditing and compliance with the new Sabanes-Oxley Act

  • 42

    The clients GL accountant ABC.com comes to you with a problem. A journal cannot be posted because it has not been approved. The preparer cannot submit the journal for approval because the Approve Button is grayed out in the Enter Journals form, and the supervisor has not received a notification requesting the approval. What do you suggest as the possible cause for this problem?

    Budgetary control has been enabled for the set of books, and funds have not been reserved for the journal.

  • 43

    ABC.com is a global company based in the United States with divisions in North American, Europe and Asia. All of the journal imports, recurring journals, mass allocations and manual journal entries have been posted for their European subsidiary. What is the next logical step in the period-close process?

    Revalue foreign currency balances.

  • 44

    Which reports would be appropriate as part of a financial month-end close? (Choose all that apply.)

    Account Analysis, Trial Balance - Detail

  • 45

    ABC.com wants to define a consolidation process for its enterprise. It has two sets of books: set of books A and Set of Books B. Both sets of books will be defined in Oracle General Ledger. Set of books A will have three companies with the same chart of accounts as set of books B. Set of books A will have USD as its currency. Set of books B will have four companies with the same chart of accounts and different calendar as set of books A. Set of books B will have GPD as its currency.

    Global Consolidation System

  • 46

    ABC.com has a requirement that all budget entries are made through journals. Where would you set this up?

    Set of Books

  • 47

    In which three ways do sub-ledgers transfer information into General Ledger? (Choose three.)

    Detail Journals, Summary Journals, Batch Transfer

  • 48

    Which four are valid consolidation tools?

    Financial Statement Generator, Applications Desktop Integrator, Global Consolidation System, Interface Data Transformer

  • 49

    In the course of implementing General Ledger, you and your customer have created a number of Financial Statement Generator reports in a test environment. They have been tested and you are now ready to create these same reports in a production environment. You want to run the Financial Statement Generator transfer program. What is the minimum necessary to run this program? (Choose two.)

    Same set of books must be defined., Database links must be defined.

  • 50

    Which subledger transfers journal information directly to General Ledger to create an unposted journal entry?

    Assets

  • 51

    You set the GL: Journal Review Required profile option to Yes. What is the result?

    requires generated Autoallocation Journals to be reviewed before posting

  • 52

    What is the effect of summary accounts on the efficiency of the posting process?

    Use of summary accounts decreases the efficiency of the posting process.

  • 53

    ABC.com has three companies in Canada, two companies in the United States, two companies in Singapore, and one company in Belgium. All the companies, except for one in Canada, have the same fiscal year-end calendar. ABC Enterprise wants to use a common chart of accounts structure globally and set up each company as a balancing segment value. What is the minimum number of sets of books that should be defined?

    5

  • 54

    A ABC.com manager wants to review the cash balance by company. He has asked you to create the summary account template. ABC.coms accounting flexfield has four segments: Company (5 values) Cost Centers (30 values) Region (4 values) Account (180 values) The total number of cash accounts is 5, which are associated with 2 parents: 3 accounts are associated with the parent called Checking; 2 accounts are identified with the parent called Savings. To combine the Cash parents, you create a rollup group named Cash. Which summary account template would you create to review cash balances by company? (D: Detail) (T: Total)

    D-T-T-Cash

  • 55

    Joe is the controller of ABC.com, your client. He is anxious to see you demonstrate the basic functionality of General Ledger with a set of books that somewhat reflects his company's business. Tell him the minimum four pieces of information you need from him, to create a set of books for your demonstration. (Choose four.)

    accounting calendar with periods and fiscal year end, retained earnings account, company organization structure for Chart of Accounts, the base (functional) currency of his company

  • 56

    You work as a DBA for ABC.com. Please study the exhibit carefully. You are implementing Oracle General Ledger at ABC.com's site. ABC.com is based in the U.S. but has a global presence in many countries worldwide, and has transactions in multiple currencies. The implementation team decides that Oracle General Ledger multi currency setup will be part of the implementation. ABC.com's Chief Financial Officer wants a system which has features are displayed in the exhibit. Which of the requirements can be satisfied with the implementation?

    All requirements from I to V can be satisfied.

  • 57

    ABC.com is a U.S.-based company with business operations in North America and Europe. It has existing Oracle GL sets of books in its single global instance. All sets of books use a global chart of accounts and a common accounting calendar. It just expanded its business to Australia and acquired two new companies with the same year end as ABC.com. It wants to be able to include the new companies in existing financial reports created with Financial Statements Generator (FSG). How can it easily integrate the two new companies into its existing GL with minimal effort?

    Define two new company values, enable AUD currency, and define a new set of books. Translate AUD to USD and include the two new companies for FSG reports in USD

  • 58

    ABC.com, the GL accountant comes to you with a requirement to define a particular Autoallocation request set where approvers are sent notifications automatically for the generated journals. If there are any problems in generating the journals, then he should have the option to rollback the whole process. What is your response?

    The GL:Autoallocation Rollback Allow profile option must be enabled.

  • 59

    ABC.com's GL accountant is responsible for taking care of recurring journals. She comes to you with a problem: she ran the Generate Recurring Journal program before the AP and Payroll entries had been posted to GL. As a result, the recurring journal entries created are incorrect. She has not yet posted the generated recurring journal, and wants to know whether she can generate it again. The Sequential Numbering profile option is set to Partially used. What response do you offer?

    Delete the first generated recurring journal and generate it again.

  • 60

    When you change a summary account template funds check level from None to Advisory or Absolute, you need to _____.

    delete the original template and then recreate it for the appropriate funds check level

  • 61

    To review available Financial Statement Generator elements, which two reports would be helpful? (Choose two.)

    Column Set Summary Listing, Row Set Detail Listing

  • 62

    You are implementing Oracle General Ledger at a ABC.com site. ABC.com is based in the U.S. but has a presence in many countries worldwide, and has transactions in multiple currencies. The implementation team decides that GL multi currency setup will be part of the implementation. The company's management in the U.S. wants to see all the transactions in U.S. dollars, whereas the management in Europe wants to see the transactions in euros. The CFO has stated this requirement: While entering the daily transactions the user should have the ability to enter the current exchange rate, but at month end the assets and liabilities in euros could be converted into U.S. dollars at the monthly average exchange rate. Can this requirement be satisfied?

    Oracle GL provides this functionality and there is no problem in satisfying the requirement.

  • 63

    You are implementing Oracle General Ledger at a ABC.com site. ABC.com is based in the U.S. but has a presence in many countries worldwide, and has transactions in multiple currencies. The implementation team decides that GL multi currency setup will be part of the implementation. ABC.com's management in the U.S. wants to see all the transactions in U.S. dollars, whereas the management in Europe wants to see the transactions in euros. The CFO has stated this requirement: While entering the daily transactions the user should have the ability to enter the current exchange rate, but at month end the assets and liabilities in euros could be converted into U.S. dollars at the monthly average exchange rate. Can this requirement be satisfied?

    Oracle GL provides this functionality and there is no problem in satisfying the requirement.

  • 64

    You work as a DBA for ABC.com. Please study the exhibit carefully. ABC.com wants to distribute rent expense to its various departments on the basis of floor space. It has taken these steps: Which are the next two steps needed to distribute the rent cost to the various departments? (Choose two.)

    Post the journal., Define and generate MassAllocation.

  • 65

    ABC.com has a legal entity in each of its business operations in the United States, Canada, Malaysia, Singapore, and Italy. The controller in Italy advises that the corporation must use the Italian statutory accounts as its natural accounts. The corporation decides to define five sets of books (one for each country) but wants to use a single, global chart of accounts structure. Choose a possible design (for the sets of books) that uses a single, global chart of accounts structure, and also meets the Italian controller's requirement.

    The list of values in the Account segment includes a range reserved for Italy.

  • 66

    You are implementing Oracle General Ledger at a ABC.com site. ABC.com is based in the US but has a presence in many countries worldwide, and has transactions in multiple currencies. The implementation team decides that GL multicurrency setup will be part of the implementation. The Controller wants a system which allows the flexibility to enter transactions in any foreign currency, and at the same time automatically performs currency conversion online and in real time. She wants to know whether this requirement could be satisfied. What is the correct response?

    Oracle GL provides this functionality and there is no problem in satisfying the requirement.

  • 67

    After discussions with the client, the implementation team decides that the GL Autoallocation functionality would help satisfy the clients requirements to automatically allocate the rent and other expenses to all the departments based on the defined formula. The GL accountant comes to you with a requirement that the approver of the journal should be automatically informed once the journal is generated. What is your response?

    Autoallocation uses Workflow, so there is no problem in satisfying this requirement.

  • 68

    One of your co-workers, ABC.com, is working to define and develop Financial Statement Generator reports where the budget amounts and actual amounts would display on the report per period. Tess comes to you and says that he has defined an FSG report according to the client's requirements; the actual amounts are correctly shown, but the problem is that budget amounts are not showing up on the report. What is your response?

    The budget name needs to be associated with the row set through control values.

  • 69

    Which five statements are true about the elements required for a set of books? (Choose five.)

    The same segment security rules apply to all segments that use the same value sets and have security enabled, although you can choose to assign the security rules to specific responsibilities., Multiple chart of accounts structures can share the same value sets., It is technically possible to use the same balancing segment value in multiple sets of books., Adjusting periods are used for journal entries originating in General Ledger only., Enable the appropriate functional currency before you define a set of books.

  • 70

    Identify two features of Content Sets when creating reports using Financial Statement Generator (FSG)? (Choose two.)

    They provide the ability to override row set definition., They enable the generation of multiple similar reports in a single run.

  • 71

    ABC.com, the GL accountant, says that he has heard about the budget upload functionality of Oracle GL and he is eager to test it. She is unable to test it in the CRP instance. What is your explanation?

    Budget journals are required at the set of books level.

  • 72

    In creating a report, what is true about the column set? (Choose two.)

    Formats can be set for each column., Calculations can be performed using columns.

  • 73

    ABC.com is getting ready to complete its month-end process. It needs to create a profit and loss statement and it wants to use the Financial Statement Generator feature to create the report. Which two elements are required to create the report? (Choose two.)

    Column Set, Row Set

  • 74

    Select the two minimum set up steps for intercompany accounting. (Choose two.)

    Enable Balance Intercompany Journal when defining the set of books., Set up intercompany accounts for journal source and journal category of Other.

  • 75

    Which three are part of the Global Consolidation System functionality ? (Choose three.)

    View the multilevel structure of your consolidation in a graphical format., Define mapping rules to determine how subsidiary account balances roll up into the parent., View the status and monitor subsidiary account balances for any changes that occur after the subsidiary data has been transferred.

  • 76

    ABC.com has two sets of books and six inventory organizations. What is the minimum number of times that ABC.com needs to run the general ledger interface in order to close the inventory at the end of each accounting cycle?

    6

  • 77

    A client has a requirement to allocate the rent and other expenses to all the departments based on the formula defined in GL Mass Allocation. Mario, the GL accountant, comes to you and asks whether the Mass Allocation program checks cross-validation rules, because this checking would help to prevent the creation of invalid accounts. What is your response?

    The program does NOT check cross-validation rules.

  • 78

    Which four attributes are validated during the Journal Import Verification Process? (Choose four.)

    Account Combination, Period, Balanced Journal, Cross Validation Rule

  • 79

    ABC.com, the GL accountant comes to you and says that the Accounting Department requires two current budgets, as they work with two senior executives within the company who have different budget figures, and Tess has to prepare and submit budgets to both of them. What is your response?

    It is not possible to have more than one current budget.

  • 80

    Your client wants the ability to report with Financial Statements Generator (FSG) and perform account inquiry at the summary (business unit) level of its Cost Center segment. A business unit is a group of cost centers and a business unit manager typically has several cost centers under his or her responsibility. Which option will meet the client's requirements?

    Define parent cost centers and a hierarchy of parent-child cost centers. Define Rollup Groups for the parent cost centers, and Summary Accounts. Create FSG based on the parent cost center values or Summary Accounts.

  • 81

    Which three statements are true about the revaluation process? (Choose three.)

    Revaluation calculates the differences between the current cumulative functional currency balance of the foreign transactions and the revalued functional currency balance calculated using the revaluation rate., The revaluation process revalues the foreign currency portion of the account balances using the revaluation rate defined in the Period Rates table., You must post the revaluation journal entries.

  • 82

    The GL user entered a taxable journal and posted it. Later the user realizes that he entered a wrong tax code. What should he do?

    reverse and re-enter the journal

  • 83

    The Accounting flexfield structure is Company-Department-Product-Account. Product has two rollup groups: Domestic and International. Department has one rollup group: Manufacturing. All accounting flexfield segment values can use alphanumeric characters. Which summary account template would Oracle General Ledger not allow you to create? (D: Detail) (T: Total)

    D-D-D-D

  • 84

    Which two statements would be true when helping a customer make implementation decisions for General Ledger? (Choose two)

    Integration issues can be minimized., Training can be standardized when Oracle is implemented without customization.

  • 85

    During the testing phase of your implementation, you find that you are unable to delete a journal batch, though it is not yet posted. You ask the technical consultant for help and he e-mails you a checklist of scenarios in which batches cannot be deleted. Which scenarios would be on this checklist? (Choose three.)

    Funds are in the process of being reserved for the batch., The source is frozen., Funds have been reserved for the batch.

  • 86

    Select the three true statements about mapping rules. (Choose three.)

    Mapping sets enable you transfer data from multiple subsidiaries simultaneously., A rollup rule tells General Ledger what detail level of information to transfer and how to roll that information up to the parent., You can define a combination of segment values and account rules.

  • 87

    What are two benefits of using the Journals Import: Group By Effective Date profile option? (Choose two.)

    Make daily updates to daily business intelligence., Account for business transactions by effective date or by accounting date.

  • 88

    You are implementing Oracle General Ledger at a client site. The client is based in the U.S. but has a presence in many countries worldwide, and has transactions in multiple currencies. The implementation team decides that GL multi currency setup will be part of the implementation. The GL accountant tells you that the companys outstanding loans in Europe in euros, and at every month end there is a need to revalue and report these loans in US dollars on the current exchange rate. She wants a system that automatically performs this revaluation using the month-end exchange rates. She wants to know whether this requirement can be satisfied. What is your response?

    Oracle GL provides this functionality and there is no problem in satisfying the requirement.

  • 89

    ABC.com wants to compare actual amounts against their budgeted amounts. Which reporting or query options would provide that detail? (Choose two.)

    On-line Account Inquiry, Financial Statement Generator

  • 90

    What is true about the budgetary control summary account template's indication that funds are available?

    When the summary account template is a Debit balance type, the amount is positive; when the template is a Credit balance type, the amount is negative.

  • 91

    US.-based ABC.com wants to consolidate the U.K. subsidiary accounting and the China subsidiary accounting into the U.S. parent accounting information. Both foreign subsidiaries and the U.S. parent have different currencies and different calendars. Which correctly describes the steps required before transferring balances to the U.S. parent?

    Run the revaluation process, post the revaluation journal, translate foreign currency, run the Trial Balance Report in the translated currency in the subsidiary set of books, review the Trial Balance to ensure accuracy.

  • 92

    ABC.com, the GL accountant, comes to you and asks whether she can use the Constant (C) segment type with parent segment values while defining the mass allocation formula. What is your response?

    You can only do so if there is a summary account associated with the parent.

  • 93

    ABC.com is implementing Oracle E-Business Suite 11.5.10. It wants to use a global chart of accounts. It has business operations in Canada, the United States, France, and Spain. You are told that both France and Spain require Document Sequencing whereas Canada and the United States do not. There are three legal entities in Canada, four in the United States, two in France, and two in Spain. All legal entities have the same fiscal year end. Advise the DBI Enterprise corporate controller what is feasible, in order to set up the minimum number of set of books, without customization.

    1 set of books for Canada, 1 for the U.S. and 2 for France and 2 for Spain. Enable Document Sequencing for France and Spain sets of books

  • 94

    Which three are true about the Global Consolidation System? (Choose three.)

    consolidates data from legacy feeder system, performs multidimensional analysis of consolidated financial data using Oracle Financial Analyzer, automatically generates journal entries to eliminate intercompany balances based on defined rules

  • 95

    Select the two minimum set up steps for intercompany accounting. (Choose two.)

    Set up intercompany accounts for journal source and journal category of Other., Enable Balance Intercompany Journal when defining the set of books.

  • 96

    ABC.com, the GL accountant, says that she has defined the budget and she wants her assistant accountants to enter and update budgets, but she does not want this budget to be the default budget. What is your response?

    If the client wants to do this, then the budget status should be Open.

  • 97

    The clients GL accountant, George, is responsible for taking care of recurring journals. He comes to you with a problem. He defined a recurring journal batch, and after that he generated the recurring journal from the definition. He wants to know whether he can add new lines in this unposted journal. What explanation would you give to George?

    Additional lines can be added to an unposted recurring journal through Review journal window.

  • 98

    Your client would like a consolidation process to consolidate operations in the UK and US. Your client requires a summary of transactions from both companies. Company 01 is located in Chicago; Company 02 is located in London. Both companies share only the same calendar. Which actions should be considered when defining the consolidation process for your client? (Choose all that apply.)

    Define mapping rules to map Company 01 and Company 02 to Company 90., lDefine an elimination set to include a group of related elimination entries., Define a consolidation process using the Global Consolidation System by defining Parent Company 90 to consolidate data from Company 01 and Company 02.

  • 99

    A General Ledger user at ABC.com opens the account inquiry screen, chooses a line item, and wants to drill down to Sub-ledger and find out more details about an Accounts Payable invoice. The user is unable to drill down. What is the likely explanation for this? (Choose two.)

    Journal source was not set up to import references., Drilldown was option not added to responsibility.

  • 100

    For which two business reasons would you use reporting hierarchies instead of summary accounts? (Choose two.)

    The primary use for summarization is only for reports., You want to easily reorganize summary views in the future.

  • (1-50)

    (1-50)

    ユーザ名非公開 · 50問 · 7ヶ月前

    (1-50)

    (1-50)

    50問 • 7ヶ月前
    ユーザ名非公開

    (51-100)

    (51-100)

    ユーザ名非公開 · 50問 · 7ヶ月前

    (51-100)

    (51-100)

    50問 • 7ヶ月前
    ユーザ名非公開

    (101-150)

    (101-150)

    ユーザ名非公開 · 50問 · 7ヶ月前

    (101-150)

    (101-150)

    50問 • 7ヶ月前
    ユーザ名非公開

    Mock 2

    Mock 2

    ユーザ名非公開 · 100問 · 7ヶ月前

    Mock 2

    Mock 2

    100問 • 7ヶ月前
    ユーザ名非公開

    151-175

    151-175

    ユーザ名非公開 · 25問 · 7ヶ月前

    151-175

    151-175

    25問 • 7ヶ月前
    ユーザ名非公開

    176-200

    176-200

    ユーザ名非公開 · 25問 · 7ヶ月前

    176-200

    176-200

    25問 • 7ヶ月前
    ユーザ名非公開

    (151-200)

    (151-200)

    ユーザ名非公開 · 50問 · 7ヶ月前

    (151-200)

    (151-200)

    50問 • 7ヶ月前
    ユーザ名非公開

    200-240

    200-240

    ユーザ名非公開 · 42問 · 7ヶ月前

    200-240

    200-240

    42問 • 7ヶ月前
    ユーザ名非公開

    240-300

    240-300

    ユーザ名非公開 · 58問 · 7ヶ月前

    240-300

    240-300

    58問 • 7ヶ月前
    ユーザ名非公開

    Final Mock (All)

    Final Mock (All)

    ユーザ名非公開 · 300問 · 7ヶ月前

    Final Mock (All)

    Final Mock (All)

    300問 • 7ヶ月前
    ユーザ名非公開

    問題一覧

  • 1

    One of your ABC.com co-workers, Tim, is working to define and develop Financial Statement Generator reports where the budget amounts and actual amounts would display on the report per period. Tim comes to you and says that he has defined an FSG report according to the client's requirements; the actual amounts are correctly shown, but the problem is that budget amounts are not showing up on the report. What is your response?

    The budget name needs to be associated with the row set through control values.

  • 2

    Jason, the corporate controller of ABC.com where you are implementing Oracle General Ledger, Accounts Payable, an Accounts Receivable, is very excited about the Global Intercompany System (GIS). He wrote some notes from a conversation with his accounting manager about GIS. He wants you to validate which points he has written down about GIS are true. Identify Jason's three correct points. (Choose three.)

    You can set up GIS so that the sender's transactions do not need to be approved by the receiver., Each company that uses GIS must be set up as a subsidiary that is associated with a balancing segment value., You can optionally send notifications to a defined user or responsibility when an intercompany transaction is initiated.

  • 3

    One of ABC.com's clients wants the ability to report with Financial Statements Generator (FSG) and perform account inquiry at the summary (business unit) level of its Cost Center segment. A business unit is a group of cost centers and a business unit manager typically has several cost centers under his or her responsibility. Which option will meet the client's requirements?

    Define parent cost centers and a hierarchy of parent-child cost centers. Define Rollup Groups for the parent cost centers, and Summary Accounts. Create FSG based on the parent cost center values or Summary Accounts.

  • 4

    Which report would provide information about the processing type (parallel or sequential) that may be defined for reports?

    Content Set Summary Listing

  • 5

    After you determine your needs and organize your summary account structure, which General Ledger tools can you use to define parent-child values and rollup groups?

    Account Hierarchy Manager or Account Hierarchy Editor (provided Applications Desktop Integrator is installed).

  • 6

    The Consolidation Workbench enables you to _____, _____, and _____. (Choose three.)

    access the State Controller., create consolidations sets, which launch multiple consolidations in a single step., create multilevel hierarchies, which you can view using the graphical Consolidation Hierarchy Viewer.

  • 7

    ABC.com wants to define a consolidation process for its enterprise. It has two sets of books: Set of Books A and Set of Books B. Both sets of books will use Oracle General Ledger. Set of Books A has three companies with the same calendar and chart of accounts as Set of Books B. Set of Books A has USD as its currency. Set of Books B has four companies with the same chart of accounts and calendar as Set of Books A. Set of Books B has GPD as its currency.

    Financial Statement Generator

  • 8

    You are implementing Oracle General Ledger at ABC.coms site. ABC.com is based in the US but has a global presence in many countries worldwide, and has transactions in multiple currencies. The implementation team decides that GL multi currency setup will be part of the implementation. The GL accountant approaches you to discuss multiple reporting currencies (MRC); he wants to implement MRC and link the primary set of books with the reporting set of books. Additionally, he says that the primary and reporting sets of books all have different calendars but share the same chart of accounts. What response do you provide?

    The primary and reporting set of books must share the same calendar and chart of accounts.

  • 9

    ABC.com is a $2 million company operating from the U.S., and has one set of books. It is spinning off from its parent company and will be operating as an independent company. It is considering implementing Oracle Financials but wants the product to work exactly in the same way as its legacy systems from its parent company. What considerations should be presented to ABC in order for it to make a well-informed decision? (Choose all that apply.)

    Patching is simplified on a non-customized Oracle implementation., Adding customizations to replicate the legacy system could increase cost of future upgrades., Integration issues between modules are reduced when there are no customizations.

  • 10

    Identify the two setups that control the defaulting of Tax Information on a journal entry. (Choose two.)

    Set of Books , Account

  • 11

    During a period, several preapproved batches of miscellaneous transactions were entered and released. The project manager informs you that he is unable to view the accounting in the expenditure inquiry form. Which process was likely omitted?

    distribute costs

  • 12

    What are the possible posting options in Oracle General Ledger?

    Post Journal batches individually Post multiple batches Use AutoPost

  • 13

    You are implementing Oracle General Ledger at a ABC.com site. ABC.com is based in the US but has a presence in many countries worldwide, and has transactions in multiple currencies. The implementation team decides that GL multi currency setup will be part of the implementation. John, a junior consultant helping you in the implementation effort, comes to you and says that he is testing the system and entering journals in US dollars, yen and euros. He says that he is able to enter the journals in US dollars and euros, but cannot enter the journals in Japanese yen. What possible explanation can you provide to John for this?

    Yen currency has not been enabled.

  • 14

    ABC.com has offices around the world, spread across different legal entities. ABC.com is implementing Oracle General Ledger. Its accounting department wants to know how to reduce the burden of elimination entries. What do you recommend?

    Recurring Journals

  • 15

    ABC.com has many Financial Statement Generator reports created to produce Profit & Loss statements and Balance Sheet reports. Occasionally ABC.com has a need to run a report that is slightly different than the standard ones that are already created. Which two types of changes could XYZ make using the Row Order feature? (Choose two.)

    display segment values and descriptions, sort based on column values

  • 16

    ABC.com has two diverse business operations in retail stores and services. It has five legal entities in Canada and five in the United States for both operations. The fiscal year end is the same for all the legal entities with 12 monthly periods. However, ABC.com wants to use a 4-5-4 accounting calendar for its retail operations and a calendar-month accounting calendar for the services operations. ABC.com also wants to use a single chart of accounts structure. Which five items must ABC.com define to meet the minimum setup steps that are required for the sets of books for all legal entities? (Choose five.)

    two accounting calendars, four sets of books, chart of accounts structure, period types or use seeded ones, one accounting calendar

  • 17

    After creating a number of Financial Statement Generator reports, ABC.com wants a list of the definitions for one specific account. Which report should be run to provide that information?

    FSG: Where Used Report

  • 18

    Exhibit: You work as a DBA for ABC.com. Please study the exhibit carefully. GL Consolidation: Preserve Journal Batching is set to Yes. GL Consolidation: Preserve Journal Effective Date is set to Yes. What would the result be?

    1, 3, 4

  • 19

    ABC.com is a national company with five divisions that share the same set of books. Select the statement that best describes the consolidation process for ABC Corporation.

    Enter eliminating journals and run financial reports.

  • 20

    ABC.com, the GL accountant, comes to you and says that he has defined the budget, and budget amounts have been entered and approved by management. After approval he wants his assistant accountants to NOT be able to update this budget. What is your response?

    If the client wants to do this, then the budget status should be Frozen.

  • 21

    Which two are true statements regarding elimination? (Choose two.)

    You must specify an elimination company in the Elimination Sets window., Currency is an optional component when defining an elimination set.

  • 22

    What is the effect of summary accounts on the efficiency of the posting process?

    should share the same period.

  • 23

    When you enter a journal, the journals in that batch _____.

    should share the same period

  • 24

    To review available Financial Statement Generator elements, which two reports would be helpful? (Choose two.)

    Column Set Summary Listing, Row Set Detail Listing

  • 25

    ABC.com has offices around the world, spread across different legal entities. ABC.com is implementing Oracle General Ledger. Its accounting department wants to know how to reduce the burden of elimination entries. What do you recommend?

    Recurring Journals

  • 26

    Oracle General Ledger provides a variety of ways to get information from reports and queries. What can you do using standard reports that you cannot do using on-line queries? (Choose all that apply.)

    group reports into report sets, view non-financial information

  • 27

    Which statement is correct about the differences between the functionalities of parent accounts and summary accounts?

    Summary accounts balances can be viewed in the Account Inquiry form, whereas parent accounts balances cannot be viewed in that form.

  • 28

    Which two statements correctly describe the translation process? (Choose two.)

    You can rerun the translation process more than once per period., Translation for a subsidiary can be initiated from the parent using the State Controller Translate button.

  • 29

    For each subledger there should be one _____.

    Journal Source

  • 30

    All of the manual journal entries are defaulting to a non current period. Which step was omitted from the accounting cycle?

    Update Period

  • 31

    ABC.com would like a consolidation process to consolidate operations in the UK and US. ABC.com requires a summary of transactions from both companies. Company 01 is located in Chicago; Company 02 is located in London. Both companies share only the same calendar. Which actions should be considered when defining the consolidation process for ABC.com? (Choose all that apply.)

    Define a consolidation process using the Global Consolidation System by defining Parent Company 90 to consolidate data from Company 01 and Company 02., Define an elimination set to include a group of related elimination entries., Define mapping rules to map Company 01 and Company 02 to Company 90

  • 32

    A manager at ABC.com wants to review the cash balance by company. He has asked you to create the summary account template. ABC.coms accounting flexfield has four segments: Company (5 values) Cost Centers (30 values) Region (4 values) Account (180 values) The total number of cash accounts is 5, which are associated with 2 parents: 3 accounts are associated with the parent called Checking. 2 accounts are identified with the parent called Savings. To combine the Cash parents, you created a rollup group named Cash. How many accounts would the summary account template generate?

    10

  • 33

    ABC.com wants to have 16 accounting periods that include an adjusting period for each quarter in its 4-5-4 accounting calendar. Its fiscal year end is March 31. The normal month end is on a Friday, but the last day of each quarter is always on the last day of the quarter's final calendar month. Choose the remaining setup for the calendar to meet the requirement.

    Define 12 monthly periods based on the 4-5-4 calendar ending on the last Friday of each month, except for the last month of each quarter ending on the last day of the month. Define an adjusting period for each of the last day of the quarter.

  • 34

    ABC.com wants to compare actual amounts against their budgeted amounts. Which reporting or query options would provide that detail? (Choose two.)

    On-line Account Inquiry, Financial Statement Generator

  • 35

    Your subledger accountants are attempting to import their journals to the general ledger at the end of the period. The journal import processes are completing with a warning and no journals are being generated. Which three steps would you take to troubleshoot this condition? (Choose three.)

    Confirm that data was sent from the subledger., Verify the output of the Journal Import request, Run journal import with all group IDs.

  • 36

    Which item CANNOT be queried in the Find Consolidation Process window?

    Parent Calendar

  • 37

    ABC.com, the GL accountant, is preparing a PowerPoint presentation for the accounting staff to explain the steps for creating mass allocation journal entries. Which five steps should Tess include in his presentation? (Choose five .)

    validate mass allocation definition, create mass allocation definition, post journal entries, generate mass allocation journals, review journal entries

  • 38

    Which rule has to be applied when using summary accounts to create a Mass Allocation journal?

    Constant (C) must be assigned to each rollup group used in the formula line.

  • 39

    ABC.com wants to use one set of books for its many subsidiary companies in Canada that will share the global chart of accounts structure and the Corporate Accounting Calendar. The controller is concerned about users charging to the wrong company when entering a journal entry. Which setup would address the controller's concern?

    Segment security rules would prevent users from seeing companies that they are not supposed to see.

  • 40

    ABC.com, a Canadian subsidiary of a U.S. company, wants to have an adjusting period in addition to its 12 calendar month accounting periods. Its fiscal year end is March 31. It will use foreign currency translations for its financial reports to the U.S. parent company, beginning April 2006. The company wants to use accounting period names that show the calendar year, not fiscal year. It plans to go live beginning April 1, 2006 with conversion of 1 year historical GL balances (fiscal year ending March 31, 2006). Choose the most appropriate accounting calendar setup.

    Period Type: Calendar. Accounting periods named: Apr-05 through Mar-07, with two adjusting periods named Adj-06 and Adj-07.

  • 41

    What are three benefits of using the Journals Import: Group By Effective Date profile option? (Choose three.)

    Make daily updates to daily business intelligence., Account for business transactions by effective date or by accounting date., facilitates financial auditing and compliance with the new Sabanes-Oxley Act

  • 42

    The clients GL accountant ABC.com comes to you with a problem. A journal cannot be posted because it has not been approved. The preparer cannot submit the journal for approval because the Approve Button is grayed out in the Enter Journals form, and the supervisor has not received a notification requesting the approval. What do you suggest as the possible cause for this problem?

    Budgetary control has been enabled for the set of books, and funds have not been reserved for the journal.

  • 43

    ABC.com is a global company based in the United States with divisions in North American, Europe and Asia. All of the journal imports, recurring journals, mass allocations and manual journal entries have been posted for their European subsidiary. What is the next logical step in the period-close process?

    Revalue foreign currency balances.

  • 44

    Which reports would be appropriate as part of a financial month-end close? (Choose all that apply.)

    Account Analysis, Trial Balance - Detail

  • 45

    ABC.com wants to define a consolidation process for its enterprise. It has two sets of books: set of books A and Set of Books B. Both sets of books will be defined in Oracle General Ledger. Set of books A will have three companies with the same chart of accounts as set of books B. Set of books A will have USD as its currency. Set of books B will have four companies with the same chart of accounts and different calendar as set of books A. Set of books B will have GPD as its currency.

    Global Consolidation System

  • 46

    ABC.com has a requirement that all budget entries are made through journals. Where would you set this up?

    Set of Books

  • 47

    In which three ways do sub-ledgers transfer information into General Ledger? (Choose three.)

    Detail Journals, Summary Journals, Batch Transfer

  • 48

    Which four are valid consolidation tools?

    Financial Statement Generator, Applications Desktop Integrator, Global Consolidation System, Interface Data Transformer

  • 49

    In the course of implementing General Ledger, you and your customer have created a number of Financial Statement Generator reports in a test environment. They have been tested and you are now ready to create these same reports in a production environment. You want to run the Financial Statement Generator transfer program. What is the minimum necessary to run this program? (Choose two.)

    Same set of books must be defined., Database links must be defined.

  • 50

    Which subledger transfers journal information directly to General Ledger to create an unposted journal entry?

    Assets

  • 51

    You set the GL: Journal Review Required profile option to Yes. What is the result?

    requires generated Autoallocation Journals to be reviewed before posting

  • 52

    What is the effect of summary accounts on the efficiency of the posting process?

    Use of summary accounts decreases the efficiency of the posting process.

  • 53

    ABC.com has three companies in Canada, two companies in the United States, two companies in Singapore, and one company in Belgium. All the companies, except for one in Canada, have the same fiscal year-end calendar. ABC Enterprise wants to use a common chart of accounts structure globally and set up each company as a balancing segment value. What is the minimum number of sets of books that should be defined?

    5

  • 54

    A ABC.com manager wants to review the cash balance by company. He has asked you to create the summary account template. ABC.coms accounting flexfield has four segments: Company (5 values) Cost Centers (30 values) Region (4 values) Account (180 values) The total number of cash accounts is 5, which are associated with 2 parents: 3 accounts are associated with the parent called Checking; 2 accounts are identified with the parent called Savings. To combine the Cash parents, you create a rollup group named Cash. Which summary account template would you create to review cash balances by company? (D: Detail) (T: Total)

    D-T-T-Cash

  • 55

    Joe is the controller of ABC.com, your client. He is anxious to see you demonstrate the basic functionality of General Ledger with a set of books that somewhat reflects his company's business. Tell him the minimum four pieces of information you need from him, to create a set of books for your demonstration. (Choose four.)

    accounting calendar with periods and fiscal year end, retained earnings account, company organization structure for Chart of Accounts, the base (functional) currency of his company

  • 56

    You work as a DBA for ABC.com. Please study the exhibit carefully. You are implementing Oracle General Ledger at ABC.com's site. ABC.com is based in the U.S. but has a global presence in many countries worldwide, and has transactions in multiple currencies. The implementation team decides that Oracle General Ledger multi currency setup will be part of the implementation. ABC.com's Chief Financial Officer wants a system which has features are displayed in the exhibit. Which of the requirements can be satisfied with the implementation?

    All requirements from I to V can be satisfied.

  • 57

    ABC.com is a U.S.-based company with business operations in North America and Europe. It has existing Oracle GL sets of books in its single global instance. All sets of books use a global chart of accounts and a common accounting calendar. It just expanded its business to Australia and acquired two new companies with the same year end as ABC.com. It wants to be able to include the new companies in existing financial reports created with Financial Statements Generator (FSG). How can it easily integrate the two new companies into its existing GL with minimal effort?

    Define two new company values, enable AUD currency, and define a new set of books. Translate AUD to USD and include the two new companies for FSG reports in USD

  • 58

    ABC.com, the GL accountant comes to you with a requirement to define a particular Autoallocation request set where approvers are sent notifications automatically for the generated journals. If there are any problems in generating the journals, then he should have the option to rollback the whole process. What is your response?

    The GL:Autoallocation Rollback Allow profile option must be enabled.

  • 59

    ABC.com's GL accountant is responsible for taking care of recurring journals. She comes to you with a problem: she ran the Generate Recurring Journal program before the AP and Payroll entries had been posted to GL. As a result, the recurring journal entries created are incorrect. She has not yet posted the generated recurring journal, and wants to know whether she can generate it again. The Sequential Numbering profile option is set to Partially used. What response do you offer?

    Delete the first generated recurring journal and generate it again.

  • 60

    When you change a summary account template funds check level from None to Advisory or Absolute, you need to _____.

    delete the original template and then recreate it for the appropriate funds check level

  • 61

    To review available Financial Statement Generator elements, which two reports would be helpful? (Choose two.)

    Column Set Summary Listing, Row Set Detail Listing

  • 62

    You are implementing Oracle General Ledger at a ABC.com site. ABC.com is based in the U.S. but has a presence in many countries worldwide, and has transactions in multiple currencies. The implementation team decides that GL multi currency setup will be part of the implementation. The company's management in the U.S. wants to see all the transactions in U.S. dollars, whereas the management in Europe wants to see the transactions in euros. The CFO has stated this requirement: While entering the daily transactions the user should have the ability to enter the current exchange rate, but at month end the assets and liabilities in euros could be converted into U.S. dollars at the monthly average exchange rate. Can this requirement be satisfied?

    Oracle GL provides this functionality and there is no problem in satisfying the requirement.

  • 63

    You are implementing Oracle General Ledger at a ABC.com site. ABC.com is based in the U.S. but has a presence in many countries worldwide, and has transactions in multiple currencies. The implementation team decides that GL multi currency setup will be part of the implementation. ABC.com's management in the U.S. wants to see all the transactions in U.S. dollars, whereas the management in Europe wants to see the transactions in euros. The CFO has stated this requirement: While entering the daily transactions the user should have the ability to enter the current exchange rate, but at month end the assets and liabilities in euros could be converted into U.S. dollars at the monthly average exchange rate. Can this requirement be satisfied?

    Oracle GL provides this functionality and there is no problem in satisfying the requirement.

  • 64

    You work as a DBA for ABC.com. Please study the exhibit carefully. ABC.com wants to distribute rent expense to its various departments on the basis of floor space. It has taken these steps: Which are the next two steps needed to distribute the rent cost to the various departments? (Choose two.)

    Post the journal., Define and generate MassAllocation.

  • 65

    ABC.com has a legal entity in each of its business operations in the United States, Canada, Malaysia, Singapore, and Italy. The controller in Italy advises that the corporation must use the Italian statutory accounts as its natural accounts. The corporation decides to define five sets of books (one for each country) but wants to use a single, global chart of accounts structure. Choose a possible design (for the sets of books) that uses a single, global chart of accounts structure, and also meets the Italian controller's requirement.

    The list of values in the Account segment includes a range reserved for Italy.

  • 66

    You are implementing Oracle General Ledger at a ABC.com site. ABC.com is based in the US but has a presence in many countries worldwide, and has transactions in multiple currencies. The implementation team decides that GL multicurrency setup will be part of the implementation. The Controller wants a system which allows the flexibility to enter transactions in any foreign currency, and at the same time automatically performs currency conversion online and in real time. She wants to know whether this requirement could be satisfied. What is the correct response?

    Oracle GL provides this functionality and there is no problem in satisfying the requirement.

  • 67

    After discussions with the client, the implementation team decides that the GL Autoallocation functionality would help satisfy the clients requirements to automatically allocate the rent and other expenses to all the departments based on the defined formula. The GL accountant comes to you with a requirement that the approver of the journal should be automatically informed once the journal is generated. What is your response?

    Autoallocation uses Workflow, so there is no problem in satisfying this requirement.

  • 68

    One of your co-workers, ABC.com, is working to define and develop Financial Statement Generator reports where the budget amounts and actual amounts would display on the report per period. Tess comes to you and says that he has defined an FSG report according to the client's requirements; the actual amounts are correctly shown, but the problem is that budget amounts are not showing up on the report. What is your response?

    The budget name needs to be associated with the row set through control values.

  • 69

    Which five statements are true about the elements required for a set of books? (Choose five.)

    The same segment security rules apply to all segments that use the same value sets and have security enabled, although you can choose to assign the security rules to specific responsibilities., Multiple chart of accounts structures can share the same value sets., It is technically possible to use the same balancing segment value in multiple sets of books., Adjusting periods are used for journal entries originating in General Ledger only., Enable the appropriate functional currency before you define a set of books.

  • 70

    Identify two features of Content Sets when creating reports using Financial Statement Generator (FSG)? (Choose two.)

    They provide the ability to override row set definition., They enable the generation of multiple similar reports in a single run.

  • 71

    ABC.com, the GL accountant, says that he has heard about the budget upload functionality of Oracle GL and he is eager to test it. She is unable to test it in the CRP instance. What is your explanation?

    Budget journals are required at the set of books level.

  • 72

    In creating a report, what is true about the column set? (Choose two.)

    Formats can be set for each column., Calculations can be performed using columns.

  • 73

    ABC.com is getting ready to complete its month-end process. It needs to create a profit and loss statement and it wants to use the Financial Statement Generator feature to create the report. Which two elements are required to create the report? (Choose two.)

    Column Set, Row Set

  • 74

    Select the two minimum set up steps for intercompany accounting. (Choose two.)

    Enable Balance Intercompany Journal when defining the set of books., Set up intercompany accounts for journal source and journal category of Other.

  • 75

    Which three are part of the Global Consolidation System functionality ? (Choose three.)

    View the multilevel structure of your consolidation in a graphical format., Define mapping rules to determine how subsidiary account balances roll up into the parent., View the status and monitor subsidiary account balances for any changes that occur after the subsidiary data has been transferred.

  • 76

    ABC.com has two sets of books and six inventory organizations. What is the minimum number of times that ABC.com needs to run the general ledger interface in order to close the inventory at the end of each accounting cycle?

    6

  • 77

    A client has a requirement to allocate the rent and other expenses to all the departments based on the formula defined in GL Mass Allocation. Mario, the GL accountant, comes to you and asks whether the Mass Allocation program checks cross-validation rules, because this checking would help to prevent the creation of invalid accounts. What is your response?

    The program does NOT check cross-validation rules.

  • 78

    Which four attributes are validated during the Journal Import Verification Process? (Choose four.)

    Account Combination, Period, Balanced Journal, Cross Validation Rule

  • 79

    ABC.com, the GL accountant comes to you and says that the Accounting Department requires two current budgets, as they work with two senior executives within the company who have different budget figures, and Tess has to prepare and submit budgets to both of them. What is your response?

    It is not possible to have more than one current budget.

  • 80

    Your client wants the ability to report with Financial Statements Generator (FSG) and perform account inquiry at the summary (business unit) level of its Cost Center segment. A business unit is a group of cost centers and a business unit manager typically has several cost centers under his or her responsibility. Which option will meet the client's requirements?

    Define parent cost centers and a hierarchy of parent-child cost centers. Define Rollup Groups for the parent cost centers, and Summary Accounts. Create FSG based on the parent cost center values or Summary Accounts.

  • 81

    Which three statements are true about the revaluation process? (Choose three.)

    Revaluation calculates the differences between the current cumulative functional currency balance of the foreign transactions and the revalued functional currency balance calculated using the revaluation rate., The revaluation process revalues the foreign currency portion of the account balances using the revaluation rate defined in the Period Rates table., You must post the revaluation journal entries.

  • 82

    The GL user entered a taxable journal and posted it. Later the user realizes that he entered a wrong tax code. What should he do?

    reverse and re-enter the journal

  • 83

    The Accounting flexfield structure is Company-Department-Product-Account. Product has two rollup groups: Domestic and International. Department has one rollup group: Manufacturing. All accounting flexfield segment values can use alphanumeric characters. Which summary account template would Oracle General Ledger not allow you to create? (D: Detail) (T: Total)

    D-D-D-D

  • 84

    Which two statements would be true when helping a customer make implementation decisions for General Ledger? (Choose two)

    Integration issues can be minimized., Training can be standardized when Oracle is implemented without customization.

  • 85

    During the testing phase of your implementation, you find that you are unable to delete a journal batch, though it is not yet posted. You ask the technical consultant for help and he e-mails you a checklist of scenarios in which batches cannot be deleted. Which scenarios would be on this checklist? (Choose three.)

    Funds are in the process of being reserved for the batch., The source is frozen., Funds have been reserved for the batch.

  • 86

    Select the three true statements about mapping rules. (Choose three.)

    Mapping sets enable you transfer data from multiple subsidiaries simultaneously., A rollup rule tells General Ledger what detail level of information to transfer and how to roll that information up to the parent., You can define a combination of segment values and account rules.

  • 87

    What are two benefits of using the Journals Import: Group By Effective Date profile option? (Choose two.)

    Make daily updates to daily business intelligence., Account for business transactions by effective date or by accounting date.

  • 88

    You are implementing Oracle General Ledger at a client site. The client is based in the U.S. but has a presence in many countries worldwide, and has transactions in multiple currencies. The implementation team decides that GL multi currency setup will be part of the implementation. The GL accountant tells you that the companys outstanding loans in Europe in euros, and at every month end there is a need to revalue and report these loans in US dollars on the current exchange rate. She wants a system that automatically performs this revaluation using the month-end exchange rates. She wants to know whether this requirement can be satisfied. What is your response?

    Oracle GL provides this functionality and there is no problem in satisfying the requirement.

  • 89

    ABC.com wants to compare actual amounts against their budgeted amounts. Which reporting or query options would provide that detail? (Choose two.)

    On-line Account Inquiry, Financial Statement Generator

  • 90

    What is true about the budgetary control summary account template's indication that funds are available?

    When the summary account template is a Debit balance type, the amount is positive; when the template is a Credit balance type, the amount is negative.

  • 91

    US.-based ABC.com wants to consolidate the U.K. subsidiary accounting and the China subsidiary accounting into the U.S. parent accounting information. Both foreign subsidiaries and the U.S. parent have different currencies and different calendars. Which correctly describes the steps required before transferring balances to the U.S. parent?

    Run the revaluation process, post the revaluation journal, translate foreign currency, run the Trial Balance Report in the translated currency in the subsidiary set of books, review the Trial Balance to ensure accuracy.

  • 92

    ABC.com, the GL accountant, comes to you and asks whether she can use the Constant (C) segment type with parent segment values while defining the mass allocation formula. What is your response?

    You can only do so if there is a summary account associated with the parent.

  • 93

    ABC.com is implementing Oracle E-Business Suite 11.5.10. It wants to use a global chart of accounts. It has business operations in Canada, the United States, France, and Spain. You are told that both France and Spain require Document Sequencing whereas Canada and the United States do not. There are three legal entities in Canada, four in the United States, two in France, and two in Spain. All legal entities have the same fiscal year end. Advise the DBI Enterprise corporate controller what is feasible, in order to set up the minimum number of set of books, without customization.

    1 set of books for Canada, 1 for the U.S. and 2 for France and 2 for Spain. Enable Document Sequencing for France and Spain sets of books

  • 94

    Which three are true about the Global Consolidation System? (Choose three.)

    consolidates data from legacy feeder system, performs multidimensional analysis of consolidated financial data using Oracle Financial Analyzer, automatically generates journal entries to eliminate intercompany balances based on defined rules

  • 95

    Select the two minimum set up steps for intercompany accounting. (Choose two.)

    Set up intercompany accounts for journal source and journal category of Other., Enable Balance Intercompany Journal when defining the set of books.

  • 96

    ABC.com, the GL accountant, says that she has defined the budget and she wants her assistant accountants to enter and update budgets, but she does not want this budget to be the default budget. What is your response?

    If the client wants to do this, then the budget status should be Open.

  • 97

    The clients GL accountant, George, is responsible for taking care of recurring journals. He comes to you with a problem. He defined a recurring journal batch, and after that he generated the recurring journal from the definition. He wants to know whether he can add new lines in this unposted journal. What explanation would you give to George?

    Additional lines can be added to an unposted recurring journal through Review journal window.

  • 98

    Your client would like a consolidation process to consolidate operations in the UK and US. Your client requires a summary of transactions from both companies. Company 01 is located in Chicago; Company 02 is located in London. Both companies share only the same calendar. Which actions should be considered when defining the consolidation process for your client? (Choose all that apply.)

    Define mapping rules to map Company 01 and Company 02 to Company 90., lDefine an elimination set to include a group of related elimination entries., Define a consolidation process using the Global Consolidation System by defining Parent Company 90 to consolidate data from Company 01 and Company 02.

  • 99

    A General Ledger user at ABC.com opens the account inquiry screen, chooses a line item, and wants to drill down to Sub-ledger and find out more details about an Accounts Payable invoice. The user is unable to drill down. What is the likely explanation for this? (Choose two.)

    Journal source was not set up to import references., Drilldown was option not added to responsibility.

  • 100

    For which two business reasons would you use reporting hierarchies instead of summary accounts? (Choose two.)

    The primary use for summarization is only for reports., You want to easily reorganize summary views in the future.