Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - FEM Tables and Views

TABLE - FEM.FEM_ACTIVITIES
TABLE - FEM.FEM_ACTIVITIES_HIER
TABLE - FEM.FEM_ALLOC_BR_COND_SUM_GT
TABLE - FEM.FEM_ALLOC_BR_FCTR_SUM_GT
TABLE - FEM.FEM_BR_DISABLED_MBRS_GT
TABLE - FEM.FEM_BR_ROOT_RULES_GT
TABLE - FEM.FEM_BR_VALID_STATUS_GT
TABLE - FEM.FEM_COLUMN_REQUIREMNT_TL
TABLE - FEM.FEM_COST_OBJECTS
TABLE - FEM.FEM_COST_OBJECTS_HIER
TABLE - FEM.FEM_COST_OBJ_HIER_QTY
TABLE - FEM.FEM_DB_LINKS_TL
TABLE - FEM.FEM_FOLDERS_TL
TABLE - FEM.FEM_INTG_AOL_VALSET_MAP
TABLE - FEM.FEM_INTG_BAL_DEF_BSVS
TABLE - FEM.FEM_INTG_BAL_DEF_BUDGTS
TABLE - FEM.FEM_INTG_BAL_DEF_CURRS
TABLE - FEM.FEM_INTG_BAL_DEF_ENCS
TABLE - FEM.FEM_INTG_BAL_RULES
TABLE - FEM.FEM_INTG_BAL_RULE_DEFS
TABLE - FEM.FEM_INTG_BPI_CURR_GT
TABLE - FEM.FEM_INTG_BUDGT_DS
TABLE - FEM.FEM_INTG_CALENDAR_MAP
TABLE - FEM.FEM_INTG_COA_GVSC_MAP
TABLE - FEM.FEM_INTG_DELTA_LOADS
TABLE - FEM.FEM_INTG_DIM_RULES
TABLE - FEM.FEM_INTG_DIM_RULE_DEFS
TABLE - FEM.FEM_INTG_ENC_TYPE_DS
TABLE - FEM.FEM_INTG_HIER_DEF_SEGS
TABLE - FEM.FEM_INTG_HIER_RULES
TABLE - FEM.FEM_INTG_OGL_CCID_MAP
TABLE - FEM.FEM_LD_CAL_PERIODS_GT
TABLE - FEM.FEM_LD_DIM_REQUESTS_GT
TABLE - FEM.FEM_LD_HIER_REQUESTS_GT
TABLE - FEM.FEM_LD_INTERFACE_DATA_GT
TABLE - FEM.FEM_OBJECT_CATALOG_TL
TABLE - FEM.FEM_OBJECT_DEFINITION_TL
TABLE - FEM.FEM_SOURCE_DATA_INTERIM_GT
TABLE - FEM.FEM_TABLES_TL
TABLE - FEM.FEM_TAB_COLUMNS_GT
TABLE - FEM.FEM_TAB_COLUMNS_TL
TABLE - FEM.FEM_TAB_INDX_INFO_GT
TABLE - FEM.FEM_TAB_INFO_GT
VIEW - APPS.FEM_INTG_BAL_RULE_BSVS_V

Table: FEM_ACTIVITIES

Description: Activity Members
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
FEM_ACTIVITIES_PK UNIQUE APPS_TS_TX_IDX ACTIVITY_ID
FEM_ACTIVITIES_U1 UNIQUE APPS_TS_TX_IDX LOCAL_VS_COMBO_ID
ACTIVITY_DISPLAY_CODE
Columns
Name Datatype Length Mandatory Comments
ACTIVITY_ID NUMBER
Y Activity Identifier
ACTIVITY_DISPLAY_CODE VARCHAR2 (2000) Y Activity Display Code
SUMMARY_FLAG VARCHAR2 (1) Y Summary Flag
START_DATE_ACTIVE DATE

Start Date Active
END_DATE_ACTIVE DATE

End Date Active
ACTIVITY_STRUCTURE_ID NUMBER (38) Y Activity Structure Identifier
LOCAL_VS_COMBO_ID NUMBER (9) Y Local Value Set Combination Identifier
TASK_ID NUMBER
Y Task dimension member identifier
COMPANY_COST_CENTER_ORG_ID NUMBER

Company Cost Center Organization dimension member identifier
CUSTOMER_ID NUMBER

Customer Identifier
CHANNEL_ID NUMBER

Channel Identifier
PRODUCT_ID NUMBER

Product Identifier
PROJECT_ID NUMBER

Project Identifier
USER_DIM1_ID NUMBER

User Dimension1 Identifier
USER_DIM2_ID NUMBER

User Dimension2 Identifier
USER_DIM3_ID NUMBER

User Dimension3 Identifier
USER_DIM4_ID NUMBER

User Dimension4 Identifier
USER_DIM5_ID NUMBER

User Dimension5 Identifier
USER_DIM6_ID NUMBER

User Dimension6 Identifier
USER_DIM7_ID NUMBER

User Dimension7 Identifier
USER_DIM8_ID NUMBER

User Dimension8 Identifier
USER_DIM9_ID NUMBER

User Dimension9 Identifier
USER_DIM10_ID NUMBER

User Dimension10 Identifier
SEGMENT1 VARCHAR2 (60)
Segment1
SEGMENT2 VARCHAR2 (60)
Segment2
SEGMENT3 VARCHAR2 (60)
Segment3
SEGMENT4 VARCHAR2 (60)
Segment4
SEGMENT5 VARCHAR2 (60)
Segment5
SEGMENT6 VARCHAR2 (60)
Segment6
SEGMENT7 VARCHAR2 (60)
Segment7
SEGMENT8 VARCHAR2 (60)
Segment8
SEGMENT9 VARCHAR2 (60)
Segment9
SEGMENT10 VARCHAR2 (60)
Segment10
SEGMENT11 VARCHAR2 (60)
Segment11
SEGMENT12 VARCHAR2 (60)
Segment12
SEGMENT13 VARCHAR2 (60)
Segment13
SEGMENT14 VARCHAR2 (60)
Segment14
SEGMENT15 VARCHAR2 (60)
Segment15
SEGMENT16 VARCHAR2 (60)
Segment16
SEGMENT17 VARCHAR2 (60)
Segment17
SEGMENT18 VARCHAR2 (60)
Segment18
SEGMENT19 VARCHAR2 (60)
Segment19
SEGMENT20 VARCHAR2 (60)
Segment20
SEGMENT21 VARCHAR2 (60)
Segment21
SEGMENT22 VARCHAR2 (60)
Segment22
SEGMENT23 VARCHAR2 (60)
Segment23
SEGMENT24 VARCHAR2 (60)
Segment24
SEGMENT25 VARCHAR2 (60)
Segment25
SEGMENT26 VARCHAR2 (60)
Segment26
SEGMENT27 VARCHAR2 (60)
Segment27
SEGMENT28 VARCHAR2 (60)
Segment28
SEGMENT29 VARCHAR2 (60)
Segment29
SEGMENT30 VARCHAR2 (60)
Segment30
CREATION_DATE DATE
Y Identifies the date on which the data was created
CREATED_BY NUMBER (15) Y Identifies the user that created the data
LAST_UPDATED_BY NUMBER (15) Y Identifies the user that last updated the data
LAST_UPDATE_DATE DATE
Y Identifies the data on which the data was last updated
LAST_UPDATE_LOGIN NUMBER (15)
Identifies the login user that last updated the data
ENABLED_FLAG VARCHAR2 (1) Y Designates whether or not the member is enabled. A N designates that the member has been logically deleted
PERSONAL_FLAG VARCHAR2 (1) Y Designates whether or not the dimension member is a personal member only available to the Created By user
OBJECT_VERSION_NUMBER NUMBER
Y Framework required column for stale data detection
READ_ONLY_FLAG VARCHAR2 (1) Y

[top of page]

FEM.FEM_ACTIVITIES does not reference any database object

FEM.FEM_ACTIVITIES is referenced by following:

