Thursday, March 30, 2017

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

NameDatabaseLengthPrecisionNot NullCommentsFlexfield Mapping
STATUSVARCHAR250YesJournal Import status. Use: NEW.
GL_INTERFACE_IDNUMBER18Interface Identifier. Oracle internal use only. Populated by the journal import program.
CREATION_DATETIMESTAMPWho column: date and time of the creation of the row.
LAST_UPDATE_DATETIMESTAMPWho column: date and time of the last update of the row.
LAST_UPDATE_LOGINVARCHAR232Who column: session login associated to the user who last updated the row.
LAST_UPDATED_BYVARCHAR264Who column: user who last updated the row.
OBJECT_VERSION_NUMBERNUMBER9Used 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_IDNUMBER18Ledger identifier. Use the Manage Primary Ledgers task to find valid values.
JE_SOURCE_NAMEVARCHAR225Oracle internal use only. Use column USER_JE_SOURCE_NAME to populate journal source.
JE_CATEGORY_NAMEVARCHAR225Oracle internal use only. Use column USER_JE_CATEGORY_NAME to populate journal category.
ACCOUNTING_DATEDATEYesEffective date of the journal entry. Used to assign the accounting period.
CURRENCY_CODEVARCHAR215YesEntered 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_CREATEDDATEYesWho column: date the row was created.
CREATED_BYVARCHAR264Who column: user who created the row.
ACTUAL_FLAGVARCHAR21YesBalance type of the journal. Use: A. Meaning: Actual.
REQUEST_IDNUMBER18Enterprise Service Scheduler: request ID of the job that created or last updated the row.
ENCUMBRANCE_TYPE_IDNUMBEROracle internal use only.
BUDGET_VERSION_IDNUMBEROracle internal use only.
CURRENCY_CONVERSION_DATEDATEDate of exchange rate. Date format: YYYY/MM/DD. Required if CURRENCY_CONVERSION_TYPE is not User.
CURRENCY_CONVERSION_TYPEVARCHAR230Currency 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_RATENUMBERForeign currency exchange rate. Mandatory if CURRENCY_CONVERSION_TYPE is User.
SEGMENT1VARCHAR225Segment 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.
SEGMENT2VARCHAR225Segment 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.
SEGMENT3VARCHAR225Segment 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.
SEGMENT4VARCHAR225Segment 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.
SEGMENT5VARCHAR225Segment 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.
SEGMENT6VARCHAR225Segment 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.
SEGMENT7VARCHAR225Segment 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.
SEGMENT8VARCHAR225Segment 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.
SEGMENT9VARCHAR225Segment 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.
SEGMENT10VARCHAR225Segment 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.
SEGMENT11VARCHAR225Segment 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.
SEGMENT12VARCHAR225Segment 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.
SEGMENT13VARCHAR225Segment 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.
SEGMENT14VARCHAR225Segment 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.
SEGMENT15VARCHAR225Segment 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.
SEGMENT16VARCHAR225Segment 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.
SEGMENT17VARCHAR225Segment 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.
SEGMENT18VARCHAR225Segment 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.
SEGMENT19VARCHAR225Segment 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.
SEGMENT20VARCHAR225Segment 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.
SEGMENT21VARCHAR225Segment 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.
SEGMENT22VARCHAR225Segment 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.
SEGMENT23VARCHAR225Segment 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.
SEGMENT24VARCHAR225Segment 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.
SEGMENT25VARCHAR225Segment 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.
SEGMENT26VARCHAR225Segment 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.
SEGMENT27VARCHAR225Segment 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.
SEGMENT28VARCHAR225Segment 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.
SEGMENT29VARCHAR225Segment 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.
SEGMENT30VARCHAR225Segment 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_DRNUMBERTransaction debit amount in the entered currency.
ENTERED_CRNUMBERTransaction credit amount in the entered currency.
ACCOUNTED_DRNUMBERJournal debit amount in the ledger currency.
ACCOUNTED_CRNUMBERJournal credit amount in the ledger currency.
TRANSACTION_DATEDATEOracle internal use only. Date of transaction.
REFERENCE1VARCHAR2100Reference column: batch name. Free text field. Not validated.
REFERENCE2VARCHAR2240Reference column: batch description. Free text field. Not validated.
REFERENCE3VARCHAR2100Oracle internal use only.
REFERENCE4VARCHAR2100Reference column: journal entry name. Free text field. Not validated.
REFERENCE5VARCHAR2240Reference column: journal entry description. Free text field. Not validated.
REFERENCE6VARCHAR2100Reference column: journal entry reference. Free text field. Not validated.
REFERENCE7VARCHAR2100Reference column: journal entry reversal flag. Valid values: Y, N.
REFERENCE8VARCHAR2100Reference 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.
REFERENCE9VARCHAR2100Reference column: journal reversal method. Valid values: Y, N. Meanings: Y changes sign, N switches debits/credits.
REFERENCE10VARCHAR2240Reference column: journal entry line description. Free text field. Not validated.
REFERENCE11VARCHAR2240Oracle internal use only.
REFERENCE12VARCHAR2100Oracle internal use only.
REFERENCE13VARCHAR2100Oracle internal use only.
REFERENCE14VARCHAR2100Oracle internal use only.
REFERENCE15VARCHAR2100Oracle internal use only.
REFERENCE16VARCHAR2100Oracle internal use only.
REFERENCE17VARCHAR2100Oracle internal use only.
REFERENCE18VARCHAR2100Oracle internal use only.
REFERENCE19VARCHAR2100Oracle internal use only.
REFERENCE20VARCHAR2100Oracle internal use only.
REFERENCE21VARCHAR2240Reference column: journal line. Free text field. Not validated.
REFERENCE22VARCHAR2240Reference column: journal line. Free text field. Not validated.
REFERENCE23VARCHAR2240Reference column: journal line. Free text field. Not validated.
REFERENCE24VARCHAR2240Reference column: journal line. Free text field. Not validated.
REFERENCE25VARCHAR2240Reference column: journal line. Free text field. Not validated.
REFERENCE26VARCHAR2240Reference column: journal line. Free text field. Not validated.
REFERENCE27VARCHAR2240Reference column: journal line. Free text field. Not validated.
REFERENCE28VARCHAR2240Reference column: journal line. Free text field. Not validated.
REFERENCE29VARCHAR2240Reference column: journal line. Free text field. Not validated.
REFERENCE30VARCHAR2240Reference column: journal line. Free text field. Not validated.
INTERFACE_RUN_IDNUMBER18Oracle internal use only.
JE_BATCH_IDNUMBER18Oracle internal use only.
PERIOD_NAMEVARCHAR215Period name. Use the Manage Accounting Calendars task to identify valid values.
JE_HEADER_IDNUMBER18Oracle internal use only.
JE_LINE_NUMNUMBER18Oracle internal use only.
CHART_OF_ACCOUNTS_IDNUMBER18Oracle internal use only. Chart of accounts identifier.
FUNCTIONAL_CURRENCY_CODEVARCHAR215Oracle internal use only. Ledger base currency.
CODE_COMBINATION_IDNUMBER18Use 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_GLDATEOracle internal use only. Date journal import created batch. Populated by the journal import program.
WARNING_CODEVARCHAR24Oracle internal use only.
STATUS_DESCRIPTIONVARCHAR2240Oracle internal use only. Journal import status description. Populated by the journal import program.
STAT_AMOUNTNUMBERStatistical amount.
USER_JE_CATEGORY_NAMEVARCHAR225YesJournal entry category. Use the Manage Journal Categories task to find valid values.
USER_JE_SOURCE_NAMEVARCHAR225YesJournal entry source user defined name. Use the Manage Journal Sources page to find valid values.
USER_CURRENCY_CONVERSION_TYPEVARCHAR230Type 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_IDNUMBER18Groups lines for journals. Use positive integers. Lines with the same GROUP_ID are grouped into the same journal.
SUBLEDGER_DOC_SEQUENCE_IDNUMBEROracle internal use only. Sequential numbering sequence defining column. Populated by journal import program when journal is sequenced.
SUBLEDGER_DOC_SEQUENCE_VALUENUMBEROracle internal use only. Sequential numbering sequence value. Populated by journal import program when journal is sequenced.
ATTRIBUTE1VARCHAR2150Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE2VARCHAR2150Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE3VARCHAR2150Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE4VARCHAR2150Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE5VARCHAR2150Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE6VARCHAR2150Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE7VARCHAR2150Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE8VARCHAR2150Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE9VARCHAR2150Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE10VARCHAR2150Segment value for Journals Lines descriptive flexfield.
ATTRIBUTE11VARCHAR2150Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE12VARCHAR2150Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE13VARCHAR2150Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE14VARCHAR2150Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE15VARCHAR2150Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE16VARCHAR2150Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE17VARCHAR2150Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE18VARCHAR2150Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE19VARCHAR2150Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE20VARCHAR2150Segment value for Journals Captured Information descriptive flexfield.
ATTRIBUTE_CATEGORYVARCHAR2150Context 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_CATEGORY2VARCHAR2150Context 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_DATEDATEOracle internal use only.
TAX_CODEVARCHAR215Oracle internal use only.
INVOICE_IDENTIFIERVARCHAR220Oracle internal use only.
INVOICE_AMOUNTNUMBEROracle internal use only.
ATTRIBUTE_CATEGORY3VARCHAR2150Oracle internal use only.
USSGL_TRANSACTION_CODEVARCHAR230Government transaction code. Oracle internal use only. Only applicable if Oracle Federal Financials is used.
DESCR_FLEX_ERROR_MESSAGEVARCHAR2240Oracle internal use only.
JGZZ_RECON_REFVARCHAR2240Oracle internal use only.
AVERAGE_JOURNAL_FLAGVARCHAR21Oracle internal use only.
GL_SL_LINK_IDNUMBERLink to associated subledger data. Oracle internal use only.
GL_SL_LINK_TABLEVARCHAR230Table containing associated subledger data. Oracle internal use only.
ORIGINATING_BAL_SEG_VALUEVARCHAR225Originating balancing segment value for intercompany transaction. Overrides default balancing segment value. Should be a valid value for value set used for intercompany.
REFERENCE_DATEDATEReference Date for sequencing to meet statutory requirements in Italy. Date format: YYYY/MM/DD.
SET_OF_BOOKS_IDNUMBER18Oracle internal use only.
BALANCING_SEGMENT_VALUEVARCHAR225Oracle internal use only.
MANAGEMENT_SEGMENT_VALUEVARCHAR225Oracle internal use only.
FUNDS_RESERVED_FLAGVARCHAR21Oracle internal use only.
CODE_COMBINATION_ID_INTERIMNUMBER18Oracle internal use only.
CURRENCY_CONV_DATE_INTERDATEOracle internal use only.
CURRENCY_CONV_TYPE_INTERVARCHAR230Oracle internal use only.
CURRENCY_CONV_RATE_INTERNUMBER18Oracle internal use only.
LOAD_REQUEST_IDNUMBER18Enterprise Service Scheduler: request ID of the interface load job that created the row.
LEGAL_ENTITY_IDNUMBER18Legal Entity Identifier. Foreign key to XLE_ENTITY_PROFILES
LEGAL_ENTITY_IDENTIFIERVARCHAR230Unique number used to identify a legal entity. Foreign key to XLE_ENTITY_PROFILES.LEGAL_ENTITY_IDENTIFIER.
LEDGER_NAMEVARCHAR230Ledger name for the journal to be imported. Used in file based data import.

Foreign Keys

TableForeign TableForeign Key Column
GL_INTERFACEGL_LEDGERSLEDGER_ID
GL_INTERFACEGL_JE_BATCHESJE_BATCH_ID
GL_INTERFACEGL_JE_HEADERSJE_HEADER_ID
GL_INTERFACEGL_JE_LINESJE_HEADER_ID, JE_LINE_NUM
GL_INTERFACEGL_CODE_COMBINATIONSCODE_COMBINATION_ID

Indexes


IndexUniquenessTablespaceColumn
GL_INTERFACE_N1Non UniqueDefaultUSER_JE_SOURCE_NAME, LEDGER_ID, SET_OF_BOOKS_ID, GROUP_ID
GL_INTERFACE_N2Non UniqueDefaultREQUEST_ID, JE_HEADER_ID, STATUS, CODE_COMBINATION_ID
GL_INTERFACE_N3Non UniqueDefaultSUBLEDGER_DOC_SEQUENCE_VALUE, SUBLEDGER_DOC_SEQUENCE_ID
GL_INTERFACE_N4Non UniqueDefaultREFERENCE26, REFERENCE22, REFERENCE23

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






No comments:

Post a Comment