Mock 2

100問 • 7ヶ月前

問題一覧

Your client is in the process of closing its first year-end. The client completed the accounting cycle and found that several income statement accounts have a remaining balance. What would be the likely cause of these remaining balances?

Natural accounts were defined with incorrect account type.

Revenue accounts can be viewed only by the head of the Finance team, who has a GL Superuser responsibility. She has successfully created a standard Profit and Loss statement for the company. Another member of the department with a General Ledger Supervisor responsibility has been asked to run the standard Profit and Loss statement for Feb-06. The report shows only the expenses accounts. Which two steps should she perform so that the Profit and Loss statement will run successfully? (Choose two.)

Ask to have the profile option FSG: Enforce Segment Value Security changed to No., Ask to have security removed from her responsibility.

Which four statements are true about the Global Intercompany System AutoAccounting Rules? (Choose four.)

Sender Clearing Rules automatically generate the sender clearing transaction line., You can use only one set of Autoaccounting rules per pair of sender/receiver chart of accounts., Receiver Clearing Rules automatically generate the receiver clearing transaction line., Receiver Distribution Rules automatically generate the receiver transaction distribution line(s).

What does the elimination program enable you to do? (Choose all that apply.)

create journal entries for all values in the source account to zero them out and post them to a target account, eliminate intercompany balances for fully reciprocating elimination that repeat every accounting period

Which three statements are true about mapping rules? (Choose three.)

You can define account rules., You can define segment rules instead of account rules for faster processing., You can define segment mapping rules.

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.

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

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

What does the elimination program enable you to do? (Choose all that apply.)

eliminate intercompany balances for fully reciprocating elimination that repeat every accounting period, create journal entries for all values in the source account to zero them out and post them to a target account

What are the possible posting options in Oracle General Ledger?

Post Journal batches individually Post multiple batches Use AutoPost

ABC.com, the GL accountant comes to you and says that she is running the tests to check budget functionality. She says that the GL period is closed, but she was able to post the budget journal in a closed period. You check the setups and confirm that the GL period in which Tess was able to post the budget journal is closed. What explanation do you provide to Tess?

The budget year is Open.

Exhibit: You work as a DBA for ABC.com. Please study the exhibit carefully. Choose the correct set of events, in their correct order, for the accounting process.

G, F, E, A, B, D, C

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.

ABC.com's global chart of accounts structure includes the Company (balancing) segment and Intercompany segment (with Intercompany segment qualifier) in order to properly identify the intercompany trading party. Which statement is NOT true about using an Intercompany segment in the chart of accounts structure? (Choose the statement that is NOT true.)

If a journal entry is balanced within the same company value in the balancing segment, GL automatically uses the value in the Intercompany segment to create additional journal lines for the trading company.

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

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

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

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

Assets

Your manager has asked you to create a period close process that maximizes the efficiency of your two staff members and minimizes the number of closing days. Identify two sets of subledgers that can be closed concurrently. (Choose two.)

Order Management and Projects, Payables and Receivables

Which five do you need to define to meet the minimum pre-requisites to create a set of books? (Choose five.)

a retained earnings account, an accounting calendar, the functional currency (or a seeded currency), a chart of accounts structure, at least one value for each segment of the chart of accounts

ABC.com, the GL accountant comes to you and says that she has defined two budgets, but after selecting the budget organization in the Enter Budget Amounts form, she can select only one budget from the list of values (LOV). What is your response?

The first fiscal year of the budget was never opened.

Ask to have security removed from her responsibility., Ask to have the profile option FSG: Enforce Segment Value Security changed to No.

ABC.com, the GL accountant, says that the budget for which she is trying to enter data requires budget journals, but she wants to enter budget amounts directly. You check the budget setups and confirm that the Require Budget Journal option is not enabled at the set of books level. What could be cause of Tess's problem?

The Require Budget Journal option is enabled at the budget level.

ABC.com, the GL accountant comes to you with a requirement that all the journal batches for financial allocations should be automatically generated and validated. She wants to know whether Oracle GL functionality can satisfy this requirement. What is your response?

It is possible to satisfy this requirement by using the autoallocation functionality.

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

