Oracle Accounts Payables Interview Questions Vol.1

Oracle E-Business Suite > Oracle Financial > Oracle Interview Questions (AP)

Question What are the various possible period statuses in AP?

Answer Various period statuses of AP module are

- Never Opened

- Open

- Closed

Question 'Period Close Exception Report' lists some payments under the heading 'Future Dated Payments Requiring Maturity Event and Account'. What action should be taken to resolve this?

Answer To resolve this issue 'Update Matured Future Payment Status' program needs to be submitted with appropriate Maturity Date.

Question Can a period be closed if the Payment Batch in that period is in the status 'Formatted'?

Answer If a period can be closed only after the payment is accounted and transferred to GL. Since, the status of payment is not 'Confirmed'; this payment will not allow for AP period closure.

Question Will an Invoice without a Distribution Line come in the 'Period Close Exception Report'? What action will be required to resolve it?

Answer An Invoice without a distribution will not hinder period closing process. Hence, no action will be required.

However, it is recommended to enter distributions, if a valid invoice; else delete such invoices.

Question What are the most common issues encountered while AP Period Closing process?

Answer Without going to technicality, on a broader level the most common issues are:

- Invoice (Distributions) not Validated

- Invoices on Hold

- Invoices not Accounted

- Payments not Accounted

- Invoices & Payments accounting entries not transferred to GL

- Maturity Accounting not done for Future Dated payments

 

The above issues may arise either because users forgot to run relevant programs or because of bugs (which are quite many in AP) and awaiting resolution from Oracle (after Service Request i.e SR is raised).

Question Is it mandatory to resolve the issues in All the Operating Units of a given Legal Entity? Or  the period can be closed once issues of one Operating Unit are resolved?

Answer It is mandatory to resolve all the issues of ALL the Operating of a given Legal Entity/ Set of Books (SOB). 

Oracle Payables Interface :

1) Explain the Interface process.

Answer The interface process starts with uploading the legacy data, which is in the form of flat file to the temporary table, and validating the data in the temporary. After that the data to be transferred to the Interface tables. From there by running the Customer Open Interface concurrent program, the data that is in the interface tables are transferred to main tables.

2) What are the various tables involved in AP Interface?

Answer AP_INVOICES_INTERFACE

AP_INVOICE_LINES_INTERFACE

3) What is the program used to import invoices from interface tables?

Answer   - Payables Open Interface Import

4) What the various validation to be done before transferring data from temporary table to interface tables?

Answer The various type of validations are:
Not null validation:

 few columns like

- Invoice Number,

- Invoice Date,

- Currency Code etc should not null

Data Type Validation:

- Invoice Amount

- Invoice Date

Business Validation:

- Is the GL date in open period? GL_PERIOD_STATUSES

- Invoice number is not repeating

- Invoice distribution total should match with Invoice header amount

Generation of CCID

GET_CCID

5)  What cases do you use Mapping? How did you achieve mapping functionality? Give some examples?

6) How can achieve that either complete files is inserted or complete file is rejected; while inserting into Open Interface tables?

7)  Can you give segment values or CCID while inserted records into AP_INVOICE_LINES_INTERFACE table?

8) Does the records in the Interface table get auto-purged after getting successfully imported into base tables?

Ans) No. We have run Payables Open Interface Purge

9) What are the errors encoutered while Importing Invoices?