APPS
SYNONYM - FEM_ACTIVITIES

[top of page]

Table: FEM_ACTIVITIES_HIER

Description: Activity Hierarchies
Comments

Activity Hierarchy Details

Indexes
Index Type Tablespace Column
FEM_ACTIVITIES_HIER_PK UNIQUE APPS_TS_TX_IDX HIERARCHY_OBJ_DEF_ID
PARENT_ID
CHILD_ID
FEM_ACTIVITIES_HIER_N1 NONUNIQUE APPS_TS_TX_IDX HIERARCHY_OBJ_DEF_ID
CHILD_ID
Columns
Name Datatype Length Mandatory Comments
HIERARCHY_OBJ_DEF_ID NUMBER (9) Y Hierarchy Object Definition Identifier
PARENT_DEPTH_NUM NUMBER
Y Distance of the parent member from the top of the hierarchy
PARENT_ID NUMBER
Y Identifier of the parent dimension member
CHILD_DEPTH_NUM NUMBER
Y Distance of the child member from the top of the hierarchy
CHILD_ID NUMBER
Y Identifier of the child dimension member
SINGLE_DEPTH_FLAG VARCHAR2 (1) Y Single Depth Flag for designating if there is only one depth separating the parent member from the child member
DISPLAY_ORDER_NUM NUMBER
Y Display order number within the hierarchy for the parent child relationship
WEIGHTING_PCT NUMBER (3)
Weighting Percentage designating the relative weight assigned to the child from the parent
CREATION_DATE DATE
Y Identifies the date on which the row was created
CREATED_BY NUMBER (15) Y Identifies the user that created the row
LAST_UPDATED_BY NUMBER (15) Y Identifies the user that last modified the row
LAST_UPDATE_DATE DATE
Y Identifies the date on which the row was last modified
LAST_UPDATE_LOGIN NUMBER (15)
Identifies the login user that last modified the row
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number for stale data detection
READ_ONLY_FLAG VARCHAR2 (1)
A Y designates that the row is read only and cannot be changed by users

[top of page]

FEM.FEM_ACTIVITIES_HIER does not reference any database object

FEM.FEM_ACTIVITIES_HIER is referenced by following:

APPS
SYNONYM - FEM_ACTIVITIES_HIER

[top of page]

Table: FEM_ALLOC_BR_COND_SUM_GT

Description: Stores condition descriptive information displayed by the Condition Summary pluggable region
Comments
Stores condition descriptive information displayed by the Condition Summary pluggable region
Columns
Name Datatype Length Mandatory Comments
CONDITION_OBJ_DEF_ID NUMBER (9) Y Identifies the object definition for the condition
TABLE_DISPLAY_NAME VARCHAR2 (150) Y Translatable table for the condition component
COLUMN_DISPLAY_NAME VARCHAR2 (150) Y Translatable column name for the condition component
CONDITION_TYPE VARCHAR2 (80) Y Designates the type of condition component
HIER_ATTR_DISPLAY_NAME VARCHAR2 (150)
If the condition component is a hierarchy, this column stores the translatable column name; If it is an attribute component, it stores the translatable attribute name
CONDITION_VALUE VARCHAR2 (1000) Y Stores the actual condition value for each component of the condition
COND_VALUE_ATTR_DATA_TYPE VARCHAR2 (30)

[top of page]

FEM.FEM_ALLOC_BR_COND_SUM_GT does not reference any database object

FEM.FEM_ALLOC_BR_COND_SUM_GT is referenced by following:

APPS
SYNONYM - FEM_ALLOC_BR_COND_SUM_GT

[top of page]

Table: FEM_ALLOC_BR_FCTR_SUM_GT

Description: Stores Factor Table descriptive information displayed by the Factor Table Details pluggable region
Comments
Stores Factor Table descriptive information displayed by the Factor Table Details pluggable region
Columns
Name Datatype Length Mandatory Comments
FACTOR_OBJ_DEF_ID NUMBER (9) Y Identifies the object definition for the Factor Table Rule
MATCHING_DIMENSION_NAME VARCHAR2 (150) Y Translatable name for the matching dimension
HIERARCHY_NAME VARCHAR2 (150)
Translatable name for the hierarchy
DIMENSION_GROUP_NAME VARCHAR2 (150)
Translable name from the hierarchy level
HIER_RELATION_DESC VARCHAR2 (150)
Translatable text that describes how the factor table uses the hierarchy level

[top of page]

FEM.FEM_ALLOC_BR_FCTR_SUM_GT does not reference any database object

FEM.FEM_ALLOC_BR_FCTR_SUM_GT is referenced by following:

APPS
SYNONYM - FEM_ALLOC_BR_FCTR_SUM_GT

[top of page]

Table: FEM_BR_DISABLED_MBRS_GT

Description: Disabled dimension members referenced by a business rule
Comments
Disabled dimension members referenced by a business rule
Indexes
Index Type Tablespace Column
FEM_BR_DISABLED_MBRS_GT_U1 UNIQUE OBJECT_DEFINITION_ID
CONTEXT_CODE
DIMENSION_ID
DIMENSION_MEMBER
VALUE_SET_ID
Columns
Name Datatype Length Mandatory Comments
OBJECT_DEFINITION_ID NUMBER (9) Y Object definition ID
CONTEXT_CODE VARCHAR2 (30) Y Provides the context as to where within the business rule is the disabled dimension member referenced
DIMENSION_ID NUMBER (9)
Dimension ID
DIMENSION_MEMBER VARCHAR2 (40)
Dimension member ID or code
VALUE_SET_ID NUMBER

Value set ID

[top of page]

FEM.FEM_BR_DISABLED_MBRS_GT does not reference any database object

FEM.FEM_BR_DISABLED_MBRS_GT is referenced by following:

APPS
SYNONYM - FEM_BR_DISABLED_MBRS_GT

[top of page]

Table: FEM_BR_ROOT_RULES_GT

Description: Root business rules to be checked for disabled dimension members
Comments
Root business rules to be checked for disabled dimension members
Indexes
Index Type Tablespace Column
FEM_BR_ROOT_RULES_GT_U1 UNIQUE OBJECT_DEFINITION_ID
Columns
Name Datatype Length Mandatory Comments
OBJECT_DEFINITION_ID NUMBER (9) Y Object definition ID for the root rule

[top of page]

FEM.FEM_BR_ROOT_RULES_GT does not reference any database object

FEM.FEM_BR_ROOT_RULES_GT is referenced by following:

APPS
SYNONYM - FEM_BR_ROOT_RULES_GT

[top of page]

Table: FEM_BR_VALID_STATUS_GT

Description: Shows whether or not a business rule contains references to disabled dimension members
Comments
Shows whether or not a business rule contains references to disabled dimension members
Indexes
Index Type Tablespace Column
FEM_BR_VALID_STATUS_GT_U1 UNIQUE OBJECT_DEFINITION_ID
Columns
Name Datatype Length Mandatory Comments
OBJECT_DEFINITION_ID NUMBER (9) Y Object definition ID
VALID_FLAG VARCHAR2 (1) Y Flag if the rule is valid (Y) or not (N)

[top of page]

FEM.FEM_BR_VALID_STATUS_GT does not reference any database object

FEM.FEM_BR_VALID_STATUS_GT is referenced by following:

APPS
SYNONYM - FEM_BR_VALID_STATUS_GT

[top of page]

Table: FEM_COLUMN_REQUIREMNT_TL

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_COLUMN_REQUIREMNT_TL_1 UNIQUE APPS_TS_SEED SYS_NC00011$
LANGUAGE
FEM_COLUMN_REQUIREMNT_TL_PK UNIQUE APPS_TS_SEED COLUMN_NAME
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
LANGUAGE VARCHAR2 (4) Y
COLUMN_NAME VARCHAR2 (30) Y
SOURCE_LANG VARCHAR2 (4) Y
DISPLAY_NAME VARCHAR2 (150) Y
DESCRIPTION VARCHAR2 (255) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER

[top of page]

FEM.FEM_COLUMN_REQUIREMNT_TL does not reference any database object

FEM.FEM_COLUMN_REQUIREMNT_TL is referenced by following:

APPS
SYNONYM - FEM_COLUMN_REQUIREMNT_TL

[top of page]

Table: FEM_COST_OBJECTS

Description: Cost Object Members
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
FEM_COST_OBJECTS_PK UNIQUE APPS_TS_TX_IDX COST_OBJECT_ID
FEM_COST_OBJECTS_U1 UNIQUE APPS_TS_TX_IDX LOCAL_VS_COMBO_ID
COST_OBJECT_DISPLAY_CODE
Columns
Name Datatype Length Mandatory Comments
COST_OBJECT_ID NUMBER
Y Cost Object Identifier
COST_OBJECT_DISPLAY_CODE VARCHAR2 (2000) Y Cost Object Display Code
SUMMARY_FLAG VARCHAR2 (1) Y Summary Flag
START_DATE_ACTIVE DATE

Start Date Active
END_DATE_ACTIVE DATE

End Date Active
COST_OBJECT_STRUCTURE_ID NUMBER (38) Y Cost Object Structure definining column
LOCAL_VS_COMBO_ID NUMBER (9)
Local Value Set Combination Identifier
UOM_CODE VARCHAR2 (30)
FINANCIAL_ELEM_ID NUMBER
Y Financial Element Identifier
LEDGER_ID NUMBER
Y Ledger Identifier
PRODUCT_ID NUMBER

Product Identifier
COMPANY_COST_CENTER_ORG_ID NUMBER

Company Cost Center Organization dimension member identifier
CUSTOMER_ID NUMBER

Customer Identifier
CHANNEL_ID NUMBER

Channel Identifier
PROJECT_ID NUMBER

Project Identifier
USER_DIM1_ID NUMBER

User Dimension1 Identifier
USER_DIM2_ID NUMBER

User Dimension2 Identifier
USER_DIM3_ID NUMBER

User Dimension3 Identifier
USER_DIM4_ID NUMBER

User Dimension4 Identifier
USER_DIM5_ID NUMBER

User Dimension5 Identifier
USER_DIM6_ID NUMBER

User Dimension6 Identifier
USER_DIM7_ID NUMBER

User Dimension7 Identifier
USER_DIM8_ID NUMBER

User Dimension8 Identifier
USER_DIM9_ID NUMBER

User Dimension9 Identifier
USER_DIM10_ID NUMBER

User Dimension10 Identifier
SEGMENT1 VARCHAR2 (60)
Composite Segment stores the Financial Element display code
SEGMENT2 VARCHAR2 (60)
Composite Segment stores the Ledger display code
SEGMENT3 VARCHAR2 (60)
Composite Segment stores the Product display code
SEGMENT4 VARCHAR2 (60)
Composite Segment stores the Company Cost Center Organization display code
SEGMENT5 VARCHAR2 (60)
Composite Segment stores the Customer display code
SEGMENT6 VARCHAR2 (60)
Composite Segment stores the Channel display code
SEGMENT7 VARCHAR2 (60)
Composite Segment stores the Project display code
SEGMENT8 VARCHAR2 (60)
Composite Segment stores the User Dimension1 display code
SEGMENT9 VARCHAR2 (60)
Composite Segment stores the User Dimension2 display code
SEGMENT10 VARCHAR2 (60)
Composite Segment stores the User Dimension3 display code
SEGMENT11 VARCHAR2 (60)
Composite Segment stores the User Dimension4 display code
SEGMENT12 VARCHAR2 (60)
Composite Segment stores the User Dimension5 display code
SEGMENT13 VARCHAR2 (60)
Composite Segment stores the User Dimension6 display code
SEGMENT14 VARCHAR2 (60)
Composite Segment stores the User Dimension7 display code
SEGMENT15 VARCHAR2 (60)
Composite Segment stores the User Dimension8 display code
SEGMENT16 VARCHAR2 (60)
Composite Segment stores the User Dimension9 display code
SEGMENT17 VARCHAR2 (60)
Composite Segment stores the User Dimension10 display code
SEGMENT18 VARCHAR2 (60)
Composite Segment available for future use
SEGMENT19 VARCHAR2 (60)
Composite Segment available for future use
SEGMENT20 VARCHAR2 (60)
Composite Segment available for future use
SEGMENT21 VARCHAR2 (60)
Composite Segment available for future use
SEGMENT22 VARCHAR2 (60)
Composite Segment available for future use
SEGMENT23 VARCHAR2 (60)
Composite Segment available for future use
SEGMENT24 VARCHAR2 (60)
Composite Segment available for future use
SEGMENT25 VARCHAR2 (60)
Composite Segment available for future use
SEGMENT26 VARCHAR2 (60)
Composite Segment available for future use
SEGMENT27 VARCHAR2 (60)
Composite Segment available for future use
SEGMENT28 VARCHAR2 (60)
Composite Segment available for future use
SEGMENT29 VARCHAR2 (60)
Composite Segment available for future use
SEGMENT30 VARCHAR2 (60)
Composite Segment available for future use
CREATION_DATE DATE

Identifies the date on which the data was created
CREATED_BY NUMBER (15)
Identifies the user that created the data
LAST_UPDATED_BY NUMBER (15)
Identifies the user that last updated the data
LAST_UPDATE_DATE DATE

Identifies the data on which the data was last updated
LAST_UPDATE_LOGIN NUMBER (15)
Identifies the login user that last updated the data
OBJECT_VERSION_NUMBER NUMBER
Y Framework required column for stale data detection
ENABLED_FLAG VARCHAR2 (1) Y Designates whether or not the member is enabled. A N designates that the member has been logically deleted
PERSONAL_FLAG VARCHAR2 (1) Y Designates whether or not the dimension member is a personal member only available to the Created By user
READ_ONLY_FLAG VARCHAR2 (1) Y

[top of page]

FEM.FEM_COST_OBJECTS does not reference any database object

FEM.FEM_COST_OBJECTS is referenced by following:

APPS
SYNONYM - FEM_COST_OBJECTS

[top of page]

Table: FEM_COST_OBJECTS_HIER

Description: Cost Objects Hierarchies
Comments

Cost Object Hierarchy Details

Indexes
Index Type Tablespace Column
FEM_COST_OBJECTS_HIER_PK UNIQUE APPS_TS_TX_IDX RELATIONSHIP_ID
EFFECTIVE_START_DATE
FEM_COST_OBJECTS_HIER_U1 UNIQUE APPS_TS_TX_IDX HIERARCHY_OBJ_ID
PARENT_ID
CHILD_ID
CHILD_SEQUENCE_NUM
EFFECTIVE_START_DATE
FEM_COST_OBJECTS_HIER_N1 NONUNIQUE APPS_TS_TX_IDX HIERARCHY_OBJ_ID
CHILD_ID
CHILD_SEQUENCE_NUM
Columns
Name Datatype Length Mandatory Comments
RELATIONSHIP_ID NUMBER (9) Y Unique identifier for a parent-child relationship between Cost Objects
EFFECTIVE_START_DATE DATE
Y The first day of the time period during which this parent-child relationship is effective/applicable
HIERARCHY_OBJ_ID NUMBER (9) Y Identifies the Bill Container
PARENT_ID NUMBER
Y Identifier of the parent dimension member
CHILD_ID NUMBER
Y Identifier of the child dimension member
CHILD_SEQUENCE_NUM NUMBER (9)
Since it is possible for duplicate parent/child relationships to exist in the same hierarchy, it is necessary to employ CHILD_SEQUENCE_NUM as an additional portion of the logical key. This number need only be unique within a given hierarchy/parent/child combination.
DISPLAY_ORDER_NUM NUMBER
Y Designates the relative order that the child is displayed on the user-interface. The order is relative to the immediate parent of the child. This means that all children of the same parent are displayed in the order indicated by DISPLAY_ORDER_NUM.\
EFFECTIVE_END_DATE DATE
Y Date on which the parent-child relationship expires
BOM_REFERENCE VARCHAR2 (30)
Bill of Materials reference information from the source system
CREATION_DATE DATE
Y Identifies the date on which the row was created
CREATED_BY NUMBER (15) Y Identifies the user that created the row
LAST_UPDATED_BY NUMBER (15) Y Identifies the user that last modified the row
LAST_UPDATE_DATE DATE
Y Identifies the date on which the row was last modified
LAST_UPDATE_LOGIN NUMBER (15)
Identifies the login user that last modified the row
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number for stale data detection

