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 - GCS Tables and Views

TABLE - GCS.GCS_AD_TRANSACTIONS
TABLE - GCS.GCS_AD_TRIAL_BALANCES
TABLE - GCS.GCS_BAL_INTERFACE_T
TABLE - GCS.GCS_CATEGORIES_B
TABLE - GCS.GCS_CATEGORIES_TL
TABLE - GCS.GCS_CONS_DATA_STATUSES
TABLE - GCS.GCS_CONS_ENG_RUNS
TABLE - GCS.GCS_CONS_ENG_RUN_DTLS
TABLE - GCS.GCS_CONS_IMPACT_ANALYSES
TABLE - GCS.GCS_CONS_RELATIONSHIPS
TABLE - GCS.GCS_CURR_TREATMENTS_B
TABLE - GCS.GCS_CURR_TREATMENTS_TL
TABLE - GCS.GCS_DATASET_CODES
TABLE - GCS.GCS_DATA_SUB_DTLS
TABLE - GCS.GCS_DATA_TYPE_CODES_B
TABLE - GCS.GCS_DATA_TYPE_CODES_TL
TABLE - GCS.GCS_DIMENSION_MEMBERS_T
TABLE - GCS.GCS_DIMENSION_TEMPLATES
TABLE - GCS.GCS_ELIM_RULES_B
TABLE - GCS.GCS_ELIM_RULES_TL
TABLE - GCS.GCS_ELIM_RULE_RELS
TABLE - GCS.GCS_ELIM_RULE_STEPS_B
TABLE - GCS.GCS_ELIM_RULE_STEPS_TL
TABLE - GCS.GCS_ENTITIES_ATTR
TABLE - GCS.GCS_ENTITY_CCTR_ORGS
TABLE - GCS.GCS_ENTITY_CONS_ATTRS
TABLE - GCS.GCS_ENTITY_ORGANIZATIONS
TABLE - GCS.GCS_ENTRIES_GT
TABLE - GCS.GCS_ENTRY_HEADERS
TABLE - GCS.GCS_ENTRY_LINES
TABLE - GCS.GCS_ENTRY_LINES_GT
TABLE - GCS.GCS_EPB_DIM_MAPS
TABLE - GCS.GCS_FEM_POSTING_GT
TABLE - GCS.GCS_FLATTENED_RELNS
TABLE - GCS.GCS_HIERARCHIES_B
TABLE - GCS.GCS_HIERARCHIES_TL
TABLE - GCS.GCS_HIER_GRP_MEMBERS
TABLE - GCS.GCS_HIER_MEMBERS_T
TABLE - GCS.GCS_HISTORICAL_RATES
TABLE - GCS.GCS_INTERCO_ELM_TRX
TABLE - GCS.GCS_INTERCO_MAP_DTLS
TABLE - GCS.GCS_INTERCO_MEMBERS
TABLE - GCS.GCS_INTERCO_RULES_B
TABLE - GCS.GCS_INTERCO_RULES_TL
TABLE - GCS.GCS_LEX_MAP_COLUMNS
TABLE - GCS.GCS_LEX_MAP_CONDITIONS
TABLE - GCS.GCS_LEX_MAP_DERIVATIONS
TABLE - GCS.GCS_LEX_MAP_DRV_DETAILS
TABLE - GCS.GCS_LEX_MAP_PLSQL_FUNCS
TABLE - GCS.GCS_LEX_MAP_RULES
TABLE - GCS.GCS_LEX_MAP_RULE_SETS
TABLE - GCS.GCS_LEX_MAP_RULE_STAGES
TABLE - GCS.GCS_LEX_MAP_STRUCTS
TABLE - GCS.GCS_LOBS
TABLE - GCS.GCS_ROLE_ENTITY_RELNS
TABLE - GCS.GCS_ROLE_HIER_RELNS
TABLE - GCS.GCS_RULE_SCOPE_DIMS
TABLE - GCS.GCS_RULE_SCOPE_DTLS
TABLE - GCS.GCS_SYSTEM_OPTIONS
TABLE - GCS.GCS_SYSTEM_TASKS
TABLE - GCS.GCS_TRANSLATION_STATUSES
TABLE - GCS.GCS_TRANSLATION_TRACK_H
TABLE - GCS.GCS_TREATMENTS_B
TABLE - GCS.GCS_TREATMENTS_TL
TABLE - GCS.GCS_WRITEBACK_HEADERS
TABLE - GCS.GCS_WRITEBACK_LINES
TABLE - GCS.GCS_XML_FILES
VIEW - APPS.GCS_ACTIVE_DIMS_V
VIEW - APPS.GCS_CATEGORIES_VL
VIEW - APPS.GCS_CURR_TREATMENTS_VL
VIEW - APPS.GCS_DATA_TYPE_CODES_VL
VIEW - APPS.GCS_ELIM_RULES_VL
VIEW - APPS.GCS_ELIM_RULE_STEPS_VL
VIEW - APPS.GCS_FEM_ACTIVE_DIMS_V
VIEW - APPS.GCS_FINANCIAL_ITEMS_HIER_V
VIEW - APPS.GCS_FINANCIAL_ITEMS_V
VIEW - APPS.GCS_FIN_STMTS_V
VIEW - APPS.GCS_FIN_STMT_DTLS_V
VIEW - APPS.GCS_GL_JI_GROUPS_V
VIEW - APPS.GCS_HIERARCHIES_VL
VIEW - APPS.GCS_ITEMS_TO_NAT_ACCTS_V
VIEW - APPS.GCS_LEX_MAP_SEQUENCES_V
VIEW - APPS.GCS_NAT_ACCTS_HIER_V
VIEW - APPS.GCS_NAT_ACCTS_V
VIEW - APPS.GCS_TREATMENTS_VL

Table: GCS_AD_TRANSACTIONS

Description: GCS Acquisition and Disposal transaction control records that reflect the most current transaction states
Primary Key: GCS_AD_TRANSACTIONS_PK
  1. AD_TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_AD_TRANSACTIONS.PRE_CONS_RELATIONSHIP_ID %
GCS_AD_TRANSACTIONS.POST_CONS_RELATIONSHIP_ID %
GCS_AD_TRANSACTIONS.ASSOC_ENTRY_ID %
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
GCS_AD_TRANSACTIONS_U1 UNIQUE APPS_TS_TX_IDX AD_TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
AD_TRANSACTION_ID NUMBER (15) Y AD Transaction Identifier
PRE_CONS_RELATIONSHIP_ID NUMBER (15)
Previous Consolidation Relationship Identifier
POST_CONS_RELATIONSHIP_ID NUMBER (15)
Post Consolidation Relationship Identifier
TRANSACTION_TYPE_CODE VARCHAR2 (30) Y Transaction Type Code
ENTRY_TYPE_CODE VARCHAR2 (30)
Entry type code
REQUEST_ID NUMBER (15)
Concurrent Request Identifier
ASSOC_RECUR_ENTRY_ID NUMBER (15)
Associated entry defining column
TOTAL_CONSIDERATION NUMBER

Consideration Given or Received
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
INTERMEDIATE_TREATMENT_ID NUMBER (15)
Intermediate Consolidation Treatment Identifier (Only applies to Public Offering with Acquisition)
INTERMEDIATE_PERCENT_OWNED NUMBER

Intermediate Ownership Percentage (Only applies to Public Offering with Acquisition)
CAL_PERIOD_ID NUMBER
Y Dimension identifying column
TRANSACTION_DATE DATE
Y Transaction Date
ASSOC_ENTRY_ID NUMBER (15)
Associated entry defining column
HIDDEN_FLAG VARCHAR2 (1) Y Hidden Flag
ENABLED_FLAG VARCHAR2 (1) Y Enabled Flag

[top of page]

GCS.GCS_AD_TRANSACTIONS does not reference any database object

GCS.GCS_AD_TRANSACTIONS is referenced by following:

APPS
SYNONYM - GCS_AD_TRANSACTIONS

[top of page]

Table: GCS_AD_TRIAL_BALANCES

Description: Acquisition and disposal transaction trial balances
Primary Key: GCS_AD_TRIAL_BALANCES_PK
  1. AD_TRANSACTION_ID
  2. TRIAL_BALANCE_SEQ
  3. COMPANY_COST_CENTER_ORG_ID
  4. INTERCOMPANY_ID
  5. LINE_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_AD_TRIAL_BALANCES.AD_TRANSACTION_ID %
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.

Columns
Name Datatype Length Mandatory Comments
AD_TRANSACTION_ID NUMBER (15) Y Acquisition and disposal transaction defining column
TRIAL_BALANCE_SEQ NUMBER (15) Y Trial balance sequence number
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
COMPANY_COST_CENTER_ORG_ID NUMBER
Y Organization dimension defining column
NATURAL_ACCOUNT_ID NUMBER

Natural account dimension defining column
INTERCOMPANY_ID NUMBER
Y Intercompany dimension defining column
CHANNEL_ID NUMBER

Channel dimension defining column
CUSTOMER_ID NUMBER

Customer dimension defining column
FINANCIAL_ELEM_ID NUMBER

Financial Element defining column
LINE_ITEM_ID NUMBER
Y Line item dimension defining column
PRODUCT_ID NUMBER

Product dimension defining column
PROJECT_ID NUMBER

Project dimension defining column
USER_DIM1_ID NUMBER

Dimension defining column
USER_DIM2_ID NUMBER

Dimension defining column
USER_DIM3_ID NUMBER

Dimension defining column
USER_DIM4_ID NUMBER

Dimension defining column
USER_DIM5_ID NUMBER

Dimension defining column
USER_DIM6_ID NUMBER

Dimension defining column
USER_DIM7_ID NUMBER

Dimension defining column
USER_DIM8_ID NUMBER

Dimension defining column
USER_DIM9_ID NUMBER

Dimension defining column
USER_DIM10_ID NUMBER

Dimension defining column
DEBIT_AMOUNT NUMBER

Debit amount
CREDIT_AMOUNT NUMBER

Credit amount
ENTITY_ID NUMBER
Y Entity dimension defining column
TASK_ID NUMBER

Task dimension defining column

[top of page]

GCS.GCS_AD_TRIAL_BALANCES does not reference any database object

GCS.GCS_AD_TRIAL_BALANCES is referenced by following:

APPS
SYNONYM - GCS_AD_TRIAL_BALANCES

[top of page]

Table: GCS_BAL_INTERFACE_T

Description: Stores line level information on data transferred to FEM_BALANCES
Primary Key: GCS_BAL_INTERFACE_T_PK
  1. LOAD_ID
Comments

GCS_BAL_INTERFACE_T stores line level information on data that has been or is in the processing of being loaded to FEM_BALANCES.

Indexes
Index Type Tablespace Column
SYS_IL0000399880C00034$$ UNIQUE APPS_TS_TX_DATA
GCS_BAL_INTERFACE_T_N1 NONUNIQUE APPS_TS_TX_IDX LOAD_ID
Columns
Name Datatype Length Mandatory Comments
LOAD_ID NUMBER (15) Y Load Identifying Column
CCTR_ORG_DISPLAY_CODE VARCHAR2 (150)
Company Cost Center Org Display Code
FINANCIAL_ELEM_DISPLAY_CODE VARCHAR2 (150)
Financial Element Display Code
PRODUCT_DISPLAY_CODE VARCHAR2 (150)
Product Display Code
NATURAL_ACCOUNT_DISPLAY_CODE VARCHAR2 (150)
Natural Account Display Code
CHANNEL_DISPLAY_CODE VARCHAR2 (150)
Channel Display Code
LINE_ITEM_DISPLAY_CODE VARCHAR2 (150)
Line Item Display Code
PROJECT_DISPLAY_CODE VARCHAR2 (150)
Product Display Code
CUSTOMER_DISPLAY_CODE VARCHAR2 (150)
Customer Display Code
INTERCOMPANY_DISPLAY_CODE VARCHAR2 (150)
Intercompany Display Code
TASK_DISPLAY_CODE VARCHAR2 (150)
Task Display Code
USER_DIM1_DISPLAY_CODE VARCHAR2 (150)
User Dim 1 Display Code
USER_DIM2_DISPLAY_CODE VARCHAR2 (150)
User Dim 2 Display Code
USER_DIM3_DISPLAY_CODE VARCHAR2 (150)
User Dim3 Display Code
USER_DIM4_DISPLAY_CODE VARCHAR2 (150)
User Dim 4 Display Code
USER_DIM5_DISPLAY_CODE VARCHAR2 (150)
User Dim 5 Display Code
USER_DIM6_DISPLAY_CODE VARCHAR2 (150)
User Dim 6 Display Code
USER_DIM7_DISPLAY_CODE VARCHAR2 (150)
User Dim 7 Display Code
USER_DIM8_DISPLAY_CODE VARCHAR2 (150)
User Dim 8 Display Code
USER_DIM9_DISPLAY_CODE VARCHAR2 (150)
User Dim 9 Display Code
USER_DIM10_DISPLAY_CODE VARCHAR2 (150)
User Dim 10 Display Code
PTD_DEBIT_BALANCE_E NUMBER

Period-to-Date Entered Debit Balance
PTD_CREDIT_BALANCE_E NUMBER

Period-to-Date Entered Credit Balance
YTD_DEBIT_BALANCE_E NUMBER

Year-to-Date Entered Debit Balance
YTD_CREDIT_BALANCE_E NUMBER

Year-to-Date Entered Credit Balance
PTD_DEBIT_BALANCE_F NUMBER

Period-to-Date Functional Debit Balance
PTD_CREDIT_BALANCE_F NUMBER

Period-to-Date Functional Credit Balance
YTD_DEBIT_BALANCE_F NUMBER

Year-to-Date Functional Debit Balance
YTD_CREDIT_BALANCE_F NUMBER

Year-to-Date Functional Credit Balance
PTD_BALANCE_E NUMBER

Period-to-Date Entered Balance
PTD_BALANCE_F NUMBER

Period-to-Date Functional Balance
YTD_BALANCE_E NUMBER

Year-to-Date Entered Balance
YTD_BALANCE_F NUMBER

Year-to-Date Functional Balance
ERROR_MESSAGE_CODE CLOB (4000)
Error Message Code
CURRENCY_CODE VARCHAR2 (30)
Currency Code
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
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (15) Y Change Indicator Column

[top of page]

GCS.GCS_BAL_INTERFACE_T does not reference any database object

GCS.GCS_BAL_INTERFACE_T is referenced by following:

APPS
SYNONYM - GCS_BAL_INTERFACE_T

[top of page]

Table: GCS_CATEGORIES_B

Description: Non-Translatable Information for the Processing Categories
Primary Key: GCS_CATEGORIES_B_PK
  1. CATEGORY_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_CONS_ENG_RUN_DTLS.CATEGORY_CODE GCS_CATEGORIES_B
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
GCS_CATEGORIES_B_U1 UNIQUE APPS_TS_TX_IDX CATEGORY_CODE
Columns
Name Datatype Length Mandatory Comments
CATEGORY_CODE VARCHAR2 (80) Y Category defining column
CATEGORY_NUMBER NUMBER (15) Y Category Sequence Number
NET_TO_RE_FLAG VARCHAR2 (1) Y Net to Retained Earnings
TARGET_ENTITY_CODE VARCHAR2 (30) Y Target Entity for Category
CATEGORY_TYPE_CODE VARCHAR2 (30) Y Category Type
ASSOCIATED_OBJECT_ID NUMBER
Y Foreign key to Object Dimension defining column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (15) Y Standard Who Column
ORG_OUTPUT_CODE VARCHAR2 (30)
Organization Output Option ('CHILD_BASE_ORG', 'BASE_ORG')
SUPPORT_MULTI_PARENTS_FLAG VARCHAR2 (1) Y Support multi parents
ENABLED_FLAG VARCHAR2 (1) Y Category enabled
SPECIFIC_INTERCOMPANY_ID NUMBER

Specific intercompany
GL_CATEGORY_CODE VARCHAR2 (30)
General Ledger Category Code

[top of page]

GCS.GCS_CATEGORIES_B does not reference any database object

GCS.GCS_CATEGORIES_B is referenced by following:

APPS
SYNONYM - GCS_CATEGORIES_B

[top of page]

Table: GCS_CATEGORIES_TL

Description: Translatable Information for the Processing Categories
Primary Key: GCS_CATEGORIES_TL_PK
  1. CATEGORY_CODE
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_CATEGORIES_TL.CATEGORY_CODE %
GCS_CATEGORIES_TL.SOURCE_LANG FND_LANGUAGES
GCS_CATEGORIES_TL.LANGUAGE FND_LANGUAGES
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
GCS_CATEGORIES_TL_U1 UNIQUE APPS_TS_TX_IDX CATEGORY_CODE
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
CATEGORY_CODE VARCHAR2 (80) Y Category defining column
CATEGORY_NAME VARCHAR2 (80) Y Category Name
DESCRIPTION VARCHAR2 (240)
Description
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source Language

[top of page]

GCS.GCS_CATEGORIES_TL does not reference any database object

GCS.GCS_CATEGORIES_TL is referenced by following:

APPS
SYNONYM - GCS_CATEGORIES_TL

[top of page]

Table: GCS_CONS_DATA_STATUSES

Description: Stores data status for consolidation entities.
Primary Key: GCS_CONS_DATA_STATUSES_PK
  1. HIERARCHY_ID
  2. CONSOLIDATION_ENTITY_ID
  3. CAL_PERIOD_ID
  4. BALANCE_TYPE_CODE
Comments

GCS_CONS_DATA_STATUSES stores data submission status for
each hierarchy, entity, calendar period, and balance type code.

Columns
Name Datatype Length Mandatory Comments
HIERARCHY_ID NUMBER (15) Y Hierarchy defining column
CONSOLIDATION_ENTITY_ID NUMBER (15) Y Consolidation entity defining column
CAL_PERIOD_ID NUMBER
Y Calendar period defining column
BALANCE_TYPE_CODE VARCHAR2 (30) Y Balance type code
STATUS_CODE VARCHAR2 (30) Y Status code
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]

