Oracle 1Z0-516 EBS R12 General Essential Practice Exam Set 7

You reviewed all the reconciliation reports for month-end close. Identify the correct sequence of actions you would undertake to close the month.


Options are :

  • Run AR Reconciliation Report, run Sales Journal Report, run Create Accounting Program.
  • Run Sales Journal Report, run AR to GL Reconciliation Report, run Create Accounting Program.
  • Run Create Accounting Program, run AR Reconciliation Report, run AR to GL Reconciliation Report.
  • Run Applied Receipts Report, run AR Reconciliation Report, run Journal Import.

Answer :Run Create Accounting Program, run AR Reconciliation Report, run AR to GL Reconciliation Report.

Which Oracle resource would you use to log, manage, and resolve product-related issues that you encounter in Oracle E-Business Suite Release 12?


Options are :

  • AppsNet
  • Oracle Technology Network (OTN)
  • Bug Database
  • MetaLink
  • AppsWorld

Answer :MetaLink

Party Merge provides the capability to merge parties and their related entities in the Oracle Trading Community Architecture (TCA) Registry, thereby eliminating duplicate data in the Registry. Select four entities that can be successfully merged using the Party Merge functionality. (Choose four.)


Options are :

  • You can merge bill-to sites with ship-to sites.
  • You can merge bill-to sites with bill-to sites.
  • You can merge individuals with organizations.
  • You can merge individuals with individuals.
  • You can merge organizations with organizations

Answer :You can merge bill-to sites with bill-to sites. You can merge individuals with organizations. You can merge individuals with individuals. You can merge organizations with organizations

1Z0-238 R12 Oracle Install,Patch & Maintain Oracle APP Test Set 2

Your company needs a solution that provides the option of transferring a high volume of customer receipts from the bank into the Oracle Accounts Receivable system. You do not want the customers account balance to be affected immediately when the receipts are transferred and uploaded to the receivables system. Which is the most appropriate receipt creation method to implement in Oracle Receivables?


Options are :

  • Quickcash receipts
  • Miscellaneous receipts
  • Cash receipts
  • Manual receipts
  • Automatic receipts

Answer :Quickcash receipts

All receipts that fail validation during AutoLockbox processing remain in the _____ table.


Options are :

  • AR_PAYMENTS_INTERFACE_ALL
  • AR_INTERIM_CASH_RCPT_LINES_ALL
  • AR_INTERIM_CASH_RECEIPTS_ALL
  • AR_PAYMENT_SCHEDULE

Answer :AR_PAYMENTS_INTERFACE_ALL

Choose the correct sequence of events taking place in the data access set setup process. 1. Define a legal entity. 2. Define ledger sets. 3. Define data access sets. 4. Define a secondary ledger. 5. Define a primary ledger. 6. Assign a data access set to responsibilities. 7. Define operating units.


Options are :

  • 1, 7, 3, 2, 5, 4, 6
  • 1, 7, 5, 4, 2, 3, 6
  • 1, 2, 3, 4, 5, 6, 7
  • 1, 7, 4, 5, 3, 2, 6

Answer :1, 7, 5, 4, 2, 3, 6

1Z1-574 Oracle IT Architecture Essentials Practice Exam Set 5

Your client will use the seeded credit classifications of Low Risk, Moderate Risk, and High Risk to evaluate the credit worthiness of customers. It has also created the following credit review types: New Credit Limit Domestic Credit International Credit Guarantor of Credit Lease Application Credit How many credit checklists should the management set up in Oracle Credit Management to perform credit reviews in accordance with the organization's current policies?


Options are :

  • Eight
  • One
  • Five
  • Fifteen
  • Ten
  • Three

Answer :Fifteen

ABC Enterprise closes its books on March 31st. These activities have been identified to be performed for the closure of books. 1) post 2) translate 3) review 4) consolidate 5) revalue 6) run accounting reports 7) close accounting period In which order must these activities be performed?


Options are :

  • 1, 3, 5, 2, 4, 6, 7
  • 1, 5, 2, 3, 4, 7, 6
  • 1, 3, 2, 5, 7, 4, 6
  • 5, 2, 3, 1, 7, 4, 6

