Table of Contents

Connections

Commands

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.

Did this answer your question?