Questions For Oracle Payables

1. What are the types of Invoices , what is prepayment & steps to apply it to an Invoice ?

2. What are the Distribution Type while entering the Invoice?

3. What's the difference between the "Payables Open Interface Import"
Program and the "Payables Invoice Import" program?

4.What is Debit Memo & Credit Memo in Payables?

5. What is Proxima Payment Terms?

6. What will accrue in Payables?

7. What is Tolerance?

8. What is Aging Periods?

9. What is a Payable Document?

10. What are the tables associated with Invoice?

11. Which interface tables are used for Invoice Import , give the important columns?

12. What is 2 way , 3 way and 4 way matching?

13. How you will transfer payables to general ledger?

14. You created a set of book , where you will attach this SOB in AP?

15. What is use of AP Accounting Periods?

16. What is Interest Invoice and how it can be created?

17. What is a Hold? Explain the types of Hold

18. How many key flexfields are there in Payables?

19. Explain the set up used for Automatic or Manual Supplier Numbering.

20. Can you hold the partial payment if yes then how?

21. Can you cancel the invoice? If yes, explain.

Showing Answers 1 - 17 of 17 Answers


  • Feb 24th, 2007

we have to assign the sob in ap  through the this path

  Was this answer useful?  Yes


  • May 11th, 2007

Invoice types in AP :
Standared invoice 
Debit memo 
Credit memo 
PO Defult      
Mixed Invoice
Withholding Tax
Expence Invoice 
Prepayment Invoice


  • May 16th, 2007

Prepayment is invoice u enter to pay an advance Payment to Expences to a  supplier or Employee

Steps for Prepayment :
1.we have to check Payable options.
2.Create Prepayment Invoice.
3.we have to apply to Invoice.
4.Pay the Prepayment Amount.
5.Cash Clearing at Cash Management Module.

  Was this answer useful?  Yes

2way,3 Way and 4 matching

2way match: we match the Invoice with Reciept of Items.
check whether both are same in terms of quantiy in the invoice and quantity recieved ie reciept quantity.

3way match: we match the invoice , reciept and PO.
Check and match the quantity in Invoice , Reciept and PO are same

4 way match: we match the Invoice, reciept , PO and Inspection
check and match the quantity in Invoice, reciept , Po and Inspection are same


  • Mar 26th, 2008

Use the Aging Periods window to define time periods for the Invoice Aging Report.

The Invoice Aging Report provides information about invoice payments due during four periods you specify. Payables displays the invoice information in four columns.


  • Mar 26th, 2008

Accounting periods are the periods in which you perform 
your operations.Accounting periods are closed so as to
ensure that no accounting entries can be passed in that
period after they are clsoed.Suppose you have issued your
results without closing your accounting periods and then
you chnage some entries in that period thus in turn
misleading the public at large.So it is important to close
your accounting periods.Also, if accounting periods in Ap
are not closed it shall not allow you to run GL.Prior to
closng the periods it is important to ensure that all your
invoices are validated and no hold exists on any one of
them.If hold exists it shall not allow you to run GL.


  • Mar 26th, 2008

When the payable accounting entries are created,then run 
the program called 'Payables Tranfer to GL' Program. Which
sends the invoice entries and payable entries to GL
interface. then submit a request called Journal import to
import journal entries to GL

Types of Invoice in Payables


1. Standard invoice
2. Debit memo
3. Credit memo
4. Prepayment
5. Expenses Report
6. PO defualt
7. Quick match
8. Mixed invoice
9. Withholding Tax
10. Interest invoice
11. Recurring invoice

amjad khan  

  Was this answer useful?  Yes


  • Sep 22nd, 2010

1) The types of Invoices are
1) Standard Invoice
2) Credit Memo
3) Debit Memo
4) Prepayment
5) With Holding Tax
6) Expense Report
7) PO Default
8) Mixed Invoice
9) Recurring Invoice
10) Mixed Invoice.

Prepayments are of 2 types. They are
1) Temporary Prepayment.
Permanent Prepayment.

If we raise a Temporary Prepayment, we can adjust this payments while making payments to the supplier.

In case of Permanent Prepayment, we cannot adjust this payments. It will be like deposit. If we want to make Permanent Prepayment to Temporary Prepayment go to the
particular invoice change it as temporary prepayment and save it.

  Was this answer useful?  Yes


  • Sep 22nd, 2010

The distribution Set in the Invoice headers will help us distribute the invoice amt automatically. If we do not select any distribution set we need to do it manually by selecting distribution button

  Was this answer useful?  Yes


  • Feb 2nd, 2012

The "Payables Invoice Import" is designed to import expense reports. The sources are:
Oracle Project Accounting

The "Payables Invoice Import" should be used to import expense report data from the Invoice Import Interface Tables (AP_EXPENSE_REPORT_ HEADERS&LINES).The expense report data is from expense reports you enter in Payables, Self-Service Expenses, or Oracle Projects.

The "Payables Open Interface Import" program was designed to accomplish high volume invoice import complete with all of the features of online invoice entry, including these sources:

User Defined Source
Oracle Property Manager

  Was this answer useful?  Yes


  • Feb 14th, 2012

DRM-Customer raise the DRM to reduce the liability.
CRM-Supplier raise the CRM and also we can use for refunds.
case1 PO is 100 items.
Suppler sent 100 Items
We receive 100 Items
But some goods are damaged so we return 10 items
At this situation we raise a debit memo for 10 items.(reducing the liability)

Case2:PO is 100 items
supplier sent 100 items we receive 100 items but bill is for 110 items
If the supplier find out the mistake then he will sent a credit memo for 10 items.
for refunds also we can use credit memo.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions