1. Tables and Views for Financials
  2. XLA_ANALYTICAL_HDRS_B

XLA_ANALYTICAL_HDRS_B

This table contains the header information for the analytical criteria. Since some analytical criteria are delivered as seeded data by the product teams, the name and the description are subjected to translation, so there are two tables for the analytical criteria.

Details

  • Schema: FUSION

  • Object owner: XLA

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

XLA_ANALYTICAL_HDRS_B_PK

ANALYTICAL_CRITERION_CODE

Columns

Name Datatype Length Precision Not-null Comments Status
SUPPORTING_REFERENCE_ID NUMBER 18 Yes Supporting reference unique identifier.
AMB_CONTEXT_CODE VARCHAR2 30 Yes Accounting methods builder context. Active
APPLICATION_ID NUMBER 18 Identifier of a functional area within a software suite of products. For example: Financials, or Payroll. Active
ANALYTICAL_CRITERION_CODE VARCHAR2 30 Yes Supporting reference short name. Active
ANALYTICAL_CRITERION_TYPE_CODE VARCHAR2 1 Yes An abbreviated name that indicates the owner of a supporting reference. Possible values are C: defined by the user, S: predefined by Oracle. Active
SUPP_REF_ORDER NUMBER 2 Order of the supporting reference
BALANCING_FLAG VARCHAR2 1 Yes Indicates whether balance will be maintained for the specific supporting reference Active
DISPLAY_ORDER NUMBER Yes Not currently used. Active
ENABLED_FLAG VARCHAR2 1 Yes Indicates whether the supporting reference is enabled. Active
YEAR_END_CARRY_FORWARD_CODE VARCHAR2 30 Not currently used. Active
UPDATED_FLAG VARCHAR2 1 Indicate if the application accounting definition is updated since last exported Active
VERSION_NUM NUMBER Version number generated automatically at the time of export Active
UPDATED_IN_ESSBASE VARCHAR2 1 Indicates If the specific dimension is created for the supporting reference in ESSBASE.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Indexes

Index Uniqueness Tablespace Columns Status
XLA_ANALYTICAL_HDRS_B_U1 Unique Default ANALYTICAL_CRITERION_CODE, ORA_SEED_SET1 Active
XLA_ANALYTICAL_HDRS_B_U11 Unique Default ANALYTICAL_CRITERION_CODE, ORA_SEED_SET2