[top of page]

FEM.FEM_COST_OBJECTS_HIER does not reference any database object

FEM.FEM_COST_OBJECTS_HIER is referenced by following:

APPS
SYNONYM - FEM_COST_OBJECTS_HIER

[top of page]

Table: FEM_COST_OBJ_HIER_QTY

Description: Consumption quantities of the Cost Object Hierarchies
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
FEM_COST_OBJ_HIER_QTY_PK UNIQUE APPS_TS_TX_IDX RELATIONSHIP_ID
DATASET_CODE
CAL_PERIOD_ID
Columns
Name Datatype Length Mandatory Comments
RELATIONSHIP_ID NUMBER
Y Unique identifier for a parent-child relationship between Cost Objects
DATASET_CODE NUMBER
Y Dataset for the consumption quantity
CAL_PERIOD_ID NUMBER
Y Foreign key to the Calendar Period dimension
CHILD_QTY NUMBER
Y Indicates thenecessary child quantities with respect to the parent quantity
PARENT_QTY NUMBER
Y Indicates the parent quantity to use when calculating the consumption quantity
YIELD_PERCENTAGE NUMBER
Y Yield percentage
CREATION_DATE DATE
Y Identifies the date on which the row was created
CREATED_BY NUMBER (15) Y Identifies the user that created the row
LAST_UPDATED_BY NUMBER (15) Y Identifies the user that last modified the row
LAST_UPDATE_DATE DATE
Y Identifies the date on which the row was last modified
LAST_UPDATE_LOGIN NUMBER (15)
Identifies the login user that last modified the row
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number for stale data detection

[top of page]

FEM.FEM_COST_OBJ_HIER_QTY does not reference any database object

FEM.FEM_COST_OBJ_HIER_QTY is referenced by following:

APPS
SYNONYM - FEM_COST_OBJ_HIER_QTY

[top of page]

Table: FEM_DB_LINKS_TL

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_DB_LINKS_TL_1 UNIQUE APPS_TS_TX_IDX SYS_NC00011$
LANGUAGE
FEM_DB_LINKS_TL_PK UNIQUE APPS_TS_TX_IDX DATABASE_LINK
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
DATABASE_LINK VARCHAR2 (40) Y
DB_LINK_NAME VARCHAR2 (150)
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
DESCRIPTION VARCHAR2 (255)
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

FEM.FEM_DB_LINKS_TL does not reference any database object

FEM.FEM_DB_LINKS_TL is referenced by following:

APPS
SYNONYM - FEM_DB_LINKS_TL

[top of page]

Table: FEM_FOLDERS_TL

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_FOLDERS_TL_PK UNIQUE APPS_TS_TX_IDX FOLDER_ID
LANGUAGE
FEM_FOLDERS_TL_UK1 UNIQUE APPS_TS_TX_IDX SYS_NC00011$
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
FOLDER_ID NUMBER (9) Y
FOLDER_NAME VARCHAR2 (150) Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
DESCRIPTION VARCHAR2 (255)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

FEM.FEM_FOLDERS_TL does not reference any database object

FEM.FEM_FOLDERS_TL is referenced by following:

APPS
SYNONYM - FEM_FOLDERS_TL

[top of page]

Table: FEM_INTG_AOL_VALSET_MAP

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_INTG_AOL_VALSET_MAP_U1 NONUNIQUE APPS_TS_TX_IDX SEGMENT1_VALUE_SET_ID
SEGMENT2_VALUE_SET_ID
SEGMENT3_VALUE_SET_ID
SEGMENT4_VALUE_SET_ID
SEGMENT5_VALUE_SET_ID
FEM_VALUE_SET_ID
Columns
Name Datatype Length Mandatory Comments
DIMENSION_ID NUMBER (9) Y Dimension identifier
SEGMENT1_VALUE_SET_ID NUMBER (10) Y Accounting key flexfield segment value set identifier
FEM_VALUE_SET_ID NUMBER
Y FEM value set identifier
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
SEGMENT2_VALUE_SET_ID NUMBER (10)
Accounting key flexfield segment value set identifier
SEGMENT3_VALUE_SET_ID NUMBER (10)
Accounting key flexfield segment value set identifier
SEGMENT4_VALUE_SET_ID NUMBER (10)
Accounting key flexfield segment value set identifier
SEGMENT5_VALUE_SET_ID NUMBER (10)
Accounting key flexfield segment value set identifier

[top of page]

FEM.FEM_INTG_AOL_VALSET_MAP does not reference any database object

FEM.FEM_INTG_AOL_VALSET_MAP is referenced by following:

APPS
SYNONYM - FEM_INTG_AOL_VALSET_MAP

[top of page]

Table: FEM_INTG_BAL_DEF_BSVS

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_INTG_BAL_DEF_BSVS_U1 UNIQUE APPS_TS_TX_IDX BAL_RULE_OBJ_DEF_ID
BALANCE_SEG_VALUE
Columns
Name Datatype Length Mandatory Comments
BAL_RULE_OBJ_DEF_ID NUMBER (9) Y Balances Rule object version identifier
BALANCE_SEG_VALUE VARCHAR2 (150) Y Balance Segment Value
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number for OA Framework Use
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

FEM.FEM_INTG_BAL_DEF_BSVS does not reference any database object

FEM.FEM_INTG_BAL_DEF_BSVS is referenced by following:

APPS
SYNONYM - FEM_INTG_BAL_DEF_BSVS

[top of page]

Table: FEM_INTG_BAL_DEF_BUDGTS

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_INTG_BAL_DEF_BUDGTS_U1 UNIQUE APPS_TS_TX_IDX BAL_RULE_OBJ_DEF_ID
BUDGET_ID
Columns
Name Datatype Length Mandatory Comments
BAL_RULE_OBJ_DEF_ID NUMBER (9) Y Balances Rule object version defining column
BUDGET_ID NUMBER
Y Budget version identifier
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number for OA Framework Use
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

FEM.FEM_INTG_BAL_DEF_BUDGTS does not reference any database object

FEM.FEM_INTG_BAL_DEF_BUDGTS is referenced by following:

APPS
SYNONYM - FEM_INTG_BAL_DEF_BUDGTS

[top of page]

Table: FEM_INTG_BAL_DEF_CURRS

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_INTG_BAL_DEF_CURRS_U1 UNIQUE APPS_TS_TX_IDX BAL_RULE_OBJ_DEF_ID
XLATED_CURRENCY_CODE
Columns
Name Datatype Length Mandatory Comments
BAL_RULE_OBJ_DEF_ID NUMBER (9) Y Balances Rule object version identifier
XLATED_CURRENCY_CODE VARCHAR2 (15) Y Currency code
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number for OA Framework Use
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

FEM.FEM_INTG_BAL_DEF_CURRS does not reference any database object

FEM.FEM_INTG_BAL_DEF_CURRS is referenced by following:

APPS
SYNONYM - FEM_INTG_BAL_DEF_CURRS

[top of page]

Table: FEM_INTG_BAL_DEF_ENCS

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_INTG_BAL_DEF_ENCS_U1 UNIQUE APPS_TS_TX_IDX BAL_RULE_OBJ_DEF_ID
ENCUMBRANCE_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
BAL_RULE_OBJ_DEF_ID NUMBER (9) Y Balances Rule object version identifier
ENCUMBRANCE_TYPE_ID NUMBER
Y Encumbrance type identifier
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number for OA Framework Use
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

