My Oracle Support Banner

General Ledger FAQ for 11i Journal Import (Doc ID 342391.1)

Last updated on OCTOBER 10, 2022

Applies to:

Oracle General Ledger - Version 10.7 to [Release 10.7 to 11.5.10]
Information in this document applies to any platform.
Executable:GLLEZL - Journal Import
Executable:GLLEZLSRS - Executable to allow submission of Journal Import through the Standard Request Submission
Executable:GLLDEL - Delete Journal Import Source


This FAQ provides the answers for the most common questions about Journal Import.

Technical briefs also provide a useful insight into the topic. Please refer to the following: <Note:130542.1> General Ledger: Journal Import Process.

If you are receiving errors or having problems related to Journal Import then it is recommended to use the <Note:330821.1> Journal Import Troubleshooting Guide

Questions regarding usage, functional clarification, general information, documentation or functionality of the Oracle General Ledger product will receive the fastest response (generally real time to 24hrs timeframe) if they are posted on the My Oracle Support Community for Oracle E-Business Suite General Ledger.
This is monitored on a daily basis by Oracle Support Services (OSS) with the highest importance. Discussion threads often receive multiple responses from other users and/or consultants on questions and issues.
OSS is strongly recommending that issues of this nature be posted on the Oracle E-Business Suite General Ledger Community.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Questions and Answers
 1. What is Group ID used for?
 2. Can Reversals be automatically generated?
 3. How is the Effective Date derived?
 4. How is the GL Batch Name derived?
 5. How is the Period determined?
 6. How to import journals for Adjusting Periods?
 7. Subledger transactions were transferred but are missing in GL
 8. Create Summary Journals: what is the advantage of using it?
 9. Can Descriptive Flexfield be Imported?
 10. Rollback Segment: can this be modified?
 11. Can Journal Import be Automated or included in a request set?
 12. How to improve Performance?
 13. Where to check for the Error Messages (Status codes)?
 14. Can lines be deleted from GL_INTERFACE?
 15. How to check the contents of the GL_INTERFACE table?
 16. How to correct Validation Errors in the GL_INTERFACE table?
 17. What are the primary GL tables updated by Journal Import?
 18. Are Cross-Validation or Security Rules validated?
 19. Community Discussions

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.