Table: FII_AR_OPERATIONS_SUMMARY | Oracle EBS ETRM Search

Table: FII_AR_OPERATIONS_SUMMARY 12.1.1 standalone

owner FII·FII - Financial Intelligence·23 columns

This summary table holds Orders to Cash operations information. It is used to support Order to Cash portlets

FII.FII_AR_OPERATIONS_SUMMARY·Explore FII module →

Table: FII_AR_OPEN_INSTALLMENT_F 12.1.1

owner FII·FII - Financial Intelligence·25 columns

This summary table holds summary information of open installments. It is used to support Risk Indicator portlets.

FII.FII_AR_OPEN_INSTALLMENT_F·Explore FII module →

Table: FII_AR_OPER_CUST_SUMMARY_F 12.1.1

owner FII·FII - Financial Intelligence·18 columns

This summary table holds Customer operations information. It is used to support Order to Cash portlets.

FII.FII_AR_OPER_CUST_SUMMARY_F·Explore FII module →

Table: FII_AR_RISK_INDICATOR_F 12.1.1

owner FII·FII - Financial Intelligence·15 columns

This summary table holds summary information of different kind of transactions which are either open or past due. It is used to support Risk Indicator portlets.

FII.FII_AR_RISK_INDICATOR_F·Explore FII module →

Table: ISC_EDW_BOOK_SUM1_FSTG 12.1.1 standalone

owner ISC·ISC - Supply Chain Intelligence·76 columns

ISC.ISC_EDW_BOOK_SUM1_FSTG·Explore ISC module →

Table: ISC_EDW_BOOK_SUM1_F 12.1.1 standalone

owner ISC·ISC - Supply Chain Intelligence·62 columns

ISC.ISC_EDW_BOOK_SUM1_F·Explore ISC module →

Table: FII_PA_BUDGET_F 12.1.1

owner FII·FII - Financial Intelligence·45 columns

FII_PA_BUDGET_F is the project budget fact table

FII.FII_PA_BUDGET_F·Explore FII module →

Table: ISC_EDW_BOOKINGS_F_DLOG 12.1.1

owner ISC·ISC - Supply Chain Intelligence·119 columns

This is the delete log table for the Bookings fact

ISC.ISC_EDW_BOOKINGS_F_DLOG·Explore ISC module →

Table: FII_PA_COST_F 12.1.1

owner FII·FII - Financial Intelligence·56 columns

Project Cost fact table.

FII.FII_PA_COST_F·Explore FII module →

Table: FII_PA_BUDGET_FSTG 12.1.1 standalone

owner FII·FII - Financial Intelligence·66 columns

FII_PA_BUDGET_FSTG is the interface table for the project budget fact

FII.FII_PA_BUDGET_FSTG·Explore FII module →

Table: FII_PA_REVENUE_FSTG 12.1.1 standalone

owner FII·FII - Financial Intelligence·75 columns

FII_PA_REVENUE_FSTG is the staging table for the project revenue fact.

FII.FII_PA_REVENUE_FSTG·Explore FII module →

Table: FII_PA_REVENUE_F 12.1.1

owner FII·FII - Financial Intelligence·46 columns

FII_PA_REVENUE_F is the project revenue fact table

FII.FII_PA_REVENUE_F·Explore FII module →

Table: ISC_EDW_BOOKINGS_F 12.1.1 standalone

owner ISC·ISC - Supply Chain Intelligence·119 columns

Bookings fact table

ISC.ISC_EDW_BOOKINGS_F·Explore ISC module →

Table: OPI_EDW_COGS_FSTG 12.1.1 standalone

owner OPI·OPI - Operations Intelligence·152 columns

Interface table for COGS Shipment Fact

OPI.OPI_EDW_COGS_FSTG·Explore OPI module →

Table: FII_AR_TRX_DIST_FSTG 12.1.1 standalone

owner FII·FII - Financial Intelligence·192 columns

Accounts Receivable Revenue Fact table

FII.FII_AR_TRX_DIST_FSTG·Explore FII module →

Table: FII_PA_COST_FSTG 12.1.1 standalone

owner FII·FII - Financial Intelligence·91 columns

FII_PA_COST_FSTG is the staging table for the project cost fact.

