GL INTERFACING (JOURNAL IMPORT PROGRAM)

CREATE OR REPLACE PROCEDURE PROCEDURE_VALIDATION(ERRBUF VARCHAR2,RETCODE VARCHAR2) AS
ERROR_FLAG VARCHAR2(10):='N';
V_ERROR_MSG VARCHAR2(200);
V_ERROR_CODE VARCHAR2(200);
V_CURRENCY_CODE VARCHAR2(20);
V_COMBINATION  VARCHAR2(200);
V_SOURCE_NAME   VARCHAR2(200);
V_BOOKS_ID    NUMBER(20);
CATEGORY_NAME VARCHAR2(200);
V_CREATED_BY  NUMBER(20);
L_COUNT NUMBER(25):=0;
CURSOR C1 IS SELECT * FROM GL_STAGE;
BEGIN
FOR I IN C1 LOOP
L_COUNT:=L_COUNT+1;
BEGIN
IF (I.STATUS='Y') THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'Status is valid');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
ELSE
ERROR_FLAG :='Y';
FND_FILE.PUT_LINE(FND_FILE.LOG,'Status is invalid');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
END IF;
END;


BEGIN
IF (I.ACCOUNTING_DATE)<SYSDATE THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'accounting date is  is valid');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
ELSE
ERROR_FLAG :='Y';
FND_FILE.PUT_LINE(FND_FILE.LOG,'accounting date is invalid');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
END IF;
END;

BEGIN
IF(I.ACTUAL_FLAG='A') THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'actual flag is valid');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
ELSE
ERROR_FLAG :='Y';
FND_FILE.PUT_LINE(FND_FILE.LOG,'actual flag is invalid');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
END IF;
END;

BEGIN
SELECT  (CURRENCY_CODE) INTO V_CURRENCY_CODE FROM FND_CURRENCIES_TL WHERE CURRENCY_CODE=I.CURRENCY_CODE;
EXCEPTION
WHEN NO_DATA_FOUND THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'currency code column FOR THE RECORD IS MISSING PLEASE UPDATE THE currency code COLUMN');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
WHEN TOO_MANY_ROWS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'too many Currency codes');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
WHEN OTHERS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'currency code is invalid');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
V_ERROR_CODE:=SQLCODE;
V_ERROR_MSG:=SQLERRM;
FND_FILE.PUT_LINE(FND_FILE.LOG,'The error code and error msg:'||V_ERROR_CODE||','||V_ERROR_MSG);
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
END;

BEGIN
SELECT (USER_JE_CATEGORY_NAME) INTO CATEGORY_NAME FROM GL_JE_CATEGORIES_TL WHERE USER_JE_CATEGORY_NAME=I.USER_JE_CATEGORY_NAME;
EXCEPTION
WHEN NO_DATA_FOUND THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'CATEGORY COLUMN FOR THE RECORD IS MISSING PLEASE UPDATE THE CATEGORY COLUMN');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
WHEN TOO_MANY_ROWS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'TOO MANY CATEGORY_NAMES');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
WHEN OTHERS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'CATEGORY IS INVALID');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
V_ERROR_CODE:=SQLCODE;
V_ERROR_MSG:=SQLERRM;
FND_FILE.PUT_LINE(FND_FILE.LOG,'THE ERROR CODE AND ERROR MSG:'||V_ERROR_CODE||','||V_ERROR_MSG);
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
END;

BEGIN
SELECT USER_JE_SOURCE_NAME INTO V_SOURCE_NAME FROM GL_JE_SOURCES_TL WHERE USER_JE_SOURCE_NAME=I.USER_JE_SOURCE_NAME;
EXCEPTION
WHEN NO_DATA_FOUND THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'SOURCE NAME COLUMN FOR THE RECORD IS MISSING PLEASE UPDATE THE CREATED BY COLUMN');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
WHEN TOO_MANY_ROWS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'TOO MANY SOURCES_NAMES');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
WHEN OTHERS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'SOURCE NAME IS INVALID');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
V_ERROR_CODE:=SQLCODE;
V_ERROR_MSG:=SQLERRM;
FND_FILE.PUT_LINE(FND_FILE.LOG,'THE ERROR CODE AND ERROR MSG:'||V_ERROR_CODE||','||V_ERROR_MSG);
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
END;

