This connector has been discontinued
This article is for an unsupported connector that will soon be removed from the Workiva platform.
It can no longer be activated within a workspace.
Click here to learn more about discontinued connectors.
To import a journal from Oracle E-Business Suite (EBS) as part of a chain, add a step that includes an Oracle EBS Import Journal command.
To enable this command, an IT admin first creates an Oracle E-Business Suite connector.
Import journal
To import a journal based on a tabular data set that contains all of its lines, use an Import journal command.
Properties
Property | Detail |
---|---|
Delimiter | Select the delimiter of the the tabular data file that contains the journal lines. |
Data | Enter the file that contains the journal lines. This file should follow the schema of the GL_INTERFACE table in the Oracle EBS database. |
User | Enter the name of the user to use to import the journal. This user must have access to import journals to the Ledger input and SQLGL application. |
User responsibility | Enter the responsibility associated with the User input and SQLGL application. |
Ledger | Enter the name of the ledger associated with the journal, such as Vision Operations (USA). |
Actual flag | Select the journal amounts to import:
|
Encumbrance type | If the Actual flag input is E, enter the encumbrance type to import. |
Budget version | If the Actual flag input is B, enter the budget version to import. |
Period name (budget only) | If the Actual flag input is B, enter the period name for the budget transactions. This period name must be associated with an open budget fiscal year. |
Autopost rule | Enter the autopost rule to use to automatically post the journals after the import. This rule must be set to have the journal result in a posted state. |
Import options | Enter the options for the Journal Import program (GLLEZL) in the SQLGL application. |
Group ID | Enter a unique ID to identify the import. To instead use a randomly-generated number, leave blank. |
Outputs
Output | Output type |
---|---|
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 |