Oracle Application's Blog: Top 15 Oracle Payables Technical interview questions

Top 15 Oracle Payables Technical interview questions

Here in this post , I am sharing the Oracle Module Payables related Technical Interview Questions in Oracle Apps r12. This is the list of Most commonly asked Payable's Technical Questions in the Interview. You will get the Detailed Answers against these Payables Questions.

Oracle Payables Technical interview questions List

Payables Invoice Table in Oracle ?

Answers :

AP_INVOICES_ALL

AP_INVOICE_LINES_ALL

AP_INVOICE_DISTRIBUTIONS_ALL

AP_PAYMENT_SCHEDULES_ALL

AP_HOLDS_ALL

Payables Invoice Payments Tables in Oracle apps ?

Answers :

AP_CHECKS_ALL

AP_INVOICE_PAYMENTS_ALL

AP_PAYMENT_HISTORY_ALL

CE_BANKS_V

CE_BANK_BRANCHES_V

CE_BANK_ACCOUNTS

What are the Xla table in oracle apps ?

Answers :

XLA_EVENTS

XLA_TRANSACTION_ENTITIES

XLA_DISTRIBUTION_LINKS

XLA_AE_HEADERS

XLA_AE_LINES

How to Join between AP_Checks_All and xla tables ?

Answers :

select aca.CHECKRUN_NAME, aca.CHECK_NUMBER, Aca.AMOUNT,

APHa.TRANSACTION_TYPE, APHa.TRX_PMT_AMOUNT,

APHD.AMOUNT PAY_DIST_AMOUNT,

xdl.ACCOUNTING_LINE_CODE, XDL.LINE_DEFINITION_CODE, XDL.EVENT_CLASS_CODE,

nvl(xal.accounted_dr,0) accounted_dr, nvl(xal.accounted_cr,0) accounted_cr

from apps.XLA_DISTRIBUTION_LINKS xdl,apps.AP_PAYMENT_HIST_DISTS aphd,

apps.AP_PAYMENT_HISTORY_ALL APHA,apps.AP_CHECKS_ALL aca,apps.xla_ae_headers xah,apps.xla_ae_lines xal

where xdl.SOURCE_DISTRIBUTION_TYPE = 'AP_PMT_DIST'

and xdl.APPLICATION_ID = 200

and xdl.SOURCE_DISTRIBUTION_ID_NUM_1 in (1213175,1213176)

and aphd.PAYMENT_HIST_DIST_ID=xdl.SOURCE_DISTRIBUTION_ID_NUM_1

and apha.PAYMENT_HISTORY_ID=aphd.PAYMENT_HISTORY_ID

and aca.check_id=apha.check_id

and xdl.AE_LINE_NUM = xal.AE_LINE_NUM

AND XDL.AE_HEADER_ID = XAL.AE_HEADER_ID

What are the Interface Tables in Oracle Payables to Create AP invoices ?

Answers :

1.AP_INVOICES_INTERFACE

2.AP_INVOICE_LINES_INTERFACE

3.AP_INTERFACE_REJECTIONS

What is the Standard Program name to import AP invoices from Interface ?

Answers :

Payables Open Interface Import is uses to import the Interface invoices from Interface to Oracle Invoice Base Tables.

How to find the Unpaid Invoices from Backend ?

Answers :

In AP_INVOICES_ALL we have an Column “PAYMENT_STATUS_FLAG” this column can be use to find the Paid and Unpaid invoices in Oracle apps.

PAYMENT_STATUS_FLAG Values (N, P, Y)

N= ‘Not Paid’

P=’Partial Paid’

Y=’Paid’

How to Link between AP invoices Tables and XLA Tables ?

Answers :

XLA Tables used in the link between ap and xla tables

GL_JE_BATCHES (je_batch_id) => GL_JE_HEADERS (je_batch_id)

GL_JE_HEADERS (je_header_id) => GL_JE_LINES (je_header_id)

GL_JE_LINES (je_header_id, je_line_num) => GL_IMPORT_REFERENCES (je_header_id, je_line_num)

GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id) => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id)

XLA_AE_LINES (application_id, ae_header_id) => XLA_AE_HEADERS (application_id, ae_header_id)

XLA_AE_HEADERS (application_id, event_id) => XLA_EVENTS (application_id, event_id)

How to fnd the Cancelled Invoices from Backend in Oracle Apps ?

Answers :

In the AP_INVOICES_ALL table we have Column “cancelled_date”. The Invoices which have date in this Column will be cancel invoices.

Select * From AP_INVOICES_ALL

Where cancelled_date is not null

What are the Supplier Interface Tables in Oracle apps r12 ?

Answers :

AP_SUPPLIERS_INT

AP_SUPPLIER_SITES_INT

AP_SUP_SITE_CONTACTS_INT

Standard Import Program's to Import Supplier Interface records in Supplier Base Tables.

Supplier Open Interface Import

Supplier Sites Open Interface Import

Supplier Contacts Open Interface Import

What are the Payment Process Profiles table in Oracle Apps ?

AP_INV_SELECTION_CRITERIA_ALL

This table Stores all the information about PPR /Payment batch which is submitted for the payment. Like which are the filters this batch will select the due invoice payments.

AP_SELECTED_INVOICES_ALL

AP_SELECTED_INVOICES_ALL is a temporary table that stores
information about invoices selected for payment in a
payment batch. Your Oracle Payables application
inserts into this table after you initiate a payment batch.
There will be one row for each invoice that Payables selects for
payment in the current payment batch. When you build payments
in a payment batch, your Oracle Payables
application uses information in this table to create
rows in AP_SELECTED_INVOICE_CHECKS

AP_UNSELECTED_INVOICES_ALL

In this table, system stores information’s about that invoices which are due for payment but not rejected by the payment batch due to some issues. We can also get the rejection details for the invoice too.

SELECT * FROM AP_UNSELECTED_INVOICES_ALL

How to find the Invoice Validation Status from Back in Oracle apps

Invoice distributions are validated individually and the status is stored at the invoice distribution level. This status is stored in AP_INVOICE_DISTRIBUTIONS_ALL.MATCH_STATUS_FLAG.

Valid values for the column are:

A - Validated (it used to be called Approved)

N or NULL - Never validated

T - Tested but not validated

The invoice header form derives the invoice validation status based on the following:

'Validated'

- If all of the invoice distributions have a MATCH_STATUS_FLAG = 'A'

'Never Validated'

- If all of the invoice distributions have a MATCH_STATUS_FLAG = null or 'N'

'Needs Revalidation'

- If there are any rows in AP_HOLDS that do not have a release code.

- If any of the invoice distributions have a MATCH_STATUS_FLAG = 'T'.

- If the invoice distributions have MATCH_STATUS_FLAG values = 'N', null and 'A' (mixed).

How to find the Standard Invoices Applied against the Prepayment Invoice from Oracle backend ?

select a1.invoice_num "Prepayment Invoice Number",a1.invoice_amount "Prepayment Invoice Amount",a3.invoice_num "Applied Invoice Number" from apps.ap_invoices_all a1,apps.ap_invoice_lines_all a2, apps.ap_invoices_all a3

where a1.invoice_num=:P_PREPAY_INV_NUMBER

and a2.PREPAY_INVOICE_ID=a1.invoice_id

and a2.invoice_id=a3.invoice_id