21 Most Important Oracle r12 Payables Interview Questions

21 Most Important Oracle r12 Payables Interview Questions

Here in this Post, I will share the most frequently used Oracle Payables Interview Questions. I have tried to put the Details answers with the working example for most of these questions so that this can helps the interviewers in their preparations.

 

21 Payables Interview Questions

1. Types of Invoices in Oracle Apps

Answers :

Standard

Prepayment

 

Expense Report

Mixed Invoice

 

Credit Invoice

Debit Invoice

2.What is Mixed Type Invoice in Oracle Apps

Answers :

Mixed Invoice is one of the invoice type in the Oracle Payables. You can enter both the Negative and the Positive Amount for this Mixed Type Invoice. This Payment type is not rigid like Standard, Prepayment, Credit & Debit Memo Invoices to enter the amount in the specific signs (Positive or Negative) .

3. Difference Between the Manual Hold and the System Hold.

Answers :

System Hold apply to the Invoice if Something Mismatched in the Invoice as per the Standard Process Like Invoice Header Total and Line Total Should be Equal Other System Hold for Example related to Invoice Matching If Something goes about the Invoice Tolerance Limit then System Put the Hold. System hold is something related to setup Controls. But Manual Hold is something which put manually in the Invoice due to any reason like Product received from the Supplier is Damaged so need to hold the Payment for that Invoice.

4. What is Pay Alone in AP Invoice?

Answers :

Pay alone is something related to Invoice Payment. This is the Flag we set for AP Invoice, It Means this invoice will be paid alone. For example, Supplier A has 3 Invoices, but for 1 Invoice we have enabled the Pay Alone Flag Then When we will run the Payment Batch then System will create one Check for two invoices and Separate one Check for Pay Alone Invoice. This Is the Working of Pay Alone.

5. Can We pay the AP invoice before Due Date?

Answers :

 

Yes, we can Pay the Invoice Before Due date. For Manual Payment, there is no concern but for Payment Batch, When we are running the Payment Process Request then we need to Enter the Pay Through Date this Date is Very Important, If we have set the Pay Through Date “07-Dec” then this Payment Request will pick only those AP invoices which has been due before “07-Dec-2018”.

 

6. How AP Invoice Payment Due Date Calculates in Oracle Payables

Answers :

Invoice Payment Due date depends on the Two Factors.

1.Payment Terms attached to the Invoice

2. Invoice Date.

For Example, if Payment Terms is 30 Days and the Invoice Date is 12-Dec-2018

Then Payment Due Date Will be : 12-Jan-2019

7. What is Primary and Secondary Ledger in Oracle Payables ?

Answers :

 

Primary Ledger is the Main Ledger and Secondary Ledger is the Replica of the Primary Ledger. We Do transactions in the Primary Ledger. The main reason of using Primary and Secondary Ledger is the difference in the Organization Requirment and the Statuary Requirment. For example, One US based company office is in India and as per US Company, their Calendar works from Oct to Sep but the in India their calendar works from Apr to Mar SO in this Kind of Requirment, Primary and Secondary Ledger concept comes. Where we can design the Primary calendar as per the US based but can design the Secondary calendar as per India Statuary Requirment. 

8. What is Recurring Invoice in Oracle ?

Answers :

 

As its name represents ‘Recurring’. Recurring means again and again. If any Organization books the Office rent invoice every month for the same amount or any other fixed expenses every month then oracle has provided the Recurring Invoice. We just need to do the recurring Invoice setup for that amount and system will create the invoice automatically on the First day of the Months.

 

11. What is the Use of Payables Trial Balance report ?

Answers :

Payables Trial Balance Report shows the Total Liability or the Supplier Outstanding in the System. This Report shows the Liability in the System supplier and Site Level. This Provide the Summary Information’s for all the Unpaid amount for the Supplier Invoices which are validated.

 

 

12. What we do in the AP and GL reconciliation ?

Answers :

 

In the AP and GL reconciliation, we try to Match the Total Liability from the Payables with the Liability accounts total in the GL. We have some set of Liability accounts in the Payables, which we only use in the Invoice Headers to book the Liability and we match only these Liability GL accounts in the AP and GL reconciliation report.

We took the help of Payables Trial Balance report to find the Total AP liability and then Run the GL Trial Balance report to match the Payables Trial Balance Report Total with the GL trial Liability Accounts.

 

14. Distribution Set in Oracle Payables

 

Answers :

Distribution set is the combination of multiple Distribution lines using different -2 GL accounts Combination. For Example , We booked most of the AP invoices in two different GL accounts combination so each time we need to enter two lines in the invoice distributions to book the AP invoices expenses in these two GL accounts but this process can be make query quickly and easy. Oracle have functionality like Distributions set in oracle payables where we can any number of GL accounts line for a Given Distribution sets and then in the Oracle Payables Invoices we don’t need to create Distribution lines manually. We just need to enter the Distributions Set in the Ap invoice Lines and oracle system automatically creates the Invoice distribution lines with GL accounts given in the distribution set in oracle payables r12.

 

16. Types of Calendar In Oracle Payables

 

Answers :

 

Accounting Calendar: - Accounting Calendar is related to the Ledger which we attach the GL Ledger during creation. Accounting calendar is the system calendar, If we need to enter any transaction in the System for Specific period then that period in the Accounting Calendar should be open. If the Period is Closed we cannot do any transaction for that period. This Totally controls the system.

Special Calendar: Special Calendar does not have any link with the Accounting.  We define this Calendar to be used by Recurring Invoices, Payables Tax Setups and in the Payments Terms too.

For Example, With the help of Special Calendar we determine the Tax Authority Invoices Dates or For Recurring invoices, System create the Recurring invoice from first day of the Month but if we have an Requirment to create around 10 of each month then we can design the Special calendar for Recurring Invoices in which each month will be start from 10^th.

 

18. Special Calendar Types

Answers :

 

1. Recurring Invoice
2. Withholding Tax
3. Payment Terms
4. Key Indicator

20. Can we Do Cross Currency Payment in Oracle Payables r12 ?

Answers :

Cross currency is If I have received the Supplier Invoice in USD but I will pay this Invoice with my Base Currency INR. So this Is Called Cross currency in Oracle Payables. In Oracle apps r12 we have no option to use Cross currency.

21. Can we do Multi Site Payment for the Same Supplier in Oracle Payables r12 ?

Answers :

Yes, we can do the single payment for the multiple sites invoices for the Same Supplier in Payables r12. This Feature in available in the Oracle r12.