1Z0-518 sample questions

Question 1

A global manufacturing firm is implementing Oracle R12.1 Receivables across three operating units: US, UK, and Germany. The implementation consultant has configured Multi-Org Access Control (MOAC). A senior AR manager based in the US needs to process receipts and create adjustments for customers in both the US and UK operating units, but must be prevented from accessing any German transactions. How should this security requirement be configured?

Accepted Answer

Create a single security profile that includes the US and UK operating units. Assign this security profile to the user's responsibility using the MO: Security Profile profile option.

Answer

Create a new responsibility and assign it to the user. Use profile options to limit access to the US and UK operating units.

Answer

Assign two separate security profiles, one for the US and one for the UK, to the AR manager's responsibility.

Answer

Set the MO: Operating Unit profile option at the user level to the US operating unit, and create a cross-OU responsibility for UK access.

Question 2

During data migration, a large number of legacy invoices are being imported into Oracle Receivables using the AutoInvoice interface. The AutoInvoice Master program completes, but the validation report shows that hundreds of records have been rejected with the error 'Your transaction numbering method is 'Automatic' but you have entered a transaction number.' What is the most efficient way to resolve this issue and re-process the rejected lines?

Accepted Answer

Run a SQL script to update the `RA_INTERFACE_LINES_ALL` table, setting the `trx_number` column to NULL for all rejected lines, and then re-run the AutoInvoice Master program.

Answer

Delete all rejected lines from the interface tables and re-populate the tables from the legacy system without the transaction numbers.

Answer

Temporarily change the Transaction Source setting 'Allow Transaction Numbering' to 'Yes' and re-run the AutoInvoice Master program.

Answer

Use the AutoInvoice Correction form to query the rejected lines, manually nullify the `trx_number` field for each line, and re-submit the import.

Question 3

A company wants to automatically apply receipts received via a bank lockbox file to open invoices. However, for a specific high-volume customer, 'Global Imports,' any receipts that cannot be matched to an invoice should be automatically placed on-account instead of being left unapplied. Which setup is required to achieve this specific requirement for only this customer?

Accepted Answer

In the Customer Account Profile for 'Global Imports', check the 'AutoCash Rule Set' option and assign a rule set that places remaining amounts on-account.

Answer

Set the system option 'Allow Unapplied Receipts' to 'No'.

Answer

In the Lockbox definition, set the 'Unapplied Receipt Rule' to 'On Account'.

Answer

Create a new Receipt Class with the 'Creation Method' set to 'Automatic' and assign it to the 'Global Imports' customer.

Question 4

The financial controller has mandated a new policy: all manual adjustments exceeding $500 must be approved by an AR Manager. Adjustments below this threshold do not require approval. Which set of configurations in Oracle Receivables is required to enforce this policy? (Select TWO)

Show answer & explanation

Correct answers: A, C

Accepted Answer

Define approval limits for each AR user in the Approval Limits window, specifying the document type as 'Adjustment'.

Accepted Answer

Enable the 'Require Approvals' checkbox on the System Options 'Trans and Customers' tab.

Answer

Set the profile option 'AR: Allow Adjustments' to 'Yes' at the site level.

Answer

Create a new Receivables Activity for adjustments and link it to an Oracle Workflow process.

Answer

Modify the 'Adjustment' transaction type to include an approval step.

Question 5

