Table: FII_CC_PMV_AGRT_NODES | Oracle EBS ETRM Search

Table: FII_CC_PMV_AGRT_NODES 12.1.1

owner FII·FII - Financial Intelligence·8 columns

This table stores the information whether the node is aggregated and available for viewby

FII.FII_CC_PMV_AGRT_NODES·Explore FII module →

Table: FII_COST_CENTER_GRANTS 12.1.1

owner FII·FII - Financial Intelligence·9 columns

This table stores cost center delegations from bis_grants view after removing duplicate delegations. Only the top-level nodes in a series of delegations are stored in this table.

FII.FII_COST_CENTER_GRANTS·Explore FII module →

View: FII_AR_REVENUE_B_V2 12.1.1

FII - Financial Intelligence·12 columns

APPS.FII_AR_REVENUE_B_V2·↳ FII_AR_REVENUE_B·Explore FII module →

Table: FII_COM_CC_MAPPINGS 12.1.1 standalone

owner FII·FII - Financial Intelligence·13 columns

This table stores the Company Cost center mappings to both manager and line of business for MV refresh programs

FII.FII_COM_CC_MAPPINGS·Explore FII module →

Table: CN_PAYMENT_API_ALL 12.2.2 link

owner CN·CN - Incentive Compensation·18 columns

Holds the output of the payment process.

CN.CN_PAYMENT_API_ALL·Explore CN module →

View: FII_AP_INV_B_V1 12.1.1

FII - Financial Intelligence·10 columns

APPS.FII_AP_INV_B_V1·↳ FII_AP_INV_B·Explore FII module →

View: FII_GL_AGRT_SUM_MV_S_V 12.1.1

FII - Financial Intelligence·17 columns

APPS.FII_GL_AGRT_SUM_MV_S_V·↳ FII_GL_AGRT_SUM_MV·Explore FII module →

View: FII_GL_JE_SUMMARY_B_P_V 12.1.1

FII - Financial Intelligence·20 columns

APPS.FII_GL_JE_SUMMARY_B_P_V·↳ FII_GL_JE_SUMMARY_B·Explore FII module →

View: FII_AR_REVENUE_B_V1 12.1.1

FII - Financial Intelligence·12 columns

APPS.FII_AR_REVENUE_B_V1·↳ FII_AR_REVENUE_B·Explore FII module →

View: FII_GL_TREND_SUM_MV_P_V 12.1.1

FII - Financial Intelligence·18 columns

APPS.FII_GL_TREND_SUM_MV_P_V·↳ FII_GL_TREND_SUM_MV·Explore FII module →

View: FII_GL_AGRT_SUM_MV_P_V 12.1.1

FII - Financial Intelligence·21 columns

APPS.FII_GL_AGRT_SUM_MV_P_V·↳ FII_GL_AGRT_SUM_MV·Explore FII module →

Table: FII_RECONV_GL_ROLLUP_GT 12.1.1 standalone

owner FII·FII - Financial Intelligence·19 columns

FII.FII_RECONV_GL_ROLLUP_GT·Explore FII module →

View: FII_GL_TREND_SUM_MV_S_V 12.1.1

FII - Financial Intelligence·14 columns

APPS.FII_GL_TREND_SUM_MV_S_V·↳ FII_GL_TREND_SUM_MV·Explore FII module →

View: FII_GL_JE_SUMMARY_B_S_V 12.1.1

FII - Financial Intelligence·20 columns

APPS.FII_GL_JE_SUMMARY_B_S_V·↳ FII_GL_JE_SUMMARY_B·Explore FII module →

Table: POA_API_001_MV 12.1.1 standalone

FND - Application Object Library·22 columns

APPS.POA_API_001_MV·Explore FND module →

Table: FII_GL_CCID_DIMENSIONS 12.1.1 standalone

owner FII·FII - Financial Intelligence·16 columns

This table stores the detail information for each code combinations.

FII.FII_GL_CCID_DIMENSIONS·Explore FII module →

Table: FII_AP_INV_DIST_T 12.1.1 standalone

owner FII·FII - Financial Intelligence·24 columns

Table to hold data in Oracle Payables not posted to SLA.

FII.FII_AP_INV_DIST_T·Explore FII module →

View: FII_AP_INV_B_V2 12.1.1

FII - Financial Intelligence·10 columns

APPS.FII_AP_INV_B_V2·↳ FII_AP_INV_B·Explore FII module →

View: FII_GL_LOCAL_SNAP_F_P_V 12.1.1

FII - Financial Intelligence·35 columns

APPS.FII_GL_LOCAL_SNAP_F_P_V·↳ FII_GL_LOCAL_SNAP_F·Explore FII module →

Table: FII_BUDGET_BASE 12.1.1 standalone

owner FII·FII - Financial Intelligence·29 columns

This is the base fact table that stores the budget and forecase data.

FII.FII_BUDGET_BASE·Explore FII module →

Table: FII_BUDGET_INTERFACE 12.1.1 standalone

owner FII·FII - Financial Intelligence·27 columns

This table stores budget and forecast data users will upload into the DBI system.

FII.FII_BUDGET_INTERFACE·Explore FII module →

Table: POA_IDL_BS_J_MV 12.1.1 standalone

FND - Application Object Library·20 columns

APPS.POA_IDL_BS_J_MV·Explore FND module →

View: FII_GL_LOCAL_SNAP_F_S_V 12.1.1

FII - Financial Intelligence·35 columns

APPS.FII_GL_LOCAL_SNAP_F_S_V·↳ FII_GL_LOCAL_SNAP_F·Explore FII module →

Table: FII_BUDGET_BASE_T 12.1.1 standalone

owner FII·FII - Financial Intelligence·29 columns

This table is used for internal processing only

