Required NULL Columns in the GL_INTERFACE Table
Some columns in the GL_INTERFACE table must be NULL as Journal Import uses them for internal processing or does not use them in the current release. The following columns must be NULL in release 10 of your General Ledger application:
REFERENCE3: Do not enter a value in this column.
REFERENCE9: Do not enter values in this column.
REFERENCE11 through REFERENCE20: Do not enter a value in this column.
TRANSACTION_DATE: Do not enter a value in this column.
JE_BATCH_ID: Do not enter a value in this column.
JE_HEADER_ID: Do not enter a value in this column.
JE_LINE_NUM: Do not enter a value in this column.
CHART_OF_ACCOUNTS_ID: Do not enter a value in this column.
FUNCTIONAL_CURRENCY_CODE: Do not enter a value in this column.
DATE_CREATED_IN_GL: Do not enter a value in this column.
WARNING_CODE: Do not enter a value in this column.
STATUS_DESCRIPTION: Do not enter a value in this column.
DESC_FLEX_ERROR_MESSAGE: Do not enter a value in this column.
REQUEST_ID: Do not enter a value in this column.
SUBLEDGER_DOC_SEQUENCE_ID: Do not enter a value in this column.
SUBLEDGER_DOC_SEQUENCE_VALUE: Used for communication between General Ledger and the subledgers. Do not populate with your own data.
See Also
Overview of Setting Up
Overview of Multi-Currency Accounting
The General Ledger Accounting Cycle
Defining Conversion Rate Types
Defining Statistical Units of Measure
Defining Descriptive Flexfield Segments
Defining Segment Values
Understanding the GL_INTERFACE Table
Assigning Values for Accounts
Assigning Values for Additional and Conditionally Required Columns
Assigning Values for Currency Conversion
Assigning Values for Optional Columns
Importing Specialized Data
About Journal Import Validation