Help Desk

Submit a ticket My Tickets
Welcome
Login

Oracle E-Business Suite Command Reference

Connector to interact with the Oracle E-Business suite APIs and underlying database to perform complex processes such as importing journals.

Connections

Oracle E-Business Suite

Connector to the Oracle E-Business Suite application.

Inputs

Input Type Detail Notes
Database Username TextField When executing commands that utilize the backend database, this will be the username used to authenticate.
Database Password TextField When executing commands that utilize the backend database, this will be the password for the user.
Database Connection URL TextField The connection url. (e.g. jdbc:oracle:thin:@127.0.0.1:1521:EBSDB)

Commands

Import Journal

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.

Inputs

Input Type Detail Notes
Delimiter DropdownField The delimiter of the tabular data file containing the journal lines.
Data FileField The file containing the journal lines.
User TextField 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.
User Responsibility TextField The responsibility associated to the user performing the import. This responsibility must be associated to the SQLGL application.
Ledger TextField The name of the ledger associated to the Journal. (e.g Vision Operations (USA) )
Actual Flag DropdownField Select the value A for actual amounts, B for Budget amounts, or E for encumbrance amounts.
Encumbrance Type TextField If you selected the value E for the Actual Flag input, you must enter the appropriate encumbrance type.
Budget Version TextField If you selected the value B for the Actual Flag input, you must enter the appropriate budget version.
Period Name (Budget only) TextField 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.
Autopost Rule TextField 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.
Import Options GroupField Specify the options for the import program. These are the options for the Journal Import program (GLLEZL) in the SQLGL application.
Group ID NumberField Optionally provide a Group ID to identify the import, if you do not set this a number will be randomly generated.

Outputs

Output Output Type Notes
Journal Entry Lines File
Lines Imported Integer
Import Errors Json
Import Log File File
Import Output File File
JE Header Id Integer
JE Batch Id Integer
Posting Log File File
Posting Output File File
JE Batch Log File File
JE Batch Output File File
Import Succeeded? Boolean
Posting Succeeded? Boolean

Exit Codes

Code Type Detail
0 Success Success
1 Error Invalid inputs were given
3 Error The Journal import failed.
B
Brian is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.