FII.FII_BUDGET_BASE_T·Explore FII module →

Table: FII_GL_JE_SUMMARY_B 12.1.1 standalone

owner FII·FII - Financial Intelligence·30 columns

Base Summary table for General Ledger entries. It is used to support revenue and expenses related portlets.

FII.FII_GL_JE_SUMMARY_B·Explore FII module →

Table: FII_AP_INV_DIST_F 12.1.1 standalone

owner FII·FII - Financial Intelligence·31 columns

Table to hold data in Oracle Payables not posted to SLA.

FII.FII_AP_INV_DIST_F·Explore FII module →

Table: POA_API_BS_J_MV 12.1.1 standalone

FND - Application Object Library·35 columns

APPS.POA_API_BS_J_MV·Explore FND module →

Table: POA_BIS_SAVINGS_RPT 12.1.1 standalone

owner PO·PO - Purchasing·36 columns

Temporary table for Purchasing Intelligence reports.

PO.POA_BIS_SAVINGS_RPT·Explore PO module →

View: POA_BIS_SAVINGS_RPT_V 12.1.1

PO - Purchasing·36 columns

APPS.POA_BIS_SAVINGS_RPT_V·↳ POA_BIS_SAVINGS_RPT·Explore PO module →

Table: FII_FA_EXP_MV 12.1.1 standalone

FND - Application Object Library·26 columns

APPS.FII_FA_EXP_MV·Explore FND module →

View: FII_GL_BASE_MAP_MV_S_V 12.1.1

FII - Financial Intelligence·15 columns

APPS.FII_GL_BASE_MAP_MV_S_V·↳ FII_GL_BASE_MAP_MV·Explore FII module →

Table: POA_PQC_BS_J2_MV 12.1.1 standalone

FND - Application Object Library·39 columns

APPS.POA_PQC_BS_J2_MV·Explore FND module →

View: FII_GL_SNAP_F_S_V 12.1.1

FII - Financial Intelligence·39 columns

APPS.FII_GL_SNAP_F_S_V·↳ FII_GL_SNAP_F·Explore FII module →

Table: FII_GL_JE_SUMMARY_STG 12.1.1 standalone

owner FII·FII - Financial Intelligence·36 columns

This table is used for internal processesing only

FII.FII_GL_JE_SUMMARY_STG·Explore FII module →

Table: FII_AR_REVENUE_STG 12.1.1 standalone

owner FII·FII - Financial Intelligence·37 columns

FII.FII_AR_REVENUE_STG·Explore FII module →

Table: FII_AR_REVENUE_B 12.1.1 standalone

owner FII·FII - Financial Intelligence·42 columns

Base Summary Table for Receivables Revenue. It is used to support Revenue related portlets.

FII.FII_AR_REVENUE_B·Explore FII module →

Table: FII_GL_ENC_CARRYFWD_T 12.1.1 standalone

owner FII·FII - Financial Intelligence·28 columns

This is a temp table for storing the encumbrance carry forward data.

FII.FII_GL_ENC_CARRYFWD_T·Explore FII module →

Table: CN_PAYMENT_API_ALL 12.1.1 link

owner CN·CN - Incentive Compensation·18 columns

Holds the output of the payment process.

CN.CN_PAYMENT_API_ALL·Explore CN module →

Table: POA_BIS_SAVINGS 12.1.1 standalone

owner PO·PO - Purchasing·39 columns

Purchase details and analysis based on contracts

PO.POA_BIS_SAVINGS·Explore PO module →

Table: POA_POD_002_MV 12.1.1 standalone

FND - Application Object Library·59 columns

APPS.POA_POD_002_MV·Explore FND module →

View: FII_GL_BASE_MAP_MV_P_V 12.1.1

FII - Financial Intelligence·19 columns

APPS.FII_GL_BASE_MAP_MV_P_V·↳ FII_GL_BASE_MAP_MV·Explore FII module →

Table: FII_FA_EXP_T 12.1.1 standalone

owner FII·FII - Financial Intelligence·40 columns

This is the staging table for the Asset Expense Base Summary extraction program

FII.FII_FA_EXP_T·Explore FII module →

Table: POA_POD_001_MV 12.1.1 standalone

FND - Application Object Library·61 columns

APPS.POA_POD_001_MV·Explore FND module →

View: HXTFV_SUM_HOURS_WORKED 12.2.2

HXT - Time and Labor·46 columns

APPS.HXTFV_SUM_HOURS_WORKED·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·Explore HXT module →

Table: POA_API_002_MV 12.1.1 standalone

FND - Application Object Library·20 columns

APPS.POA_API_002_MV·Explore FND module →

Table: FII_BUDGET_DELTAS 12.1.1 standalone

owner FII·FII - Financial Intelligence·21 columns

This table stores the prior version date that we need to use during the upload process.

FII.FII_BUDGET_DELTAS·Explore FII module →

Table: FII_GL_BUDGET_EXTRACT_T 12.1.1 standalone

owner FII·FII - Financial Intelligence·22 columns

Temporary table for GL budget extraction.

FII.FII_GL_BUDGET_EXTRACT_T·Explore FII module →

Table: POA_PQC_001_MV 12.1.1 standalone

FND - Application Object Library·42 columns

APPS.POA_PQC_001_MV·Explore FND module →

Table: FII_FA_EXP_F 12.1.1 standalone

owner FII·FII - Financial Intelligence·35 columns

This is the fact table for the Asset Expense Base Summary extraction program

FII.FII_FA_EXP_F·Explore FII module →

Table: FII_BUDGET_STG 12.1.1 standalone

owner FII·FII - Financial Intelligence·35 columns

This table is used for internal processing only

FII.FII_BUDGET_STG·Explore FII module →

Results for “cost_center_id”