BEGIN
SELECT distinct (CREATED_BY) INTO V_CREATED_BY FROM FND_USER WHERE CREATED_BY=I.CREATED_BY;
EXCEPTION
WHEN NO_DATA_FOUND THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'created by Column FOR THE RECORD IS MISSING PLEASE UPDATE THE created by COLUMN');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
WHEN TOO_MANY_ROWS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'too many created_by');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
WHEN OTHERS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'created by is invalid');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
V_ERROR_CODE:=SQLCODE;
V_ERROR_MSG:=SQLERRM;
FND_FILE.PUT_LINE(FND_FILE.LOG,'The error code and error msg:'||V_ERROR_CODE||','||V_ERROR_MSG);
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
END;

BEGIN
IF I.DATE_CREATED<=SYSDATE THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'date created is valid');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
ELSE
ERROR_FLAG :='Y';
FND_FILE.PUT_LINE(FND_FILE.LOG,'accounting date is invalid');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
END IF;
END;

BEGIN
SELECT  (SET_OF_BOOKS_ID) INTO V_BOOKS_ID FROM GL_SETS_OF_BOOKS WHERE SET_OF_BOOKS_ID=I.SET_OF_BOOKS_ID;
EXCEPTION
WHEN NO_DATA_FOUND THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'set of books id column FOR THE RECORD IS MISSING PLEASE UPDATE THE set of books id COLUMN');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
WHEN TOO_MANY_ROWS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'too many category_names');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
WHEN OTHERS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'set of books id is invalid');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
V_ERROR_CODE:=SQLCODE;
V_ERROR_MSG:=SQLERRM;
FND_FILE.PUT_LINE(FND_FILE.LOG,'The error code and error msg:'||V_ERROR_CODE||','||V_ERROR_MSG);
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
END;

BEGIN
SELECT  DISTINCT (SEGMENT1||SEGMENT2||SEGMENT3||SEGMENT4||SEGMENT5) INTO V_COMBINATION FROM GL_CODE_COMBINATIONS WHERE SEGMENT1=I.SEGMENT1 AND SEGMENT2=I.SEGMENT2 AND  SEGMENT3=I.SEGMENT3 AND SEGMENT4=I.SEGMENT4 AND SEGMENT5=I.SEGMENT5;
EXCEPTION
WHEN NO_DATA_FOUND THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'SEGMENTS COLUMN FOR THE RECORD IS MISSING PLEASE UPDATE THE SEGMENTS');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
WHEN TOO_MANY_ROWS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'too many category_names');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
WHEN OTHERS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,'CODE COMBINATION IS INVALID');
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
V_ERROR_CODE:=SQLCODE;
V_ERROR_MSG:=SQLERRM;
FND_FILE.PUT_LINE(FND_FILE.LOG,'THE ERROR CODE AND ERROR MSG:'||V_ERROR_CODE||','||V_ERROR_MSG);
FND_FILE.PUT_LINE(FND_FILE.LOG,L_COUNT);
END;

IF (ERROR_FLAG='N') THEN
INSERT INTO GL_INTERFACE
(STATUS,
SET_OF_BOOKS_ID,
ACCOUNTING_DATE,
CURRENCY_CODE,
DATE_CREATED,
CREATED_BY,
ACTUAL_FLAG,
USER_JE_CATEGORY_NAME,
USER_JE_SOURCE_NAME,
SEGMENT1,
SEGMENT2,
SEGMENT3,
SEGMENT4,
SEGMENT5,
ENTERED_DR,
ENTERED_CR,
ACCOUNTED_DR,
ACCOUNTED_CR
) VALUES
(I.STATUS,
V_BOOKS_ID,
I.ACCOUNTING_DATE,
V_CURRENCY_CODE,
I.DATE_CREATED,
V_CREATED_BY,
I.ACTUAL_FLAG,
CATEGORY_NAME,
V_SOURCE_NAME,
I.SEGMENT1,
I.SEGMENT2,
I.SEGMENT3,
I.SEGMENT4,
I.SEGMENT5,
I.ENTERED_DR,
I.ENTERED_CR,
I.ACCOUNTED_DR,
I.ACCOUNTED_CR);
END IF;
END LOOP;
END PROCEDURE_VALIDATION;
/


Then Once the Data is in GL_Interface then Run the Journal Import Program with Source name and the Group Id then data comes onto GL_JE_HEADERS,GL_JE_LINES and GL_JE_batches
and once you post the balances then we can have data on GL_Balances.

https://docs.oracle.com/cloud/latest/financialscs_gs/OEDMF/GL_INTERFACE_tbl.htm

GL_INTERFACE

GL_INTERFACE contains journal entry batches through Journal Import. You insert rows in this table and then use the Import Journals window to create journal batches. You must supply values for all NOT NULL columns. For a complete description of how to load this table, see the Oracle General Ledger User Guide.