Answer :1, 3, 5, 2, 4, 6, 7

Which relationship group would you assign to allow each party to pay for its own transactions, as well as the transactions of all parties that are lower in the hierarchy (children, grandchildren, and so on)?


Options are :

  • Pay group
  • Pay without
  • Pay parties
  • Pay below

Answer :Pay below

1Z0-982 Oracle Enterprise Planning and Budgeting Cloud Test Set 3

You created an invoice with one line item of $100 and a tax of $10. This line item is credited with an applied credit memo of $50. What is the credit to the tax line?


Options are :

  • $10
  • $5
  • $20
  • $1

Answer :$5

Which three payment terms validations are performed by AutoInvoice for imported balance forward billing (BFB) transactions? (Choose three.)


Options are :

  • All transactions are batched by batch source name and request ID
  • Transactions with nonbalance forward billing payment terms for balance forward customers have the override terms check box selected.
  • Transactions with balance forward billing payment terms have balance forward billing enabled at the account and site profiles.
  • Transactions with balance forward billing payment terms having the external billing cycle have a billing date.
  • The transaction is stamped with legal entity information.

Answer :Transactions with nonbalance forward billing payment terms for balance forward customers have the override terms check box selected. Transactions with balance forward billing payment terms have balance forward billing enabled at the account and site profiles. Transactions with balance forward billing payment terms having the external billing cycle have a billing date.

Your client has requested that you set up gapless numbering for its invoices. In your testing, you realized that the numbers for deleted invoices were missing from the sequence. How would you prevent that problem?


Options are :

  • Do not allow deletion of invoices.
  • Select Show Deleted Invoice Numbers in your system options.
  • Create a custom report listing deleted invoice numbers.
  • Reuse deleted invoice numbers.

Answer :Do not allow deletion of invoices.

Oracle 12c SQL Certified Associate 1Z0-071 Real Exam 2019 Set 3

Oracle Credit Management (OCM) uses lookups to help speed up data entry and increase accuracy. Select two required lookups used by OCM. (Choose two.)


Options are :

  • Payment terms
  • Risk code
  • Credit rating
  • Credit review type
  • Credit classification

Answer :Credit review type Credit classification

Select two correct statements for the management segment qualifier in Oracle General Ledger. (Choose two.)


Options are :

  • The management segment can be a natural account segment.
  • The management segment cannot be an intercompany segment.
  • Data access sets cannot limit access to specific management segment values.
  • The management segment can be a balancing segment.
  • This segment qualifier is used for management reporting and analysis

Answer :The management segment cannot be an intercompany segment. Data access sets cannot limit access to specific management segment values.

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


Options are :

  • For calendar conversion, the journal effective date determines the corresponding nonadjusting period in the secondary ledger.
  • The General Ledger Posting program uses the rules to determine which journals to automatically transfer to the secondary ledger during posting.
  • Journal conversion rules are applied to select the journals for transfer to the secondary ledger based on journal batches.
  • Chart of account conversion is required if the primary ledger and secondary ledger have the same chart of accounts structure.
  • Currency conversion rules are required for consolidating primary and secondary ledgers only when their currencies are different.

Answer :For calendar conversion, the journal effective date determines the corresponding nonadjusting period in the secondary ledger. The General Ledger Posting program uses the rules to determine which journals to automatically transfer to the secondary ledger during posting. Currency conversion rules are required for consolidating primary and secondary ledgers only when their currencies are different.

Oracle 1Z0-207 Billing & Revenue Mgmt Pricing Practice Exam Set 6

ABC Company is implementing Oracle Financials. The finance manager wants to set up a control point before the Receivables entries are transferred to General Ledger. Which two statements are correct about the control mechanisms that Receivables can provide? (Choose two.)


Options are :

  • Oracle Approvals Management (AME) Workflow can be used to approve or reject the adjustment activities.
  • Oracle approval limit can be used to approve or reject the invoices.
  • Oracle Approvals Management (AME) Workflow can be used to approve or reject the invoices.
  • Oracle approval limit can be used to approve or reject the credit memos.
  • Oracle approval limit can be used to approve or reject the adjustment activities.
  • Oracle Approvals Management (AME) Workflow can be used to approve or reject the credit memos.