FII.FII_PA_COST_FSTG·Explore FII module →

Table: FII_AR_TRX_DIST_F 12.1.1 standalone

owner FII·FII - Financial Intelligence·134 columns

Accounts Receivable Revenue Fact table.

FII.FII_AR_TRX_DIST_F·Explore FII module →

Table: FII_AR_TRX_DIST_F_DLOG 12.1.1 standalone

owner FII·FII - Financial Intelligence·134 columns

This is a delete log table for the Accounts Receivable Revenue Fact (FII_AR_TRX_DIST_F). When a record is updated in the Accounts Receivable Revenue Fact, the old record is moved into the DLOG table. Thus, the DLOG table remembers the val

FII.FII_AR_TRX_DIST_F_DLOG·Explore FII module →

Table: ISC_EDW_BOOKINGS_FSTG 12.1.1 standalone

owner ISC·ISC - Supply Chain Intelligence·172 columns

Interface table for the Bookings fact

ISC.ISC_EDW_BOOKINGS_FSTG·Explore ISC module →

PACKAGE: APPS.FII_AR_CASH_PKG 12.1.1

APPS.FII_AR_CASH_PKG SQL Statements 12.1.1

PACKAGE BODY: APPS.FII_AR_CASH_PKG 12.1.1

TABLE: FII.FII_AR_RISK_INDICATOR_F 12.1.1

owner FII

APPS.FII_AR_RISK_PKG SQL Statements 12.1.1

PACKAGE: APPS.FII_AR_RISK_PKG 12.1.1

PACKAGE BODY: APPS.FII_AR_RISK_PKG 12.1.1

TABLE: FII.FII_AR_OPER_CUST_SUMMARY_F 12.1.1

owner FII

TABLE: FII.FII_AR_OPEN_INSTALLMENT_F 12.1.1

owner FII

View: FII_AR_TRX_DIST_MGR1_F 12.2.2

FII - Financial Intelligence (Obsolete)

Internal view used for EDW data extraction.

Not implemented in this database·Explore FII module →

TABLE: ISC.ISC_EDW_BACKLOG_SUM1_F 12.1.1

owner ISC

TABLE: FII.FII_AR_OPERATIONS_SUMMARY 12.1.1

owner FII

View: FII_AR_TRX_DIST_MGR1_F 12.1.1

FII - Financial Intelligence

Internal view used for EDW data extraction.

Not implemented in this database·Explore FII module →

PACKAGE BODY: APPS.ISC_EDW_BACKLOG_SUM1_F_C 12.1.1

used by 1

TABLE: FII.FII_PA_REVENUE_F 12.1.1

owner FII

TABLE: ISC.ISC_EDW_BOOK_SUM1_F 12.1.1

owner ISC

PACKAGE BODY: APPS.FII_AR_CASH_PKG 12.1.1

PACKAGE: APPS.ISC_EDW_BACKLOG_SUM1_F_C 12.1.1

used by 1

TABLE: FII.FII_PA_BUDGET_F 12.1.1

owner FII

TABLE: FII.FII_PA_COST_F 12.1.1

owner FII

APPS.ISC_EDW_BACKLOG_SUM1_F_C SQL Statements 12.1.1

TABLE: ISC.ISC_EDW_BOOK_SUM1_FSTG 12.1.1

owner ISC

PACKAGE BODY: APPS.FII_AR_RISK_PKG 12.1.1

TABLE: FII.FII_PA_BUDGET_FSTG 12.1.1

owner FII

TABLE: FII.FII_PA_REVENUE_FSTG 12.1.1

owner FII

TABLE: FII.FII_PA_COST_FSTG 12.1.1

owner FII

TABLE: ISC.ISC_EDW_BOOKINGS_F 12.1.1

owner ISC

TABLE: FII.FII_AR_TRX_DIST_F 12.1.1

owner FII

TABLE: ISC.ISC_EDW_BOOKINGS_F_DLOG 12.1.1

owner ISC

TABLE: OPI.OPI_EDW_COGS_FSTG 12.1.1

owner OPI

TABLE: ISC.ISC_EDW_BOOKINGS_FSTG 12.1.1

owner ISC

Results for “set_of_books_fk_key”