AP Interface Questions

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?