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