You are implementing Oracle General Ledger at a client site. The client 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 GL multi currency setup will be part of the implementation. One of the companies in Europe has a requirement to maintain account balances both in U.S. dollar and in euros, and for this purpose they have to enter each transaction twice in their present system, once in U.S. dollars and then again in euros. The Controller wants a system where transactions can be entered only in one currency, and then be automatically converted into another currency. Additionally they need the flexibility to enter different exchange rates for different types of accounts. He wants to know whether this requirement cold be fulfilled. What is your response?

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

The controller has asked you to produce a report that identifies the total outstanding receivable by customer, as of the period-ending date. Which report would fulfill this request?

Aging Report

Your client is closing its first period. The Accounting Manager informs you that she is unable to transfer payables to the general ledger or run other reports. She is using the Company XYZ Payable Manager responsibility. What is the likely cause of this error?

The responsibility is set up without a request group.

Mark, the GL accountant comes to you and says that he is running the tests to check budget functionality. He says that the GL period is closed, but he was able to post the budget journal in a closed period. You check the setups and confirm that the GL period in which Peter was able to post the budget journal is closed. What explanation do you provide to Mark?

The budget year is Open.

Which three functions can the Payables Accounting Process perform? (Choose three.)

transfers data to the interface table, runs the journal import, creates accounting entries

Which two actions would you perform using the Column Set Builder? (Choose two.)

create format mask, define calculations in new column

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

Enter eliminating journals and run financial reports.

Which type(s) of journal entry does General Ledger automatically reverse and post?

actuals only

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

Update Period

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.

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

ABC.com wants to ensure that no changes are made to unposted journals that come in from their subledgers. At which setup can you control this?

journal sources

Which four does Oracle Consolidation enable you to consolidate? (Choose four.)

multiple subsidiaries with different calendars to one parent set of books, multiple subsidiaries with different currencies to one parent set of books, multiple subsidiaries with same calendar to one parent set of books, multiple subsidiaries to one parent set of books

After running the Payables Accounting Process and posting the Journal Import, the accountant determines that several invoices have not been transferred to the General Ledger. Which three can cause an invoice to not be transferred to the General Ledger? (Choose three.)

Invoice is on hold., Invoice is unvalidated., Invoice is unaccounted.

Which action is part of the Projects tieback process?

Updates cost distribution lines.

ABC.com runs the Program-Create Journals, after which the Create Journal Entries Execution Report is automatically created. Identify three components that the report Create Journal Entries Execution Report reports on. (Choose three.)

Budget Journals, Purchasing Encumbrance Entries, Payables Encumbrance Entries

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

Trial Balance - Detail, Account Analysis

An auditor has asked the payables manager to provide detail that supports the Oracle Payables Liability amount listed on the balance sheet. Which report would best meet the auditor's request?

Accounts Payable Trial Balance

Which three activities would use summary accounts? (Choose three.)

Formulate a budget for employee benefits in each company based on the total of all budgeted employee salaries., Estimate a sales commission accrual based on the total of all product sales for each division., Allocate the total monthly costs of the Information Services department to other departments.

ABC.com has many parent segment values with a large number of child values in each parent. ABC.com is having problems running reports. Which profile option would enable better performance?

FSG: Enable Search Optimization

You are implementing Oracle General Ledger at a client site. The client 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.

ABC.com has a calendar with 12 monthly periods. Their fiscal year is the calendar year. ABC.com uses Average Balance Processing. ABC.com's Accrual category is defined with Autoreversal, with the reversal period as the Next Day, and an effective date rule of Roll. An accrual journal entered on 29-Apr-05 will be reversed on the _____.

next business day in the same period or next period based on transaction calendar

You are about to set up an accounting calendar for a new set of books at ABC.com. ABC.com's fiscal year end is March 31. The company is not sure if it wants to convert one year or two years of history in the GL. The controller wants to choose conversion of one-year history for an April 1, 2007 go-live date, but also wants to keep the option open for conversion of two-year history (to be decided before the go live date). ABC.com will use the GL Translation functionality, beginning from the first period, with historical GL balances. Which solution would meet ABC.com's requirement?

Define the calendar for Mar-05 through Mar-08. Open Mar-05 through Apr-06 periods. Plan to convert historical data from Apr-06 through Mar-07. If they choose a two-year history, they can always close all periods except Apr-06 later.

Purchasing Encumbrance Entries, Payables Encumbrance Entries, Budget Journals

ABC.com has decided on a chart of accounts structure that consists of four segments: Company - Cost Center - Account - Sub Account. It has one company value only, and wants to have the ability to restrict (limit the appearance of) the lists of Account values and Sub Account values for some cost centers. What are the design option would meet Newco Inc.'s requirement?

Define a value set with Independent validation and Non-Hierarchical Security for each of the three segments: Cost Center, Account and Sub Account. Enable security for all three segments and define security rules to restrict lists accordingly.

For each subledger there should be one _____.

Journal Source

ABC.com has many business units set up as company values in the Company (Balancing) segment for three sets of books: Canada, U.S. and Brazil. The sets of books share a common chart of accounts (COA) structure. The COA structure also has an Intercompany segment (with Intercompany Qualifier) that uses the same value set as the Company segment. Which three options will best use GL Intercompany functionality, given the multiple sets of books that share a common COA? (Choose three.)

Enable security for the Company segment, and define appropriate security rules, and assign them to the responsibility for each set of books., Enable the Balance Intercompany Journal option when defining each set of books., Create a clearing company for each set of books to handle many-to-many intercompany accounting in each set of books.

The ABC.com Corporation has five segments in its accounting flexfield. For a special Profit and Loss report, they want to sort by the fourth segment, which is product. In which definition would this be done?

Row Order

ABC.com, the GL accountant comes to you and says that to minimize maintenance efforts, disabled account code combinations should be automatically deleted from budget organization periodically. At the same time, if new account code combinations have been defined, then these should be automatically added. What is your response?

To do this, automatically run the Maintain Budget Organization program periodically.

What is a benefit of the secondary tracking segment?

More details are provided to retained earnings, cumulative translation adjustments, and revaluation gains/losses accounts.

Isa Global Inc. is based in the United States with divisions in Europe and Asia. All 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?

revaluing foreign currency balances

Select two actions that ledger sets permit. (Choose two.)

viewing account balances for multiple ledgers in one view , grouping multiple ledgers that share the same chart of accounts and calendar

Select three activities that must be performed to complete the setup of the key accounting flexfield. (Choose three.)

Define a value set. , Define an account structure. , Define valid segment values.

Which two statements are true about the reporting currency in Oracle General Ledger? (Choose two.)

It is an integrated extension of a ledger. , It replaces multiple reporting currencies.

Identify the four setup options that control supplier defaults. (Choose four.)

financial options , payables options, purchasing options , Payables system setup

Identify three ways that an invoice can be submitted for validation. (Choose three.)

online by clicking the Validate button in the Invoice Batches window , in batch by submitting the Payables Invoice Validation program from the Submit Request window , online by selecting either the Validate check box or the Validate Related Invoices check box in the Invoice Actions window

You are working on an implementation for Accounts Payable for ABC Inc. Your client has three requirements: 1. They want to be able to pay only certain types of suppliers by batch. 2. Each payment batch must be under $100,000 USD, or the batch automatically gets canceled without user intervention. 3. Each single payment for a supplier site must be between $10 USD and $10,000 USD, or the payment is automatically not issued. To meet the above requirements, you perform these steps: a) Set up suppliers with pay groups for each type, and use them when running the payment batch. b) Set up the payment batch with Maximum Outlay equal to $100,000 USD. c) Set up the payment batch with Maximum/Minimum payments as $10 USD and $10,000 USD. Which requirements have you met?

1 and 3

Payables lists four seeded payment methods. They are check, outsourced check, electronic, and wire. Choose the correct description for wire.

a funds transfer initiated by contacting the bank and requesting wire payment to the bank of a supplier

With Oracle Cash Management, you can reconcile payments created in Payables to your bank statements. When you reconcile payments using Oracle Cash Management, Cash Management updates the status of payments. Select the new status.

reconciled

Which event reverses an accrual for an item set to accrue on receipt?

matching an invoice in Payables to a purchase order

Identify three setup options that are defined in the Financial Options window. (Choose three.)

retainage , miscellaneous , expenses clearing

Select two actions available in Oracle General Ledger. (Choose two.)

importing data from subsidiary ledgers , consolidating balances from multiple ledgers