FEM.FEM_INTG_BAL_DEF_ENCS does not reference any database object

FEM.FEM_INTG_BAL_DEF_ENCS is referenced by following:

APPS
SYNONYM - FEM_INTG_BAL_DEF_ENCS

[top of page]

Table: FEM_INTG_BAL_RULES

Description:
Comments
Primary Key: FEM_INTG_BAL_RULES_U1
  1. BAL_RULE_OBJ_ID
Indexes
Index Type Tablespace Column
FEM_INTG_BAL_RULES_U1 UNIQUE APPS_TS_TX_IDX BAL_RULE_OBJ_ID
FEM_INTG_BAL_RULES_N1 NONUNIQUE APPS_TS_TX_IDX LEDGER_ID
Columns
Name Datatype Length Mandatory Comments
BAL_RULE_OBJ_ID NUMBER (9) Y Balances Rule object identifier
LEDGER_ID NUMBER
Y Accounting books identifier
CHART_OF_ACCOUNTS_ID NUMBER (15) Y Source Accounting key flexfield structure identifier
BAL_SEG_COLUMN_NAME VARCHAR2 (30) Y Balance Segment Name
DS_BAL_TYPE_CODE VARCHAR2 (30) Y Balance Type
MAINTAIN_QTD_FLAG VARCHAR2 (1) Y Maintain quarter-to-date amounts flag
INCLUDE_AVG_BAL_FLAG VARCHAR2 (1) Y Include Average Balance Flag
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number for OA Framework Use
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

FEM.FEM_INTG_BAL_RULES does not reference any database object

FEM.FEM_INTG_BAL_RULES is referenced by following:

APPS
SYNONYM - FEM_INTG_BAL_RULES

[top of page]

Table: FEM_INTG_BAL_RULE_DEFS

Description:
Comments
Primary Key: FEM_INTG_BAL_RULE_DEFS_U1
  1. BAL_RULE_OBJ_DEF_ID
Indexes
Index Type Tablespace Column
FEM_INTG_BAL_RULE_DEFS_U1 UNIQUE APPS_TS_TX_IDX BAL_RULE_OBJ_DEF_ID
Columns
Name Datatype Length Mandatory Comments
BAL_RULE_OBJ_DEF_ID NUMBER (9) Y Balances Rule object version identifier
LOAD_METHOD_CODE VARCHAR2 (30) Y Execution Mode
BAL_SEG_VALUE_OPTION_CODE VARCHAR2 (30) Y Balance Segment Value options
CURRENCY_OPTION_CODE VARCHAR2 (30) Y Currency Options
XLATED_BAL_OPTION_CODE VARCHAR2 (30) Y Translated Balance Options
ACTUAL_OUTPUT_DATASET_CODE NUMBER

Output Dataset identifier
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number for OA Framework Use
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

FEM.FEM_INTG_BAL_RULE_DEFS does not reference any database object

FEM.FEM_INTG_BAL_RULE_DEFS is referenced by following:

APPS
SYNONYM - FEM_INTG_BAL_RULE_DEFS

[top of page]

Table: FEM_INTG_BPI_CURR_GT

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_INTG_BPI_CURR_GT_N1 NONUNIQUE DATASET_CODE
CAL_PERIOD_ID
CODE_COMBINATION_ID
FINANCIAL_ELEM_ID
Columns
Name Datatype Length Mandatory Comments
DATASET_CODE NUMBER
Y Dataset code
CAL_PERIOD_ID NUMBER
Y Calendar Period Identifier
CODE_COMBINATION_ID NUMBER

Code combination Identifier from General Ledger
FINANCIAL_ELEM_ID NUMBER

Financial Element Identifier
DELTA_RUN_ID NUMBER

Incremental Run Identifier from General Ledger
XTD_BALANCE_F_SUM NUMBER

Aggregated Periodic Balance
QTD_BALANCE_F_SUM NUMBER

Aggregated Quarterly Balance
YTD_BALANCE_F_SUM NUMBER

Aggregated Yearly Balance

[top of page]

FEM.FEM_INTG_BPI_CURR_GT does not reference any database object

FEM.FEM_INTG_BPI_CURR_GT is referenced by following:

APPS
SYNONYM - FEM_INTG_BPI_CURR_GT

[top of page]

Table: FEM_INTG_BUDGT_DS

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_INTG_BUDGT_DS_U1 UNIQUE APPS_TS_TX_IDX BUDGET_ID
Columns
Name Datatype Length Mandatory Comments
BUDGET_ID NUMBER
Y Budget version identifier
OUTPUT_DATASET_CODE NUMBER
Y Output Dataset identifier
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number for OA Framework Use
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

FEM.FEM_INTG_BUDGT_DS does not reference any database object

FEM.FEM_INTG_BUDGT_DS is referenced by following:

APPS
SYNONYM - FEM_INTG_BUDGT_DS

[top of page]

Table: FEM_INTG_CALENDAR_MAP

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_INTG_CALENDAR_MAP_U1 NONUNIQUE APPS_TS_TX_IDX PERIOD_SET_NAME
PERIOD_TYPE
Columns
Name Datatype Length Mandatory Comments
PERIOD_SET_NAME VARCHAR2 (15) Y Accounting calendar name
PERIOD_TYPE VARCHAR2 (15) Y Accounting period type name
CAL_PER_HIER_OBJ_DEF_ID NUMBER (9) Y Calendar Period hierarchy identifier
DIMENSION_GROUP_ID NUMBER (9) Y Dimension group identifier
CALENDAR_ID NUMBER (5) Y Calendar identifier
EFFECTIVE_PERIOD_NUM_MIN NUMBER (15)
Denormalized minimum processed period number (period_year*10000 + period_num)
EFFECTIVE_PERIOD_NUM_MAX NUMBER (15)
Denormalized maximum processed period number (period_year*10000 + period_num)
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column

[top of page]

FEM.FEM_INTG_CALENDAR_MAP does not reference any database object

FEM.FEM_INTG_CALENDAR_MAP is referenced by following:

APPS
SYNONYM - FEM_INTG_CALENDAR_MAP

[top of page]

Table: FEM_INTG_COA_GVSC_MAP

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_INTG_COA_GVSC_MAP_U1 NONUNIQUE APPS_TS_TX_IDX CHART_OF_ACCOUNTS_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Columns
Name Datatype Length Mandatory Comments
CHART_OF_ACCOUNTS_ID NUMBER (15) Y Accounting key flexfield structure identifier
EFFECTIVE_START_DATE DATE
Y Effective start date of the relationship between chart of accounts and global value set combination
EFFECTIVE_END_DATE DATE
Y Effective end date of the relationship between chart of accounts and global value set combination
GLOBAL_VS_COMBO_ID NUMBER (9) Y Global value set combination identifier
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

FEM.FEM_INTG_COA_GVSC_MAP does not reference any database object

FEM.FEM_INTG_COA_GVSC_MAP is referenced by following:

APPS
SYNONYM - FEM_INTG_COA_GVSC_MAP

[top of page]

Table: FEM_INTG_DELTA_LOADS

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_INTG_DELTA_LOADS_U1 UNIQUE APPS_TS_TX_IDX LEDGER_ID
DATASET_CODE
CAL_PERIOD_ID
DELTA_RUN_ID
BALANCE_SEG_VALUE
LOADED_FLAG
Columns
Name Datatype Length Mandatory Comments
LEDGER_ID NUMBER
Y Ledger identifier
DATASET_CODE NUMBER
Y Dataset identifier
CAL_PERIOD_ID NUMBER
Y Period identifier
DELTA_RUN_ID NUMBER (15) Y Delta Run identifier
LOADED_FLAG VARCHAR2 (1) Y Flag indicating if the delta run ID has been loaded
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
BALANCE_SEG_VALUE VARCHAR2 (150) Y Balancing segment value

[top of page]

FEM.FEM_INTG_DELTA_LOADS does not reference any database object

