Wednesday, December 2, 2015

Oracle Financial Intelligence module database tables

EDW_AP_APPY_CHECK_LSTG
EDW_AP_APPY_CHECK_LTC
EDW_AP_APPY_PAYMENT_LSTG
EDW_AP_APPY_PAYMENT_LTC
EDW_AP_APPY_PYMT_MTHD_LSTG
EDW_AP_APPY_PYMT_MTHD_LTC
EDW_AP_PAYMENT_A_LTC
EDW_AP_PAYMENT_M
EDW_AP_PAY_TERM_A_LTC
EDW_AP_PAY_TERM_M
EDW_AP_PTRM_PAY_TERM_LSTG
EDW_AP_PTRM_PAY_TERM_LTC
EDW_ARDN_DOC_NUM_LSTG
EDW_ARDN_DOC_NUM_LTC
EDW_ARTT_CODE_LSTG
EDW_ARTT_CODE_LTC
EDW_ARTT_TYPE_LSTG
EDW_ARTT_TYPE_LTC
EDW_AR_DOC_NUM_A_LTC
EDW_AR_DOC_NUM_M
EDW_AR_TRX_TYPE_A_LTC
EDW_AR_TRX_TYPE_M
EDW_CONS_SET_OF_BOOKS
EDW_CURRENCY_A_LTC
EDW_CURRENCY_M
EDW_CURR_CURRENCY_LSTG
EDW_CURR_CURRENCY_LTC
EDW_EQUI_SET_OF_BOOKS
EDW_GL_ACCT10_M
EDW_GL_ACCT1_M
EDW_GL_ACCT2_M
EDW_GL_ACCT3_M
EDW_GL_ACCT4_M
EDW_GL_ACCT5_M
EDW_GL_ACCT6_M
EDW_GL_ACCT7_M
EDW_GL_ACCT8_M
EDW_GL_ACCT9_M
EDW_GL_BOOK_A_LTC
EDW_GL_BOOK_BOOK_LSTG
EDW_GL_BOOK_BOOK_LTC
EDW_GL_BOOK_FA_BOOK_LSTG
EDW_GL_BOOK_FA_BOOK_LTC
EDW_GL_BOOK_M
EDW_HOLD_A_LTC
EDW_HOLD_HOLD_LSTG
EDW_HOLD_HOLD_LTC
EDW_HOLD_HOLD_TYPE_LSTG
EDW_HOLD_HOLD_TYPE_LTC
EDW_HOLD_M
EDW_ILTY_INV_LN_TYP_LSTG
EDW_ILTY_INV_LN_TYP_LTC
EDW_INV_LN_TYP_A_LTC
EDW_INV_LN_TYP_M
EDW_INV_SOURCE_A_LTC
EDW_INV_SOURCE_M
EDW_INV_TYPE_A_LTC
EDW_INV_TYPE_M
EDW_IVSR_INV_SOURCE_LSTG
EDW_IVSR_INV_SOURCE_LTC
EDW_IVTY_INV_LSTG
EDW_IVTY_INV_LTC
EDW_IVTY_INV_TYPE_LSTG
EDW_IVTY_INV_TYPE_LTC
EDW_PA_EXP_TYPE_A_LTC
EDW_PA_EXP_TYPE_M
EDW_PA_PAEX_EXP_TYPE_LSTG
EDW_PA_PAEX_EXP_TYPE_LTC
EDW_PROJECT_A_LTC
EDW_PROJECT_M
EDW_PROJ_CATEG1_LSTG
EDW_PROJ_CATEG1_LTC
EDW_PROJ_CATEG2_LSTG
EDW_PROJ_CATEG2_LTC
EDW_PROJ_CATEG3_LSTG
EDW_PROJ_CATEG3_LTC
EDW_PROJ_CATEG4_LSTG
EDW_PROJ_CATEG4_LTC
EDW_PROJ_CATEG5_LSTG
EDW_PROJ_CATEG5_LTC
EDW_PROJ_CATEG6_LSTG
EDW_PROJ_CATEG6_LTC
EDW_PROJ_CATEG7_LSTG
EDW_PROJ_CATEG7_LTC
EDW_PROJ_CLS1_LSTG
EDW_PROJ_CLS1_LTC
EDW_PROJ_CLS2_LSTG
EDW_PROJ_CLS2_LTC
EDW_PROJ_CLS3_LSTG
EDW_PROJ_CLS3_LTC
EDW_PROJ_CLS4_LSTG
EDW_PROJ_CLS4_LTC
EDW_PROJ_CLS5_LSTG
EDW_PROJ_CLS5_LTC
EDW_PROJ_CLS6_LSTG
EDW_PROJ_CLS6_LTC
EDW_PROJ_CLS7_LSTG
EDW_PROJ_CLS7_LTC
EDW_PROJ_PRJ_TYP_LSTG
EDW_PROJ_PRJ_TYP_LTC
EDW_PROJ_PROJECT_LSTG
EDW_PROJ_PROJECT_LTC
EDW_PROJ_TASK_LSTG
EDW_PROJ_TASK_LTC
EDW_PROJ_TOP_TASK_LSTG
EDW_PROJ_TOP_TASK_LTC
EDW_RELEASE_A_LTC
EDW_RELEASE_M
EDW_RESR_REV_SRC_LSTG
EDW_RESR_REV_SRC_LTC
EDW_REV_SOURCE_A_LTC
EDW_REV_SOURCE_M
EDW_RLSE_RELEASE_LSTG
EDW_RLSE_RELEASE_LTC
EDW_RLSE_RELEASE_TYPE_LSTG
EDW_RLSE_RELEASE_TYPE_LTC
EDW_SEGMENT_CLASSES
EDW_SET_OF_BOOKS
EDW_SICM_SIC_LSTG
EDW_SICM_SIC_LTC
EDW_SIC_CODE_A_LTC
EDW_SIC_CODE_M
EDW_TIME_A_LTC
EDW_TIME_CAL_DAY_LSTG
EDW_TIME_CAL_DAY_LTC
EDW_TIME_CAL_NAME_LSTG
EDW_TIME_CAL_NAME_LTC
EDW_TIME_CAL_PERIOD_LSTG
EDW_TIME_CAL_PERIOD_LTC
EDW_TIME_CAL_QTR_LSTG
EDW_TIME_CAL_QTR_LTC
EDW_TIME_CAL_YEAR_LSTG
EDW_TIME_CAL_YEAR_LTC
EDW_TIME_DAY_LSTG
EDW_TIME_DAY_LTC
EDW_TIME_EP_CAL_NAME_LSTG
EDW_TIME_EP_CAL_NAME_LTC
EDW_TIME_EP_CAL_PERIOD_LSTG
EDW_TIME_EP_CAL_PERIOD_LTC
EDW_TIME_EP_CAL_QTR_LSTG
EDW_TIME_EP_CAL_QTR_LTC
EDW_TIME_EP_CAL_YEAR_LSTG
EDW_TIME_EP_CAL_YEAR_LTC
EDW_TIME_HALF_MONTH_LSTG
EDW_TIME_HALF_MONTH_LTC
EDW_TIME_HALF_YEAR_LSTG
EDW_TIME_HALF_YEAR_LTC
EDW_TIME_M
EDW_TIME_MONTH_LSTG
EDW_TIME_MONTH_LTC
EDW_TIME_PA_PERIOD_LSTG
EDW_TIME_PA_PERIOD_LTC
EDW_TIME_PERIOD_445_LSTG
EDW_TIME_PERIOD_445_LTC
EDW_TIME_QTR_LSTG
EDW_TIME_QTR_LTC
EDW_TIME_WEEK_LSTG
EDW_TIME_WEEK_LTC
EDW_TIME_YEAR_LSTG
EDW_TIME_YEAR_LTC
EDW_VBH_ROOTS
EDW_VBH_TEMP1
EDW_VBH_TEMP10
EDW_VBH_TEMP2
EDW_VBH_TEMP3
EDW_VBH_TEMP4
EDW_VBH_TEMP5
EDW_VBH_TEMP6
EDW_VBH_TEMP7
EDW_VBH_TEMP8
EDW_VBH_TEMP9
FII_AP_AGING_BKTS_B
FII_AP_BUCKET_CALCS
FII_AP_DBI_LOG_EXP_T
FII_AP_DBI_LOG_PS_T
FII_AP_DBI_LOG_T
FII_AP_DISCOUNTS_SUMMARY
FII_AP_DUE_COUNTS_B
FII_AP_FUNC_RATES_TEMP
FII_AP_HOLD_DATA_F
FII_AP_HOLD_DATA_FSTG
FII_AP_HOLD_HIST_B
FII_AP_HOLD_MSNG_RATES
FII_AP_INDEX_TEMP
FII_AP_INVH_MSNG_RATES
FII_AP_INVOICE_B
FII_AP_INVOICE_IDS
FII_AP_INV_B
FII_AP_INV_DIST_F
FII_AP_INV_DIST_T
FII_AP_INV_HOLDS_B
FII_AP_INV_ID
FII_AP_INV_LINES_F
FII_AP_INV_LINES_FSTG
FII_AP_INV_ON_HOLD_F
FII_AP_INV_ON_HOLD_FSTG
FII_AP_INV_PAYMTS_F
FII_AP_INV_PAYMTS_FSTG
FII_AP_INV_STG
FII_AP_IPAY_MSNG_RATES
FII_AP_LINE_MSNG_RATES
FII_AP_OP_INDICATOR_SUMMARY
FII_AP_PAY_CHK_STG
FII_AP_PAY_SCHED_B
FII_AP_PAY_SCHED_ID
FII_AP_PAY_SCHED_TEMP
FII_AP_PREPAY_T
FII_AP_PREPAY_WH_STG
FII_AP_PS_BUCKETS
FII_AP_PS_RATES_TEMP
FII_AP_PS_WORK_JOBS
FII_AP_SCHP_MSNG_RATES
FII_AP_SCH_PAYMTS_F
FII_AP_SCH_PAYMTS_FSTG
FII_AP_SUM_WORK_JOBS
FII_AP_TMP_HOLD_PK
FII_AP_TMP_INVH_PK
FII_AP_TMP_IPAY_PK
FII_AP_TMP_LINE_PK
FII_AP_TMP_SCHP_PK
FII_AP_TRANS_BACKLOG_SUMMARY
FII_AP_UNPOST_HEADERS_T
FII_AP_WH_TAX_T
FII_AR_CASH_FSTG
FII_AR_CASH_INV_MISS_RATE
FII_AR_COLL_IND_SUMMARY
FII_AR_COLL_IND_TEMP
FII_AR_OPEN_INSTALLMENT_F
FII_AR_OPEN_INSTALLMENT_FSTG
FII_AR_OPEN_INV_MISS_RATE
FII_AR_OPERATIONS_SUMMARY
FII_AR_OPER_CUST_SUMMARY_F
FII_AR_PROD_REV_INCLUDE_STG
FII_AR_PROD_REV_JOBS
FII_AR_PROD_REV_MISS_RATE
FII_AR_PROD_REV_SUM1_F
FII_AR_PROD_REV_SUM2_F
FII_AR_PROD_REV_SUM3_F
FII_AR_PROD_REV_SUM4_F
FII_AR_PROD_REV_SUMMARY_F
FII_AR_PROD_REV_SUMMARY_FSTG
FII_AR_REC_FSTG
FII_AR_REVENUE_B
FII_AR_REVENUE_F_DLOG
FII_AR_REVENUE_ID
FII_AR_REVENUE_JOBS
FII_AR_REVENUE_MARGIN_DLOG
FII_AR_REVENUE_STG
FII_AR_REV_ACCTS
FII_AR_RISK_INDICATOR_F
FII_AR_SALES_CREDITS
FII_AR_SALES_CREDITS_D_T
FII_AR_TRX_DIST_F
FII_AR_TRX_DIST_FSTG
FII_AR_TRX_DIST_F_DLOG
FII_AR_TRX_MSNG_RT
FII_BIS_APIPY_TEMP
FII_BUDGET_BASE
FII_BUDGET_BASE_T
FII_BUDGET_BASE_UPG_T
FII_BUDGET_DELTAS
FII_BUDGET_INTERFACE
FII_BUDGET_STG
FII_CC_MGR_HIERARCHIES
FII_CC_MGR_SUP
FII_CC_PMV_AGRT_NODES
FII_CHANGE_LOG
FII_COMPANY_GRANTS
FII_COMPANY_HIERARCHIES
FII_COMPANY_SETS
FII_COM_CC_DIM_MAPS
FII_COM_CC_MAPPINGS
FII_COM_PMV_AGRT_NODES
FII_COST_CENTER_GRANTS
FII_COST_CTR_HIERARCHIES
FII_DIM_MAPPING_RULES
FII_DIM_NORM_HIERARCHY
FII_ENCUM_TYPE_MAPPINGS
FII_E_REVENUE_F
FII_E_REVENUE_FSTG
FII_E_REVENUE_SUMMARY_F
FII_FA_ACCT_CLASS_CODE_GT
FII_FA_CAT_DIMENSIONS
FII_FA_CAT_SEGMENTS
FII_FA_EXP_CJE_IDS
FII_FA_EXP_F
FII_FA_EXP_HDR_IDS
FII_FA_EXP_T
FII_FA_NEW_EXP_CJE_IDS
FII_FA_NEW_EXP_HDR_IDS
FII_FA_WORKER_JOBS
FII_FC_PMV_AGRT_NODES
FII_FC_TYPE_NORM_ASSIGN
FII_FINANCIAL_DIMENSIONS
FII_FIN_CAT_LEAF_MAPS
FII_FIN_CAT_MAPPINGS
FII_FIN_CAT_TYPE_ASSGNS
FII_FIN_ITEM_ACCOUNTS
FII_FIN_ITEM_ASSIGNMENTS
FII_FIN_ITEM_HIERARCHIES
FII_FIN_ITEM_LEAF_HIERS
FII_FIN_ITEM_SETS
FII_FULL_COMPANY_HIERS
FII_FULL_COST_CTR_HIERS
FII_FULL_FIN_ITEM_HIERS
FII_FULL_LOB_HIERS
FII_FULL_UDD1_HIERS
FII_FULL_UDD2_HIERS
FII_GLOBAL_START_DATES
FII_GL_BUDGET_EXTRACT_T
FII_GL_CCID_DIMENSIONS
FII_GL_CCID_PROD_INT
FII_GL_ENC_CARRYFWD_F
FII_GL_ENC_CARRYFWD_T
FII_GL_JE_SUMMARY_B
FII_GL_JE_SUMMARY_STG
FII_GL_LOCAL_SNAP_F
FII_GL_MAX_CCID
FII_GL_NEW_JRL_HEADER_IDS
FII_GL_PROCESSED_HEADER_IDS
FII_GL_SNAP_F
FII_GL_SNAP_SUM_F
FII_GL_WORKER_JOBS
FII_INDEXES
FII_LOB_ASSIGNMENTS
FII_LOB_COST_CENTER_ORGS
FII_LOB_HIERARCHIES
FII_MT_BASE_FACT
FII_MT_BASE_FACT_ATTR
FII_MT_BASE_FACT_DRV_DEP
FII_MT_BASE_FACT_FK
FII_MT_BUCKET_BASIS
FII_MT_BUCKET_SET
FII_MT_BUCKET_SET_RANGE
FII_MT_DIMENSION
FII_MT_DIMENSION_ATTR
FII_MT_DIMENSION_LEVEL
FII_MT_DIMENSION_ROLE
FII_MT_DIM_LEVEL_HIERARCHY
FII_MT_SLICE
FII_MT_SLICE_FK
FII_MT_SUM_FACT
FII_MT_SUM_FACT_FK
FII_MT_SUM_FACT_MEASURE
FII_MT_SUM_FACT_SLICE
FII_NEW_CCID
FII_ORG_MGR_MAPPINGS
FII_PARTY_MKT_CLASS
FII_PARTY_MKT_CLASS_STG
FII_PA_BUDGET_F
FII_PA_BUDGET_FSTG
FII_PA_BUDGET_M
FII_PA_BUDGET_PK
FII_PA_COST_F
FII_PA_COST_FSTG
FII_PA_COST_PK
FII_PA_PABU_BUDGET_LSTG
FII_PA_PABU_BUDGET_LTC
FII_PA_REVENUE_EVT_PK
FII_PA_REVENUE_EXP_PK
FII_PA_REVENUE_F
FII_PA_REVENUE_FSTG
FII_PRODUCT_ASSIGNMENTS
FII_PROD_COA_ASSIGN_TYPE
FII_RECONV_GL_ROLLUP_GT
FII_RECONV_RATES
FII_REPORTING_STRUCTURES
FII_SLG_ASSIGNMENTS
FII_SLG_BUDGET_ASGNS
FII_SOURCE_LEDGER_GROUPS
FII_SYSTEM_EVENT_LOG
FII_TANDE
FII_TANDE_ACCT_SEG
FII_TANDE_ACCT_SEG_VAL
FII_TANDE_CCID
FII_TANDE_EMP_EXP_SUM
FII_TANDE_FMNTH_EXP_SUM
FII_TANDE_MISSING_RATES
FII_TANDE_RMNTH_EXP_SUM
FII_TANDE_STG
FII_TANDE_SUMMARY
FII_TIME_CAL_NAME
FII_TIME_CAL_PERIOD
FII_TIME_CAL_QTR
FII_TIME_CAL_RPT_STRUCT
FII_TIME_CAL_YEAR
FII_TIME_DAY
FII_TIME_ENT_PERIOD
FII_TIME_ENT_QTR
FII_TIME_ENT_YEAR
FII_TIME_GL_PERIODS
FII_TIME_MONTH
FII_TIME_P445
FII_TIME_QTR
FII_TIME_ROLLING_OFFSETS
FII_TIME_RPT_STRUCT
FII_TIME_STRUCTURES
FII_TIME_WEEK
FII_TIME_YEAR
FII_TIME_YEAR445
FII_TMP_PK
FII_TOP_SPENDERS_STG
FII_TOP_SPNDR_SUM_B
FII_TPRT_TRADE_PARTNER_LTC
FII_UDD1_HIERARCHIES
FII_UDD1_MAPPINGS
FII_UDD1_PMV_AGRT_NODES
FII_UDD2_HIERARCHIES
FII_UDD2_MAPPINGS

No comments: