Assigning Values for Additional Required and
Conditionally Required Columns
You must enter values in all columns of the GL_INTERFACE table that require values, which includes all of the not null columns, in order for Journal Import to successfully convert your import data into journal entries.
Enter values in the following required columns of the GL_INTERFACE table:
STATUS: Enter the value NEW to indicate that you are bringing new data into your General Ledger application.
SET_OF_BOOKS_ID: Enter the appropriate set of books ID for your transaction. You define your set of books in the Set of Books form of your General Ledger application. You can find a list of valid values in the SET_OF_BOOKS_ID column of the Sets of Books table (GL_SETS_OF_BOOKS. SET_OF_BOOKS_ID).
Suggestion: You may use the following SQL*Statement to access the appropriate set of books ID:
SELECT SET_OF_BOOKS_ID, NAME
FROM GL_SETS_OF_BOOKS;
USER_JE_SOURCE_NAME: Enter the journal entry source name for your transaction. You define journal sources in the Journal Sources form of your General Ledger application. You can find a list of valid values in the USER_JE_SOURCE_NAME column of the Journal Entry Sources table (GL_JE_SOURCES.USER_JE_SOURCE_NAME).
USER_JE_CATEGORY_NAME: Enter the journal category name for your transaction. You define journal categories in the Journal Categories form of your General Ledger application. You can find a list of valid values in the USER_JE_CATEGORY_ NAME column of the Journal Entry Categories table (GL_JE_CATEGORIES.USER_JE_ CATEGORY_NAME).
CURRENCY_CODE: Enter the currency code for your transaction. You define new currency codes in the Currencies form of your General Ledger application. You can find a list of valid values in the CURRENCY_CODE column of the Currencies table (FND_CURRENCIES.CURRENCY_CODE).
DATE_CREATED: Enter the date your import journal entry line was created. The information you enter here is for your own records, and does not appear in your General Ledger application.
CREATED_BY: Enter an ID that you can use to identify the data coming from your feeder system. The ID you enter provides you with an audit trail from Journal Import data to your feeder system. However, your Journal Import data will be removed from the GL_INTERFACE table after it is successfully imported, and this ID will not appear in your General Ledger application.
ACTUAL_FLAG: Enter the value A for actual amounts, B for Budget amounts, or E for encumbrance amounts.
ENCUMBRANCE_TYPE_ID: If you entered the value E in the ACTUAL_FLAG column of the GL_INTERFACE table, you must enter the appropriate encumbrance ID. You define new encumbrance types in the Encumbrance Types form of your General Ledger application. You can find a list of valid values in the ENCUMBRANCE_TYPE_ID column of the Encumbrance Types table (GL_ ENCUMBRANCE_TYPES. ENCUMBRANCE_ TYPE_ID).
Suggestion: We recommend you use the following SQL*Statement to identify the appropriate encumbrance type ID:
SELECT ENCUMBRANCE_TYPE_ID,
ENCUMBRANCE_TYPE
FROM GL_ENCUMBRANCE_TYPES
WHERE ENABLED_FLAG = 'Y';
BUDGET_VERSION_ID: If you entered the value B in the ACTUAL_FLAG column of the GL_INTERFACE table, you must enter the appropriate budget ID. You define new budget versions in the Define Budget form of your General Ledger application. You can find a list of valid values in the BUDGET_ VERSION_ID column of the Budget Versions table (GL_BUDGET_VERSIONS.BUDGET_VERSION_ ID).
Suggestion: We recommend you use the following SQL*Statement to identify the appropriate budget version ID:
SELECT BUDGET_VERSION_ID,
BUDGET_NAME
FROM GL_BUDGET_VERSIONS
WHERE STATUS IN ('C','O');
PERIOD_NAME: Enter a period name for your budget transactions (ACTUAL_FLAG = B) only. This column is required when you are importing budget data using Journal Import. 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.
ENTERED_DR: Enter the debit amount for each line of your transaction. Enter a value for the ENTERED_DR or the ENTERED_CR column in a given row, but not both values in one row.
ENTERED_CR: Enter the credit amount for each line of your transaction. Enter a value for the ENTERED_DR or the ENTERED_CR column in a given row, but not both values in one row.
See Also
Defining Sets of Books
Defining Budgets
Defining Currencies
Defining Encumbrance Types
Defining Journal Sources
Defining Journal Categeories
Understanding the GL_INTERFACE Table
Assigning Values for Accounts
Assigning Values for Currency Conversion
Assigning Values to Optional Columns
Required NULL Columns in the GL_INTERFACE Table
Importing Specialized Data
About Journal Import Validation
Overview (of Average Balance Processing)