FEM.FEM_INTG_DELTA_LOADS is referenced by following:

APPS
SYNONYM - FEM_INTG_DELTA_LOADS

[top of page]

Table: FEM_INTG_DIM_RULES

Description:
Comments
Primary Key: FEM_INTG_DIM_RULES_U1
  1. DIM_RULE_OBJ_ID
Indexes
Index Type Tablespace Column
FEM_INTG_DIM_RULES_U1 UNIQUE APPS_TS_TX_IDX DIM_RULE_OBJ_ID
FEM_INTG_DIM_RULES_N1 NONUNIQUE APPS_TS_TX_IDX CHART_OF_ACCOUNTS_ID
Columns
Name Datatype Length Mandatory Comments
DIM_RULE_OBJ_ID NUMBER (9) Y Dimension rule object identifier
CHART_OF_ACCOUNTS_ID NUMBER (15) Y Source Accounting key flexfield structure identifier
DIMENSION_ID NUMBER (9) Y Target Dimension identifier
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number for OA Framework use
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

FEM.FEM_INTG_DIM_RULES does not reference any database object

FEM.FEM_INTG_DIM_RULES is referenced by following:

APPS
SYNONYM - FEM_INTG_DIM_RULES

[top of page]

Table: FEM_INTG_DIM_RULE_DEFS

Description:
Comments
Primary Key: FEM_INTG_DIM_RULE_DEFS_U1
  1. DIM_RULE_OBJ_DEF_ID
Indexes
Index Type Tablespace Column
FEM_INTG_DIM_RULE_DEFS_U1 UNIQUE APPS_TS_TX_IDX DIM_RULE_OBJ_DEF_ID
Columns
Name Datatype Length Mandatory Comments
DIM_RULE_OBJ_DEF_ID NUMBER (9) Y Dimension rule object version identifier
DIM_MAPPING_OPTION_CODE VARCHAR2 (30) Y Dimension mapping option for the version
SEGMENT_COUNT NUMBER (9) Y Number of segments used in concatenation. This will be 0 for single value case, and 1 for single segment case.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number for OA Framework use
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
DEFAULT_MEMBER_ID NUMBER (9)
Default dimension member identifier
DEFAULT_MEMBER_VALUE_SET_ID NUMBER (9)
Used with default member ID, uniquely identifies the default member
APPLICATION_COLUMN_NAME1 VARCHAR2 (30)
First segment column name
APPLICATION_COLUMN_NAME2 VARCHAR2 (30)
Second segment column name
APPLICATION_COLUMN_NAME3 VARCHAR2 (30)
Third segment column name
APPLICATION_COLUMN_NAME4 VARCHAR2 (30)
Fourth segment column name
APPLICATION_COLUMN_NAME5 VARCHAR2 (30)
Fifth segment column name
FEM_VALUE_SET_ID NUMBER

FEM Value Set identifier that represents the value set this rule definition is associated with
MAX_CCID_PROCESSED NUMBER (15)
Identifier of the maximum GL Code Combination maintained by the rule definition
MAX_FLEX_VALUE_ID_PROCESSED NUMBER (15)
Identifier of the maximum segment value maintained by the rule definition

[top of page]

FEM.FEM_INTG_DIM_RULE_DEFS does not reference any database object

FEM.FEM_INTG_DIM_RULE_DEFS is referenced by following:

APPS
SYNONYM - FEM_INTG_DIM_RULE_DEFS

[top of page]

Table: FEM_INTG_ENC_TYPE_DS

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_INTG_ENC_TYPE_DS_U1 UNIQUE APPS_TS_TX_IDX ENCUMBRANCE_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
ENCUMBRANCE_TYPE_ID NUMBER
Y Encumbrance type identifier
OUTPUT_DATASET_CODE NUMBER
Y Output Dataset identifier
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number for OA Framework Use
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

FEM.FEM_INTG_ENC_TYPE_DS does not reference any database object

FEM.FEM_INTG_ENC_TYPE_DS is referenced by following:

APPS
SYNONYM - FEM_INTG_ENC_TYPE_DS

[top of page]

Table: FEM_INTG_HIER_DEF_SEGS

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_INTG_HIER_DEF_SEGS_U1 UNIQUE APPS_TS_TX_IDX HIER_RULE_OBJ_DEF_ID
DISPLAY_ORDER_NUM
FEM_INTG_HIER_DEF_SEGS_U2 UNIQUE APPS_TS_TX_IDX HIER_RULE_OBJ_DEF_ID
HIER_TRAVERSAL_SEQ_CODE
Columns
Name Datatype Length Mandatory Comments
HIER_RULE_OBJ_DEF_ID NUMBER (9) Y Hierarchy rule object definition identifier
DISPLAY_ORDER_NUM NUMBER (9) Y Display order number
APPLICATION_COLUMN_NAME VARCHAR2 (30) Y Segment column name
HIER_TRAVERSAL_SEQ_CODE VARCHAR2 (30) Y Hierarchy traversal sequence
TOP_PARENT_VALUE VARCHAR2 (150) Y Starting parent value
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number for OA Framework use
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
HIER_OBJ_DEF_ID NUMBER (9)
Hierarchy structure object definition identifier

[top of page]

FEM.FEM_INTG_HIER_DEF_SEGS does not reference any database object

FEM.FEM_INTG_HIER_DEF_SEGS is referenced by following:

APPS
SYNONYM - FEM_INTG_HIER_DEF_SEGS

[top of page]

Table: FEM_INTG_HIER_RULES

Description:
Comments
Primary Key: FEM_INTG_HIER_RULES_U1
  1. HIER_RULE_OBJ_ID
Indexes
Index Type Tablespace Column
FEM_INTG_HIER_RULES_U1 UNIQUE APPS_TS_TX_IDX HIER_RULE_OBJ_ID
FEM_INTG_HIER_RULES_N1 NONUNIQUE APPS_TS_TX_IDX DIM_RULE_OBJ_DEF_ID
Columns
Name Datatype Length Mandatory Comments
HIER_RULE_OBJ_ID NUMBER (9) Y Hierarchy rule object identifier
DIM_RULE_OBJ_DEF_ID NUMBER (9) Y Dimension rule object definition identifier
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number for OA Framework use
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
HIERARCHY_OBJ_ID NUMBER (9)
Hierarchy structure object identifier
FLATTEN_HIER_FLAG VARCHAR2 (1)
Flag indicating whether hierarchy should be flattened
SEQUENCE_ENFORCED_FLAG VARCHAR2 (1)
Flag indicating whether hierarchy should be created as sequence-enforced

[top of page]

FEM.FEM_INTG_HIER_RULES does not reference any database object

FEM.FEM_INTG_HIER_RULES is referenced by following:

APPS
SYNONYM - FEM_INTG_HIER_RULES

[top of page]

Table: FEM_INTG_OGL_CCID_MAP

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_INTG_OGL_CCID_MAP_U1 UNIQUE APPS_TS_TX_IDX CODE_COMBINATION_ID
GLOBAL_VS_COMBO_ID
FEM_INTG_OGL_CCID_MAP_N1 NONUNIQUE APPS_TS_TX_IDX GLOBAL_VS_COMBO_ID
LINE_ITEM_ID
COMPANY_COST_CENTER_ORG_ID
INTERCOMPANY_ID
NATURAL_ACCOUNT_ID
Columns
Name Datatype Length Mandatory Comments
CODE_COMBINATION_ID NUMBER (15) Y Accounting key flexfield combination identifier
GLOBAL_VS_COMBO_ID NUMBER (9) Y Global value set combination identifier
COMPANY_COST_CENTER_ORG_ID NUMBER
Y Company-Cost Center Organization identifier
NATURAL_ACCOUNT_ID NUMBER
Y Natural Account identifier
LINE_ITEM_ID NUMBER
Y Line Item identifier
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
EXTENDED_ACCOUNT_TYPE VARCHAR2 (30)
Natural Account extended account type
PRODUCT_ID NUMBER

