Oracle 1Z0-516 Online Practice Questions and Exam Preparation

Oracle 1Z0-516 Online Questions & Answers

• Question 261:

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

  A. Change the status of the invoice to incomplete. Delete the invoice, and then enter and complete the invoice for RightSide.
  B. Change the status of the invoice to incomplete. Change the customer in the invoice to RightSide. Complete the invoice.
  C. Create an adjustment to the invoice for the entire amount, and then create a negative adjustment to the account of RightSide.
  D. 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.
  E. 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.
  A. Change the status of the invoice to incomplete. Delete the invoice, and then enter and complete the invoice for RightSide.
  B. Change the status of the invoice to incomplete. Change the customer in the invoice to RightSide. Complete the invoice.
  D. 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.

• Question 262:

  Given the following code:

  

  Which function, when filled in the blank, will return a value of 1?

  A. arrayfind
  B. findinsidearray
  C. findarray
  D. findinarray
  C. findarray

• Question 263:

  When implementing Subscription Ordering according the Subscription Ordering Implementation Guide, you are asked to modify the formula for the Price (List) line level attribute. What must you do to properly modify the formula?

  A. Add an initial condition that tests for a valid price value in the Price files of the BOM Item Definition table with a true value of the valid price value.
  B. Add an initial condition that tests for the Action Code to be either DELETE or TERMINATE with a true value of zero.
  C. Add an initial condition that tests for a valid entry in a specific Subscription Ordering price book with a true value of zero.
  D. Add an initial condition that tests for the Action Code to be either DELETE or TERMINATE with a true value of Part Base Price.
  E. Add an initial condition that tests for a valid price value in the Price field of the BOM Item Mapping table with a true value of the valid price value.
  D. Add an initial condition that tests for the Action Code to be either DELETE or TERMINATE with a true value of Part Base Price.

• Question 264:

  ABC Corp. has determined its Accounting Key Flexfield structure for the implementation of Oracle E-Business Suite Release 12. The Accounting Key Flexfield structure contains five Segments: Company, Business Unit, Department, Account, and Product.

  They have the following requirements:

  1) The Department values should be based on the Business Units. 2) They want to produce a quarterly Balance Sheet for each Company.

  Which three statements are true? (Choose three.)

  A. The Product Value Set is dependent on the Accounts.
  B. The Business Unit Value Set is defined as Independent.
  C. The Account Segment has a Value Set with no Validation.
  D. The Company Segment is qualified as the Balancing Segment.
  E. The Department Segment is qualified as an Intercompany Segment.
  F. Cross-validation rules are required to enforce dependency of Departments on the Business Units.
  B. The Business Unit Value Set is defined as Independent.
  D. The Company Segment is qualified as the Balancing Segment.
  F. Cross-validation rules are required to enforce dependency of Departments on the Business Units.

• Question 265:

  Which attribute type cannot be displayed on the line item grid?

  A. HTML attributes
  B. Currency attributes
  C. Text attributes
  D. Single-select menu attributes
  C. Text attributes

• Question 266:

  

  View the Exhibit. While entering a journal in the Journals form, you enter a code combination of 29.402.4519.2103.240 in the five-segment Accounting Flexfield. However, you are unable to proceed after entering this account combination.

  What could be the problem in the structure definition of the Accounting Flexfield?

  A. The "Freeze Rollup Groups" check box is selected.
  B. The "Allow Dynamic Inserts" check box is deselected.
  C. The "Freeze Flexfield Definition" check box is selected.
  D. The "Cross-Validate Segments" check box is selected.
  B. The "Allow Dynamic Inserts" check box is deselected.

• Question 267:

  When doing a part search from home page, you have the Create Quote button to create a new Transaction.

  How do you change the label of this button?

  A. Open the Text Administration admin page, go to "C", change the entry "Create Quote" and enter "Translated Text"
  B. Go to the Process Invocation admin page, open the Part Search Results page, and change the name of the action that has the type "Start"
  C. Go to the Process Invocation admin page, open the Part Search Results page, select navigation "Rules" of the action that has the type "Start", and change the name of the invocation rule which points to the right commerce process
  D. Open the Commerce Process admin page, navigate to Process Actions, and change the label of the "_action_new_transaction" action
  D. Open the Commerce Process admin page, navigate to Process Actions, and change the label of the "_action_new_transaction" action

• Question 268:

  The Related Parts data table exists in the QA environment and in the production environment. The table has 3,000 records in the QA environment and 4,000 records in the production environment.

  How many records will be present in the data table in the production environment if this table is migrated from the QA environment?

  A. 1,000
  B. 7,000
  C. 4,000
  D. 3,000
  C. 4,000

• Question 269:

  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.

  A. 6, 5, 2, 1, 4, 3
  B. 3, 2, 1, 6, 4, 5
  C. 6, 5, 1, 3, 2, 4
  D. 6, 5, 2, 1, 3, 4
  E. 6, 2, 3, 1, 5, 4
  D. 6, 5, 2, 1, 3, 4

• Question 270:

  You have transferred, closed, and reconciled all subledgers. The sales manager informs you about a material transaction that was completed on the last business day of the closing period. Select the best option in this situation.

  A. Ignoring the transaction in the current period
  B. Opening the subledger to enter the transaction
  C. Reversing the prior postings and retransferring data from the subledgers
  D. Recording a manual accrual journal in the current period and reversing the journal in the next period
  D. Recording a manual accrual journal in the current period and reversing the journal in the next period