GCS.GCS_CONS_DATA_STATUSES does not reference any database object

GCS.GCS_CONS_DATA_STATUSES is referenced by following:

APPS
SYNONYM - GCS_CONS_DATA_STATUSES

[top of page]

Table: GCS_CONS_ENG_RUNS

Description: Header level information for consolidation processes
Primary Key: GCS_CONS_ENG_RUNS_PK
  1. RUN_NAME
  2. HIERARCHY_ID
  3. RUN_ENTITY_ID
  4. PARENT_ENTITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_CONS_ENG_RUNS.HIERARCHY_ID %
GCS_CONS_ENG_RUNS.REQUEST_ID FND_CONCURRENT_REQUESTS
GCS_CONS_ENG_RUNS.ANALYSIS_CYCLE_ID %
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
GCS_CONS_ENG_RUNS_U1 UNIQUE APPS_TS_TX_IDX RUN_NAME
HIERARCHY_ID
RUN_ENTITY_ID
PARENT_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
RUN_NAME VARCHAR2 (240) Y User specified consolidation process defining column
HIERARCHY_ID NUMBER (15) Y Consolidation Hierarchy defining column
RUN_ENTITY_ID NUMBER (15) Y Consolidation Entity defining column
PARENT_ENTITY_ID NUMBER (15) Y Consolidation Parent Entity defining column
CAL_PERIOD_ID NUMBER
Y Calendar Period defining column
BALANCE_TYPE_CODE VARCHAR2 (30) Y Balance Type
PROCESS_METHOD VARCHAR2 (30) Y Process Method
STATUS_CODE VARCHAR2 (30) Y Process Status
OBJECT_VERSION_NUMBER NUMBER (15) Y Version Identifier
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LOCKED_FLAG VARCHAR2 (1) Y Indicates if results are locked
IMPACTED_FLAG VARCHAR2 (1) Y Indicates if results are impacted
START_TIME DATE

Indicates start time of consolidation
END_TIME DATE

Indicates end time of consolidation
MOST_RECENT_FLAG VARCHAR2 (1) Y Most Recent Run Defining Column
ITEM_KEY VARCHAR2 (240) Y Workflow Process Defining Column
ASSOCIATED_RUN_NAME VARCHAR2 (240)
Associated Run Defining Column
REQUEST_ID NUMBER (15)
Request Identifier
ANALYSIS_CYCLE_ID NUMBER

Enterprise Planning and Budgetting Business Process Identifier

[top of page]

GCS.GCS_CONS_ENG_RUNS does not reference any database object

GCS.GCS_CONS_ENG_RUNS is referenced by following:

APPS
SYNONYM - GCS_CONS_ENG_RUNS

[top of page]

Table: GCS_CONS_ENG_RUN_DTLS

Description: Detail level information for consolidation processes
Primary Key: GCS_CONS_ENG_RUN_DTLS_PK
  1. RUN_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_CONS_ENG_RUN_DTLS.PRE_PROP_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_ENG_RUN_DTLS.PRE_PROP_STAT_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_ENG_RUN_DTLS.CATEGORY_CODE GCS_CATEGORIES_B
GCS_CONS_ENG_RUN_DTLS.ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_ENG_RUN_DTLS.RULE_ID %
GCS_CONS_ENG_RUN_DTLS.CONS_RELATIONSHIP_ID %
GCS_CONS_ENG_RUN_DTLS.STAT_ENTRY_ID GCS_ENTRY_HEADERS
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
GCS_CONS_ENG_RUN_DTLS_U1 UNIQUE APPS_TS_TX_IDX RUN_DETAIL_ID
GCS_CONS_ENG_RUN_DTLS_N1 NONUNIQUE APPS_TS_TX_IDX RUN_NAME
CONSOLIDATION_ENTITY_ID
CHILD_ENTITY_ID
CATEGORY_CODE
Columns
Name Datatype Length Mandatory Comments
RUN_DETAIL_ID NUMBER (15) Y Run Detail defining column
RUN_NAME VARCHAR2 (240) Y User specified consolidation process defining column
CONSOLIDATION_ENTITY_ID NUMBER
Y Consolidation Entity defining column
CHILD_ENTITY_ID NUMBER

Entity dimension defining column for child entity
CONTRA_CHILD_ENTITY_ID NUMBER

Counter Entity defining column (used for Intercompany)
RULE_ID NUMBER (15)
Consolidation rule defining column
ENTRY_ID NUMBER (15)
Entry header defining column
REQUEST_ERROR_CODE VARCHAR2 (400)
Concurrent Request Error
STAT_ENTRY_ID NUMBER (15)
STAT Entry header defining column
BP_REQUEST_ERROR_CODE VARCHAR2 (400)
Balances Processor Request Error
PRE_PROP_ENTRY_ID NUMBER (15)
Functional Pre-Proportional Entry defining column
PRE_PROP_STAT_ENTRY_ID NUMBER (15)
Stat Pre-Proportional Stat Entry defining column
CONS_RELATIONSHIP_ID NUMBER (15)
Relational defining column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CATEGORY_CODE VARCHAR2 (50) Y Category Code

[top of page]

GCS.GCS_CONS_ENG_RUN_DTLS does not reference any database object

GCS.GCS_CONS_ENG_RUN_DTLS is referenced by following:

APPS
SYNONYM - GCS_CONS_ENG_RUN_DTLS

[top of page]

Table: GCS_CONS_IMPACT_ANALYSES

Description: Impact Analysis information for consolidation processes
Primary Key: GCS_CONS_IMPACT_ANALYSES_PK
  1. IMPACT_ANALYSIS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_CONS_IMPACT_ANALYSES.PRE_RELATIONSHIP_ID GCS_CONS_RELATIONSHIPS
GCS_CONS_IMPACT_ANALYSES.STAT_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.ORIGINAL_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.PRE_PROP_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.PRE_PROP_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.LOAD_ID GCS_DATA_SUB_DTLS
Comments

GCS_CONS_IMPACT_ANALYSES stores the impact analysis information used to inform end-users of alterations to data or data structures, which impact consolidation results.

Indexes
Index Type Tablespace Column
GCS_CONS_IMPACT_ANALYSES_U1 UNIQUE APPS_TS_TX_IDX IMPACT_ANALYSIS_ID
GCS_CONS_IMPACT_ANALYSES_N1 NONUNIQUE APPS_TS_TX_IDX RUN_NAME
CHILD_ENTITY_ID
CONSOLIDATION_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
IMPACT_ANALYSIS_ID NUMBER (15) Y Impact Analysis Defining Column
RUN_NAME VARCHAR2 (240) Y Consolidation Process Defining Column
CONSOLIDATION_ENTITY_ID NUMBER (15) Y Consolidation entity defining column
CHILD_ENTITY_ID NUMBER (15)
Child entity defining column
MESSAGE_NAME VARCHAR2 (30)
Message Code
PRE_RELATIONSHIP_ID NUMBER (15)
Prior Consolidation Relationship defining column
POST_RELATIONSHIP_ID NUMBER (15)
Post Consolidation Relationship defining column
DATE_TOKEN DATE

Date Substitution Token
STAT_ENTRY_ID NUMBER (15)
Stat Entry defining column
ENTRY_ID NUMBER (15)
Entry defining column
ORIGINAL_ENTRY_ID NUMBER (15)
Original Entry defining column
PRE_PROP_ENTRY_ID NUMBER (15)
Pre-Proportional Entry defining column
PRE_PROP_STAT_ENTRY_ID NUMBER (15)
Pre-Proportional Stat Entry defining column
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
OBJECT_VERSION_NUMBER NUMBER (15) Y Change Indicator Column
LOAD_ID NUMBER (15)
Load Identifier

[top of page]

GCS.GCS_CONS_IMPACT_ANALYSES does not reference any database object

GCS.GCS_CONS_IMPACT_ANALYSES is referenced by following:

APPS
SYNONYM - GCS_CONS_IMPACT_ANALYSES

[top of page]

Table: GCS_CONS_RELATIONSHIPS

Description: GCS consolidation hierarchy relationship information
Primary Key: GCS_CONS_RELATIONSHIPS_PK
  1. CONS_RELATIONSHIP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_CONS_RELATIONSHIPS.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_CONS_RELATIONSHIPS.TREATMENT_ID GCS_TREATMENTS_B
GCS_CONS_RELATIONSHIPS.CURR_TREATMENT_ID GCS_CURR_TREATMENTS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_CONS_IMPACT_ANALYSES.PRE_RELATIONSHIP_ID GCS_CONS_RELATIONSHIPS
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
GCS_CONS_RELATIONSHIPS_U1 UNIQUE APPS_TS_SEED CONS_RELATIONSHIP_ID
GCS_CONS_RELATIONSHIPS_N1 NONUNIQUE APPS_TS_SEED HIERARCHY_ID
PARENT_ENTITY_ID
CHILD_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
CONS_RELATIONSHIP_ID NUMBER (15) Y Consolidation hierarchy relationship defining column
HIERARCHY_ID NUMBER (15) Y Consolidation hierarchy defining column
PARENT_ENTITY_ID NUMBER
Y Parent entity defining column
CHILD_ENTITY_ID NUMBER
Y Child entity defining column
OWNERSHIP_PERCENT NUMBER
Y Percentage owned of child entity by parent entity
START_DATE DATE
Y Relationship start date
TREATMENT_ID NUMBER (15)
Consolidation treatment of child entity by parent entity
CURR_TREATMENT_ID NUMBER (15)
Currency treatment of child entity by parent entity
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
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
END_DATE DATE

Relationship end date
DOMINANT_PARENT_FLAG VARCHAR2 (1) Y Dominant parent flag
ACTUAL_OWNERSHIP_FLAG VARCHAR2 (1) Y Actual ownership flag
DELTA_OWNED NUMBER

Percentage indirectly owned of child entity by parent entity

[top of page]

GCS.GCS_CONS_RELATIONSHIPS does not reference any database object

GCS.GCS_CONS_RELATIONSHIPS is referenced by following:

APPS
SYNONYM - GCS_CONS_RELATIONSHIPS

[top of page]

Table: GCS_CURR_TREATMENTS_B

Description: Consolidation currency treatments
Primary Key: GCS_CURR_TREATMENTS_B_PK
  1. CURR_TREATMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_CURR_TREATMENTS_B.ENDING_RATE_TYPE GL_DAILY_CONVERSION_TYPES
GCS_CURR_TREATMENTS_B.AVERAGE_RATE_TYPE GL_DAILY_CONVERSION_TYPES
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_CONS_RELATIONSHIPS.CURR_TREATMENT_ID GCS_CURR_TREATMENTS_B
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
GCS_CURR_TREATMENTS_B_U1 UNIQUE APPS_TS_SEED CURR_TREATMENT_ID
Columns
Name Datatype Length Mandatory Comments
CURR_TREATMENT_ID NUMBER (15) Y Currency Treatment defining column
ENDING_RATE_TYPE VARCHAR2 (30) Y Ending Rate Type
AVERAGE_RATE_TYPE VARCHAR2 (30) Y Average Rate Type
EQUITY_MODE_CODE VARCHAR2 (30) Y Equity Account Mode
INC_STMT_MODE_CODE VARCHAR2 (30) Y Income Statement Account Mode
ENABLED_FLAG VARCHAR2 (1) Y Enabled Flag
DEFAULT_FLAG VARCHAR2 (1) Y Default Flag
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
FINANCIAL_ELEM_ID NUMBER

Foreign Key to Financial Element defining column
PRODUCT_ID NUMBER

Foreign Key to Product defining column
NATURAL_ACCOUNT_ID NUMBER

Foreign Key to Natural Account defining column
CHANNEL_ID NUMBER

Foreign Key to Channel defining column
LINE_ITEM_ID NUMBER

Foreign Key to Line Item defining column
PROJECT_ID NUMBER

Foreign Key to Project defining column
CUSTOMER_ID NUMBER

Foreign Key to Customer defining column
CTA_USER_DIM1_ID NUMBER

Foreign Key to User Dim1 defining column
CTA_USER_DIM2_ID NUMBER

Foreign Key to User Dim2 defining column
CTA_USER_DIM3_ID NUMBER

Foreign Key to User Dim3 defining column
CTA_USER_DIM4_ID NUMBER

Foreign Key to User Dim4 defining colunm
CTA_USER_DIM5_ID NUMBER

Foreign Key to User Dim5 defining column
CTA_USER_DIM6_ID NUMBER

Foreign Key to User Dim6 defining column
CTA_USER_DIM7_ID NUMBER

Foreign Key to User Dim7 defining column
CTA_USER_DIM8_ID NUMBER

Foreign Key to User Dim8 defining column
CTA_USER_DIM9_ID NUMBER

Foreign Key to User Dim9 defining column
CTA_USER_DIM10_ID NUMBER

Foreign Key to User Dim10 defining column
TASK_ID NUMBER

Foreign Key to Task defining column
OBJECT_VERSION_NUMBER NUMBER (15) Y Version Identifier

[top of page]

GCS.GCS_CURR_TREATMENTS_B does not reference any database object

GCS.GCS_CURR_TREATMENTS_B is referenced by following:

APPS
SYNONYM - GCS_CURR_TREATMENTS_B

[top of page]

Table: GCS_CURR_TREATMENTS_TL

Description: Translation table for GCS Currency treatments
Primary Key: GCS_CURR_TREATMENTS_TL_PK
  1. CURR_TREATMENT_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_CURR_TREATMENTS_TL.LANGUAGE FND_LANGUAGES
GCS_CURR_TREATMENTS_TL.SOURCE_LANG FND_LANGUAGES
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
GCS_CURR_TREATMENTS_TL_U1 UNIQUE APPS_TS_SEED CURR_TREATMENT_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
CURR_TREATMENT_ID NUMBER (15) Y Currency Treatment defining column
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source Lang
CURR_TREATMENT_NAME VARCHAR2 (50) Y Currency Treatment Name
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
DESCRIPTION VARCHAR2 (240)
Description

[top of page]

GCS.GCS_CURR_TREATMENTS_TL does not reference any database object

GCS.GCS_CURR_TREATMENTS_TL is referenced by following:

APPS
SYNONYM - GCS_CURR_TREATMENTS_TL

[top of page]

Table: GCS_DATASET_CODES

Description: GCS hierarchy dataset code information
Primary Key: GCS_DATASET_CODES_PK
  1. HIERARCHY_ID
  2. BALANCE_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_DATASET_CODES.HIERARCHY_ID GCS_HIERARCHIES_B
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
GCS_DATASET_CODES_U1 UNIQUE APPS_TS_SEED HIERARCHY_ID
BALANCE_TYPE_CODE
GCS_DATASET_CODES_U2 UNIQUE APPS_TS_SEED HIERARCHY_ID
DATASET_CODE
Columns
Name Datatype Length Mandatory Comments
HIERARCHY_ID NUMBER (15) Y Consolidation hierarchy defining column
BALANCE_TYPE_CODE VARCHAR2 (30) Y Balance type code
DATASET_CODE NUMBER
Y Data set defining column
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]

GCS.GCS_DATASET_CODES does not reference any database object

GCS.GCS_DATASET_CODES is referenced by following:

APPS
SYNONYM - GCS_DATASET_CODES

[top of page]

Table: GCS_DATA_SUB_DTLS

Description: Stores tracking information on pristine data loads made to FEM_BALANCES
Primary Key: GCS_DATA_SUB_DTLS_PK
  1. LOAD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_DATA_SUB_DTLS.CURRENCY_CODE FND_CURRENCIES
GCS_DATA_SUB_DTLS.RULE_SET_ID GCS_LEX_MAP_RULE_SETS
GCS_DATA_SUB_DTLS.ASSOCIATED_REQUEST_ID FND_CONCURRENT_REQUESTS
GCS_DATA_SUB_DTLS.VALIDATION_RULE_SET_ID GCS_LEX_MAP_RULE_SETS
GCS_DATA_SUB_DTLS.BALANCES_RULE_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_CONS_IMPACT_ANALYSES.LOAD_ID GCS_DATA_SUB_DTLS
Comments

GCS_DATA_SUB_DTLS stores header level information regarding pristine data loads submitted by end-users, which impact their pristine data in FEM_BALANCES.

GCS_DATA_SUB_DTLS stores Acquisition and Disposal transaction control records as they relate to changes in consolidation hierarchies. Each record in GCS_AD_TRANSACTIONS has several GCS_AD_TRIAL_BALANCES records.

Indexes
Index Type Tablespace Column
GCS_DATA_SUB_DTLS_U1 UNIQUE APPS_TS_TX_IDX LOAD_ID
SYS_IL0000399869C00013$$ UNIQUE APPS_TS_TX_DATA
GCS_DATA_SUB_DTLS_N1 NONUNIQUE APPS_TS_TX_IDX ASSOCIATED_REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
LOAD_ID NUMBER (15) Y Load defining column
LOAD_NAME VARCHAR2 (50) Y User-Defined Load Name
ENTITY_ID NUMBER
Y Entity defining column
CAL_PERIOD_ID NUMBER
Y Calendar Period defining column
CURRENCY_CODE VARCHAR2 (30)
Currency Code defining column
BALANCE_TYPE_CODE VARCHAR2 (30) Y Balance Type defining column
LOAD_METHOD_CODE VARCHAR2 (30) Y Load Methods defining column
CURRENCY_TYPE_CODE VARCHAR2 (30) Y Currency Options defining column
AMOUNT_TYPE_CODE VARCHAR2 (30) Y Amount Type defining column
MEASURE_TYPE_CODE VARCHAR2 (30) Y Measure Type defining column
RULE_SET_ID NUMBER (15)
Interface Data Transformer Rule Set defining column
NOTIFY_OPTIONS_CODE VARCHAR2 (30) Y Notification Options defining column
NOTIFICATION_TEXT CLOB (4000)
Notification Text
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
OBJECT_VERSION_NUMBER NUMBER (15) Y Change defining column
START_TIME DATE
Y Start Time
END_TIME DATE

End Time
STATUS_CODE VARCHAR2 (30) Y Status Code
LOCKED_FLAG VARCHAR2 (1) Y Locked Data defining column
MOST_RECENT_FLAG VARCHAR2 (1) Y Most recent flag
ASSOCIATED_REQUEST_ID NUMBER (15)
Associated Concurrent Request
VALIDATION_RULE_SET_ID NUMBER (15)
Validation Rule Set Defining column
BALANCES_RULE_ID NUMBER (9)
Balances Rule Defining Column

[top of page]

GCS.GCS_DATA_SUB_DTLS does not reference any database object

GCS.GCS_DATA_SUB_DTLS is referenced by following:

APPS
SYNONYM - GCS_DATA_SUB_DTLS

[top of page]

Table: GCS_DATA_TYPE_CODES_B

Description: Stores validate data types for Consolidation
Comments

GCS_DATA_TYPE_CODES_B stores the consolidation data type code information

Indexes
Index Type Tablespace Column
GCS_DATA_TYPE_CODES_B_U1 UNIQUE APPS_TS_TX_IDX DATA_TYPE_ID
DATA_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
DATA_TYPE_CODE VARCHAR2 (30) Y Data Type defining column
ENFORCE_BALANCING_FLAG VARCHAR2 (1) Y Enforce Balancing Flag
APPLY_ELIM_RULES_FLAG VARCHAR2 (1) Y Apply Elimination Rules Flag
APPLY_CONS_RULES_FLAG VARCHAR2 (1) Y Apply Consolidation Rules Flag
SOURCE_DATASET_CODE NUMBER (15)
Dataset code used for Pristine Balances
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (15) Y Version Identifier
DATA_TYPE_ID NUMBER (15) Y Data Type Id defining column

[top of page]

GCS.GCS_DATA_TYPE_CODES_B does not reference any database object

GCS.GCS_DATA_TYPE_CODES_B is referenced by following:

APPS
SYNONYM - GCS_DATA_TYPE_CODES_B

[top of page]

Table: GCS_DATA_TYPE_CODES_TL

Description: Stores translatable information for data types
Comments

GCS_DATA_TYPE_CODES_TL stores the translatable display names for data type codes

Indexes
Index Type Tablespace Column
GCS_DATA_TYPE_CODES_TL_U1 UNIQUE APPS_TS_TX_IDX DATA_TYPE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source Lang
DATA_TYPE_NAME VARCHAR2 (150) Y Data Type Name
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
DESCRIPTION VARCHAR2 (240)
Description
DATA_TYPE_ID NUMBER (15) Y Data Type Id defining column

[top of page]

GCS.GCS_DATA_TYPE_CODES_TL does not reference any database object

GCS.GCS_DATA_TYPE_CODES_TL is referenced by following:

APPS
SYNONYM - GCS_DATA_TYPE_CODES_TL

[top of page]

Table: GCS_DIMENSION_MEMBERS_T

Description: FCH dimension members
Comments

GCS_DIMENSION_MEMBERS_T stores dimension members to be loaded into FEM schema.

Indexes
Index Type Tablespace Column
GCS_DIMENSION_MEMBERS_T_U1 UNIQUE APPS_TS_INTERFACE SEQUENCE_NUM
DIMENSION_VARCHAR_LABEL
DISPLAY_CODE
VALUE_SET_DISPLAY_CODE
GCS_DIMENSION_MEMBERS_T_U2 UNIQUE APPS_TS_INTERFACE SEQUENCE_NUM
DIMENSION_VARCHAR_LABEL
NAME
VALUE_SET_DISPLAY_CODE
Columns
Name Datatype Length Mandatory Comments
DIMENSION_VARCHAR_LABEL VARCHAR2 (30) Y Dimension defining column
SEQUENCE_NUM NUMBER (15) Y Sequence number
DISPLAY_CODE VARCHAR2 (150) Y Dimension member display code
NAME VARCHAR2 (150) Y Dimension member name
DESCRIPTION VARCHAR2 (255)
Dimension member description
VALUE_SET_DISPLAY_CODE VARCHAR2 (150) Y Value set display code
EXT_ACCOUNT_TYPE_CODE VARCHAR2 (30)
Extended account type code
COMPANY_VS_DISPLAY_CODE VARCHAR2 (150)
Company value set display code
COMPANY_DISPLAY_CODE VARCHAR2 (150)
Company display code
COST_CENTER_VS_DISPLAY_CODE VARCHAR2 (150)
Cost center value set display code
COST_CENTER_DISPLAY_CODE VARCHAR2 (150)
Cost center display code
DIMENSION_GROUP_DISPLAY_CODE VARCHAR2 (150)
Dimension group display code
OBJECT_VERSION_NUMBER NUMBER (15) Y Change defining column
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]

GCS.GCS_DIMENSION_MEMBERS_T does not reference any database object

GCS.GCS_DIMENSION_MEMBERS_T is referenced by following:

APPS
SYNONYM - GCS_DIMENSION_MEMBERS_T

[top of page]

Table: GCS_DIMENSION_TEMPLATES

Description: GCS dimension templates for retained earnings and suspense handling
Primary Key: GCS_DIMENSION_TEMPLATES_PK
  1. HIERARCHY_ID
  2. TEMPLATE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_DIMENSION_TEMPLATES.HIERARCHY_ID GCS_HIERARCHIES_B
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
GCS_DIMENSION_TEMPLATES_U1 UNIQUE APPS_TS_SEED HIERARCHY_ID
TEMPLATE_CODE
Columns
Name Datatype Length Mandatory Comments
HIERARCHY_ID NUMBER (15) Y Consolidation hierarchy defining column
TEMPLATE_CODE VARCHAR2 (30) Y Template type defining column
FINANCIAL_ELEM_ID NUMBER

Foreign key to the Financial Element dimension
PRODUCT_ID NUMBER

Foreign key to the Product dimension
NATURAL_ACCOUNT_ID NUMBER

Foreign key to the Natual Account dimension
CHANNEL_ID NUMBER

Foreign key to the Channel dimension
LINE_ITEM_ID NUMBER

Foreign key to the Line Item dimension
PROJECT_ID NUMBER

Foreign key to the Project dimension
CUSTOMER_ID NUMBER

Foreign key to the Customer dimension
TASK_ID NUMBER

Foreign key to the Task dimension
USER_DIM1_ID NUMBER

Foreign key to user defined dimension
USER_DIM2_ID NUMBER

Foreign key to user defined dimension
USER_DIM3_ID NUMBER

Foreign key to user defined dimension
USER_DIM4_ID NUMBER

Foreign key to user defined dimension
USER_DIM5_ID NUMBER

Foreign key to user defined dimension
USER_DIM6_ID NUMBER

Foreign key to user defined dimension
USER_DIM7_ID NUMBER

Foreign key to user defined dimension
USER_DIM8_ID NUMBER

Foreign key to user defined dimension
USER_DIM9_ID NUMBER

Foreign key to user defined dimension
USER_DIM10_ID NUMBER

Foreign key to user defined dimension
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
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]

GCS.GCS_DIMENSION_TEMPLATES does not reference any database object

GCS.GCS_DIMENSION_TEMPLATES is referenced by following:

APPS
SYNONYM - GCS_DIMENSION_TEMPLATES

[top of page]

Table: GCS_ELIM_RULES_B

Description: GCS consolidation rules
Primary Key: GCS_ELIM_RULES_B_PK
  1. RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ELIM_RULES_B.TO_TREATMENT_ID %
GCS_ELIM_RULES_B.FROM_TREATMENT_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_ELIM_RULES_TL.RULE_ID GCS_ELIM_RULES_B
GCS_ELIM_RULE_RELS.RULE_ID GCS_ELIM_RULES_B
GCS_ELIM_RULE_STEPS_B.RULE_ID GCS_ELIM_RULES_B
GCS_ENTRY_HEADERS.RULE_ID GCS_ELIM_RULES_B
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
GCS_ELIM_RULES_B_U1 UNIQUE APPS_TS_TX_IDX RULE_ID
GCS_ELIM_RULES_B_N1 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_TYPE_CODE
TO_TREATMENT_ID
FROM_TREATMENT_ID
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER (15) Y Consolidation rule defining column
SEEDED_RULE_FLAG VARCHAR2 (1) Y Indicates whether the rule is seed data or user-defined
TRANSACTION_TYPE_CODE VARCHAR2 (80) Y Transaction type code
RULE_TYPE_CODE VARCHAR2 (30) Y Consolidation rule type code
FROM_TREATMENT_ID NUMBER (15)
Old consolidation treatment code
TO_TREATMENT_ID NUMBER (15)
New consolidation treatment code
ENABLED_FLAG VARCHAR2 (1) Y Enabled flag
OBJECT_VERSION_NUMBER NUMBER (15)
Object version number
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

GCS.GCS_ELIM_RULES_B does not reference any database object

GCS.GCS_ELIM_RULES_B is referenced by following:

APPS
SYNONYM - GCS_ELIM_RULES_B

[top of page]

Table: GCS_ELIM_RULES_TL

Description: Translation table for GCS_ELIM_RULES_B
Primary Key: GCS_ELIM_RULES_TL_PK
  1. RULE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ELIM_RULES_TL.RULE_ID GCS_ELIM_RULES_B
GCS_ELIM_RULES_TL.LANGUAGE FND_LANGUAGES
GCS_ELIM_RULES_TL.SOURCE_LANG FND_LANGUAGES
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
GCS_ELIM_RULES_TL_U1 UNIQUE APPS_TS_TX_IDX RULE_ID
LANGUAGE
GCS_ELIM_RULES_TL_U2 UNIQUE APPS_TS_TX_IDX LANGUAGE
RULE_NAME
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER (15) Y Consolidation rule defining column
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Language in which the translatable names were entered into the system
RULE_NAME VARCHAR2 (50) Y User-entered rule name
DESCRIPTION VARCHAR2 (240)
Description
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

GCS.GCS_ELIM_RULES_TL does not reference any database object

GCS.GCS_ELIM_RULES_TL is referenced by following:

APPS
SYNONYM - GCS_ELIM_RULES_TL

[top of page]

Table: GCS_ELIM_RULE_RELS

Description: GCS consolidation treatment and consolidation rules relationship information
Primary Key: GCS_ELIM_RULE_RELS_PK
  1. TREATMENT_ID
  2. RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ELIM_RULE_RELS.TREATMENT_ID %
GCS_ELIM_RULE_RELS.RULE_ID GCS_ELIM_RULES_B
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
GCS_ELIM_RULE_RELS_U1 UNIQUE APPS_TS_SEED TREATMENT_ID
RULE_ID
Columns
Name Datatype Length Mandatory Comments
TREATMENT_ID NUMBER (15) Y Consolidation treatment defining column
RULE_ID NUMBER (15) Y Consolidation rule defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

GCS.GCS_ELIM_RULE_RELS does not reference any database object

GCS.GCS_ELIM_RULE_RELS is referenced by following:

APPS
SYNONYM - GCS_ELIM_RULE_RELS

[top of page]

Table: GCS_ELIM_RULE_STEPS_B

Description: GCS elimination rule steps
Primary Key: GCS_ELIM_RULE_STEPS_B_PK
  1. RULE_ID
  2. STEP_SEQ
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ELIM_RULE_STEPS_B.RULE_ID GCS_ELIM_RULES_B
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
GCS_ELIM_RULE_STEPS_B_U1 UNIQUE APPS_TS_TX_IDX RULE_ID
STEP_SEQ
GCS_ELIM_RULE_STEPS_B_U2 UNIQUE APPS_TS_TX_IDX RULE_STEP_ID
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER (15) Y Consolidation rule defining column
STEP_SEQ NUMBER (15) Y Consolidation rule step sequence
FORMULA_TEXT VARCHAR2 (2000) Y User-defined formula text
PARSED_FORMULA VARCHAR2 (2000) Y Parsed formula expression
COMPILED_VARIABLES VARCHAR2 (150)
Variables used in parsed formula
SQL_STATEMENT_NUM NUMBER (15)
Foreign key to the SQL statement used for the formula
OBJECT_VERSION_NUMBER NUMBER (15)
Object version number
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
RULE_STEP_ID NUMBER (15) Y Consolidaiton rule step defining column

[top of page]

GCS.GCS_ELIM_RULE_STEPS_B does not reference any database object

GCS.GCS_ELIM_RULE_STEPS_B is referenced by following:

APPS
SYNONYM - GCS_ELIM_RULE_STEPS_B

[top of page]

Table: GCS_ELIM_RULE_STEPS_TL

Description: Translation table for GCS_ELIM_RULE_STEPS_B
Primary Key: GCS_ELIM_RULE_STEPS_TL_PK
  1. LANGUAGE
  2. RULE_STEP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ELIM_RULE_STEPS_TL.LANGUAGE FND_LANGUAGES
GCS_ELIM_RULE_STEPS_TL.SOURCE_LANG FND_LANGUAGES
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
GCS_ELIM_RULE_STEPS_TL_U1 UNIQUE APPS_TS_TX_IDX LANGUAGE
RULE_STEP_ID
Columns
Name Datatype Length Mandatory Comments
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Language in which the translatable names were entered into the system
STEP_NAME VARCHAR2 (50) Y User-entered step name
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
RULE_STEP_ID NUMBER (15) Y Consolidation rule step definition column

[top of page]

GCS.GCS_ELIM_RULE_STEPS_TL does not reference any database object

GCS.GCS_ELIM_RULE_STEPS_TL is referenced by following:

APPS
SYNONYM - GCS_ELIM_RULE_STEPS_TL

[top of page]

Table: GCS_ENTITIES_ATTR

Description: GCS entity additional data type information
Primary Key: GCS_ENTITIES_ATTR_PK
  1. ENTITY_ID
  2. DATA_TYPE_CODE
Comments

GCS_ENTITIES_ATTR stores additional data type attribute information for the entity

Indexes
Index Type Tablespace Column
GCS_ENTITIES_ATTR_U1 UNIQUE APPS_TS_TX_IDX ENTITY_ID
DATA_TYPE_CODE
EFFECTIVE_START_DATE
Columns
Name Datatype Length Mandatory Comments
ENTITY_ID NUMBER
Y Entity Id defining column
DATA_TYPE_CODE VARCHAR2 (30) Y Data Type defining column
LEDGER_ID NUMBER
Y Ledger Id
SOURCE_SYSTEM_CODE NUMBER
Y Source System Code
BALANCES_RULE_ID NUMBER

Balances Rule Id
TRANSFORM_RULE_SET_ID NUMBER

Transformation Rule Set Id
VALIDATION_RULE_SET_ID NUMBER

Validation Rule Set Id
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (15) Y Version Identifier
EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

[top of page]

GCS.GCS_ENTITIES_ATTR does not reference any database object

GCS.GCS_ENTITIES_ATTR is referenced by following:

APPS
SYNONYM - GCS_ENTITIES_ATTR

[top of page]

Table: GCS_ENTITY_CCTR_ORGS

Description: Summary of all GCS entity organizations
Primary Key: GCS_ENTITY_CCTR_ORGS_PK
  1. ENTITY_ID
  2. COMPANY_COST_CENTER_ORG_ID
Comments

GCS_ENTITY_CCTR_ORGS is a summary table storing all organizations for local entities within each consolidation hierarchy

Indexes
Index Type Tablespace Column
GCS_ENTITY_CCTR_ORGS_U1 UNIQUE APPS_TS_SEED ENTITY_ID
COMPANY_COST_CENTER_ORG_ID
Columns
Name Datatype Length Mandatory Comments
ENTITY_ID NUMBER
Y Entity defining column
COMPANY_COST_CENTER_ORG_ID NUMBER
Y Organization dimension defining column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
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]

GCS.GCS_ENTITY_CCTR_ORGS does not reference any database object

GCS.GCS_ENTITY_CCTR_ORGS is referenced by following:

APPS
SYNONYM - GCS_ENTITY_CCTR_ORGS

[top of page]

Table: GCS_ENTITY_CONS_ATTRS

Description: GCS consolidation hierarchy node information
Primary Key: GCS_ENTITY_CONS_ATTRS_PK
  1. HIERARCHY_ID
  2. ENTITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ENTITY_CONS_ATTRS.CURRENCY_CODE FND_CURRENCIES
GCS_ENTITY_CONS_ATTRS.HIERARCHY_ID GCS_HIERARCHIES_B
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
GCS_ENTITY_CONS_ATTRS_U1 UNIQUE APPS_TS_SEED HIERARCHY_ID
ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
HIERARCHY_ID NUMBER (15) Y Consolidation hierarchy defining column
CURRENCY_CODE VARCHAR2 (15) Y Currency code
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
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
ENTITY_ID NUMBER
Y Entity defining column

[top of page]

GCS.GCS_ENTITY_CONS_ATTRS does not reference any database object

GCS.GCS_ENTITY_CONS_ATTRS is referenced by following:

APPS
SYNONYM - GCS_ENTITY_CONS_ATTRS

[top of page]

Table: GCS_ENTITY_ORGANIZATIONS

Description: GCS entity organization dimension filter information
Primary Key: GCS_ENTITY_ORGANIZATIONS_PK
  1. ENTITY_ID
  2. COMPANY_COST_CENTER_ORG_ID
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
GCS_ENTITY_ORGANIZATIONS_U1 UNIQUE APPS_TS_SEED ENTITY_ID
COMPANY_COST_CENTER_ORG_ID
Columns
Name Datatype Length Mandatory Comments
ENTITY_ID NUMBER
Y Entity defining column
COMPANY_COST_CENTER_ORG_ID NUMBER
Y Organization dimension defining column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
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]

GCS.GCS_ENTITY_ORGANIZATIONS does not reference any database object

GCS.GCS_ENTITY_ORGANIZATIONS is referenced by following:

APPS
SYNONYM - GCS_ENTITY_ORGANIZATIONS

[top of page]

Table: GCS_ENTRIES_GT

Description:
Comments
Indexes
Index Type Tablespace Column
GCS_ENTRIES_GT_N1 NONUNIQUE RULE_ID
STEP_SEQ
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER (15)
Rule identifying column
STEP_SEQ NUMBER