Answer :Oracle approval limit can be used to approve or reject the adjustment activities. Oracle Approvals Management (AME) Workflow can be used to approve or reject the credit memos.

Your company is using Oracle Receivables and Trade Management to create and resolve claims. A non-invoice-related claim is generated in Oracle Receivables and transferred to Trade Management for investigation. The balancing segments used for accounting on the individual transactions are: Claim Investigation:1001 Unapplied Cash: 1000 Cash: 1000 Receivables: 2000 Receipt Write-Off: 3000 If you are using the Account Generator to update the balancing segment values, what is the balancing segment that is derived if the claim is resolved via receipt write-off?


Options are :

  • 2000
  • 1000
  • 3000
  • 1001

Answer :1000

After registering new data sources, you must complete your Bill Presentment Architecture by creating database views. How many database views can you create for each data source?


Options are :

  • Nine
  • Three
  • Unlimited
  • One

Answer :Unlimited

1Z0-982 Oracle Enterprise Planning and Budgeting Cloud Test Set 1

You are setting up Receivable Accounting Events in Subledger Accounting. Identify the Event Entity.


Options are :

  • Invoices
  • Deposits
  • Transactions
  • Guarantees
  • Chargebacks

Answer :Transactions

Which four transaction types or activities are affected by the "AR : Disable Receivable Activity Balancing Segment" profile option? (Choose four.)


Options are :

  • Adjustments
  • Invoices
  • Debit memos
  • Activity applications (such as receipt write-off, short-term debt, and claims investigation)
  • Late charges
  • Discounts (both earned and unearned)

Answer :Adjustments Activity applications (such as receipt write-off, short-term debt, and claims investigation) Late charges Discounts (both earned and unearned)

A user attempted to close the Accounts Receivable accounting period and received an error. What could be the cause of the error?


Options are :

  • . Invoices are entered but not completed
  • Create Accounting program did not run.
  • There are AutoInvoice interface errors.
  • There are lockbox interface errors.
  • There are existing invoice exceptions.
  • There are lockbox interface errors.

Answer :Create Accounting program did not run.

OCA Oracle Database 11g Administrator Certified Associate Set 1

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


Options are :

  • Define security rules.
  • Create account combinations.
  • Define a value set.
  • Define valid segment values.
  • Create aliases.
  • Define an account structure.

Answer :Define a value set. Define valid segment values. Define an account structure.

After reviewing an incomplete invoice entered last week by her assistant, Jovi clicked the Complete button in the Transactions window. What are three changes this would create in Oracle Receivables? (Choose three.)


Options are :

  • The invoice is now included in the standard aging and collection process if the transaction type has open receivables set to No.
  • A dunning letter is now sent to the customer for the invoice amount.
  • This invoice can now be printed.
  • This invoice now becomes eligible to be transferred to General Ledger.
  • Payment schedules are now created based on the payment terms and invoice date.

Answer :This invoice can now be printed. This invoice now becomes eligible to be transferred to General Ledger. Payment schedules are now created based on the payment terms and invoice date.

Your client wants to import paid invoices from its legacy system to Oracle Receivables. It does not want to post the paid invoices to GL or update the customer balances. How would you import invoices in this scenario?


Options are :

  • Create a transaction source and set the status to Inactive.
  • Assign a transaction type with no values for the receivable and revenue accounts.
  • Create a transaction source with the GL Date in a Closed Period box set to Adjust.
  • Assign a transaction type with the Open Receivable and Post to GL boxes deselected.

Answer :Assign a transaction type with the Open Receivable and Post to GL boxes deselected.

1Z0-206 Oracle E-Business Suite R12 SystemAdministrator Exam Set 2

A global company uses Oracle E-Business Suite Release 12 for its operations in the U.S. and Canada. The company is now adding Mexico to the Oracle E-Business Suite Release 12 Applications. As a system administrator, you need to set the MO: Operating Unit profile option for Mexico. Customer is not using Multi-Org Access Control. You set the MO: Operating Unit profile option at the _____ level.


Options are :

  • Responsibility
  • Application
  • User
  • Site

Answer :Responsibility

After creating two new customers, LeftBank and RightSide, you create and complete an invoice for $105 ($100 plus $5 tax) for LeftBank. You immediately realize that you should have created the invoice for RightSide. Which three steps can you take to correct the situation? (Choose three.)


Options are :

  • Change the status of the invoice to incomplete. Change the customer in the invoice to RightSide. Complete the invoice.
  • Create an on-account credit memo for $105 for LeftBank. Apply the on-account credit memo to the invoice. Enter and complete the invoice for RightSide.
  • Change the status of the invoice to incomplete. Delete the invoice, and then enter and complete the invoice for RightSide.
  • Create an adjustment to the invoice for the entire amount, and then create a negative adjustment to the account of RightSide.
  • Change the status of the invoice to incomplete. Change the transaction type of the invoice to a transaction type that has creation sign equal to negative sign. Complete the invoice. Enter and complete the invoice for RightSide.

Answer :Change the status of the invoice to incomplete. Change the customer in the invoice to RightSide. Complete the invoice. Create an on-account credit memo for $105 for LeftBank. Apply the on-account credit memo to the invoice. Enter and complete the invoice for RightSide. Change the status of the invoice to incomplete. Delete the invoice, and then enter and complete the invoice for RightSide.

Computer Operations Inc. has its headquarters in Frankfurt. It uses two ledgers: one for corporate accounting (primary) and another for statutory reporting (secondary). Both ledgers have different charts of accounts and accounting calendars but use EUR as the functional currency. It has a subsidiary in California, which uses its own chart of accounts and the USD currency. Identify two options by which Computer Operations Inc. can consolidate their global operations. (Choose two.)


Options are :

  • A new ledger set must be defined, which will group the Frankfurt primary ledger and the California secondary ledger.
  • The chart of accounts and calendar of the Frankfurt secondary ledger must be the same as that of the California secondary ledger.
  • A secondary ledger must be defined for California.
  • Consolidation can be done by mapping between the California secondary ledger and the Frankfurt secondary ledger.

Answer :A new ledger set must be defined, which will group the Frankfurt primary ledger and the California secondary ledger. A secondary ledger must be defined for California.

OCA Oracle Database 10g Administrator I-1Z0-042 & II-1Z0-043 Set 2

AutoInvoice does not import Receivables invoices from the interfaces. Identify two reasons that can cause AutoInvoice to fail. (Choose two.)


Options are :

  • Default Remit-to address is not defined.
  • Transaction General Ledger date is in a closed period.
  • Sold To Customer is validated by ID.
  • AutoCash rule set is not defined.
  • Receivables adjustment activities are not defined.

Answer :Default Remit-to address is not defined. Transaction General Ledger date is in a closed period.

To properly associate one transaction type with another in Receivables, you have to define transaction types in a specific order. Identify the correct order.


Options are :

  • Debit memo, invoice, credit memo
  • Invoice, debit memo, credit memo
  • Invoice, credit memo, debit memo
  • Credit memo, invoice, debit memo
  • Credit memo, debit memo, invoice
  • Debit memo, credit memo, invoice

Answer :Credit memo, invoice, debit memo

Which three statements are true about AutoInvoice? (Choose three.)


Options are :

  • It determines the GL accounts from the rows in the RA_INTERFACE_DISTRIBUTIONS_ALL table.
  • It uses the AutoInvoice clearing account if it cannot determine the Receivables account by using AutoAccounting.
  • It determines whether the invoices should have open or closed status on the basis of the line amounts.
  • It imports invoices that have only transaction types that are of the "imported" transaction class.
  • It determines the General Ledger (GL) accounts by using AutoAccounting.
  • It uses the AutoInvoice clearing account if the price multiplied by quantity does not equal the total amount for a line.

Answer :It determines the GL accounts from the rows in the RA_INTERFACE_DISTRIBUTIONS_ALL table. It determines the General Ledger (GL) accounts by using AutoAccounting. It uses the AutoInvoice clearing account if the price multiplied by quantity does not equal the total amount for a line.

Oracle 12c SQL Certified Associate 1Z0-071 Real Exam 2019 Set 4

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions