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 |