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 ...
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 ...
GL_INTERFACE_HISTORY contains the rows that are successfully imported from the GL_INTERFACE table through Journal Import. You use this information for historical reference only. Your Oracle Fusion General Ledger application adds rows to this table every time you successfully run Journal Import with the...
Stores the account combinations which needs to be created in the system. Details Schema: FUSION Object owner: GL Object type: TABLE Tablespace: INTERFACE Primary Key NameColumns GL_BULK_COMBINATIONS_INT_PK GROUP_NUMBER, ROW_NUMBER Columns
Schema: FUSION Object owner: GL Object type: TABLE Tablespace: INTERFACE Columns NameDatatypeLengthPrecisionNot-nullComments STATUS VARCHAR2 50 Yes Journal Import status GL_INTERFACE_ID NUMBER 18 Interface id. Used as a dummy primary key in some cases LEDGER_ID NUMBER 18 Ledger defining col...
This table is an interface table used to load cross-validation rules into the application. Details Schema: FUSION Object owner: GL Object type: TABLE Tablespace: INTERFACE Primary Key Name Columns GL_CROSS_VAL_RULES_INT_PK GROUP_NUMBER, ROW_NUMBER Columns NameDatatypeLengthPrecisionNot-null...
This table is an interface table used to load data for historical rates into the application. Details Schema: FUSION Object owner: GL Object type: TABLE Tablespace: INTERFACE Primary Key Name Columns GL_HISTORICAL_RATES_INT_PK GROUP_NUMBER, ROW_NUMBER Columns NameDatatypeLengthPrecisionNot-...
Schema: FUSION Object owner: GL Object type: TABLE Tablespace: APPS_TS_TX_DATA Primary Key NameColumns GL_JE_BATCHES_PK_ LAST_UPDATE_DATE, LAST_UPDATED_BY, JE_BATCH_ID Columns NameDatatypeLengthPrecisionNot-nullComments JE_BATCH_IDNUMBER18YesJournal entry batch defining column. ...
Each account range stored in this table should be related to one and only one revaluation defined in GL_REVALUATIONS. Details Schema: FUSION Object owner: GL Object type: TABLE Tablespace: FUSION_TS_TX_DATA Primary Key Name Columns GL_REVAL_ACCOUNT_RANGES_PK_ LAST_UPDATE_DATE, LAST_...
Object type: TABLE Tablespace: FUSION_TS_TX_DATA Primary Key Name Columns GL_JE_HEADERS_PK JE_HEADER_ID Columns NameDatatypeLengthPrecisionNot-nullCommentsFlexfield-mapping JE_HEADER_ID NUMBER 18 Yes Journal entry header identifier. LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date...