25 Most Important Oracle receivable interview questions

25 Most Important Oracle receivable interview questions

Here in this post , I am sharing the list of Top 25 Receivable Interview Questions in Oracle apps. These questions are very important and I have also the shared the Details answers for these questions too. Please find below the detail list.

 

 

Top 25 Receivable Interview Questions in Oracle apps

How many Types of Transaction we can create in Oracle AR?

We can Create 6 type of AR Transaction in AR as below.

1.Creditmemo

2.Invoice

3.Chargeback

4.Deposits

5.Guarenty

6.Bills Receivable

 

How we can Increase the Customer Liability or Debtor Outstanding in the AR ?

We have two ways to increase the Customer Liability or Debtor Outstanding in the AR.

1.We can Create the Standard Invoice to the Customer to Increase the Debtor Outstanding.

2.If we have already sent the Customer Invoice and don’t want to create the Invoice Again but to do the Adjustment for the Same Invoice then we can create the Debit Memo against this Customer to increase the Debtor Outstanding.

 

How we Can Decrease or reduce the Outstanding in the customer Standard Invoice in AR ?

To Reduce the Current Outstanding for the AR Invoice , We need to create the Credit Memo and then adjust this with the Standard Invoice to reduce the Outstanding of the AR Invoice for this Customer.

What is Auto Invoicing Oracle AR ?

 

Auto Invoicing is uses to Import or Migrate the Data from External Sources to create the AR invoices in Oracle Apps.  Auto Invoicing Validate the Data in the AR Interface as per setups of the Grouping, Ordering, Auto Accounting rules to create the Final Ar invoice. This Auto Invoicing helps to Create the AR Invoices from Sales Order Shipments in Oracle. Auto Invoicing Process triggers by a concurrent request ‘AUTO INVOICE MASTER PROGRAM’. Auto invoicing is used to import the AR invoices directly into the AR module.

What is Auto Accounting in Oracle AR?

Auto Accounting is a Feature in Oracle Receivables to derive the GL code Combination or Accounting KFF values for Receivable and Revenue accounts based on different parameters of the AR Invoice which is going to be migrate in AR through Auto Invoice or Manually.

For Example, we have entered the Revenue account (5 Segment) in Customer Site and in the Invoice Transaction Type. Then we can have written in the Auto Accounting rule that first three segments will be drive from Customer Site Revenue account and rest of the last two KFF segment values will be drive from AR invoice Transaction Type.

How we Differentiate or Segregate the Transactions Types in Oracle AR?

We Differentiate or Segregate the Transactions Types with the Help of Transaction Class. This determines whether this Transaction type will be Credit, Debit , Standard Invoice.

 

What is the Feature of TCA in Oracle AR?

TCA (Trading Community Architecture) comes for picture in Oracle apps r12. TCA more related to Party and more about Customer Oriented. In TCA, Oracle treats everything in Oracle application as party, which could be become its potential customer in future. To more clarifying this Statement, I will share the Working Examples as below.

For Example, I have create the Supplier A in Oracle apps but as per TCA architecture, Oracle will automatically create this Supplier A as an Party because according to TCA, Supplier can also be my Potential Customer in Future. So in Future If I need to sell some goods to this Supplier A , then I can directly create the Customer From this Party A So one Party will become my Supplier and Customer Both but with Different Relation Ship.

What is On Account Receipt in Oracle Receivables?

On Account Receipt are those Customer Payment or Receipts which we have received in our System but we are not sure about the payment reason or we don’t know the Invoice information for this payment so that is the reason we have put this payment or receipt in On Account or just received it but not applied to any Invoice. This On Account Payment or Receipt status will remain ‘Open’. On Account Receipts provide credit in the Outstanding to the Customer.

 

What is Un Applied Receipt Account in Oracle AR?

Un Applied Receipt Account are those Customer Payment or Receipts which we have received in our System but we are also sure about the payment reason or we know the Invoice information for this payment but still we have not closed this receipt to apply against the Invoices. In simpler terms, application of funds would have not taken place despite knowing the reasons as to why they were received.

 

What are the AR Interface Table in Oracle apps?

These Three tables are the part of AR Interface table

ra_interface_lines_all

ra_interface_distributions_all

ra_interface_errors_all

 

What is Grouping Rule in Oracle AR?

Grouping rule is very important to create the AR invoices through External Sources or Modules in Oracle Application. When Auto Invoice Import program migrate the AR Invoice information from Other Module or from External Source in AR then this program consider the Grouping rule first to create the AR invoices in Oracle. Grouping Rule decide how many invoices will be create in Oracle AR. For example , We have two AR Interface Lines for Customer A in the AR interface and each AR Line has different Customer Site.

Now if my Grouping Rule is Only created on the Basis of Customer Number, Then When the Auto Invoice Import program will run then this will create only 1 AR invoice for these two lines.

But if my Grouping Rule is created on the Basis of Customer Number and then Site number(Two Levels) , Then When the Auto Invoice Import program will run then this will create only 2 AR invoice for these two lines.

 

Difference between the Customer Merge and the Party Merge in Oracle Apps?

What is the Use of Transaction Type in Oracle AR?

Transaction type is Very important in Oracle receivable. We attach transaction types to AR Invoices. This helps to determine the system that the AR transactions will be transferred to GL or not and helps to default the Revenue, Receivables, Freight, Tax, Clearing, Unearned, Unbilled GL accounts in the invoice while creating the Ar Invoice. Transaction type also helps to Decide that the AR Transaction Amount sign(Negative & Positive) in AR.

What is Open and Closed Receipt in Oracle apps.

Answers :

Those receipts which are completely applied to the Customer Invoices that receipts will be Closed in the System.

If any amount is still left in the receipt to apply against the Customer Invoice that receipts will be shown Open in the System.

 

Can we Delete the AR transaction in Oracle apps?

Yes ,  we can delete the AR transaction in Oracle, But the AR transaction should be in the Incomplete Status and accounting should not be happened for that Invoice. We control this Delete Option in AR setup to allow deletion in AR Transactions/Invoices.

 

Oracle receivable interview questions