Mostly asked questions in Account Payables Modules

Hello, Some of the very much interview oriented, one of mostly asked questions in Account Payables Modules. here they are 

Questions: How many types of Invoices in Oracle Account Payables

1)Standard Invoice

2)Debit Memo

3)Credit Memo

4)Withholding tax invoice5)PO Default

6)Prepayment Invoice

7)Expense Reports

8)Recoring Invoices

9)mixed Invoices

 

  

 

 

 

 

 

Prepayment Invoice: Whenever we want make payments to the suppiler in advace that time,we create this prepayment invoice and we will make the payment.

Credit Memo,Debit Memo:Both invoices are got -ve amount,and adjusted against standard invoice.

Credit memo will be created, when ever suppiler giving discount.

Debit Memo will be created,if buyer is going to deduct the amount.

  

 

 

 

 

 

 

 

 

 

 

Question :How many key flexfields are there in Payables?

Answer: 0 (No key flexfields in PO,AP)

 

Question: Name few Account Payables Tables

AP_INVOICES_ALL

AP_INVOICE_DISTRUBUTIONS_ALL

AP_PAYMENTS_ALL

AP_PAYMENT_SCHEDULES_ALL

AP_INVOICE_PAYMENTS_ALLAP_TERMS_ALL

AP_TERM_LINES_ALL

AP_CHECKS_ALL

AP_CHECK_FORMATS

AP_HOLDS_ALL

 

 

 

 

 

 

 

 

 

 

 

Question: What is 2 way , 3 way and 4 way matching?

While creating the purchase order,we will mention the match approval level at shippments

we will have 3 types

1)two way: PO & Invoice quantities must match with in the tolerance before the corresponding invoice can be paid.

2)three way: PO, Receipt and invoice quantities must match with in the tolerance before the corresponding invoice can be paid.3)four way: PO, Receipt, Inspection and invoice quantities must match with in the tolerance before the corresponding invoice can be paid

 

 

 

 

 

 

 

 

 

 

 

 

What is a Hold? Explain the types of Hold

Invoice holds:If invoice is not approve then that invoice will be keeping under hold status.By selecting holds button in invoice form,we can see the hold details.

Select * from ap_hold_all

 

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

BASE TABLES:

AP_INVOICES_ALL

AP_INVOICE_PAYMENTS_ALL

AP_PAYMENT_SCHEDULES_ALL

AP_INVOICE_DISTRUBUTIONS_ALLAP_INVOICES_INTERFACE COLUMNS:

Invoice_id

Invoice_num

Po_number

vendor_id

vendor_num

vendor_site_id

vendor_site_code

invoice_amount

Ap_invoice_lines_interface columns:

Invoice_id

Invoice_line_id

line_number

line_type_lookup_codeamount

po_header_id

po_number

po_line_id

po_line_number

po_line_location_id

po_shipment_num

po_distrubution_id

po_distrubution_num

Inventory_item_id

 

 

 

 

 

 

 

 

 

 

 

 

Thanks – Shivmohan Purohit