GL Interface Interview Questions

1) What are the tables involved in GL Interface?

GL_INTERFACE

2) What is the program name to import journals?

Journal Import can be executed from Menu. Else Program - Import Journals program can be used.

3) What are the criteria on which journal import can be run?
 Ans) The criteria's are

          - Source Name

          - Group Id

          - Import Desc Flexfield (Y/N)

          - Create Summary Journal ( Y/N)

4) Can you give segment values or CCID in GL_Interface?

Ans) Both can be given.

5) How can we identify whether records in GL_INTERFACE are errorred records?

Ans) The status of those records will be other than NEW

6) What is the significance of Group ID?

7) If Journal import couldn't import journals because of errors, will Journal Import program end in error?

Ans) No. The Journal Import program doesnt error; but it gives details of the journal batches that have failed to import along with the error code

8) What validations are required for GL_INTERFACE?

9) Does the records get auto-purge

10) What are the errors encountered during Journal Import?

Ans)

- This date is not in any open or future enterable period

- Detail posting not allowed for this Accounting Flexfield

- Disabled Accounting Fledfield

- Invalid Currency code

- The journal entry is unbalanced and susspense posting not allowed in this et of books

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?