Product identifier
CHANNEL_ID NUMBER

Channel identifier
PROJECT_ID NUMBER

Project identifier
CUSTOMER_ID NUMBER

Customer identifier
ENTITY_ID NUMBER

Entity identifier
INTERCOMPANY_ID NUMBER

Intercompany identifier
USER_DIM1_ID NUMBER

User defined dimension 1 identifier
USER_DIM2_ID NUMBER

User defined dimension 2 identifier
USER_DIM3_ID NUMBER

User defined dimension 3 identifier
USER_DIM4_ID NUMBER

User defined dimension 4 identifier
USER_DIM5_ID NUMBER

User defined dimension 5 identifier
USER_DIM6_ID NUMBER

User defined dimension 6 identifier
USER_DIM7_ID NUMBER

User defined dimension 7 identifier
USER_DIM8_ID NUMBER

User defined dimension 8 identifier
USER_DIM9_ID NUMBER

User defined dimension 9 identifier
USER_DIM10_ID NUMBER

User defined dimension 10 identifier
TASK_ID NUMBER

Task identifier

[top of page]

FEM.FEM_INTG_OGL_CCID_MAP does not reference any database object

FEM.FEM_INTG_OGL_CCID_MAP is referenced by following:

APPS
SYNONYM - FEM_INTG_OGL_CCID_MAP

[top of page]

Table: FEM_LD_CAL_PERIODS_GT

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_LD_CAL_PERIODS_GT_N1 NONUNIQUE VALID
FEM_LD_CAL_PERIODS_GT_N2 NONUNIQUE TABLE_NAME
TABLE_ROW
Columns
Name Datatype Length Mandatory Comments
LEDGER_ID NUMBER

CAL_PERIOD_ID NUMBER

DIM_GRP_ID NUMBER

TABLE_NAME VARCHAR2 (30)
TABLE_ROW NUMBER

STATUS VARCHAR2 (10)
VALID VARCHAR2 (10)

[top of page]

FEM.FEM_LD_CAL_PERIODS_GT does not reference any database object

FEM.FEM_LD_CAL_PERIODS_GT is referenced by following:

APPS
SYNONYM - FEM_LD_CAL_PERIODS_GT

[top of page]

Table: FEM_LD_DIM_REQUESTS_GT

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_LD_DIM_REQUESTS_GT_N1 NONUNIQUE TABLE_NAME
FEM_LD_DIM_REQUESTS_GT_N2 NONUNIQUE REQUEST_ID
FEM_LD_DIM_REQUESTS_GT_N3 NONUNIQUE DIMENSION_ID
Columns
Name Datatype Length Mandatory Comments
DIMENSION_ID NUMBER

DIMENSION_VARCHAR_LABEL VARCHAR2 (30)
TABLE_NAME VARCHAR2 (30)
DIM_INTF_TABLE_NAME VARCHAR2 (30)
REQUEST_ID NUMBER

STATUS VARCHAR2 (1)

[top of page]

FEM.FEM_LD_DIM_REQUESTS_GT does not reference any database object

FEM.FEM_LD_DIM_REQUESTS_GT is referenced by following:

APPS
SYNONYM - FEM_LD_DIM_REQUESTS_GT

[top of page]

Table: FEM_LD_HIER_REQUESTS_GT

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_LD_HIER_REQUESTS_GT_N1 NONUNIQUE TABLE_NAME
FEM_LD_HIER_REQUESTS_GT_N2 NONUNIQUE REQUEST_ID
FEM_LD_HIER_REQUESTS_GT_N3 NONUNIQUE DIMENSION_ID
Columns
Name Datatype Length Mandatory Comments
DIMENSION_ID NUMBER

DIMENSION_VARCHAR_LABEL VARCHAR2 (30)
HIERARCHY_OBJECT_NAME VARCHAR2 (150)
HIER_OBJ_DEF_DISPLAY_NAME VARCHAR2 (150)
TABLE_NAME VARCHAR2 (30)
TABLE_ROW NUMBER

REQUEST_ID NUMBER

STATUS VARCHAR2 (1)

[top of page]

FEM.FEM_LD_HIER_REQUESTS_GT does not reference any database object

FEM.FEM_LD_HIER_REQUESTS_GT is referenced by following:

APPS
SYNONYM - FEM_LD_HIER_REQUESTS_GT

[top of page]

Table: FEM_LD_INTERFACE_DATA_GT

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_LD_INTERFACE_DATA_GT_N1 NONUNIQUE TABLE_NAME
TABLE_ROW
FEM_LD_INTERFACE_DATA_GT_N2 NONUNIQUE STATUS
FEM_LD_INTERFACE_DATA_GT_N3 NONUNIQUE DS_PRODUCTION_VALID_FLAG
FEM_LD_INTERFACE_DATA_GT_N4 NONUNIQUE LEDGER_ID
FEM_LD_INTERFACE_DATA_GT_N5 NONUNIQUE DATASET_CODE
FEM_LD_INTERFACE_DATA_GT_N6 NONUNIQUE LEDGER_DISPLAY_CODE
DATASET_DISPLAY_CODE
SOURCE_SYSTEM_DISPLAY_CODE
FEM_LD_INTERFACE_DATA_GT_N7 NONUNIQUE CAL_PERIOD_LEVEL
FEM_LD_INTERFACE_DATA_GT_N8 NONUNIQUE DIMENSION_GROUP_ID
LEDGER_ID
CAL_PERIOD
Columns
Name Datatype Length Mandatory Comments
LEDGER_DISPLAY_CODE VARCHAR2 (150)
DATASET_DISPLAY_CODE VARCHAR2 (150)
SOURCE_SYSTEM_DISPLAY_CODE VARCHAR2 (150)
LEDGER_ID NUMBER

DATASET_CODE NUMBER

SOURCE_SYSTEM_CODE NUMBER

CAL_PERIOD_NUMBER NUMBER

CAL_PERIOD_LEVEL VARCHAR2 (30)
CAL_PERIOD_END_DATE DATE

TABLE_NAME VARCHAR2 (30)
TABLE_ROW NUMBER

CALENDAR_ID NUMBER

CAL_PERIOD NUMBER

DIMENSION_GROUP_ID NUMBER

TIME_DIMENSION_GROUP_KEY NUMBER

BUDGET_ID NUMBER

BUDGET_DISPLAY_CODE VARCHAR2 (150)
BALANCE_TYPE_CODE VARCHAR2 (30)
ENCUMBRANCE_TYPE_ID NUMBER

ENCUMBRANCE_TYPE_CODE VARCHAR2 (150)
DS_PRODUCTION_VALID_FLAG VARCHAR2 (1)
STATUS VARCHAR2 (10)

[top of page]

FEM.FEM_LD_INTERFACE_DATA_GT does not reference any database object

FEM.FEM_LD_INTERFACE_DATA_GT is referenced by following:

APPS
SYNONYM - FEM_LD_INTERFACE_DATA_GT

[top of page]

Table: FEM_OBJECT_CATALOG_TL

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_OBJECT_CATALOG_TL_PK UNIQUE APPS_TS_TX_IDX OBJECT_ID
LANGUAGE
FEM_OBJECT_CATALOG_TL_UK1 UNIQUE APPS_TS_TX_IDX SYS_NC00011$
LANGUAGE
FEM_OBJECT_CATALOG_TL_UK2 UNIQUE APPS_TS_TX_IDX OBJECT_NAME
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER (9) Y
OBJECT_NAME VARCHAR2 (150) Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
DESCRIPTION VARCHAR2 (255)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

FEM.FEM_OBJECT_CATALOG_TL does not reference any database object

FEM.FEM_OBJECT_CATALOG_TL is referenced by following:

APPS
SYNONYM - FEM_OBJECT_CATALOG_TL

[top of page]

