TABLE - GL.GL_CONCURRENT_SCHEDULES TABLE - GL.GL_CONSOLIDATION TABLE - GL.GL_CONSOLIDATION_ACCOUNTS TABLE - GL.GL_CONSOLIDATION_AUDIT TABLE - GL.GL_CONSOLIDATION_HISTORY TABLE - GL.GL_CONSOLIDATION_SETS TABLE - GL.GL_CONS_BATCHES TABLE - GL.GL_CONS_FLEXFIELD_MAP TABLE - GL.GL_CONS_FLEX_...
16 Oracle Fusion U.S. Federal Financials 17 Oracle Middleware Extensions for Applications 18 Payables 19 Payments 20 Receivables Details Schema: FUSION Object owner: GL Object type: VIEW Columns Name LEDGER_ID LEDGER_NAME LEDGER_SHORT_NAME
Object type: TABLE Tablespace: APPS_TS_TX_DATA Primary Key Name Columns GL_LEDGER_NORM_SEG_VALS_PK_ LAST_UPDATE_DATE, LAST_UPDATED_BY, RECORD_ID Columns NameDatatypeLengthPrecisionNot-nullComments LEDGER_ID NUMBER 18 Ledger identifier. Foreign key to GL_LEDGERS. SEGMENT_TYPE_CODE VARCHAR2...
1.会计科目设置后,总账中找不到对应账簿 2.原因是新版本系统物化视图有问题,参照metalink解决方案得知原路径下物化视图有误(定义脚本有问题);找到上版本该文件重新定义该物化视图 1.drop MATERIALIZED view GL_ACCESS_SET_LEDGERS; 2:执行文件glvaslmv.sql重新生成物化视图 3.SELECT * FROM all_objects WHERE obje...
1.会计科目设置后,总账中找不到对应账簿 2.原因是新版本系统物化视图有问题,参照metalink解决方案得知原路径下物化视图有误(定义脚本有问题);找到上版本该文件重新定义该物化视图 1.drop MATERIALIZED view GL_ACCESS_SET_LEDGERS; 2:执行文件glvaslmv.sql重新生成物化视图 ...
GL Interface Table GL_INTERFACE GL_INTERFACE( 必要欄 位) St at us Var char 2 New:新增 Ledger _i d Number 帳本,Gl _LEDGERS. l edger _i d Account i ng_dat e Dat e 總帳日期 Cur r ency_code Var char 2 幣別,Fnd_cur r enci es . Cur r ency_code Dat e_cr eat ed, Dat e 資...
FND_CURRENCIES 設定匯率類別 Path:(GL)SetupCurrenciesRatesTypesBaseTable:GL_DAILY_CONVERSION_TYPES 設定匯率 Path:(GL)SetupCurrenciesRatesDailyBaseTable:GL_DAILY_RATES 設定帳本 Path:(GL)SetupFinancialsAccountingSetupManagerAccountingSetupsBaseTable:GL_LEDGERS ...
TABLE - GL.GL_LEDGERS TABLE - GL.GL_LEDGER_BSV_GT TABLE - GL.GL_LEDGER_CONFIGURATIONS TABLE - GL.GL_LEDGER_CONFIG_DETAILS TABLE - GL.GL_LEDGER_LE_BSV_GT TABLE - GL.GL_LEDGER_NORM_SEG_VALS TABLE - GL.GL_LEDGER_RELATIONSHIPS
GL_XFR_SYSTEM_LEDGERS GL_XFR_TRACKING GL_XLATE_POSTING_INTERIM GL_XLATE_RATES_GT GL_YEAR_END_BAL_GT GL_YEAR_END_INC_STMT_GT RG_TABLE_SIZES Views 14 Joint Venture Management Tables Views 15 Legal Entity Configurator Tables Views 16 Oracle Fusion U.S. Federal Financials ...
GL_CODE_COMBINATIONS contains valid account combinations for each accounting flexfield structure within the Oracle Fusion General Ledger application. Details Schema: FUSION Object owner: GL Object type: TABLE Tablespace: APPS_TS_TX_DATA Primary Key Name Columns GL_CODE_COMBINATIONS_PK CODE_COMBIN...