Details

• Schema: FUSION
• Object owner: GL
• Object type: TABLE
• Tablespace: APPS_TS_TX_DATA

Columns

Name	Database	Length	Precision	Not Null	Comments	Flexfield Mapping
STATUS	VARCHAR2	50		Yes	Journal Import status. Use: NEW.
GL_INTERFACE_ID	NUMBER		18		Interface Identifier. Oracle internal use only. Populated by the journal import program.
CREATION_DATE	TIMESTAMP				Who column: date and time of the creation of the row.
LAST_UPDATE_DATE	TIMESTAMP				Who column: date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: session login associated to the user who last updated the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9		Used to implement optimistic locking. Incremented every time the row is updated. Compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LEDGER_ID	NUMBER		18		Ledger identifier. Use the Manage Primary Ledgers task to find valid values.
JE_SOURCE_NAME	VARCHAR2	25			Oracle internal use only. Use column USER_JE_SOURCE_NAME to populate journal source.
JE_CATEGORY_NAME	VARCHAR2	25			Oracle internal use only. Use column USER_JE_CATEGORY_NAME to populate journal category.
ACCOUNTING_DATE	DATE			Yes	Effective date of the journal entry. Used to assign the accounting period.
CURRENCY_CODE	VARCHAR2	15		Yes	Entered currency of the transaction. Use the Manage Currencies task to find valid values. Use the three character ISO currency code. Example: US Dollars is USD.
DATE_CREATED	DATE			Yes	Who column: date the row was created.
CREATED_BY	VARCHAR2	64			Who column: user who created the row.
ACTUAL_FLAG	VARCHAR2	1		Yes	Balance type of the journal. Use: A. Meaning: Actual.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: request ID of the job that created or last updated the row.
ENCUMBRANCE_TYPE_ID	NUMBER				Oracle internal use only.
BUDGET_VERSION_ID	NUMBER				Oracle internal use only.
CURRENCY_CONVERSION_DATE	DATE				Date of exchange rate. Date format: YYYY/MM/DD. Required if CURRENCY_CONVERSION_TYPE is not User.
CURRENCY_CONVERSION_TYPE	VARCHAR2	30			Currency conversion type. Use Manage Currency Conversion Types task to identify valid values. For Fusion ERP in the Cloud, use USER_CURRENCY_CONVERSION_TYPE instead.
CURRENCY_CONVERSION_RATE	NUMBER				Foreign currency exchange rate. Mandatory if CURRENCY_CONVERSION_TYPE is User.
SEGMENT1	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT2	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT3	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT4	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT5	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT6	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT7	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT8	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT9	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT10	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT11	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT12	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT13	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT14	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT15	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT16	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT17	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT18	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT19	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT20	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT21	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT22	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT23	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT24	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT25	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT26	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT27	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT28	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT29	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
SEGMENT30	VARCHAR2	25			Segment of the chart of accounts. Only use if assigned to the chart of accounts of the ledger. Validation: must be a valid value for the chart of accounts.
ENTERED_DR	NUMBER				Transaction debit amount in the entered currency.
ENTERED_CR	NUMBER				Transaction credit amount in the entered currency.
ACCOUNTED_DR	NUMBER				Journal debit amount in the ledger currency.
ACCOUNTED_CR	NUMBER				Journal credit amount in the ledger currency.
TRANSACTION_DATE	DATE				Oracle internal use only. Date of transaction.
REFERENCE1	VARCHAR2	100			Reference column: batch name. Free text field. Not validated.
REFERENCE2	VARCHAR2	240			Reference column: batch description. Free text field. Not validated.
REFERENCE3	VARCHAR2	100			Oracle internal use only.
REFERENCE4	VARCHAR2	100			Reference column: journal entry name. Free text field. Not validated.
REFERENCE5	VARCHAR2	240			Reference column: journal entry description. Free text field. Not validated.
REFERENCE6	VARCHAR2	100			Reference column: journal entry reference. Free text field. Not validated.
REFERENCE7	VARCHAR2	100			Reference column: journal entry reversal flag. Valid values: Y, N.
REFERENCE8	VARCHAR2	100			Reference column: journal entry reversal period. Validation: mandatory if REFERENCE7, journal entry reversal flag, is Y. If average balance processing is enabled, enter effective date for reversal. This will be used to determine the GL period.
REFERENCE9	VARCHAR2	100			Reference column: journal reversal method. Valid values: Y, N. Meanings: Y changes sign, N switches debits/credits.
REFERENCE10	VARCHAR2	240			Reference column: journal entry line description. Free text field. Not validated.
REFERENCE11	VARCHAR2	240			Oracle internal use only.
REFERENCE12	VARCHAR2	100			Oracle internal use only.
REFERENCE13	VARCHAR2	100			Oracle internal use only.
REFERENCE14	VARCHAR2	100			Oracle internal use only.
REFERENCE15	VARCHAR2	100			Oracle internal use only.
REFERENCE16	VARCHAR2	100			Oracle internal use only.
REFERENCE17	VARCHAR2	100			Oracle internal use only.
REFERENCE18	VARCHAR2	100			Oracle internal use only.
REFERENCE19	VARCHAR2	100			Oracle internal use only.
REFERENCE20	VARCHAR2	100			Oracle internal use only.
REFERENCE21	VARCHAR2	240			Reference column: journal line. Free text field. Not validated.
REFERENCE22	VARCHAR2	240			Reference column: journal line. Free text field. Not validated.
REFERENCE23	VARCHAR2	240			Reference column: journal line. Free text field. Not validated.
REFERENCE24	VARCHAR2	240			Reference column: journal line. Free text field. Not validated.
REFERENCE25	VARCHAR2	240			Reference column: journal line. Free text field. Not validated.
REFERENCE26	VARCHAR2	240			Reference column: journal line. Free text field. Not validated.
REFERENCE27	VARCHAR2	240			Reference column: journal line. Free text field. Not validated.
REFERENCE28	VARCHAR2	240			Reference column: journal line. Free text field. Not validated.
REFERENCE29	VARCHAR2	240			Reference column: journal line. Free text field. Not validated.
REFERENCE30	VARCHAR2	240			Reference column: journal line. Free text field. Not validated.
INTERFACE_RUN_ID	NUMBER		18		Oracle internal use only.
JE_BATCH_ID	NUMBER		18		Oracle internal use only.
PERIOD_NAME	VARCHAR2	15			Period name. Use the Manage Accounting Calendars task to identify valid values.
JE_HEADER_ID	NUMBER		18		Oracle internal use only.
JE_LINE_NUM	NUMBER		18		Oracle internal use only.
CHART_OF_ACCOUNTS_ID	NUMBER		18		Oracle internal use only. Chart of accounts identifier.
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	15			Oracle internal use only. Ledger base currency.
CODE_COMBINATION_ID	NUMBER		18		Use the Manage Account Combinations task, column Account ID, to find valid values. Can be used instead of populating the SEGMENT columns individually. If CODE_COMBINATION_ID and the columns beginning with SEGMENT are populated, the SEGMENT column values take precedence.
DATE_CREATED_IN_GL	DATE				Oracle internal use only. Date journal import created batch. Populated by the journal import program.
WARNING_CODE	VARCHAR2	4			Oracle internal use only.
STATUS_DESCRIPTION	VARCHAR2	240			Oracle internal use only. Journal import status description. Populated by the journal import program.
STAT_AMOUNT	NUMBER				Statistical amount.
USER_JE_CATEGORY_NAME	VARCHAR2	25		Yes	Journal entry category. Use the Manage Journal Categories task to find valid values.
USER_JE_SOURCE_NAME	VARCHAR2	25		Yes	Journal entry source user defined name. Use the Manage Journal Sources page to find valid values.
USER_CURRENCY_CONVERSION_TYPE	VARCHAR2	30			Type of exchange rate. Use the Manage Conversion Rate Types task to find valid values. Translated value for CONVERSION_TYPE. Use either CURRENCY_CONVERSION_TYPE or USER_CURRENCY_CONVERSION_TYPE, but not both.
GROUP_ID	NUMBER		18		Groups lines for journals. Use positive integers. Lines with the same GROUP_ID are grouped into the same journal.
SUBLEDGER_DOC_SEQUENCE_ID	NUMBER				Oracle internal use only. Sequential numbering sequence defining column. Populated by journal import program when journal is sequenced.
SUBLEDGER_DOC_SEQUENCE_VALUE	NUMBER				Oracle internal use only. Sequential numbering sequence value. Populated by journal import program when journal is sequenced.
ATTRIBUTE1	VARCHAR2	150			Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE2	VARCHAR2	150			Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE3	VARCHAR2	150			Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE4	VARCHAR2	150			Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE5	VARCHAR2	150			Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE6	VARCHAR2	150			Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE7	VARCHAR2	150			Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE8	VARCHAR2	150			Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE9	VARCHAR2	150			Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE10	VARCHAR2	150			Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE11	VARCHAR2	150			Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE12	VARCHAR2	150			Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE13	VARCHAR2	150			Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE14	VARCHAR2	150			Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE15	VARCHAR2	150			Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE16	VARCHAR2	150			Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE17	VARCHAR2	150			Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE18	VARCHAR2	150			Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE19	VARCHAR2	150			Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE20	VARCHAR2	150			Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE_CATEGORY	VARCHAR2	150			Context code for Journals Lines descriptive flexfield. Use the Manage General Ledger Descriptive Flexfields task to identify valid values. Use ATTRIBUTE1 to ATTRIBUTE10 for the segment values.
ATTRIBUTE_CATEGORY2	VARCHAR2	150			Context code for Journals Captured Information descriptive flexfield. Use the Manage General Ledger Descriptive Flexfields task to identify valid values. Use ATTRIBUTE11 to ATTRIBUTE20 for the segment values.
INVOICE_DATE	DATE				Oracle internal use only.
TAX_CODE	VARCHAR2	15			Oracle internal use only.
INVOICE_IDENTIFIER	VARCHAR2	20			Oracle internal use only.
INVOICE_AMOUNT	NUMBER				Oracle internal use only.
ATTRIBUTE_CATEGORY3	VARCHAR2	150			Oracle internal use only.
USSGL_TRANSACTION_CODE	VARCHAR2	30			Government transaction code. Oracle internal use only. Only applicable if Oracle Federal Financials is used.
DESCR_FLEX_ERROR_MESSAGE	VARCHAR2	240			Oracle internal use only.
JGZZ_RECON_REF	VARCHAR2	240			Oracle internal use only.
AVERAGE_JOURNAL_FLAG	VARCHAR2	1			Oracle internal use only.
GL_SL_LINK_ID	NUMBER				Link to associated subledger data. Oracle internal use only.
GL_SL_LINK_TABLE	VARCHAR2	30			Table containing associated subledger data. Oracle internal use only.
ORIGINATING_BAL_SEG_VALUE	VARCHAR2	25			Originating balancing segment value for intercompany transaction. Overrides default balancing segment value. Should be a valid value for value set used for intercompany.
REFERENCE_DATE	DATE				Reference Date for sequencing to meet statutory requirements in Italy. Date format: YYYY/MM/DD.
SET_OF_BOOKS_ID	NUMBER		18		Oracle internal use only.
BALANCING_SEGMENT_VALUE	VARCHAR2	25			Oracle internal use only.
MANAGEMENT_SEGMENT_VALUE	VARCHAR2	25			Oracle internal use only.
FUNDS_RESERVED_FLAG	VARCHAR2	1			Oracle internal use only.
CODE_COMBINATION_ID_INTERIM	NUMBER		18		Oracle internal use only.
CURRENCY_CONV_DATE_INTER	DATE				Oracle internal use only.
CURRENCY_CONV_TYPE_INTER	VARCHAR2	30			Oracle internal use only.
CURRENCY_CONV_RATE_INTER	NUMBER		18		Oracle internal use only.
LOAD_REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: request ID of the interface load job that created the row.
LEGAL_ENTITY_ID	NUMBER		18		Legal Entity Identifier. Foreign key to XLE_ENTITY_PROFILES
LEGAL_ENTITY_IDENTIFIER	VARCHAR2	30			Unique number used to identify a legal entity. Foreign key to XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER.
LEDGER_NAME	VARCHAR2	30			Ledger name for the journal to be imported. Used in file based data import.

Foreign Keys

Table	Foreign Table	Foreign Key Column
GL_INTERFACE	GL_LEDGERS	LEDGER_ID
GL_INTERFACE	GL_JE_BATCHES	JE_BATCH_ID
GL_INTERFACE	GL_JE_HEADERS	JE_HEADER_ID
GL_INTERFACE	GL_JE_LINES	JE_HEADER_ID, JE_LINE_NUM
GL_INTERFACE	GL_CODE_COMBINATIONS	CODE_COMBINATION_ID

Indexes

Index	Uniqueness	Tablespace	Column
GL_INTERFACE_N1	Non Unique	Default	USER_JE_SOURCE_NAME, LEDGER_ID, SET_OF_BOOKS_ID, GROUP_ID
GL_INTERFACE_N2	Non Unique	Default	REQUEST_ID, JE_HEADER_ID, STATUS, CODE_COMBINATION_ID
GL_INTERFACE_N3	Non Unique	Default	SUBLEDGER_DOC_SEQUENCE_VALUE, SUBLEDGER_DOC_SEQUENCE_ID
GL_INTERFACE_N4	Non Unique	Default	REFERENCE26, REFERENCE22, REFERENCE23

https://bhaskarreddyapps.blogspot.com/2011/11/gl-interfaces.html