Table: FEM_OBJECT_DEFINITION_TL

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_OBJECT_DEFINITION_TL_PK UNIQUE APPS_TS_TX_IDX OBJECT_DEFINITION_ID
LANGUAGE
FEM_OBJECT_DEFINITION_TL_UK1 UNIQUE APPS_TS_TX_IDX SYS_NC00013$
OBJECT_ID
OLD_APPROVED_COPY_FLAG
LANGUAGE
FEM_OBJECT_DEFINITION_TL_N1 NONUNIQUE APPS_TS_TX_IDX DISPLAY_NAME
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
OBJECT_DEFINITION_ID NUMBER (9) Y
OBJECT_ID NUMBER (9) Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
OLD_APPROVED_COPY_FLAG VARCHAR2 (1) Y
DISPLAY_NAME VARCHAR2 (150) Y
DESCRIPTION VARCHAR2 (255)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

FEM.FEM_OBJECT_DEFINITION_TL does not reference any database object

FEM.FEM_OBJECT_DEFINITION_TL is referenced by following:

APPS
SYNONYM - FEM_OBJECT_DEFINITION_TL

[top of page]

Table: FEM_SOURCE_DATA_INTERIM_GT

Description: This table is a global temporary table that will serve as the interim stage in processing the data to be transferred from the detail client data interface table to the target table. This table has a one-to-one relationship with all detail
Comments
This table is a global temporary table that will serve as the interim stage in processing the data to be transferred from the detail client data interface table to the target table. This table has a one-to-one relationship with all detail client data interface and target tables.
Indexes
Index Type Tablespace Column
FEM_SOURCE_DATA_INTERIM_GT_N1 NONUNIQUE ERROR_CODE
Columns
Name Datatype Length Mandatory Comments
INTERFACE_ROWID ROWID (10)
ROWID of the corresponding record in the interface table.
ERROR_CODE VARCHAR2 (30)
Designates the status of the row. Records are first created in this table with no ERROR_CODE values. If a record is found to have an error during the validation process, the error is stored here. It will later be copied to the interface table.
DIM1 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM2 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM3 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM4 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM5 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM6 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM7 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM8 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM9 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM10 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM11 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM12 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM13 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM14 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM15 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM16 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM17 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM18 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM19 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM20 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM21 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM22 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM23 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM24 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM25 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM26 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM27 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM28 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM29 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM30 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM31 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM32 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM33 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM34 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM35 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM36 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM37 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM38 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM39 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM40 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM41 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM42 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM43 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM44 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM45 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM46 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM47 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM48 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM49 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM50 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM51 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM52 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM53 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM54 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM55 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM56 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM57 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM58 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM59 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM60 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM61 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM62 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM63 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM64 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM65 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM66 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM67 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM68 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM69 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM70 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM71 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM72 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM73 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM74 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM75 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM76 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM77 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM78 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM79 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM80 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM81 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM82 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM83 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM84 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM85 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM86 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM87 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM88 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM89 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM90 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM91 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM92 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM93 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM94 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM95 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM96 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM97 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM98 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM99 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM100 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM101 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM102 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM103 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM104 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM105 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM106 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM107 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM108 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM109 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM110 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM111 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM112 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM113 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM114 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM115 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM116 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM117 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM118 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM119 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM120 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM121 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM122 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM123 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM124 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM125 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM126 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM127 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM128 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM129 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM130 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM131 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM132 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM133 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM134 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM135 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM136 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM137 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM138 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM139 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM140 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM141 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM142 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM143 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM144 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM145 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM146 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM147 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM148 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM149 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM150 VARCHAR2 (30)
Foreign key to a dimension member table.

[top of page]

FEM.FEM_SOURCE_DATA_INTERIM_GT does not reference any database object

FEM.FEM_SOURCE_DATA_INTERIM_GT is referenced by following:

APPS
SYNONYM - FEM_SOURCE_DATA_INTERIM_GT

[top of page]

Table: FEM_TABLES_TL

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_TABLES_TL_1 UNIQUE APPS_TS_TX_IDX SYS_NC00011$
LANGUAGE
FEM_TABLES_TL_PK UNIQUE APPS_TS_TX_IDX TABLE_NAME
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANG VARCHAR2 (4) Y
TABLE_NAME VARCHAR2 (30) Y
DISPLAY_NAME VARCHAR2 (150) Y
DESCRIPTION VARCHAR2 (255) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER

[top of page]

FEM.FEM_TABLES_TL does not reference any database object

FEM.FEM_TABLES_TL is referenced by following:

APPS
SYNONYM - FEM_TABLES_TL

[top of page]

Table: FEM_TAB_COLUMNS_GT

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (30) Y
COLUMN_NAME VARCHAR2 (30) Y
DISPLAY_NAME VARCHAR2 (150)
DESCRIPTION VARCHAR2 (255)
DATA_TYPE VARCHAR2 (30) Y
DATA_LENGTH NUMBER

DATA_PRECISION NUMBER

CPM_DATATYPE VARCHAR2 (30) Y
DIMENSION_ID NUMBER

DIMENSION_NAME VARCHAR2 (80)
UOM_COLUMN_NAME VARCHAR2 (30)
UOM_COL_DISPLAY_NAME VARCHAR2 (150)
SELECTED VARCHAR2 (1) Y
DISABLE_FLAG VARCHAR2 (1) Y
CPM_SWITCHER VARCHAR2 (30) Y
DIM_SWITCHER VARCHAR2 (30) Y
UOM_SWITCHER VARCHAR2 (30) Y
ENABLED_FLAG VARCHAR2 (1) Y
RESTRICTED_FLAG VARCHAR2 (1) Y
UPDATE_FLAG VARCHAR2 (1) Y
OBJECT_VERSION_NUMBER NUMBER
Y

[top of page]

FEM.FEM_TAB_COLUMNS_GT does not reference any database object

FEM.FEM_TAB_COLUMNS_GT is referenced by following:

APPS
SYNONYM - FEM_TAB_COLUMNS_GT

[top of page]

Table: FEM_TAB_COLUMNS_TL

Description:
Comments
Indexes
Index Type Tablespace Column
FEM_TAB_COLUMNS_TL_PK UNIQUE APPS_TS_TX_IDX TABLE_NAME
COLUMN_NAME
LANGUAGE
FEM_TAB_COLUMNS_TL_N1 NONUNIQUE APPS_TS_TX_IDX COLUMN_NAME
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
LANGUAGE VARCHAR2 (4) Y
TABLE_NAME VARCHAR2 (30) Y
COLUMN_NAME VARCHAR2 (30) Y
SOURCE_LANG VARCHAR2 (4) Y
DISPLAY_NAME VARCHAR2 (150) Y
DESCRIPTION VARCHAR2 (255) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER

[top of page]

FEM.FEM_TAB_COLUMNS_TL does not reference any database object

FEM.FEM_TAB_COLUMNS_TL is referenced by following:

APPS
SYNONYM - FEM_TAB_COLUMNS_TL

[top of page]

Table: FEM_TAB_INDX_INFO_GT

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (30)
INDEX_NAME VARCHAR2 (30)
COLUMN_NAME VARCHAR2 (30)
COLUMN_POSITION NUMBER

[top of page]

FEM.FEM_TAB_INDX_INFO_GT does not reference any database object

FEM.FEM_TAB_INDX_INFO_GT is referenced by following:

APPS
SYNONYM - FEM_TAB_INDX_INFO_GT

[top of page]

Table: FEM_TAB_INFO_GT

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (30)
OWNER VARCHAR2 (30)
DB_LINK VARCHAR2 (128)

[top of page]

FEM.FEM_TAB_INFO_GT does not reference any database object

FEM.FEM_TAB_INFO_GT is referenced by following:

APPS
SYNONYM - FEM_TAB_INFO_GT

[top of page]

View: FEM_INTG_BAL_RULE_BSVS_V

Comments
Columns
Name Datatype Length Mandatory Comments
FLEX_VALUE CHAR (0)
DESCRIPTION CHAR (0)

[top of page]

APPS.FEM_INTG_BAL_RULE_BSVS_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.FEM_INTG_BAL_RULE_BSVS_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract