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

 

 

 

7 thoughts

  1. A company makes the payment in a currency different from the invoice and ledger currency. What setup options are required to make the cross currency rate type the default?

    A. Manage Payable Options and Manage Invoice Options
    B. Manage Payable Options and Manage common options for Payables and Procurement
    C. Manage Invoice Options and Manage common options for Payables and Procurement
    D. Manage common options for Payables and Procurement and Manage Procurement agents
    E. Manage Invoice Options and Manage Procurement agents

    What Will be the Answer and How will you explain it..?

    Like

  2. Hi,
    Thanks for posting, I was just looking inot the type of invoices you have mentioned, and u mentioned around 9.

    Out of 9, there is one invoice as “Expansive Invoices”, could you please give me some more details about this, as i havent heard this invoice such.

    Thanks for your help in advance

    Like

  3. Hi,
    Thanks for posting, I was just looking inot the type of invoices you have mentioned, and u mentioned around 9.

    Out of 9, there is one invoice as “Expansive Invoices”, could you please give me some more details about this, as i havent heard this invoice such.

    Thanks for you help in advance

    Like

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s