Which module of Oracle E-Business Suite Release 12 sends revaluation and accrual entries to General Ledger?

Oracle Treasury

Identify the different types of data that can be processed using the GL Interface. (Choose three.)

budget , statistical , intercompany

Choose the reason why Tina is unable to view the subledger entries from Oracle Payables in the Oracle General Ledger module. She has run the transfer program that completes successfully.

Journal Import is not submitted.

ABC Corporation has five companies, which operate in different industries. Each company has a different ledger-processing option that is industry specific. Choose the number of primary ledgers that are required to be defined.

five

Choose three tables that will be populated when the Journal Import process is run with the option to post set as "Yes." (Choose three.)

GL_JE_LINES , GL_JE_BATCHES , GL_JE_HEADERS

Select three levels where additional reporting currency representations can be maintained. (Choose three.)

journal , balance , subledger

You are implementing Oracle General Ledger at a client site. The client is based in the US, but they have a global presence in many countries and transactions in multiple currencies. The implementation team decides that the Oracle General Ledger multi-currency setup will be a part of the implementation. The client's Chief Financial Officer wants a system that has these features: 1. Enter transactions and reports in any currency. 2. Enter exchange rates online or automatically. 3. Calculate realized and unrealized gains and losses. IV. Translate actual and budget balances. 4. Produce foreign currency financial statements and reports. Which requirements can be satisfied with the implementation?

All requirements from 1 through 5 can be satisfied.

Identify three statements that are correct for the multi-currency functionality of Oracle General Ledger. (Choose three.)

Enter transactions and reports in any currency. , Enter exchange rates online and automatically. , Use daily, period end, average, and historical rates.

Which three are the benefits of the Currency Rates Manager in Oracle General Ledger? (Choose three.)

You can maintain daily rates and historical rates more easily. , You get improved efficiency with the help of the spreadsheet interface. , You can maintain consistency among different currency conversion rates.

John, the rates manager at ABC Company in the USA, is in charge of maintaining currency rates for the entire company. John had defined the rates for GBP to USD and GBP to Indian Rupee (INR) only. Sam, the company accountant, is worried that he would not be able to execute transactions involving USD and INR currencies. What does John say to help Sam?

Currency Rates Manager automatically performs the calculation between USD and INR on the basis of cross-rate rules.

Scott, the CFO at ABC Company in the USA, wants to present the annual income statement to the board of directors of the company. ABC Company engages in many exports and import activities and follows the policy to revalue all its transactions in foreign currency with the current market rates. Scott requests George, the head accountant of the company, to revalue all foreign currency transactions done during the year. Select two prerequisites that George must comply with to ensure that the revaluation is done as desired. (Choose two.)

Define accounts for unrealized gains and unrealized losses. , Define a revaluation rate for each currency for each period or date for which the revaluation must be run.

ABC Company in India imports baking equipment from XYZ Company in the USA. There is an outstanding invoice of $1,000,000 to be paid in two months. The USD-to-INR rate when the transaction was done was 47.5. Now the USD-to-INR rate has changed from 47.5 to 40.5. Jack, who is a treasury analyst at ABC Company, reviews the transactions and comes to a conclusion. Select two correct conclusions arrived upon by Jack. (Choose two.)

XYZ Company is not impacted at all by this rate change. , ABC Company has a positive impact by this rate change.

Select two statements that are correct for the secondary tracking segment. (Choose two.)

Any segment, except the natural account segment or the balancing segment, can be specified as the secondary tracking segment. , This segment will be paired with the balancing segment when generating account balances for retained earnings account, unrealized gains or losses account, and the cumulative translation adjustment account.

Identify four consolidation tools. (Choose four.)

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

Identify two correct statements about the consolidation feature of Oracle General Ledger. (Choose two.)

You can maintain multiple companies with similar or different accounting structures and consolidate their results for meaningful financial reporting., Both budget and actual balances can be consolidated.

ABC Company in the United Kingdom has three subsidiaries in three different countries. It consolidates the accounts of all subsidiaries and the headquarters by using the average balances. John is new to Oracle General Ledger. He has just joined ABC Company. He needs to consolidate for the current month. On completion of the consolidation, John was not able to tally the consolidated figures with the ledgers. Select two reasons why John failed to see the correct balances. (Choose two.)

Posting of the consolidation journals may have failed. , John may not have reversed the prior periods consolidation in the current period.

Select two restrictions that apply to consolidating budget balances. (Choose two.)

If the source and target budgets do not share the same start period, you must consolidate a specific period to a specific period. , If the source and target budgets do not share the same calendar, you must consolidate a specific period to a specific period.

Select three statuses of the consolidation workbench. (Choose three.)

posted, reversed, transferred

Select three statements that apply to Interface Data Transformer (IDT). (Choose three.)

It ensures reapplication of the same rules each time you transfer. , User-defined conditions enable you to control when transformation rules must be applied. , IDT provides automatic data conversion that converts disparate data formats into an Oracle format.

Flavour Inc. in the United Kingdom has a subsidiary in India known as Spices Inc. Flavour Inc. has a four-segment chart of accounts, whereas Spices Inc. has a five-segment chart of accounts. Select three statements that apply to consolidating ledgers with different charts of accounts. (Choose three.)

Only one action can be defined per parent segment. , Consolidations based on segment rules process faster. , A segment rule action must be defined for each segment in the parent chart of accounts.

Which two are true about elimination? (Choose two.)

You can define balancing options for eliminating entries. , You can define an elimination set to contain one elimination entry.

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

updating the period

Select the correct sequence of tasks required for period closing in Oracle General Ledger. 1. Verify that all journals are posted. 2. Close the period of each subledger. 3. Run the Trial Balance report and other month-end reports. 4. Close the period and open the next period. 5. Perform reconciliation of subsidiary ledgers. 6. Transfer and import data from all subledgers.

6, 5, 2, 1, 3, 4

You have a new employee in the buying department. She set up a number of item numbers and chose not to flag them for invoicing. Several transactions have been completed in Order Management by using these new item numbers. What effect would this event have on the Receivables closing process?

The transactions would be flagged as exceptions.

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

period, balanced journal , cross-validation rule , account combination

Identify two types of inquiries that are possible on ledger sets. (Choose two.)

an account inquiry on ledger sets to view actual accounts balances across multiple ledgers that are assigned to a ledger set , an account inquiry on ledger sets to view encumbrance account balances across multiple ledgers that are assigned to a ledger set

Natural accounts were defined with an incorrect account type.

Identify the three reports that can be processed using the State Controller window. (Choose three.)

Consolidation Audit, Consolidations Journal , Consolidation Exceptions

Your client is closing its first period. The client completed the accounting cycle for each of the subsidiary books. Its staff has called you to troubleshoot its process because the consolidation did not produce any data. Select two steps that you would perform to identify the error. (Choose two.)

Evaluate the mapping settings. , Review the GL_Interface tables.

ABC Company wants to compare consolidated actuals against consolidated budgeted amounts. Identify the two steps that must be performed to provide ABC Company with this information. (Choose two.)

Execute an online account inquiry. , Run financial statement generator reports.

Identify what three considerations must be executed before creating a report by using the financial statement generator. (Choose three.)

Determine the data to be reported. , Define attributes for rows and columns. , Decide which rows and columns will make up the report.

Which two actions would you perform by using the column set builder function? (Choose two.)

creating the format mask , defining calculations in the new column

Select two steps that are NOT elements of creating a Financial Statement Generator (FSG) report in Oracle General Ledger (Choose two.)

Attach the fiscal calendar. , Specify the default ledger for ledger sets.

the course of implementing Oracle General Ledger, you and your customer have created a number of Financial Statement Generator reports in a test environment. These reports have been tested and you are now ready to create them in your production environment. You are ready to run the FSG Transfer program. What two requirements are necessary to run this program? (Choose two.)

Database links must be defined. , The same ledgers must be defined in both instances.

100

XYZ Corporation has five segments in its accounting flexfield. For a special profit-and-loss report, they want to sort by the fourth segment, which is "product." Select the element that would meet this need.

row order

(1-50)

(1-50)

(51-100)

(51-100)

Mock 1

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

Mock 1

(101-150)

(101-150)

151-175

151-175

176-200

176-200

(151-200)

(151-200)

200-240

200-240

240-300

240-300

Final Mock (All)

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

Final Mock (All)

300問 • 7ヶ月前