Table of Contents
Oracle E-Business Suite
Connector to the Oracle E-Business Suite application.
When executing commands that utilize the backend database, this will be the username used to authenticate.
When executing commands that utilize the backend database, this will be the password for the user.
Database Connection URL
The connection url. (e.g. jdbc:oracle:thin:@127.0.0.1:1521:EBSDB)
Import a Journal by supplying a tabular data set containing all of the lines in the Journal. The file should follow the schema of the GL_INTERFACE table in your E-Business Suite database.
The delimiter of the tabular data file containing the journal lines.
The file containing the journal lines.
The name of the user that will be used to import the journal. This user must have access to import journals to the ledger specified as well as the SQLGL application.
The responsibility associated to the user performing the import. This responsibility must be associated to the SQLGL application.
The name of the ledger associated to the Journal. (e.g Vision Operations (USA) )
Select the value A for actual amounts, B for Budget amounts, or E for encumbrance amounts.
If you selected the value E for the Actual Flag input, you must enter the appropriate encumbrance type.
If you selected the value B for the Actual Flag input, you must enter the appropriate budget version.
Period Name (Budget only)
Enter a period name for your budget transactions (Actual Flag = B) only. This column is required when you are importing budget data. If you want to import budget data using Journal Import, you must supply a period name instead of an accounting date. And, your period name must be associated with an open budget fiscal year.
Specify the Autopost rule to use to automatically post the journals after the import. This must be set to have the Journal result in a posted state.
Specify the options for the import program. These are the options for the Journal Import program (GLLEZL) in the SQLGL application.
Optionally provide a Group ID to identify the import, if you do not set this a number will be randomly generated.
Journal Entry Lines
Import Log File
Import Output File
JE Header Id
JE Batch Id
Posting Log File
Posting Output File
JE Batch Log File
JE Batch Output File
Invalid inputs were given
The Journal import failed.