Step sequencing column
STEP_NAME VARCHAR2 (50)
Step name
FORMULA_TEXT VARCHAR2 (2000)
User-friendly formula text
RULE_STEP_ID NUMBER (15)
Rule step identifying column
CURRENCY_CODE VARCHAR2 (15)
Currency code
OFFSET_FLAG VARCHAR2 (1)
Offset flag
SQL_STATEMENT_NUM NUMBER

Foreign key to the SQL statement used for the formula
SRC_COMPANY_COST_CENTER_ORG_ID NUMBER

Dimension identfying column
SRC_FINANCIAL_ELEM_ID NUMBER

Dimension identfying column
SRC_PRODUCT_ID NUMBER

Dimension identfying column
SRC_NATURAL_ACCOUNT_ID NUMBER

Dimension identfying column
SRC_CHANNEL_ID NUMBER

Dimension identfying column
SRC_LINE_ITEM_ID NUMBER

Dimension identfying column
SRC_PROJECT_ID NUMBER

Dimension identfying column
SRC_CUSTOMER_ID NUMBER

Dimension identfying column
SRC_ENTITY_ID NUMBER

Dimension identfying column
SRC_INTERCOMPANY_ID NUMBER

Dimension identfying column
SRC_TASK_ID NUMBER

Dimension identfying column
SRC_USER_DIM1_ID NUMBER

Dimension identfying column
SRC_USER_DIM2_ID NUMBER

Dimension identfying column
SRC_USER_DIM3_ID NUMBER

Dimension identfying column
SRC_USER_DIM4_ID NUMBER

Dimension identfying column
SRC_USER_DIM5_ID NUMBER

Dimension identfying column
SRC_USER_DIM6_ID NUMBER

Dimension identfying column
SRC_USER_DIM7_ID NUMBER

Dimension identfying column
SRC_USER_DIM8_ID NUMBER

Dimension identfying column
SRC_USER_DIM9_ID NUMBER

Dimension identfying column
SRC_USER_DIM10_ID NUMBER

Dimension identfying column
TGT_COMPANY_COST_CENTER_ORG_ID NUMBER

Dimension identfying column
TGT_FINANCIAL_ELEM_ID NUMBER

Dimension identfying column
TGT_PRODUCT_ID NUMBER

Dimension identfying column
TGT_NATURAL_ACCOUNT_ID NUMBER

Dimension identfying column
TGT_CHANNEL_ID NUMBER

Dimension identfying column
TGT_LINE_ITEM_ID NUMBER

Dimension identfying column
TGT_PROJECT_ID NUMBER

Dimension identfying column
TGT_CUSTOMER_ID NUMBER

Dimension identfying column
TGT_ENTITY_ID NUMBER

Dimension identfying column
TGT_INTERCOMPANY_ID NUMBER

Dimension identfying column
TGT_TASK_ID NUMBER

Dimension identfying column
TGT_USER_DIM1_ID NUMBER

Dimension identfying column
TGT_USER_DIM2_ID NUMBER

Dimension identfying column
TGT_USER_DIM3_ID NUMBER

Dimension identfying column
TGT_USER_DIM4_ID NUMBER

Dimension identfying column
TGT_USER_DIM5_ID NUMBER

Dimension identfying column
TGT_USER_DIM6_ID NUMBER

Dimension identfying column
TGT_USER_DIM7_ID NUMBER

Dimension identfying column
TGT_USER_DIM8_ID NUMBER

Dimension identfying column
TGT_USER_DIM9_ID NUMBER

Dimension identfying column
TGT_USER_DIM10_ID NUMBER

Dimension identfying column
OFF_FINANCIAL_ELEM_ID NUMBER

Dimension identfying column
OFF_PRODUCT_ID NUMBER

Dimension identfying column
OFF_NATURAL_ACCOUNT_ID NUMBER

Dimension identfying column
OFF_CHANNEL_ID NUMBER

Dimension identfying column
OFF_LINE_ITEM_ID NUMBER

Dimension identfying column
OFF_PROJECT_ID NUMBER

Dimension identfying column
OFF_CUSTOMER_ID NUMBER

Dimension identfying column
OFF_ENTITY_ID NUMBER

Dimension identfying column
OFF_TASK_ID NUMBER

Dimension identfying column
OFF_USER_DIM1_ID NUMBER

Dimension identfying column
OFF_USER_DIM2_ID NUMBER

Dimension identfying column
OFF_USER_DIM3_ID NUMBER

Dimension identfying column
OFF_USER_DIM4_ID NUMBER

Dimension identfying column
OFF_USER_DIM5_ID NUMBER

Dimension identfying column
OFF_USER_DIM6_ID NUMBER

Dimension identfying column
OFF_USER_DIM7_ID NUMBER

Dimension identfying column
OFF_USER_DIM8_ID NUMBER

Dimension identfying column
OFF_USER_DIM9_ID NUMBER

Dimension identfying column
OFF_USER_DIM10_ID NUMBER

Dimension identfying column
AD_INPUT_AMOUNT NUMBER

Trial Balance Formula input
PE_INPUT_AMOUNT NUMBER

Parent Entity Formula input
CE_INPUT_AMOUNT NUMBER

Child Entity Formula input
EE_INPUT_AMOUNT NUMBER

Eliminations Formula input
OUTPUT_AMOUNT NUMBER

Formula output
BALANCE_FACTOR NUMBER

Balance column multiplier
ENTITY_ID NUMBER

Entity identifying column
YTD_CREDIT_BALANCE_E NUMBER

Credit balance input
YTD_DEBIT_BALANCE_E NUMBER

Debit balance input

[top of page]

GCS.GCS_ENTRIES_GT does not reference any database object

GCS.GCS_ENTRIES_GT is referenced by following:

APPS
SYNONYM - GCS_ENTRIES_GT

[top of page]

Table: GCS_ENTRY_HEADERS

Description: GCS consolidation entry headers
Primary Key: GCS_ENTRY_HEADERS_PK
  1. ENTRY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ENTRY_HEADERS.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_ENTRY_HEADERS.ASSOC_ENTRY_ID GCS_ENTRY_HEADERS
GCS_ENTRY_HEADERS.RULE_ID GCS_ELIM_RULES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_CONS_ENG_RUN_DTLS.PRE_PROP_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_ENG_RUN_DTLS.PRE_PROP_STAT_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_ENG_RUN_DTLS.ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_ENG_RUN_DTLS.STAT_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.STAT_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.ORIGINAL_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.PRE_PROP_ENTRY_ID GCS_ENTRY_HEADERS
GCS_CONS_IMPACT_ANALYSES.PRE_PROP_ENTRY_ID GCS_ENTRY_HEADERS
GCS_ENTRY_HEADERS.ASSOC_ENTRY_ID GCS_ENTRY_HEADERS
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
GCS_ENTRY_HEADERS_U1 UNIQUE APPS_TS_TX_IDX ENTRY_ID
Columns
Name Datatype Length Mandatory Comments
ENTRY_ID NUMBER (15) Y Entry defining column
ENTRY_NAME VARCHAR2 (80) Y Entry Name
HIERARCHY_ID NUMBER (15) Y Hierarchy defining column
DISABLED_FLAG VARCHAR2 (1) Y Disabled Entry defining column (Y/N)
ENTITY_ID NUMBER (15) Y Entity defining column
CURRENCY_CODE VARCHAR2 (30) Y Currency Code
BALANCE_TYPE_CODE VARCHAR2 (30) Y Balance Type Code
START_CAL_PERIOD_ID NUMBER
Y Calendar period defining column
END_CAL_PERIOD_ID NUMBER

Calendar period defining column
YEAR_TO_APPLY_RE NUMBER (15)
Year to Begin Application of Calculated Lines
DESCRIPTION VARCHAR2 (240)
Description
ENTRY_TYPE_CODE VARCHAR2 (30) Y Entry Type Code
ASSOC_ENTRY_ID NUMBER (15)
Associated Recurring Entry ID
PROCESSED_RUN_NAME VARCHAR2 (80)
Consolidation Run defining column
CATEGORY_CODE VARCHAR2 (30) Y Processing Bucket
PROCESS_CODE VARCHAR2 (30) Y Consolidation Engine Process Code
SUSPENSE_EXCEEDED_FLAG VARCHAR2 (1)
Suspense Exceeded Flag
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
PERIOD_INIT_ENTRY_FLAG VARCHAR2 (1) Y Period initialization flag
RULE_ID NUMBER (15)
Rule Identifier
DISABLED_CAL_PERIOD_ID NUMBER

APPROVAL_STATUS_CODE VARCHAR2 (30)
WORKFLOW_KEY VARCHAR2 (80)

[top of page]

GCS.GCS_ENTRY_HEADERS does not reference any database object

GCS.GCS_ENTRY_HEADERS is referenced by following:

APPS
SYNONYM - GCS_ENTRY_HEADERS

[top of page]

Table: GCS_ENTRY_LINES

Description: GCS consolidation entry lines
Primary Key: GCS_ENTRY_LINES_PK
  1. ENTRY_ID
  2. COMPANY_COST_CENTER_ORG_ID
  3. INTERCOMPANY_ID
  4. LINE_ITEM_ID
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.

Columns
Name Datatype Length Mandatory Comments
ENTRY_ID NUMBER (15) Y Entry defining column
LINE_TYPE_CODE VARCHAR2 (30)
Line Type for Recurring Entries (BALANCE_SHEET, PROFIT_LOSS, CALCULATED)
DESCRIPTION VARCHAR2 (240)
Description
COMPANY_COST_CENTER_ORG_ID NUMBER
Y Dimension defining column
FINANCIAL_ELEM_ID NUMBER

Financial Element defining column
PRODUCT_ID NUMBER

Dimension defining column
NATURAL_ACCOUNT_ID NUMBER

Dimension defining column
CHANNEL_ID NUMBER

Dimension defining column
LINE_ITEM_ID NUMBER
Y Dimension defining column
PROJECT_ID NUMBER

Dimension defining column
CUSTOMER_ID NUMBER

Dimension defining column
INTERCOMPANY_ID NUMBER
Y Dimension defining column
TASK_ID NUMBER

Dimension defining column
USER_DIM1_ID NUMBER

Dimension defining column
USER_DIM2_ID NUMBER

Dimension defining column
USER_DIM3_ID NUMBER

Dimension defining column
USER_DIM4_ID NUMBER

Dimension defining column
USER_DIM5_ID NUMBER

Dimension defining column
USER_DIM6_ID NUMBER

Dimension defining column
USER_DIM7_ID NUMBER

Dimension defining column
USER_DIM8_ID NUMBER

Dimension defining column
USER_DIM9_ID NUMBER

Dimension defining column
USER_DIM10_ID NUMBER

Dimension defining column
XTD_BALANCE_E NUMBER

Period to date Balance
YTD_BALANCE_E NUMBER

Year to date Balance
PTD_DEBIT_BALANCE_E NUMBER

Period to date debit Balance
PTD_CREDIT_BALANCE_E NUMBER

Period to date credit Balance
YTD_DEBIT_BALANCE_E NUMBER

Year to date debit Balance
YTD_CREDIT_BALANCE_E NUMBER

Year to date credit Balance
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
ENTRY_LINE_NUMBER NUMBER (15)
Line Number

[top of page]

GCS.GCS_ENTRY_LINES does not reference any database object

GCS.GCS_ENTRY_LINES is referenced by following:

APPS
SYNONYM - GCS_ENTRY_LINES

[top of page]

Table: GCS_ENTRY_LINES_GT

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
ENTRY_ID NUMBER (15) Y Entry defining column
COMPANY_COST_CENTER_ORG_ID NUMBER
Y Organization dimension defining column
FINANCIAL_ELEM_ID NUMBER

Financial element dimension defining column
PRODUCT_ID NUMBER

Product dimension defining column
NATURAL_ACCOUNT_ID NUMBER

Natural account dimension defining column
CHANNEL_ID NUMBER

Channel dimension defining column
LINE_ITEM_ID NUMBER
Y Line Item dimension defining column
PROJECT_ID NUMBER

Project dimension defining column
CUSTOMER_ID NUMBER

Customer dimension defining column
INTERCOMPANY_ID NUMBER
Y Intercompany dimension defining column
TASK_ID NUMBER

Task dimension defining column
USER_DIM1_ID NUMBER

User-defined dimension defining column
USER_DIM2_ID NUMBER

User-defined dimension defining column
USER_DIM3_ID NUMBER

User-defined dimension defining column
USER_DIM4_ID NUMBER

User-defined dimension defining column
USER_DIM5_ID NUMBER

User-defined dimension defining column
USER_DIM6_ID NUMBER

User-defined dimension defining column
USER_DIM7_ID NUMBER

User-defined dimension defining column
USER_DIM8_ID NUMBER

User-defined dimension defining column
USER_DIM9_ID NUMBER

User-defined dimension defining column
USER_DIM10_ID NUMBER

User-defined dimension defining column
XTD_BALANCE_E NUMBER

Period to date amount
YTD_BALANCE_E NUMBER

Year to date amount
PTD_DEBIT_BALANCE_E NUMBER

Period to date debit amount
PTD_CREDIT_BALANCE_E NUMBER

Period to date credit amount
YTD_DEBIT_BALANCE_E NUMBER

Year to date debit amount
YTD_CREDIT_BALANCE_E NUMBER

Year to date credit amount
CAL_PERIOD_ID NUMBER

Calendar period defining column
RECEIVABLES_ORG_ID NUMBER

Receivables organization dimension defining column
DESCRIPTION VARCHAR2 (240)
Description
PAYABLES_ORG_ID NUMBER

Payables organization dimension defining column

[top of page]

GCS.GCS_ENTRY_LINES_GT does not reference any database object

GCS.GCS_ENTRY_LINES_GT is referenced by following:

APPS
SYNONYM - GCS_ENTRY_LINES_GT

[top of page]

Table: GCS_EPB_DIM_MAPS

Description: Dimension mapping from FCH to EPB.
Primary Key: GCS_EPB_DIM_MAPS_PK
  1. GCS_COLUMN
Comments

GCS_ EPB_DIM_MAPS stores the dimension mapping from FCH to EPB for reporting in EPB.

Indexes
Index Type Tablespace Column
GCS_EPB_DIM_MAPS_U1 UNIQUE APPS_TS_SEED GCS_COLUMN
Columns
Name Datatype Length Mandatory Comments
GCS_COLUMN VARCHAR2 (30) Y GCS column
EPB_COLUMN VARCHAR2 (30) Y EPB column
ENABLED_FLAG VARCHAR2 (1) Y Enabled flag
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
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
HRATE_ENABLED_FLAG VARCHAR2 (1)
Historical rates enabled flag

[top of page]

GCS.GCS_EPB_DIM_MAPS does not reference any database object

GCS.GCS_EPB_DIM_MAPS is referenced by following:

APPS
SYNONYM - GCS_EPB_DIM_MAPS

[top of page]

Table: GCS_FEM_POSTING_GT

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
ENTRY_ID NUMBER (15) Y
CURRENCY_CODE VARCHAR2 (30) Y
COMPANY_COST_CENTER_ORG_ID NUMBER
Y
FINANCIAL_ELEM_ID NUMBER

PRODUCT_ID NUMBER

NATURAL_ACCOUNT_ID NUMBER

CHANNEL_ID NUMBER

LINE_ITEM_ID NUMBER
Y
PROJECT_ID NUMBER

CUSTOMER_ID NUMBER

INTERCOMPANY_ID NUMBER
Y
TASK_ID NUMBER

ENTITY_ID NUMBER

USER_DIM1_ID NUMBER

USER_DIM2_ID NUMBER

USER_DIM3_ID NUMBER

USER_DIM4_ID NUMBER

USER_DIM5_ID NUMBER

USER_DIM6_ID NUMBER

USER_DIM7_ID NUMBER

USER_DIM8_ID NUMBER

USER_DIM9_ID NUMBER

USER_DIM10_ID NUMBER

XTD_BALANCE_E NUMBER

YTD_BALANCE_E NUMBER

PTD_DEBIT_BALANCE_E NUMBER

PTD_CREDIT_BALANCE_E NUMBER

YTD_DEBIT_BALANCE_E NUMBER

YTD_CREDIT_BALANCE_E NUMBER

SEQUENCE_NUM NUMBER
Y

[top of page]

GCS.GCS_FEM_POSTING_GT does not reference any database object

GCS.GCS_FEM_POSTING_GT is referenced by following:

APPS
SYNONYM - GCS_FEM_POSTING_GT

[top of page]

Table: GCS_FLATTENED_RELNS

Description:
Comments

GCS_FLATTENED_RELNS stores all children for a particular parent at the time of consolidation

Indexes
Index Type Tablespace Column
GCS_FLATTENED_RELNS_U1 UNIQUE APPS_TS_TX_IDX RUN_NAME
PARENT_ENTITY_ID
CHILD_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
RUN_NAME VARCHAR2 (240)
Run Identifer defining column
PARENT_ENTITY_ID NUMBER

Parent Entity defining column
CHILD_ENTITY_ID NUMBER

Child Entity defining column
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
OBJECT_VERSION_NUMBER NUMBER (15) Y Standard Who Column
CONSOLIDATION_TYPE_CODE VARCHAR2 (30)
Consolidation Type Identifier

[top of page]

GCS.GCS_FLATTENED_RELNS does not reference any database object

GCS.GCS_FLATTENED_RELNS is referenced by following:

APPS
SYNONYM - GCS_FLATTENED_RELNS

[top of page]

Table: GCS_HIERARCHIES_B

