1. Tables and Views for SCM
  2. ACA_CS_CLASS_B

ACA_CS_CLASS_B

Contains the list of business classes registered for use by the application. The class table represents the metadata for a business object in the system. That is, each business object is created from a class definition. The class table contains all class definitions for all class families. Base class definitions are no different than other class definitions. In fact, the only thing that denotes a class as a base class is that its parent class ID is set to null. That is, a base class has no parent. Classes are maintained as a hierarchy. That is, all classes except for base classes are derived from a parent class. This hierarchy introduces the possibility of inheritance. With inheritance, parent class definition information may be added to or overridden by a child class.

Details

  • Schema: FUSION

  • Object owner: ACA

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

ACA_CS_CLASS_B_PK

CLASS_ID

Columns

Name Datatype Length Precision Not-null Comments
CLASS_ID NUMBER 18 Yes Primary Key. Internally generated ID which can be used as a foreign key.
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.
CLASS_CODE VARCHAR2 80 Yes Alternate Key. Internal (API) name for the class. Only alphanumeric and underscore are allowed.
DELETED_FLAG NUMBER 18 Yes Used to control soft deletes. 0 = Active; ALL other values identify the row as deleted.
DISABLE_DATE DATE Optional. The date the class is no longer active. If left blank, then the class definition will not expire.
OBJECT_CREATION_ALLOWED_FLAG VARCHAR2 1 Yes Yes/No Flag. Indicates if objects can be created from this class definition. This establishes whether a class is abstract (Flag=N; cannot be instantiated) or concrete (Flag=Y; can be instantiated). Class policy may dictate the required value for this field. Class policy will also determine if the customer may change this value.
TRACK_HISTORY_FLAG VARCHAR2 1 This is a yes/no flag which allows customers to control whether history on object's of the particular type should be tracked.
CLASS_FAMILY_CODE VARCHAR2 30 Yes Foreign Key. Refers to the class family that this class belongs to. Provides access to the normalized metadata that applies to all classes within a single class family.
CLASS_SUB_FAMILY_CODE VARCHAR2 30 Optional. Allows the product team to subdivide a family into separate factions. For example, a document family may contain two sub-families: Structured and Unstructured.
PARENT_CLASS_ID NUMBER 18 Foreign Key. Refers to the class that this class is derived from. All classes created by customers are required to have a parent class. Base (root) classes do not have a parent class. Base classes can only be created via seed data.
PRODUCT_OWNED VARCHAR2 1 Yes Yes/No Flag. Indicates if the class was created through seeded data by Agile (Oracle) and that customer modifications to the class are restricted.
CLASS_POLICY VARCHAR2 30 Yes Denotes any policies pertaining to this class. Class policy can only be set by the application or through seed data. Here are the current known values of Class Policy: ??? Standard (no restrictions) ??? Abstract Only o Object Creation Allowed Flag must = N o Object Creation Allowed Flag is read only for customers ??? Concrete Only o Object Creation Allowed Flag must = Y o Object Creation Allowed Flag is read only for customers ??? Leaf Class o Class may not be the parent to another class o Object Creation Allowed Flag must = Y o Object Creation Allowed Flag is read only for customers The values for this column are maintained in FND_LOOKUPS under the ACA_CS_CLASS_POLICY lookup type. This makes sure that everyone is aware of the possible values.
BIP_TEMPLATE VARCHAR2 400 Business Logic Parameter. Used to capture the Business Intelligence Publisher (BIP) Template to use with objects of a specified class.
NUMBER_GENERATION_METHOD VARCHAR2 30 Number generation method used to generate the number for the class type.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
ACA_CS_CLASS_B aca_cs_class_family CLASS_FAMILY_CODE
ACA_CS_CLASS_B aca_cs_class_b PARENT_CLASS_ID
aca_auto_seq_metadata_b aca_cs_class_b AUTO_SEQ_CLASS_ID
aca_cs_class_b aca_cs_class_b PARENT_CLASS_ID
aca_cs_class_tl aca_cs_class_b CLASS_ID

Indexes

Index Uniqueness Tablespace Columns
ACA_CS_CLASS_B_N2 Non Unique Default PARENT_CLASS_ID
ACA_CS_CLASS_B_N3 Non Unique Default CLASS_CODE
ACA_CS_CLASS_B_U1 Unique Default CLASS_ID, ORA_SEED_SET1
ACA_CS_CLASS_B_U11 Unique Default CLASS_ID, ORA_SEED_SET2
ACA_CS_CLASS_B_U2 Unique Default CLASS_FAMILY_CODE, CLASS_CODE, DELETED_FLAG, ORA_SEED_SET1
ACA_CS_CLASS_B_U21 Unique Default CLASS_FAMILY_CODE, CLASS_CODE, DELETED_FLAG, ORA_SEED_SET2
ACA_CS_CLASS_B_U3 Unique Default CLASS_FAMILY_CODE, CLASS_SUB_FAMILY_CODE, CLASS_CODE, DELETED_FLAG, ORA_SEED_SET1
ACA_CS_CLASS_B_U31 Unique Default CLASS_FAMILY_CODE, CLASS_SUB_FAMILY_CODE, CLASS_CODE, DELETED_FLAG, ORA_SEED_SET2