**Case Study: Global Pharma Inc. Receivables Consolidation** Global Pharma Inc. is a multinational pharmaceutical company that has grown through acquisitions. They currently operate three separate instances of Oracle E-Business Suite for their North America, Europe, and Asia-Pacific divisions. As part of a major business transformation project, they are consolidating into a single global R12.1 instance. The project has a key requirement to maintain data security and transactional integrity for each region while enabling a new global collections team, based in North America, to manage overdue invoices across all regions. The organizational structure in the new system will consist of one Business Group, three Ledgers (one for each region with its own chart of accounts and currency), and three corresponding Legal Entities. Each Legal Entity will have its own Operating Unit. The global collections team has been granted a new responsibility called 'Global Collections'. **Business Requirements:** 1. The 'Global Collections' responsibility must allow users to view customer account balances, transactions, and apply receipts for all three operating units (North America, Europe, Asia-Pacific). 2. Transactional data entry, such as creating new invoices, must remain restricted to users within their respective regional responsibilities (e.g., a user with the 'North America AR' responsibility can only create invoices in the North America Operating Unit). 3. The company uses a 5-segment Accounting Flexfield: Company, Cost Center, Account, Region, and Intercompany. The 'Region' segment must be automatically populated and validated based on the Operating Unit where a transaction is created. Which configuration is essential to allow the 'Global Collections' responsibility to access data across all three operating units?

Accepted Answer

Create a security profile that includes the North America, Europe, and Asia-Pacific operating units, and assign it to the 'Global Collections' responsibility via the MO: Security Profile profile option.

Answer

Define a separate responsibility for each operating unit and assign all three to the global collections users.

Answer

Set up Subledger Accounting (SLA) to use a secondary ledger that consolidates data from all three primary ledgers.

Answer

Define the MO: Operating Unit profile option at the site level to include all three operating units.

Question 6

True or False: In Trading Community Architecture (TCA), a single Party can be associated with multiple Customer Accounts, and a single Customer Account can be associated with multiple Parties.

Accepted Answer

False

Answer

True

Question 7

A user is attempting to complete a credit memo transaction but receives an error. The investigation reveals that the credit memo is for an invoice that has a receipt applied against it, and the receipt has already been remitted to the bank. What is the standard procedure in Oracle Receivables to handle this situation?

Accepted Answer

Reverse the remitted receipt, unapply it from the invoice, and then create and apply the credit memo.

Answer

Create an on-account credit memo and apply it to a different open invoice for the customer.

Answer

Use the Adjustments window to apply a negative adjustment to the invoice, bypassing the credit memo process.

Answer

Contact the bank to cancel the remittance, then unapply the receipt and process the credit memo.

Question 8

The Accounting Manager wants to ensure that the GL account used for freight charges on an invoice is derived from the standard memo line 'Freight' and not from the transaction type. Which component of AutoAccounting must be configured to achieve this?

Accepted Answer

Standard Lines

Answer

Transaction Types

Answer

Taxes

Answer

Salesreps

Question 9

A business needs to model a complex customer structure where a central headquarters ('Global Corp HQ') is responsible for credit decisions for all its subsidiaries, but each subsidiary ('Global Corp USA', 'Global Corp UK') is billed and pays for its own invoices. How should this be modeled in Oracle Trading Community Architecture (TCA)?

Accepted Answer

Create a party for each entity. Create separate customer accounts for each subsidiary. Then, create an account relationship where HQ is the parent account and enable credit checking at the parent level.

Answer

Create one customer account for 'Global Corp HQ' and define multiple bill-to and ship-to sites for each subsidiary.

Answer

Create separate customer accounts for each subsidiary and use a DFF to link them to the HQ account.

Answer

Create a single party for 'Global Corp' and set up profile classes for each subsidiary to manage individual billing.

Question 10

The period-end close process in Receivables must be performed in a specific sequence to ensure data integrity and accurate reporting. What is the correct final step in the Receivables period close process before the GL period can be closed?

Accepted Answer

Run the Create Accounting program with the Transfer to GL option set to 'Yes'.

Answer

Run the Revenue Recognition Master Program.

Answer

Run the AR to GL Reconciliation Report.

Answer

Close the Accounts Receivable accounting period in the 'Open/Close Periods' window.

Oracle E-Business Suite R12.1 Receivables Essentials Free Sample Questions

Lifetime One

Two

Pro Four

Premium Twelve

1Z0-518 Sample Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Trusted by professionals at