Description: GCS hierarchy header information
Primary Key: GCS_HIERARCHIES_B_PK
  1. HIERARCHY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_HIERARCHIES_B.THRESHOLD_CURRENCY FND_CURRENCIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_CONS_RELATIONSHIPS.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_DATASET_CODES.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_DIMENSION_TEMPLATES.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_ENTITY_CONS_ATTRS.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_ENTRY_HEADERS.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_HIERARCHIES_TL.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_HISTORICAL_RATES.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_INTERCO_ELM_TRX.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_ROLE_HIER_RELNS.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_TRANSLATION_STATUSES.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_TRANSLATION_TRACK_H.HIERARCHY_ID GCS_HIERARCHIES_B
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
GCS_HIERARCHIES_B_U1 UNIQUE APPS_TS_SEED HIERARCHY_ID
Columns
Name Datatype Length Mandatory Comments
HIERARCHY_ID NUMBER (15) Y Consolidation hierarchy defining column
TOP_ENTITY_ID NUMBER
Y Top entity defining column
START_DATE DATE
Y Consolidation hierarchy start date
CALENDAR_ID NUMBER
Y Time dimension hierarchy defining column
DIMENSION_GROUP_ID NUMBER (9) Y Dimension group defining column
IE_BY_ORG_CODE VARCHAR2 (30) Y Code to mark if intercompany eliminations is matched by organization, company, or cost center
BALANCE_BY_ORG_FLAG VARCHAR2 (1) Y Flag to mark if the hierarchy will balance by organization in addition to entity
ENABLED_FLAG VARCHAR2 (1) Y Flag to mark if a hierarchy is usable
THRESHOLD_AMOUNT NUMBER
Y Threshold amount
THRESHOLD_CURRENCY VARCHAR2 (15) Y Currency of the threshold amount
FEM_LEDGER_ID NUMBER
Y Ledger dimension defining column
COLUMN_NAME VARCHAR2 (30)
Additional tracking dimension defining column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
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
LOB_REPORTING_ENABLED_FLAG VARCHAR2 (1)
Flag to mark line of business reporting for intercompany eliminations.
LOB_HIERARCHY_OBJ_ID NUMBER

Line of business hierarchy defining column.
LOB_DIM_COLUMN_NAME VARCHAR2 (30)
Line of business tracking column.
SECURITY_ENABLED_FLAG VARCHAR2 (1)
Flag to enabled security
CERTIFICATION_FLAG VARCHAR2 (1) Y Flag to certification hierarchy
HIERARCHY_GRP_FLAG VARCHAR2 (1)

[top of page]

GCS.GCS_HIERARCHIES_B does not reference any database object

GCS.GCS_HIERARCHIES_B is referenced by following:

APPS
SYNONYM - GCS_HIERARCHIES_B

[top of page]

Table: GCS_HIERARCHIES_TL

Description: GCS consolidation hierarchy header name and description information
Primary Key: GCS_HIERARCHIES_TL_PK
  1. HIERARCHY_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_HIERARCHIES_TL.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_HIERARCHIES_TL.LANGUAGE FND_LANGUAGES
GCS_HIERARCHIES_TL.SOURCE_LANG FND_LANGUAGES
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
GCS_HIERARCHIES_TL_U1 UNIQUE APPS_TS_SEED HIERARCHY_ID
LANGUAGE
GCS_HIERARCHIES_TL_U2 UNIQUE APPS_TS_SEED HIERARCHY_NAME
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
HIERARCHY_ID NUMBER (15) Y Consolidation hierarchy defining column
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Language in which the translatable names were entered into the system
HIERARCHY_NAME VARCHAR2 (150) Y User-defined consolidation hierarchy name
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
DESCRIPTION VARCHAR2 (240)
Consolidation hierarchy description

[top of page]

GCS.GCS_HIERARCHIES_TL does not reference any database object

GCS.GCS_HIERARCHIES_TL is referenced by following:

APPS
SYNONYM - GCS_HIERARCHIES_TL

[top of page]

Table: GCS_HIER_GRP_MEMBERS

Description:
Primary Key: GCS_HIER_GRP_MEMBERS_PK
  1. HIERARCHY_GRP_ID
  2. HIERARCHY_ID
Comments
Indexes
Index Type Tablespace Column
GCS_HIER_GRP_MEMBERS_U1 UNIQUE APPS_TS_TX_IDX HIERARCHY_GRP_ID
HIERARCHY_ID
Columns
Name Datatype Length Mandatory Comments
HIERARCHY_GRP_ID NUMBER (15) Y
HIERARCHY_ID NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

GCS.GCS_HIER_GRP_MEMBERS does not reference any database object

GCS.GCS_HIER_GRP_MEMBERS is referenced by following:

APPS
SYNONYM - GCS_HIER_GRP_MEMBERS

[top of page]

Table: GCS_HIER_MEMBERS_T

Description: FCH dimension hierarchy members
Comments

GCS_HIER_MEMBERS_T stores dimension hierarchies data to be loaded into FEM schema.

Columns
Name Datatype Length Mandatory Comments
SEQUENCE_NUM NUMBER (15) Y Sequence number
PARENT_VS_DISPLAY_CODE VARCHAR2 (150) Y Parent value set display code
PARENT_DISPLAY_CODE VARCHAR2 (150)
Parent display code
CHILD_VS_DISPLAY_CODE VARCHAR2 (150) Y Child value set display code
CHILD_DISPLAY_CODE VARCHAR2 (150) Y Child display code
OBJECT_VERSION_NUMBER NUMBER (15) Y Change defining column
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]

GCS.GCS_HIER_MEMBERS_T does not reference any database object

GCS.GCS_HIER_MEMBERS_T is referenced by following:

APPS
SYNONYM - GCS_HIER_MEMBERS_T

[top of page]

Table: GCS_HISTORICAL_RATES

Description: GCS historical rates information
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_HISTORICAL_RATES.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_HISTORICAL_RATES.FROM_CURRENCY FND_CURRENCIES
GCS_HISTORICAL_RATES.TO_CURRENCY FND_CURRENCIES
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.

Columns
Name Datatype Length Mandatory Comments
ENTITY_ID NUMBER
Y Entity defining column
HIERARCHY_ID NUMBER (15) Y Hierarchy defining column
CAL_PERIOD_ID NUMBER
Y Calendar period identifying column
FROM_CURRENCY VARCHAR2 (15) Y From currency code
TO_CURRENCY VARCHAR2 (15) Y To currency code
COMPANY_COST_CENTER_ORG_ID NUMBER

Organization dimension defining column
FINANCIAL_ELEM_ID NUMBER

Financial element dimension defining column
PRODUCT_ID NUMBER

Product dimension defining column
NATURAL_ACCOUNT_ID NUMBER

Natural account dimension defining column
CHANNEL_ID NUMBER

Channel dimension defining column
LINE_ITEM_ID NUMBER

Line item dimension defining column
PROJECT_ID NUMBER

Project dimension defining column
CUSTOMER_ID NUMBER

Customer dimension defining column
INTERCOMPANY_ID NUMBER

Intercompany dimension defining
TASK_ID NUMBER

Task dimension defining column
USER_DIM1_ID NUMBER

User-defined dimension defining column
USER_DIM2_ID NUMBER

User-defined dimension defining column
USER_DIM3_ID NUMBER

User-defined dimension defining column
USER_DIM4_ID NUMBER

User-defined dimension defining column
USER_DIM5_ID NUMBER

User-defined dimension defining column
USER_DIM6_ID NUMBER

User-defined dimension defining column
USER_DIM7_ID NUMBER

User-defined dimension defining column
USER_DIM8_ID NUMBER

User-defined dimension defining column
USER_DIM9_ID NUMBER

User-defined dimension defining column
USER_DIM10_ID NUMBER

User-defined dimension defining column
TRANSLATED_RATE NUMBER

Historical rate
TRANSLATED_AMOUNT NUMBER

Historical amount
RATE_TYPE_CODE VARCHAR2 (30)
Historical rate type
UPDATE_FLAG VARCHAR2 (1) Y Update flag
ACCOUNT_TYPE_CODE VARCHAR2 (30)
Account type
STOP_ROLLFORWARD_FLAG VARCHAR2 (1) Y Stop roll forward year to date rate flag
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
STANDARD_RE_RATE_FLAG VARCHAR2 (1)

[top of page]

GCS.GCS_HISTORICAL_RATES does not reference any database object

GCS.GCS_HISTORICAL_RATES is referenced by following:

APPS
SYNONYM - GCS_HISTORICAL_RATES

[top of page]

Table: GCS_INTERCO_ELM_TRX

Description: Intercompany transactions table.
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_INTERCO_ELM_TRX.HIERARCHY_ID GCS_HIERARCHIES_B
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
GCS_INTERCO_ELM_TRX_N1 NONUNIQUE APPS_TS_TX_IDX HIERARCHY_ID
CAL_PERIOD_ID
CURRENCY_CODE
GCS_INTERCO_ELM_TRX_N2 NONUNIQUE APPS_TS_TX_IDX SRC_ENTITY_ID
TARGET_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
HIERARCHY_ID NUMBER (15) Y Foriegn key to the consolidation hierarchy defining column
CAL_PERIOD_ID NUMBER
Y Calendar Period defining column
SRC_COMPANY_ID NUMBER

Source company defining column
SRC_COST_CENTER_ID NUMBER

Source cost center defining column
SRC_ENTITY_ID NUMBER

Source entity defining column
COMPANY_COST_CENTER_ORG_ID NUMBER
Y Organization dimension defining column
INTERCOMPANY_ID NUMBER
Y Intercompany dimension defining column
TARGET_COMPANY_ID NUMBER

Target company defining column
TARGET_COST_CENTER_ID NUMBER

Target cost center defining column
TARGET_ENTITY_ID NUMBER

Target entity defining column
CURRENCY_CODE VARCHAR2 (15) Y Currency Code
FINANCIAL_ELEM_ID NUMBER

Financial element dimension defining column
PRODUCT_ID NUMBER

Product dimension defining column
NATURAL_ACCOUNT_ID NUMBER

Natural account dimension defining column
CHANNEL_ID NUMBER

Channel dimension defining column
LINE_ITEM_ID NUMBER
Y Line item dimension defining column
PROJECT_ID NUMBER

Project dimension defining column
CUSTOMER_ID NUMBER

Customer dimension defining column
TASK_ID NUMBER

Task dimension defining column
USER_DIM1_ID NUMBER

User-defined dimension identifying column
USER_DIM2_ID NUMBER

User-defined dimension identifying column
USER_DIM3_ID NUMBER

User-defined dimension identifying column
USER_DIM4_ID NUMBER

User-defined dimension identifying column
USER_DIM5_ID NUMBER

User-defined dimension identifying column
USER_DIM6_ID NUMBER

User-defined dimension identifying column
USER_DIM7_ID NUMBER

User-defined dimension identifying column
USER_DIM8_ID NUMBER

User-defined dimension identifying column
USER_DIM9_ID NUMBER

User-defined dimension identifying column
USER_DIM10_ID NUMBER

User-defined dimension identifying column
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
ELIM_LOB_ID NUMBER

Common elimination line of business defining column.

[top of page]

GCS.GCS_INTERCO_ELM_TRX does not reference any database object

GCS.GCS_INTERCO_ELM_TRX is referenced by following:

APPS
SYNONYM - GCS_INTERCO_ELM_TRX

[top of page]

Table: GCS_INTERCO_MAP_DTLS

Description: Intercompany Mapping information
Primary Key: GCS_INTERCO_MAP_DTLS_PK
  1. LINE_ITEM_ID
  2. LNITEM_VALUE_SET_ID
  3. INTERCOMPANY_ID
  4. INTERCOMPANY_VALUE_SET_ID
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
GCS_INTERCO_MAP_DTLS_U1 UNIQUE APPS_TS_SEED LINE_ITEM_ID
LNITEM_VALUE_SET_ID
INTERCOMPANY_ID
INTERCOMPANY_VALUE_SET_ID
Columns
Name Datatype Length Mandatory Comments
LINE_ITEM_ID NUMBER
Y Line Item Id
LNITEM_VALUE_SET_ID NUMBER
Y Line Item Value set Id
INTERCOMPANY_ID NUMBER
Y Intercompany Id
INTERCOMPANY_VALUE_SET_ID NUMBER
Y Intercompany Value set Id
OBJECT_VERSION_NUMBER NUMBER (15)
Object version number
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]

GCS.GCS_INTERCO_MAP_DTLS does not reference any database object

GCS.GCS_INTERCO_MAP_DTLS is referenced by following:

APPS
SYNONYM - GCS_INTERCO_MAP_DTLS

[top of page]

Table: GCS_INTERCO_MEMBERS

Description: Intercompany line item elimination sets
Primary Key: GCS-INTERCO_MEMBERS_PK
  1. RULE_ID
  2. LINE_ITEM_GROUP
  3. LINE_ITEM_ID
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
GCS_INTERCO_MEMBERS_U1 UNIQUE APPS_TS_SEED RULE_ID
LINE_ITEM_GROUP
LINE_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER (15) Y Foriegn key to the intercompany rule defining column
LINE_ITEM_GROUP NUMBER
Y Line item group
LINE_ITEM_ID NUMBER
Y Foreign key to the line item dimension
OBJECT_VERSION_NUMBER NUMBER (15) Y OA Framework required column
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]

GCS.GCS_INTERCO_MEMBERS does not reference any database object

GCS.GCS_INTERCO_MEMBERS is referenced by following:

APPS
SYNONYM - GCS_INTERCO_MEMBERS

[top of page]

Table: GCS_INTERCO_RULES_B

Description: GCS intercompany rules header
Primary Key: GCS_INETRCO_RULES_B_PK
  1. RULE_ID
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
GCS_INTERCO_RULES_B_U1 UNIQUE APPS_TS_SEED RULE_ID
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER (15) Y Intercompany rule defining column
ENABLED_FLAG VARCHAR2 (1) Y Enabled flag
THRESHOLD_AMOUNT NUMBER
Y Threshold amount for intercompany rule suspense handling
THRESHOLD_CURRENCY VARCHAR2 (30) Y Threshold amount currency code
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
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
SUS_FINANCIAL_ELEM_ID NUMBER

Foreign key to the Financial Element dimension
SUS_PRODUCT_ID NUMBER

Foreign key to the Product dimension
SUS_NATURAL_ACCOUNT_ID NUMBER

Foreign key to the Natural Account dimension
SUS_CHANNEL_ID NUMBER

Foreign key to the Channel dimension
SUS_LINE_ITEM_ID NUMBER

Foreign key to the Line Item dimension
SUS_PROJECT_ID NUMBER

Foreign key to the Project dimension
SUS_CUSTOMER_ID NUMBER

Foreign key to the Customer dimension
SUS_TASK_ID NUMBER

Foreign key to the Task dimension
SUS_USER_DIM1_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM2_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM3_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM4_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM5_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM6_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM7_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM8_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM9_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM10_ID NUMBER

Foreign key to user defined dimension

[top of page]

GCS.GCS_INTERCO_RULES_B does not reference any database object

GCS.GCS_INTERCO_RULES_B is referenced by following:

APPS
SYNONYM - GCS_INTERCO_RULES_B

[top of page]

Table: GCS_INTERCO_RULES_TL

Description: Translation table for GCS_INTERCO_RULES_B
Primary Key: GCS_INTERCO_RULES_TL_PK
  1. RULE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_INTERCO_RULES_TL.RULE_ID %
GCS_INTERCO_RULES_TL.LANGUAGE FND_LANGUAGES
GCS_INTERCO_RULES_TL.SOURCE_LANG FND_LANGUAGES
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
GCS_INTERCO_RULES_TL_U1 UNIQUE APPS_TS_SEED RULE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER (15) Y Intercompany rule defining column
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Language in which the translatable names were entered into the system
RULE_NAME VARCHAR2 (50) Y User entered intercompany elimination rule name
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
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
DESCRIPTION VARCHAR2 (240)
Intercompany elimination rule description

[top of page]

GCS.GCS_INTERCO_RULES_TL does not reference any database object

GCS.GCS_INTERCO_RULES_TL is referenced by following:

APPS
SYNONYM - GCS_INTERCO_RULES_TL

[top of page]

Table: GCS_LEX_MAP_COLUMNS

Description: Columns in an Interface Data Transformer staging table
Primary Key: GCS_LEX_MAP_COLUMNS_PK
  1. COLUMN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_COLUMNS.STRUCTURE_ID GCS_LEX_MAP_STRUCTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_CONDITIONS.SOURCE_COLUMN_ID GCS_LEX_MAP_COLUMNS
GCS_LEX_MAP_DERIVATIONS.LOOKUP_RESULT_COLUMN_ID GCS_LEX_MAP_COLUMNS
GCS_LEX_MAP_DRV_DETAILS.DETAIL_COLUMN_ID GCS_LEX_MAP_COLUMNS
GCS_LEX_MAP_DRV_DETAILS.LOOKUP_COLUMN_ID GCS_LEX_MAP_COLUMNS
GCS_LEX_MAP_RULES.TARGET_COLUMN_ID GCS_LEX_MAP_COLUMNS
Comments

GCS_LEX_MAP_COLUMNS stores the columns in the Interface Data Transformer table structures that are defined by GCS_LEX_MAP_STRUCTS. Each column can be read-only or read-write.

Indexes
Index Type Tablespace Column
GCS_LEX_MAP_COLUMNS_U1 UNIQUE APPS_TS_TX_IDX COLUMN_ID
GCS_LEX_MAP_COLUMNS_U2 UNIQUE APPS_TS_TX_IDX STRUCTURE_ID
COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
COLUMN_ID NUMBER (15) Y Staging table column defining column
STRUCTURE_ID NUMBER (15) Y Staging table structure defining column
COLUMN_NAME VARCHAR2 (30) Y Staging table column name
COLUMN_TYPE_CODE VARCHAR2 (30) Y Data type stored by the column. This can be 'V' for VARCHAR2, 'N' for NUMBER, or 'D' for DATE
WRITE_FLAG VARCHAR2 (1) Y Ability to write to staging table column flag
ERROR_CODE_COLUMN_FLAG VARCHAR2 (1) Y Stores error codes in column flag
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]

GCS.GCS_LEX_MAP_COLUMNS does not reference any database object

GCS.GCS_LEX_MAP_COLUMNS is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_COLUMNS

[top of page]

Table: GCS_LEX_MAP_CONDITIONS

Description: Transformation Rule Set conditions
Primary Key: GCS_LEX_MAP_CONDITIONS_PK
  1. CONDITION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_CONDITIONS.DERIVATION_ID GCS_LEX_MAP_DERIVATIONS
GCS_LEX_MAP_CONDITIONS.SOURCE_COLUMN_ID GCS_LEX_MAP_COLUMNS
Comments

GCS_LEX_MAP_CONDITIONS defines the conditions for a derivation action. Each condition is a comparison of an interface table column value against a constant value or null. All conditions for a derivation must be met before the derivation is applied.

Indexes
Index Type Tablespace Column
GCS_LEX_MAP_CONDITIONS_U1 UNIQUE APPS_TS_TX_IDX CONDITION_ID
GCS_LEX_MAP_CONDITIONS_N1 NONUNIQUE APPS_TS_TX_IDX DERIVATION_ID
Columns
Name Datatype Length Mandatory Comments
CONDITION_ID NUMBER (15) Y Condition identifier
DERIVATION_ID NUMBER (15) Y Derivation identifier
SOURCE_COLUMN_ID NUMBER (15) Y Source column to compare
COMPARISON_OPERATOR_CODE VARCHAR2 (30) Y Operators such as =, <>, like, or is not null
COMPARISON_VALUE VARCHAR2 (100)
Constant value against which to compare the Source Column. The comparison value is null if the comparison operator is set to is null or is not null.
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]

GCS.GCS_LEX_MAP_CONDITIONS does not reference any database object

GCS.GCS_LEX_MAP_CONDITIONS is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_CONDITIONS

[top of page]

Table: GCS_LEX_MAP_DERIVATIONS

Description: Transformation Rule Set derivation
Primary Key: GCS_LEX_MAP_DERIVATIONS_PK
  1. DERIVATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_DERIVATIONS.RULE_ID GCS_LEX_MAP_RULES
GCS_LEX_MAP_DERIVATIONS.LOOKUP_TABLE_ID GCS_LEX_MAP_STRUCTS
GCS_LEX_MAP_DERIVATIONS.LOOKUP_RESULT_COLUMN_ID GCS_LEX_MAP_COLUMNS
GCS_LEX_MAP_DERIVATIONS.FUNCTION_NAME GCS_LEX_MAP_PLSQL_FUNCS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_CONDITIONS.DERIVATION_ID GCS_LEX_MAP_DERIVATIONS
GCS_LEX_MAP_DRV_DETAILS.DERIVATION_ID GCS_LEX_MAP_DERIVATIONS
Comments

GCS_LEX_MAP_DERIVATIONS contains the derivation actions for populating a particular target column for a rule. Each derivation has a sequence number associated with it in the rule.

Indexes
Index Type Tablespace Column
GCS_LEX_MAP_DERIVATIONS_U1 UNIQUE APPS_TS_TX_IDX DERIVATION_ID
GCS_LEX_MAP_DERIVATIONS_N1 NONUNIQUE APPS_TS_TX_IDX RULE_ID
DERIVATION_SEQUENCE
Columns
Name Datatype Length Mandatory Comments
DERIVATION_ID NUMBER (15) Y Derivation identifier
RULE_ID NUMBER (15) Y Rule identifier
DERIVATION_SEQUENCE NUMBER
Y Sequence number for this derivation
DERIVATION_TYPE_CODE VARCHAR2 (30) Y STR(String Function), PLS(PL/SQL Function), or LUT(Lookup Table)
LOOKUP_TABLE_ID NUMBER (15)
Lookup table used if the derivation type is Lookup Table
LOOKUP_RESULT_COLUMN_ID NUMBER (15)
Result column used in the Lookup table if the derivation type is Lookup Table
FUNCTION_NAME VARCHAR2 (100)
PL/SQL function used if the derivation type is PL/SQL
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]

GCS.GCS_LEX_MAP_DERIVATIONS does not reference any database object

GCS.GCS_LEX_MAP_DERIVATIONS is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_DERIVATIONS

[top of page]

Table: GCS_LEX_MAP_DRV_DETAILS

Description: Transformation Rule Set derivation details
Primary Key: GCS_LEX_MAP_DRV_DETAILS_PK
  1. DERIVATION_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_DRV_DETAILS.DERIVATION_ID GCS_LEX_MAP_DERIVATIONS
GCS_LEX_MAP_DRV_DETAILS.DETAIL_COLUMN_ID GCS_LEX_MAP_COLUMNS
GCS_LEX_MAP_DRV_DETAILS.LOOKUP_COLUMN_ID GCS_LEX_MAP_COLUMNS
Comments

GCS_LEX_MAP_DRV_DETAILS defines the details for a derivation action such as the String Function, PL/SQL Function, and Lookup Table derivations. Derivation details include an interface table column, a PL/SQL parameter, constants, and string length.

Indexes
Index Type Tablespace Column
GCS_LEX_MAP_DRV_DETAILS_U1 UNIQUE APPS_TS_TX_IDX DERIVATION_DETAIL_ID
GCS_LEX_MAP_DRV_DETAILS_N1 NONUNIQUE APPS_TS_TX_IDX DERIVATION_ID
Columns
Name Datatype Length Mandatory Comments
DERIVATION_DETAIL_ID NUMBER (15) Y Derivation detail identifier
DERIVATION_ID NUMBER (15) Y Derivation identifier
DETAIL_COLUMN_ID NUMBER (15)
Staging table column used for copy string, substring, matching to a lookup table column, and PL/SQL parameters
DETAIL_CONSTANT VARCHAR2 (100)
Constant value used for fixed string, matching to a lookup table column, and PL/SQL parameter
STRING_MERGE_ORDER NUMBER

Sequence number for string function
STRING_ACTION_TYPE_CODE VARCHAR2 (30)
S(Get Substring), C(Copy String), or F(Assign Fixed String)
SUBSTRING_START_INDEX NUMBER

Index to begin substring
SUBSTRING_LENGTH NUMBER

Length of substring
LOOKUP_COLUMN_ID NUMBER (15)
Lookup table column for matching
PLSQL_PARAM_NAME VARCHAR2 (50)
PL/SQL function parameter name
PLSQL_PARAM_SOURCE_CODE VARCHAR2 (30)
C(Column), S(String), or N(Number)
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]

GCS.GCS_LEX_MAP_DRV_DETAILS does not reference any database object

GCS.GCS_LEX_MAP_DRV_DETAILS is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_DRV_DETAILS

[top of page]

Table: GCS_LEX_MAP_PLSQL_FUNCS

Description: Transformation Rule Set PL/SQL Functions
Primary Key: GCS_LEX_MAP_PLSQL_FUNCS_PK
  1. FUNCTION_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_DERIVATIONS.FUNCTION_NAME GCS_LEX_MAP_PLSQL_FUNCS
Comments

GCS_LEX_MAP_ PLSQL_FUNCS stores the PL/SQL functions that may be used by a Transformation Rule Set. PL/SQL functions are necessary for PL/SQL Derivation Sequence definition.

Indexes
Index Type Tablespace Column
GCS_LEX_MAP_PLSQL_FUNCS_U1 UNIQUE APPS_TS_TX_IDX FUNCTION_NAME
Columns
Name Datatype Length Mandatory Comments
FUNCTION_NAME VARCHAR2 (100) Y Function name
DESCRIPTION VARCHAR2 (240)
Function description
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]

GCS.GCS_LEX_MAP_PLSQL_FUNCS does not reference any database object

GCS.GCS_LEX_MAP_PLSQL_FUNCS is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_PLSQL_FUNCS

[top of page]

Table: GCS_LEX_MAP_RULES

Description: Transformation Rule Set Rule
Primary Key: GCS_LEX_MAP_RULES_PK
  1. RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_RULES.RULE_STAGE_ID GCS_LEX_MAP_RULE_STAGES
GCS_LEX_MAP_RULES.TARGET_COLUMN_ID GCS_LEX_MAP_COLUMNS
GCS_LEX_MAP_RULES.LOOKUP_TABLE_ID GCS_LEX_MAP_STRUCTS
GCS_LEX_MAP_RULES.VALUE_SET_ID FND_FLEX_VALUE_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_DERIVATIONS.RULE_ID GCS_LEX_MAP_RULES
Comments

GCS_LEX_MAP_RULES contains rules that are defined for target columns in a stage of a Transformation Rule Set. A rule consists of one or more conditional derivations, and can be validated using a Lookup Table or a Value Set. Only one rule may be defined for a particular target column within a stage. Additional rules can be defined for the same target column as long as the rules are contained in different stages.

Indexes
Index Type Tablespace Column
GCS_LEX_MAP_RULES_U1 UNIQUE APPS_TS_TX_IDX RULE_ID
GCS_LEX_MAP_RULES_U2 UNIQUE APPS_TS_TX_IDX RULE_STAGE_ID
TARGET_COLUMN_ID
SYS_IL0000326089C00013$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER (15) Y Rule identifier
RULE_STAGE_ID NUMBER (15) Y Stage identifier
TARGET_COLUMN_ID NUMBER (15) Y Rule target column
VALIDATION_TYPE_CODE VARCHAR2 (30) Y L(Lookup Table), V(Value Set), or N(None) for transformation rule sets, and CONDITION, LOOKUP, or PLSQL for validation rule sets
VALUE_SET_ID NUMBER (15)
Value set used if the validation type is Value Set
LOOKUP_TABLE_ID NUMBER (15)
Lookup table used if the validation type is Lookup Table
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
RULE_NAME VARCHAR2 (30)
User entered rule name
ERROR_MESSAGE CLOB (4000)
Error message for validation rules

[top of page]

GCS.GCS_LEX_MAP_RULES does not reference any database object

GCS.GCS_LEX_MAP_RULES is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_RULES

[top of page]

Table: GCS_LEX_MAP_RULE_SETS

Description: Transformation Rule Set definition
Primary Key: GCS_LEX_MAP_RULE_SETS_PK
  1. RULE_SET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_RULE_SETS.STRUCTURE_ID GCS_LEX_MAP_STRUCTS
GCS_LEX_MAP_RULE_SETS.ASSOCIATED_OBJECT_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_DATA_SUB_DTLS.RULE_SET_ID GCS_LEX_MAP_RULE_SETS
GCS_DATA_SUB_DTLS.VALIDATION_RULE_SET_ID GCS_LEX_MAP_RULE_SETS
GCS_LEX_MAP_RULE_STAGES.RULE_SET_ID GCS_LEX_MAP_RULE_SETS
Comments

GCS_LEX_MAP_RULE_SETS stores the Transformation Rule Sets. Each Rule Set is assigned a name for identification, an associated staging table structure, and an enabled or disabled flag.

Indexes
Index Type Tablespace Column
GCS_LEX_MAP_RULE_SETS_U1 UNIQUE APPS_TS_TX_IDX RULE_SET_ID
GCS_LEX_MAP_RULE_SETS_U2 UNIQUE APPS_TS_TX_IDX NAME
GCS_LEX_MAP_RULE_SETS_U3 UNIQUE APPS_TS_TX_IDX ASSOCIATED_OBJECT_ID
Columns
Name Datatype Length Mandatory Comments
RULE_SET_ID NUMBER (15) Y Rule Set identifier
NAME VARCHAR2 (30) Y Rule Set name
STRUCTURE_ID NUMBER (15) Y Table structure identifier
ENABLED_FLAG VARCHAR2 (1) Y Y(Enabled) or N(Disabled)
DESCRIPTION VARCHAR2 (240)
Rule Set description
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
RULE_SET_TYPE_CODE VARCHAR2 (30) Y TRANSFORMATION or VALIDATION
ASSOCIATED_OBJECT_ID NUMBER
Y Foreign key to Object Dimension defining column

[top of page]

GCS.GCS_LEX_MAP_RULE_SETS does not reference any database object

GCS.GCS_LEX_MAP_RULE_SETS is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_RULE_SETS

[top of page]

Table: GCS_LEX_MAP_RULE_STAGES

Description: Transformation Rule Set Stage
Primary Key: GCS_LEX_MAP_RULE_STAGES_PK
  1. RULE_STAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_RULE_STAGES.RULE_SET_ID GCS_LEX_MAP_RULE_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_RULES.RULE_STAGE_ID GCS_LEX_MAP_RULE_STAGES
Comments

GCS_LEX_MAP_RULE_STAGES stores the stages of a Transformation Rule Set. Each Rule Set contains one or more stages, and each stage consists of one or more rules.

Indexes
Index Type Tablespace Column
GCS_LEX_MAP_RULE_STAGES_U1 UNIQUE APPS_TS_TX_IDX RULE_STAGE_ID
GCS_LEX_MAP_RULE_STAGES_N1 NONUNIQUE APPS_TS_TX_IDX RULE_SET_ID
STAGE_NUMBER
Columns
Name Datatype Length Mandatory Comments
RULE_STAGE_ID NUMBER (15) Y Stage identifier
RULE_SET_ID NUMBER (15) Y Rule Set identifier
STAGE_NUMBER NUMBER
Y Stage sequence number
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]

GCS.GCS_LEX_MAP_RULE_STAGES does not reference any database object

GCS.GCS_LEX_MAP_RULE_STAGES is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_RULE_STAGES

[top of page]

Table: GCS_LEX_MAP_STRUCTS

Description: Overall structure of an Interface Data Transformer staging table
Primary Key: GCS_LEX_MAP_STRUCTS_PK
  1. STRUCTURE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_LEX_MAP_COLUMNS.STRUCTURE_ID GCS_LEX_MAP_STRUCTS
GCS_LEX_MAP_DERIVATIONS.LOOKUP_TABLE_ID GCS_LEX_MAP_STRUCTS
GCS_LEX_MAP_RULES.LOOKUP_TABLE_ID GCS_LEX_MAP_STRUCTS
GCS_LEX_MAP_RULE_SETS.STRUCTURE_ID GCS_LEX_MAP_STRUCTS
Comments

GCS_LEX_MAP_STRUCTS defines the structures of tables that can be used as staging tables by the Interface Data Transformer. Each Transformation Rule Set must have a table structure associated with it. GCS_LEX_MAP_STRUCTS also keeps the list of tables that can be used as lookup tables.

Indexes
Index Type Tablespace Column
GCS_LEX_MAP_STRUCTS_U1 UNIQUE APPS_TS_TX_IDX STRUCTURE_ID
GCS_LEX_MAP_STRUCTS_U2 UNIQUE APPS_TS_TX_IDX STRUCTURE_NAME
TABLE_USE_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
STRUCTURE_ID NUMBER (15) Y Table structure defining column
STRUCTURE_NAME VARCHAR2 (50) Y Table structure name
TABLE_USE_TYPE_CODE VARCHAR2 (30) Y Table use lookup
DESCRIPTION VARCHAR2 (240)
Table structure description
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]

GCS.GCS_LEX_MAP_STRUCTS does not reference any database object

GCS.GCS_LEX_MAP_STRUCTS is referenced by following:

APPS
SYNONYM - GCS_LEX_MAP_STRUCTS

[top of page]

Table: GCS_LOBS

Description: Image Repository for Global Consolidation System
Primary Key: GCS_LOBS_PK
  1. FILE_ID
Comments

GCS_LOBS stores the images assigning to Operating and Consolidation entities

Indexes
Index Type Tablespace Column
GCS_LOBS_U1 UNIQUE APPS_TS_TX_IDX FILE_ID
SYS_IL0000399952C00004$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
FILE_ID NUMBER (15) Y File defining column
FILE_NAME VARCHAR2 (255)
File Name
FILE_CONTENT_TYPE VARCHAR2 (255)
File Content Type
FILE_DATA BLOB (4000)
File Data
UPLOAD_DATE DATE

Upload Date
EXPIRATION_DATE DATE

Expiration Date
PROGRAM_NAME VARCHAR2 (40)
Program Name
PROGRAM_TAG VARCHAR2 (40)
Program Tag
LANGUAGE VARCHAR2 (4)
Language
ORACLE_CHARSET VARCHAR2 (30)
Oracle Character Set
FILE_FORMAT VARCHAR2 (10)
File Format
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
OBJECT_VERSION_NUMBER NUMBER (15) Y Change Indicator Column

[top of page]

GCS.GCS_LOBS does not reference any database object

GCS.GCS_LOBS is referenced by following:

APPS
SYNONYM - GCS_LOBS

[top of page]

Table: GCS_ROLE_ENTITY_RELNS

Description: Role and entity relationship information
Primary Key: GCS_ROLE_ENTITY_RELNS_PK
  1. ROLE_NAME
  2. ORIG_SYSTEM
  3. ORIG_SYSTEM_ID
  4. PARTITION_ID
  5. ENTITY_ID
Comments

GCS_ROLE_ENTITY_RELNS stores the relationship between a role and an entity.

Indexes
Index Type Tablespace Column
GCS_ROLE_ENTITY_RELNS_U1 UNIQUE APPS_TS_SEED ROLE_NAME
ORIG_SYSTEM_ID
PARTITION_ID
ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
ROLE_NAME VARCHAR2 (320) Y Role Name
ORIG_SYSTEM VARCHAR2 (30) Y Original system
ORIG_SYSTEM_ID NUMBER
Y Original system defining column
PARTITION_ID NUMBER
Y Partition defining column
ENTITY_ID NUMBER (15) Y Entity defining column
OBJECT_VERSION_NUMBER NUMBER (15)
Object version number
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]

GCS.GCS_ROLE_ENTITY_RELNS does not reference any database object

GCS.GCS_ROLE_ENTITY_RELNS is referenced by following:

APPS
SYNONYM - GCS_ROLE_ENTITY_RELNS

[top of page]

Table: GCS_ROLE_HIER_RELNS

Description: Role and hierarchy relationship information
Primary Key: GCS_ROLE_HIER_RELNS_PK
  1. ROLE_NAME
  2. ORIG_SYSTEM
  3. ORIG_SYSTEM_ID
  4. PARTITION_ID
  5. HIERARCHY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_ROLE_HIER_RELNS.HIERARCHY_ID GCS_HIERARCHIES_B
Comments

GCS_ROLE_HIER_RELNS stores the relationship between a role and a hierarchy.

Indexes
Index Type Tablespace Column
GCS_ROLE_HIER_RELNS_U1 UNIQUE APPS_TS_SEED ROLE_NAME
ORIG_SYSTEM
ORIG_SYSTEM_ID
PARTITION_ID
HIERARCHY_ID
Columns
Name Datatype Length Mandatory Comments
ROLE_NAME VARCHAR2 (320) Y Role Name
ORIG_SYSTEM VARCHAR2 (30) Y Original system name
ORIG_SYSTEM_ID NUMBER
Y Original system defining column
PARTITION_ID NUMBER
Y Partition defining column
HIERARCHY_ID NUMBER (15) Y Hierarchy defining column
OBJECT_VERSION_NUMBER NUMBER (15)
Object version number
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]

GCS.GCS_ROLE_HIER_RELNS does not reference any database object

GCS.GCS_ROLE_HIER_RELNS is referenced by following:

APPS
SYNONYM - GCS_ROLE_HIER_RELNS

[top of page]

Table: GCS_RULE_SCOPE_DIMS

Description:
Primary Key: GCS_RULE_SCOPE_DIMS_PK
  1. RULE_STEP_ID
  2. COLUMN_NAME
Comments

GCS_RULE_SCOPE_DIMS stores the dimensions assigned and the respective target member information to the Rule Scope.

Indexes
Index Type Tablespace Column
GCS_RULE_SCOPE_DIMS_U1 UNIQUE APPS_TS_TX_IDX RULE_STEP_ID
COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
RULE_STEP_ID NUMBER (15) Y Foreign Key to Rule Step defining column
COLUMN_NAME VARCHAR2 (30) Y Foreign Key to Dimension defining column
ALL_SOURCE_MEMBERS_FLAG VARCHAR2 (1) Y Indicates whether Source Member is all-inclusive
HIERARCHY_OBJ_ID NUMBER

Foreign Key to Hierarchy defining column
TARGET_MEMBER_ID NUMBER (15)
Foreign Key to Target Member defining column
OFFSET_MEMBER_ID NUMBER (15)
Foreign Key to Offset Target Member defining column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Identifier

[top of page]

GCS.GCS_RULE_SCOPE_DIMS does not reference any database object

GCS.GCS_RULE_SCOPE_DIMS is referenced by following:

APPS
SYNONYM - GCS_RULE_SCOPE_DIMS

[top of page]

Table: GCS_RULE_SCOPE_DTLS

Description:
Primary Key: GCS_RULE_SCOPE_DTLS_PK
  1. RULE_STEP_ID
  2. COLUMN_NAME
  3. SOURCE_MEMBER_ID
Comments

GCS_RULE_SCOPE_DTLS stores the source members for a specific dimension

Indexes
Index Type Tablespace Column
GCS_RULE_SCOPE_DTLS_U1 UNIQUE APPS_TS_TX_IDX RULE_STEP_ID
COLUMN_NAME
SOURCE_MEMBER_ID
Columns
Name Datatype Length Mandatory Comments
RULE_STEP_ID NUMBER (15) Y Foreign Key to Rule Step defining column
COLUMN_NAME VARCHAR2 (30) Y Foreign Key to Rule Scope defining column
SOURCE_MEMBER_ID NUMBER
Y Foreign Key to Source Member defining column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Identifier

[top of page]

GCS.GCS_RULE_SCOPE_DTLS does not reference any database object

GCS.GCS_RULE_SCOPE_DTLS is referenced by following:

APPS
SYNONYM - GCS_RULE_SCOPE_DTLS

[top of page]

Table: GCS_SYSTEM_OPTIONS

Description: Stores system level setup for Financial Consolidation Hub.
Comments

GCS_SYSTEM_OPTIONS stores the system level setup for Financial Consolidation Hub.

Indexes
Index Type Tablespace Column
GCS_SYSTEM_OPTIONS_U1 UNIQUE APPS_TS_SEED SYSTEM_OPTION_ID
Columns
Name Datatype Length Mandatory Comments
EPB_TABLE_NAME VARCHAR2 (30)
Data table leveraged for EPB
LN_ITEM_HIERARCHY_OBJ_ID NUMBER (9)
Line Item hierarchy used for Aggregation
FCH_GLOBAL_VS_COMBO_ID NUMBER (9) Y Master Global Value Set Combination
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
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
SYSTEM_OPTION_ID NUMBER (15) Y System Option Identifier
AD_TEMPLATE_CODE VARCHAR2 (80)
Acquistion and Disposal Trial Balance Template.
DS_LOAD_TEMPLATE_CODE VARCHAR2 (80)
Data Submission Loaded Data Template
DS_TB_TEMPLATE_CODE VARCHAR2 (80)
Data Submission Trial Balance Template
ENTRY_TEMPLATE_CODE VARCHAR2 (80)
Entries Template
TB_TEMPLATE_CODE VARCHAR2 (80)
Trial Balance Template
INTERCO_MAP_ENABLED_FLAG VARCHAR2 (1) Y Intercompany Mapping Enabled Flag
DS_IMPACTED_BAL_TEMPLATE_CODE VARCHAR2 (80)
Stores the Intercompany Mapping Information
INTERCO_MATCH_TEMPLATE_CODE VARCHAR2 (80)
Intercompany Matching Template
HIER_LIST_TEMPLATE_CODE VARCHAR2 (80)
Hierarchy Listing Template
VALUE_MAP_TEMPLATE_CODE VARCHAR2 (80)
Valueset Map Validation Template
ONLINE_XML_REPORT_SIZE NUMBER (15)
Maximum File Size for Synchronous Publishing
WRITEBACK_TEMPLATE_CODE VARCHAR2 (80)
Writeback Template
IC_MATCH_CONS_TEMPLATE_CODE VARCHAR2 (80)

[top of page]

GCS.GCS_SYSTEM_OPTIONS does not reference any database object

GCS.GCS_SYSTEM_OPTIONS is referenced by following:

APPS
SYNONYM - GCS_SYSTEM_OPTIONS

[top of page]

Table: GCS_SYSTEM_TASKS

Description: Stores system level tasks.
Primary Key: GCS_SYSTEM_TASKS_PK
  1. TASK_CODE
Comments

GCS_SYSTEM_TASKS stores the tasks that must be completed to initialize the system.

Indexes
Index Type Tablespace Column
GCS_SYSTEM_TASKS_U1 UNIQUE APPS_TS_SEED TASK_CODE
Columns
Name Datatype Length Mandatory Comments
TASK_CODE VARCHAR2 (30) Y Task defining column
STATUS_CODE VARCHAR2 (30) Y Task Status
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
OBJECT_VERSION_NUMBER NUMBER (15) Y Standard Who column

[top of page]

GCS.GCS_SYSTEM_TASKS does not reference any database object

GCS.GCS_SYSTEM_TASKS is referenced by following:

APPS
SYNONYM - GCS_SYSTEM_TASKS

[top of page]

Table: GCS_TRANSLATION_STATUSES

Description: GCS translation status information
Primary Key: GCS_TRANSLATION_STATUSES_PK
  1. HIERARCHY_ID
  2. ENTITY_ID
  3. CURRENCY_CODE
  4. CAL_PERIOD_ID
  5. DATASET_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_TRANSLATION_STATUSES.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_TRANSLATION_STATUSES.CURRENCY_CODE FND_CURRENCIES
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
GCS_TRANSLATION_STATUSES_U1 UNIQUE APPS_TS_TX_IDX HIERARCHY_ID
ENTITY_ID
CURRENCY_CODE
CAL_PERIOD_ID
DATASET_CODE
Columns
Name Datatype Length Mandatory Comments
CAL_PERIOD_ID NUMBER
Y Calendar period defining column
DATASET_CODE NUMBER
Y Dataset code
STATUS_CODE VARCHAR2 (30) Y Translation status
REQUEST_ID NUMBER (15)
Concurrent request identifier for the translation program run
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_ID NUMBER (15) Y Foreign key to consolidation hierarchy defining column
ENTITY_ID NUMBER
Y Foreign key to entity defining column
CURRENCY_CODE VARCHAR2 (15) Y Foreign key to currency defining column

[top of page]

GCS.GCS_TRANSLATION_STATUSES does not reference any database object

GCS.GCS_TRANSLATION_STATUSES is referenced by following:

APPS
SYNONYM - GCS_TRANSLATION_STATUSES

[top of page]

Table: GCS_TRANSLATION_TRACK_H

Description: GCS translation tracking information
Primary Key: GCS_TRANSLATION_TRACK_H_PK
  1. HIERARCHY_ID
  2. ENTITY_ID
  3. CURRENCY_CODE
  4. DATASET_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_TRANSLATION_TRACK_H.HIERARCHY_ID GCS_HIERARCHIES_B
GCS_TRANSLATION_TRACK_H.CURRENCY_CODE FND_CURRENCIES
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
GCS_TRANSLATION_TRACK_H_U1 UNIQUE APPS_TS_TX_IDX HIERARCHY_ID
ENTITY_ID
CURRENCY_CODE
DATASET_CODE
Columns
Name Datatype Length Mandatory Comments
DATASET_CODE NUMBER
Y Foreign key to dataset code
EARLIEST_EVER_PERIOD_ID NUMBER
Y Earliest period that has been translated
EARLIEST_NEVER_PERIOD_ID NUMBER
Y Earliest period that has not been translated
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_ID NUMBER (15) Y Foreign key to consolidation hierarchy defining column
ENTITY_ID NUMBER
Y Foreign key to entity defining column
CURRENCY_CODE VARCHAR2 (15) Y Foreign key to currency defining column

[top of page]

GCS.GCS_TRANSLATION_TRACK_H does not reference any database object

GCS.GCS_TRANSLATION_TRACK_H is referenced by following:

APPS
SYNONYM - GCS_TRANSLATION_TRACK_H

[top of page]

Table: GCS_TREATMENTS_B

Description: Consolidation treatments
Primary Key: GCS_TREATMENTS_B_PK
  1. TREATMENT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GCS_CONS_RELATIONSHIPS.TREATMENT_ID GCS_TREATMENTS_B
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
GCS_TREATMENTS_B_U1 UNIQUE APPS_TS_SEED TREATMENT_ID
Columns
Name Datatype Length Mandatory Comments
TREATMENT_ID NUMBER (15) Y Treatment defining column
CONSOLIDATION_TYPE_CODE VARCHAR2 (30) Y Consolidation Type
ENABLED_FLAG VARCHAR2 (1) Y Enabled Flag
OPERATOR_LOW_CODE VARCHAR2 (30)
Operator Low Code
OPERATOR_HIGH_CODE VARCHAR2 (30)
Operator applicable to the high end of the ownership percentage rate
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OWNERSHIP_PERCENT_LOW NUMBER

Ownership Percentage Low
OWNERSHIP_PERCENT_HIGH NUMBER

Ownership Percentage High
OBJECT_VERSION_NUMBER NUMBER (15) Y Version Identifier

[top of page]

GCS.GCS_TREATMENTS_B does not reference any database object

GCS.GCS_TREATMENTS_B is referenced by following:

APPS
SYNONYM - GCS_TREATMENTS_B

[top of page]

Table: GCS_TREATMENTS_TL

Description: Translation table for consolidation treatments
Primary Key: GCS_TREATMENTS_TL_PK
  1. TREATMENT_ID
  2. LANGUAGE
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
GCS_TREATMENTS_TL_U1 UNIQUE APPS_TS_SEED TREATMENT_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TREATMENT_ID NUMBER (15) Y Treatment defining column
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source Language
TREATMENT_NAME VARCHAR2 (50) Y Consolidation Treatment Name
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
DESCRIPTION VARCHAR2 (240)
Consolidation Treatment Description

[top of page]

GCS.GCS_TREATMENTS_TL does not reference any database object

GCS.GCS_TREATMENTS_TL is referenced by following:

APPS
SYNONYM - GCS_TREATMENTS_TL

[top of page]

Table: GCS_WRITEBACK_HEADERS

Description: Stores header information for General Ledger writeback
Comments

GCS_WRITEBACK_HEADERS stores the header information for writeback from Consoldiation to General Ledger

Indexes
Index Type Tablespace Column
GCS_WRTBK_HEADERS_U1 UNIQUE APPS_TS_TX_IDX WRITEBACK_ID
GCS_WRTBK_HEADERS_N1 NONUNIQUE APPS_TS_TX_IDX ENTRY_ID
MOST_RECENT_FLAG
Columns
Name Datatype Length Mandatory Comments
WRITEBACK_ID NUMBER (15) Y Writeback Entry Identifier
ENTRY_ID NUMBER (15) Y Consolidation Entry Identifier
LEDGER_ID NUMBER
Y Target Ledger Id
PERIOD_NAME VARCHAR2 (30) Y Target Period Name
CURRENCY_CODE VARCHAR2 (15) Y Currency Code
GL_CATEGORY VARCHAR2 (30) Y Target Category Code
ACCOUNTING_DATE DATE
Y Accounting Date
MOST_RECENT_FLAG VARCHAR2 (1) Y Most Recent Record Flag
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER
Y Object Identifier
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CONVERSION_RATE NUMBER

Currency Conversion Rate
REQUEST_ID NUMBER (15)
Request Identifier
STATUS_CODE VARCHAR2 (30)
Status Code

[top of page]

GCS.GCS_WRITEBACK_HEADERS does not reference any database object

GCS.GCS_WRITEBACK_HEADERS is referenced by following:

APPS
SYNONYM - GCS_WRITEBACK_HEADERS

[top of page]

Table: GCS_WRITEBACK_LINES

Description: Stores line level detail information for General Ledger writeback
Comments

GCS_WRITEBACK_LINES stores the line level detail information for writeback from Consoldiation to General Ledger

Indexes
Index Type Tablespace Column
GCS_WRTBK_LINES_U1 NONUNIQUE APPS_TS_TX_IDX WRITEBACK_ID
CODE_COMBINATION_ID
Columns
Name Datatype Length Mandatory Comments
WRITEBACK_ID NUMBER (15) Y Writeback Id
CODE_COMBINATION_ID NUMBER (15) Y GL Code Combination Id
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
OBJECT_VERSION_NUMBER NUMBER
Y Object Identifier
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
ENTERED_CR NUMBER

Entered Credit
ENTERED_DR NUMBER

Entered Debit
ACCOUNTED_CR NUMBER

Accounted Credit
ACCOUNTED_DR NUMBER

Accounted Debit
ENTRY_LINE_ROWID ROWID (10)
RowId of consolidation entry line

[top of page]

GCS.GCS_WRITEBACK_LINES does not reference any database object

GCS.GCS_WRITEBACK_LINES is referenced by following:

APPS
SYNONYM - GCS_WRITEBACK_LINES

[top of page]

Table: GCS_XML_FILES

Description: XML generated for XML Publisher reporting
Primary Key: GCS_XML_FILES_PK
  1. XML_FILE_ID
  2. XML_FILE_TYPE
  3. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GCS_XML_FILES.LANGUAGE FND_LANGUAGES
Comments

GCS_XML_FILES stores the XML files generated for XML Publisher reporting

Indexes
Index Type Tablespace Column
GCS_XML_FILES_U1 UNIQUE APPS_TS_SEED XML_FILE_ID
XML_FILE_TYPE
LANGUAGE
SYS_IL0000400006C00004$$ UNIQUE APPS_TS_SEED
SYS_IL0000400006C00005$$ UNIQUE APPS_TS_SEED
SYS_IL0000400006C00012$$ UNIQUE APPS_TS_SEED
Columns
Name Datatype Length Mandatory Comments
XML_FILE_ID NUMBER (15) Y XML File Identifier
XML_FILE_TYPE VARCHAR2 (30) Y XML File Type
LANGUAGE VARCHAR2 (4) Y Language
XML_DATA CLOB (4000)
XML Data
XML_EXECUTION_DATA CLOB (4000)
XML Execution Data
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Y Standard Who column
XML_BLOB_DATA BLOB (4000)
XML Blob Data
FILE_TYPE_CODE VARCHAR2 (30)
Type of Data Stored in the Blob Data Column

[top of page]

GCS.GCS_XML_FILES does not reference any database object

GCS.GCS_XML_FILES is referenced by following:

APPS
SYNONYM - GCS_XML_FILES

[top of page]

View: GCS_ACTIVE_DIMS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

gcs_active_dims_v is used to provide FCH active dimension details.

Columns
Name Datatype Length Mandatory Comments
DISPLAY_NAME VARCHAR2 (150) Y Dimension Name
COLUMN_NAME VARCHAR2 (30) Y Column Name
COLUMN_ORDER NUMBER

Location of this column when listed with the others

[top of page]

APPS.GCS_ACTIVE_DIMS_V references the following:

APPS
SYNONYM - FEM_APP_GRP_COL_EXCLSNS
SYNONYM - FEM_TAB_COLUMNS_TL
SYNONYM - FEM_TAB_COLUMN_PROP

APPS.GCS_ACTIVE_DIMS_V is not referenced by any database object

[top of page]

View: GCS_CATEGORIES_VL

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

GCS_CATEGORIES_VL is the view for selecting data from multilingual entity GCS_CATEGORIES

Columns
Name Datatype Length Mandatory Comments
CATEGORY_CODE VARCHAR2 (80) Y Category defining column
GL_CATEGORY_CODE VARCHAR2 (30)
General Ledger Category Code
CATEGORY_NUMBER NUMBER (15) Y Category Sequence Number
NET_TO_RE_FLAG VARCHAR2 (1) Y Net to Retained Earnings
TARGET_ENTITY_CODE VARCHAR2 (30) Y Target Entity for Category
CATEGORY_TYPE_CODE VARCHAR2 (30) Y Category Type
ASSOCIATED_OBJECT_ID NUMBER
Y Foreign key to Object Dimension defining column
ORG_OUTPUT_CODE VARCHAR2 (30)
Organization Output Option ('CHILD_BASE_ORG', 'BASE_ORG')
SUPPORT_MULTI_PARENTS_FLAG VARCHAR2 (1) Y Support multi parents
ENABLED_FLAG VARCHAR2 (1) Y Category enabled
SPECIFIC_INTERCOMPANY_ID NUMBER

