Receivable Interview Question on Oracle EBS R12

By -

 1. How many payment methods can be assigned to a customer?


a. One

b. Two

c. Eight

d. Unlimited


2. What are the two types of commitments in Oracle Receivables?


3. While entering Invoices manually, Ship to Address of the customer is mandatory.


a. True

b. False


4. Name the two Invoicing Rules in Oracle Receivables


5. Assuming a payment term ‘IMMEDIATE’ is attached to a Transaction Type, can we raise an Invoice with Payment term ’30 Days’ for the transaction type?


a. Yes

b. No


6. In which of the following field, Standard Memo Lines appear as List of values


a. Invoice Lines Description

b. Transaction Type

c. Miscellaneous Receipt Description

d. Invoice Item Code


7. Auto Cash Rule Sets are defined to 


a. Automatically apply receipts to invoices

b. Automatically apply commitments to invoices

c. Automatically apply credit memos to invoices

d. All of the above


8. If a value in a Profile class is changed, the system will


a. Automatically change the value for all existing customers with the profile class

b. Assign the new value only to new customers

c. Prompt the user whether to update for all customers or only for new customers.

d. None of the above


9. Which is of the following is a mandatory descriptive Flexfield to be defined before importing simple invoices through Auto Invoice?


a. Line Transaction Flexfield

b. Link-to Transaction Flexfield

c. Reference Transaction Flexfield

d. None of the above


10. Name the interface tables used for Auto Invoice Lines and Distributions


11. What are the valid values for the column LINE_TYPE in the interface table?


12. Can the user import invoices with user defined code combinations without using auto accounting?


a. Yes

b. No


13. Which of the following information is not required when the user is importing Credit memos?


a. Transaction Type

b. Customer 

c. Payment terms

d. Amount


14. Miscellaneous Receipts can be imported into Oracle Receivables using Auto Lockbox


c. True

d. False


15. Name the interface table used for Auto Lockbox.


16. The three steps in Auto Lockbox in sequence are 


a. Validation, Import, Post QuickCash

b. Import, Validation, Post QuickCash

c. Post QuickCash, Import, Validation

d. Any of the above


17. Lockbox is defined for a 


a. Bank

b. Bank Branch

c. Bank Account

d. None of the above


18. Lockbox transmission formats are normal copied into


a. $AR_TOP/sql

b. $AR_TOP/out

c. $AR_TOP/reports

d. $AR_TOP/bin


19. Assuming a transaction number is not assigned to a receipt in the transmission file and Auto Cash rules are not used, the system will


a. Assign a status of ‘Unidentified’

b. Assign a status of ‘Unapplied’

c. Ignore the receipt

d. Apply to the oldest invoice 


20. Dunning Letters are


a. Statement of Account Covering Letter

b. Invoice Covering Letter

c. Reminder Letters

d. Receipt Covering Letters





Answers:


1. D

2. Deposits and Guarantees

3. False

4. Bill in Advance and Bill in Arrears

5. Yes

6. A

7. A

8. C

9. A

10. RA_INTERFACE_LINES_ALL and RA_INTERFACE_DISTRIBUTIONS_ALL

11. A

12. LINE,TAX,FREIGHT & CHARGES

13. C

14. B

15. AR_PAYMENTS_INTERFACE_ALL

16. B

17. C

18. D

19. B

20. C


Comments

Post a Comment

Popular posts from this blog

Oracle DBA Queries

By -
 Useful Queries for Checking Concurrent Requests and Programs  Hi DBAs, As an Apps DBA we have to monitor the Concurrent jobs status and details frequently,This can be done with the help of the below queries. -- Concurrent Program Queries for Apps DBA: -- Query 1:For checking the locks in concurrent jobs  SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,inst_id,id1, id2, lmode, request, type FROM gV$LOCK  WHERE (id1, id2, type) IN (SELECT id1, id2, type FROM gV$LOCK WHERE request>0) ORDER BY id1,request; -- Query 2:For checking the concurrent programs running currently with Details of Processed time-- and Start Date  SELECT DISTINCT c.USER_CONCURRENT_PROGRAM_NAME,round(((sysdate-a.actual_start_date)*24*60*60/60),2) AS Process_time,  a.request_id,a.parent_request_id,a.request_date,a.actual_start_date,a.actual_completion_date,(a.actual_completion_date-a.request_date)*24*60*60 AS end_to_end,  (a.actual_start_date-a.request_date)*24*60*60 AS lag...
Read more

Setup of BOM (Bill of Material) on Oracle EBS R12

By -
Setting up Bill of Material (BOM) in Oracle E-Business Suite (EBS) R12.3 involves several configuration and master data setup steps. Here's a step-by-step guide to set up BOM in Oracle EBS R12.3: Step 1: Define BOM Parameters Navigation: Bills of Material > Setup > Parameters Define BOM parameters, such as the default BOM type, effective date, and organization. Step 2: Define BOM Item Attributes Navigation: Bills of Material > Setup > Attributes Define BOM item attributes, such as item categories and planning attributes. Step 3: Define BOM Structures Navigation: Bills of Material > Setup > BOM Structures Define BOM structures to represent different types of BOMs (e.g., Engineering, Production). Step 4: Create Bill of Material (BOM) Navigation: Bills of Material > Engineer > Bills > Bills Create the BOM by entering the header data (e.g., assembly item, BOM type) and adding the components along with their quantities and item attributes. Step 5: Define Compo...
Read more

Interview Questions and Answers on O2C (Order to cash) in Oracle EBS R12

By -
  Order-to-Cash (O2C) Basics: What is the Order-to-Cash (O2C) cycle, and what is its significance in Oracle EBS? Answer: The O2C cycle represents the end-to-end process of receiving customer orders, processing them, delivering goods or services, and receiving payments. It is a critical business process in Oracle EBS for revenue generation. What are the key components of the O2C cycle in Oracle EBS? Answer: The key components include Order Management, Pricing, Shipping, Invoicing, Receivables, and Cash Management. Order Management: Explain the role of Order Management in the O2C cycle, and how does it handle order creation, modification, and processing? Answer: Order Management is responsible for creating, modifying, and processing customer orders. It ensures that orders are accurate, fulfillable, and meet customer requirements. What are the various order types in Oracle Order Management, and how are they used within the O2C cycle? Answer: Order types include standard orders, sa...
Read more