Specific intercompany
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER (15) Y Standard Who Column
CATEGORY_NAME VARCHAR2 (80) Y Category Name
DESCRIPTION VARCHAR2 (240)
Description

[top of page]

APPS.GCS_CATEGORIES_VL references the following:

APPS
SYNONYM - GCS_CATEGORIES_B
SYNONYM - GCS_CATEGORIES_TL

APPS.GCS_CATEGORIES_VL is not referenced by any database object

[top of page]

View: GCS_CURR_TREATMENTS_VL

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

GCS_CURR_TREATMENTS_VL is the view for selecting data from multilingual entity GCS_CURR_TREATMENTS.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
CURR_TREATMENT_ID NUMBER (15) Y Currency treatment defining column
ENDING_RATE_TYPE VARCHAR2 (30) Y Ending Rate Type
AVERAGE_RATE_TYPE VARCHAR2 (30) Y Average Rate Type
EQUITY_MODE_CODE VARCHAR2 (30) Y Equity Mode
INC_STMT_MODE_CODE VARCHAR2 (30) Y Income Statement Mode
ENABLED_FLAG VARCHAR2 (1) Y Enabled Flag
DEFAULT_FLAG VARCHAR2 (1) Y Default Flag
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
FINANCIAL_ELEM_ID NUMBER

Financial Element defining column
PRODUCT_ID NUMBER

Product defining column
NATURAL_ACCOUNT_ID NUMBER

Natural Account defining column
CHANNEL_ID NUMBER

Channel defining column
LINE_ITEM_ID NUMBER

Line Item defining column
PROJECT_ID NUMBER

Project defining column
CUSTOMER_ID NUMBER

Customer defining column
CTA_USER_DIM1_ID NUMBER

User Dimension 1 defining column
CTA_USER_DIM2_ID NUMBER

User Dimension 2 defining column
CTA_USER_DIM3_ID NUMBER

User Dimension 3 defining column
CTA_USER_DIM4_ID NUMBER

User Dimension 4 defining column
CTA_USER_DIM5_ID NUMBER

User Dimension 5 defining column
CTA_USER_DIM6_ID NUMBER

User Dimension 6 defining column
CTA_USER_DIM7_ID NUMBER

User Dimension 7 defining column
CTA_USER_DIM8_ID NUMBER

User Dimension 8 defining column
CTA_USER_DIM9_ID NUMBER

User Dimension 9 defining column
CTA_USER_DIM10_ID NUMBER

User Dimension 10 defining column
TASK_ID NUMBER

Task defining column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
CURR_TREATMENT_NAME VARCHAR2 (50) Y Currency Treatment Name
DESCRIPTION VARCHAR2 (240)
Description

[top of page]

APPS.GCS_CURR_TREATMENTS_VL references the following:

APPS
SYNONYM - GCS_CURR_TREATMENTS_B
SYNONYM - GCS_CURR_TREATMENTS_TL

APPS.GCS_CURR_TREATMENTS_VL is not referenced by any database object

[top of page]

View: GCS_DATA_TYPE_CODES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

GCS_DATA_TYPE_CODES_VL is the view for selecting data from multilingual data type GCS_DATA_TYPE_CODES_B.

Columns
Name Datatype Length Mandatory Comments
DATA_TYPE_ID NUMBER (15) Y
DATA_TYPE_CODE VARCHAR2 (30) Y
ENFORCE_BALANCING_FLAG VARCHAR2 (1) Y
APPLY_ELIM_RULES_FLAG VARCHAR2 (1) Y
APPLY_CONS_RULES_FLAG VARCHAR2 (1) Y
SOURCE_DATASET_CODE NUMBER (15)
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)
OBJECT_VERSION_NUMBER NUMBER (15) Y
DATA_TYPE_NAME VARCHAR2 (150) Y
DESCRIPTION VARCHAR2 (240)

[top of page]

APPS.GCS_DATA_TYPE_CODES_VL references the following:

APPS
SYNONYM - GCS_DATA_TYPE_CODES_B
SYNONYM - GCS_DATA_TYPE_CODES_TL
APPS.GCS_DATA_TYPE_CODES_VL is referenced by following:

APPS
PACKAGE BODY - GCS_XML_DT_UTILITY_PKG

[top of page]

View: GCS_ELIM_RULES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

GCS_ELIM_RULES_VL is the view for selecting data from multilingual entity GCS_ELIM_RULES

Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER (15) Y Consolidation rule defining column
TRANSACTION_TYPE_CODE VARCHAR2 (80) Y Transaction type code
FROM_TREATMENT_ID NUMBER (15)
Old consolidation treatment code
TO_TREATMENT_ID NUMBER (15)
New consolidation treatment code
SEEDED_RULE_FLAG VARCHAR2 (1) Y Indicates whether the rule is seed data or user-defined
ENABLED_FLAG VARCHAR2 (1) Y Enabled flag
OBJECT_VERSION_NUMBER NUMBER (15)
Object version number
RULE_NAME VARCHAR2 (50) Y User-entered rule name
DESCRIPTION VARCHAR2 (240)
Description
RULE_TYPE_CODE VARCHAR2 (30) Y Consolidation rule type code
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

APPS.GCS_ELIM_RULES_VL references the following:

APPS
SYNONYM - GCS_ELIM_RULES_B
SYNONYM - GCS_ELIM_RULES_TL
APPS.GCS_ELIM_RULES_VL is referenced by following:

APPS
PACKAGE BODY - GCS_AD_ENGINE
PACKAGE BODY - GCS_ENTRY_PKG

[top of page]

View: GCS_ELIM_RULE_STEPS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

GCS_ELIM_RULE_STEPS_VL is the view for selecting data from multilingual entity GCS_ELIM_RULE_STEPS

Columns
Name Datatype Length Mandatory Comments
RULE_STEP_ID NUMBER (15) Y
RULE_ID NUMBER (15) Y
STEP_SEQ NUMBER (15) Y
FORMULA_TEXT VARCHAR2 (2000) Y
PARSED_FORMULA VARCHAR2 (2000) Y
COMPILED_VARIABLES VARCHAR2 (150)
SQL_STATEMENT_NUM NUMBER (15)
STEP_NAME VARCHAR2 (50) 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 (15)
OBJECT_VERSION_NUMBER NUMBER (15)

[top of page]

APPS.GCS_ELIM_RULE_STEPS_VL references the following:

APPS
SYNONYM - GCS_ELIM_RULE_STEPS_B
SYNONYM - GCS_ELIM_RULE_STEPS_TL
APPS.GCS_ELIM_RULE_STEPS_VL is referenced by following:

APPS
PACKAGE BODY - GCS_RULES_PROCESSOR

[top of page]

View: GCS_FEM_ACTIVE_DIMS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

gcs_fem_active_dims_v is used to provide FEM active dimension details

Columns
Name Datatype Length Mandatory Comments
DISPLAY_NAME VARCHAR2 (150) Y Dimension Name
COLUMN_NAME VARCHAR2 (30) Y Column Name
COLUMN_ORDER NUMBER

Location of this column when listed with the others

[top of page]

APPS.GCS_FEM_ACTIVE_DIMS_V references the following:

APPS
SYNONYM - FEM_TAB_COLUMNS_TL
SYNONYM - FEM_TAB_COLUMN_PROP

APPS.GCS_FEM_ACTIVE_DIMS_V is not referenced by any database object

[top of page]

View: GCS_FINANCIAL_ITEMS_HIER_V

Comments
Columns
Name Datatype Length Mandatory Comments
SEQUENCE_NUMBER NUMBER

FINANCIAL_STATEMENT_ID NUMBER (15) Y
FINANCIAL_ITEM_ID NUMBER

PARENT_FINANCIAL_ITEM_ID VARCHAR2 (0)

[top of page]

APPS.GCS_FINANCIAL_ITEMS_HIER_V references the following:

APPS
SYNONYM - GCS_HIERARCHIES_B

APPS.GCS_FINANCIAL_ITEMS_HIER_V is not referenced by any database object

[top of page]

View: GCS_FINANCIAL_ITEMS_V

Comments
Columns
Name Datatype Length Mandatory Comments
FINANCIAL_STATEMENT_ID NUMBER (15) Y
FINANCIAL_ITEM_ID NUMBER

NAME VARCHAR2 (2000) Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANGUAGE VARCHAR2 (4) Y

[top of page]

APPS.GCS_FINANCIAL_ITEMS_V references the following:

APPS
SYNONYM - FND_NEW_MESSAGES
SYNONYM - GCS_HIERARCHIES_B

APPS.GCS_FINANCIAL_ITEMS_V is not referenced by any database object

[top of page]

View: GCS_FIN_STMTS_V

Comments
Columns
Name Datatype Length Mandatory Comments
FINANCIAL_STATEMENT_ID NUMBER (15) Y

[top of page]

APPS.GCS_FIN_STMTS_V references the following:

APPS
SYNONYM - GCS_HIERARCHIES_B

APPS.GCS_FIN_STMTS_V is not referenced by any database object

[top of page]

View: GCS_FIN_STMT_DTLS_V

Comments
Columns
Name Datatype Length Mandatory Comments
FINANCIAL_STATEMENT_ID NUMBER (15) Y
NAME VARCHAR2 (150) Y
DESCRIPTION VARCHAR2 (240)
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANGUAGE VARCHAR2 (4) Y

[top of page]

APPS.GCS_FIN_STMT_DTLS_V references the following:

APPS
SYNONYM - GCS_HIERARCHIES_B
SYNONYM - GCS_HIERARCHIES_TL

APPS.GCS_FIN_STMT_DTLS_V is not referenced by any database object

[top of page]

View: GCS_GL_JI_GROUPS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

GCS_GL_JI_GROUPS_V retrieves a list of source and group id combinations from GL_INTERFACE and GL_INTERFACE_CONTROL. This information is used to get the information necessary for running Interface Data Transformer against GL_INTERFACE data.

Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER (15)
Specifies the group to which the line in the interface table belongs.
INTERFACE_TABLE_NAME VARCHAR2 (30)
The interface table in which the data is stored.
USER_JE_SOURCE_NAME VARCHAR2 (25)
The source of the line to be imported.
SET_OF_BOOKS_ID NUMBER (15)
The set of books to which this line should be imported.
REQUEST_ID NUMBER (15)
The request identifier, if journal import has already been requested for this line.

[top of page]

APPS.GCS_GL_JI_GROUPS_V references the following:

APPS
SYNONYM - GL_INTERFACE
SYNONYM - GL_INTERFACE_CONTROL
SYNONYM - GL_JE_SOURCES

APPS.GCS_GL_JI_GROUPS_V is not referenced by any database object

[top of page]

View: GCS_HIERARCHIES_VL

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

GCS_HIERARCHIES_VL is the view for selecting data from multilingual entity GCS_HIERARCHIES_B

Columns
Name Datatype Length Mandatory Comments
HIERARCHY_ID NUMBER (15) Y Consolidation hierarchy defining column
TOP_ENTITY_ID NUMBER
Y Top entity defining column
START_DATE DATE
Y Consolidation hierarchy start date
CALENDAR_ID NUMBER
Y Time dimension hierarchy defining column
DIMENSION_GROUP_ID NUMBER (9) Y Dimension group defining column
IE_BY_ORG_CODE VARCHAR2 (30) Y Code to mark if intercompany eliminations is matched by organization, company, or cost center
BALANCE_BY_ORG_FLAG VARCHAR2 (1) Y Flag to mark if the hierarchy will balance by organization in addition to entity
ENABLED_FLAG VARCHAR2 (1) Y Flag to mark if a hierarchy is usable
THRESHOLD_AMOUNT NUMBER
Y Threshold amount
THRESHOLD_CURRENCY VARCHAR2 (15) Y Currency of the threshold amount
FEM_LEDGER_ID NUMBER
Y Ledger dimension defining column
COLUMN_NAME VARCHAR2 (30)
Additional tracking dimension defining column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
HIERARCHY_NAME VARCHAR2 (150) Y User-defined consolidation hierarchy name
DESCRIPTION VARCHAR2 (240)
Consolidation hierarchy description
SECURITY_ENABLED_FLAG VARCHAR2 (1)
Flag to enabled security
CERTIFICATION_FLAG VARCHAR2 (1) Y Flag to mark certification hierarchy
LOB_REPORTING_ENABLED_FLAG VARCHAR2 (1)
Flag to mark line of business reporting for intercompany eliminations.
LOB_HIERARCHY_OBJ_ID NUMBER

Line of business hierarchy defining column.
LOB_DIM_COLUMN_NAME VARCHAR2 (30)
Line of business tracking column.
HIERARCHY_GRP_FLAG VARCHAR2 (1)

[top of page]

APPS.GCS_HIERARCHIES_VL references the following:

APPS
SYNONYM - GCS_HIERARCHIES_B
SYNONYM - GCS_HIERARCHIES_TL
APPS.GCS_HIERARCHIES_VL is referenced by following:

APPS
PACKAGE BODY - GCS_FEM_HIER_SYNC_PKG

[top of page]

View: GCS_ITEMS_TO_NAT_ACCTS_V

Comments
Columns
Name Datatype Length Mandatory Comments
FINANCIAL_STATEMENT_ID NUMBER (15) Y
FINANCIAL_ITEM_ID NUMBER

NATURAL_ACCOUNT_ID NUMBER
Y

[top of page]

APPS.GCS_ITEMS_TO_NAT_ACCTS_V references the following:

APPS
SYNONYM - FEM_GLOBAL_VS_COMBO_DEFS
SYNONYM - FEM_LN_ITEMS_B
SYNONYM - FEM_LN_ITEMS_HIER
SYNONYM - FEM_OBJECT_DEFINITION_B
SYNONYM - GCS_HIERARCHIES_B
SYNONYM - GCS_SYSTEM_OPTIONS

APPS.GCS_ITEMS_TO_NAT_ACCTS_V is not referenced by any database object

[top of page]

View: GCS_LEX_MAP_SEQUENCES_V

Comments
View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

GCS_LEX_MAP_SEQUENCES_V is a view used by the Interface Data Transformer application so that you can view your Transformation Rule Sets in a hierarchical fashion. The view retrieves the rule, derivation, derivation sequence number, derivation type, and condition text to be shown in the Interface Data Transformer Create Rule Set: Details page.

Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER (15) Y Rule identifier
DERIVATION_ID NUMBER (15) Y Derivation identifier
DERIVATION_SEQUENCE NUMBER
Y Sequence number for this derivation
CONDITION VARCHAR2 (4000)
The condition that must be satisfied by the source column values for the derivation action to be applied.
DERIVATION_TYPE VARCHAR2 (80) Y The type of action used to derive the target value: String Function, Lookup Table, or PL/SQL Function.

[top of page]

APPS.GCS_LEX_MAP_SEQUENCES_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - GCS_LEX_MAP_DERIVATIONS
PACKAGE - GCS_LEX_MAP_PKG

APPS.GCS_LEX_MAP_SEQUENCES_V is not referenced by any database object

[top of page]

View: GCS_NAT_ACCTS_HIER_V

Comments
Columns
Name Datatype Length Mandatory Comments
NATURAL_ACCOUNT_ID NUMBER
Y
NATURAL_ACCOUNT_VALUE VARCHAR2 (150) Y
PARENT_NATURAL_ACCOUNT_ID NUMBER

[top of page]

APPS.GCS_NAT_ACCTS_HIER_V references the following:

APPS
SYNONYM - FEM_GLOBAL_VS_COMBO_DEFS
SYNONYM - FEM_LN_ITEMS_B
SYNONYM - FEM_LN_ITEMS_HIER
SYNONYM - FEM_OBJECT_DEFINITION_B
SYNONYM - GCS_SYSTEM_OPTIONS

APPS.GCS_NAT_ACCTS_HIER_V is not referenced by any database object

[top of page]

View: GCS_NAT_ACCTS_V

Comments
Columns
Name Datatype Length Mandatory Comments
NATURAL_ACCOUNT_ID NUMBER
Y
NAME VARCHAR2 (150) Y
LANGUAGE VARCHAR2 (4) Y
SOURCE_LANGUAGE VARCHAR2 (4) Y

[top of page]

APPS.GCS_NAT_ACCTS_V references the following:

APPS
SYNONYM - FEM_GLOBAL_VS_COMBO_DEFS
SYNONYM - FEM_LN_ITEMS_TL
SYNONYM - GCS_SYSTEM_OPTIONS

APPS.GCS_NAT_ACCTS_V is not referenced by any database object

[top of page]

View: GCS_TREATMENTS_VL

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

GCS_TREATMENTS_VL is the view for selecting data from multilingual entity GCS_TREATMENTS

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
TREATMENT_ID NUMBER (15) Y Consolidation treatment defining column
CONSOLIDATION_TYPE_CODE VARCHAR2 (30) Y Consolidation type
ENABLED_FLAG VARCHAR2 (1) Y Enabled flag
OPERATOR_LOW_CODE VARCHAR2 (30)
Operator applicable to low end of percentage ownership
OPERATOR_HIGH_CODE VARCHAR2 (30)
Operator applicable to high end of percentage ownership
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OWNERSHIP_PERCENT_LOW NUMBER

Low End of Percentage Ownership
OWNERSHIP_PERCENT_HIGH NUMBER

High End of Percentage Ownership
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
TREATMENT_NAME VARCHAR2 (50) Y Treatment Name
DESCRIPTION VARCHAR2 (240)
Treatment Description

[top of page]

APPS.GCS_TREATMENTS_VL references the following:

APPS
SYNONYM - GCS_TREATMENTS_B
SYNONYM - GCS_TREATMENTS_TL

APPS.GCS_TREATMENTS_VL is not referenced by any database object

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