1. Tables and Views for SCM
  2. EGO_RL_USER_RULES_B

EGO_RL_USER_RULES_B

Stores rule definition which belongs to a particular rule set. RULE_ID is Surrogate Key for this entity. RULE_SED_ID is a foreign key to EGO_RL_RULE_SETS_B.

Details

  • Schema: FUSION

  • Object owner: EGO

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

EGO_RL_USER_RULES_B_PK

RULE_ID

Columns

Name Datatype Length Precision Not-null Comments
RULE_ID NUMBER 18 Yes The primary key of the table. This is also the surrogate key for this entity.
RULE_SET_ID NUMBER 18 Yes Rule Set to which the rule belongs to. Foreign Key to EGO_RL_RULE_SETS_B.
SEQUENCE NUMBER 18 Yes Decides execution order in context of other rules with in the rule set.
RULE_NAME VARCHAR2 30 Yes Specifies the internal name of the rule.
RUN_ON VARCHAR2 30 When exactly the rule needs to be executed (Create,Update etc).
RETURN_TYPE VARCHAR2 15 Return Type of the assignment rule value.
TARGET_BUS_ENT VARCHAR2 40 For assignment rules, the entity of the target attribute group.
TARGET_ATTR_GROUP_TYPE VARCHAR2 30 For assignment rules, to which attribute group type the value needs to be set.
TARGET_ATTR_GROUP_NAME VARCHAR2 80 For assignment rules, to which attribute group the value needs to set.
TARGET_ATTR_NAME VARCHAR2 30 For assignment rules, to which attribute the value needs to be assigned.
SEVERITY VARCHAR2 50 Severity of the rule, for example warning, reject or needs approval etc.
DEFAULT_CHANGE_ORDER_TYPE VARCHAR2 30 The default change order type for a Needs Approval validation rule
ENFORCE_CHANGE_ORDER_TYPE VARCHAR2 1 Specifies if the default change order type for a Needs Approval validation rule is optional or mandatory
MAX_NUM_ASSIGNED_ORGS NUMBER 5 The maximum number of organization assignments performed by this rule.
HAS_ALTERNATE_CATALOGS VARCHAR2 1 Yes Flag to indicate whether alternate catalog is used in the rule.
HAS_CONTEXT_ATTRS VARCHAR2 1 Yes Whether context attributes like batch id, new item request id are part of the rule.
HAS_MULTIROW_ATTRS VARCHAR2 1 Yes Flag to indicate whether multi row attribues are involved in the rule.
HAS_VARIANT_ATTRS VARCHAR2 1 Yes Flag to indicate whether variant attributes are involved in the rule.
HAS_STRUCT_ATTRS VARCHAR2 1 Yes Flag to indicate whether structure attributes involved in the rule.
HAS_ASSIGNED_TO_ORG_FUNC VARCHAR2 1 Flag to indicate whether assignedToOrg() function involved in rule or not.
HAS_ASSIGNED_TO_CATALOG_FUNC VARCHAR2 1 Flag to indicate whether assignedToCatalog() function involved in the rule or not.
HAS_CLASS_CHANGE_FUNCTION VARCHAR2 1 Yes Flag to indicate whether CHANGE rule function is used in rule.
HAS_EXISTS_FUNCTION VARCHAR2 1 Flag to indicate whether Exists rule function is used in rule.
HIDE_USER_MESSAGE VARCHAR2 1 Flag to indicate whether the rule's user message should be displayed after the rule is executed.
RULE_XML CLOB Yes Specifies the XML format of the rule.
GROOVY_SCRIPT CLOB Groovy script associated with the rule.
GROOVY_BYTES BLOB Compiled groovy script associated with the rule.
VERSION VARCHAR2 10 Specifies the Version of the rule.
HAS_ABORT_VALIDATION VARCHAR2 1 Flag to indicate whether to abort rule execution as soos as it finds Reject Rule
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
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.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
PRIMARY_IF_EXPRESSION VARCHAR2 1900 Primary If Expression for Audit
SECONDARY_IF_EXPRESSION1 VARCHAR2 1900 Secondary If Expression for Audit
SECONDARY_IF_EXPRESSION2 VARCHAR2 1900 Secondary If Expression for Audit
SECONDARY_IF_EXPRESSION3 VARCHAR2 1900 Secondary If Expression for Audit
SECONDARY_IF_EXPRESSION4 VARCHAR2 1900 Secondary If Expression for Audit
SECONDARY_IF_EXPRESSION5 VARCHAR2 1900 Secondary If Expression for Audit
VALIDATION_CONDITION VARCHAR2 1900 The Validation Condition for Audit
SECONDARY_IF_RETURN_VALUE1 VARCHAR2 800 Secondary Return Value for Audit
SECONDARY_IF_RETURN_VALUE2 VARCHAR2 800 Secondary Return Value for Audit
SECONDARY_IF_RETURN_VALUE3 VARCHAR2 800 Secondary Return Value for Audit
SECONDARY_IF_RETURN_VALUE4 VARCHAR2 800 Secondary Return Value for Audit
SECONDARY_IF_RETURN_VALUE5 VARCHAR2 800 Secondary Return Value for Audit

Foreign Keys

Table Foreign Table Foreign Key Column
EGO_RL_USER_RULES_B ego_rl_rule_sets_b RULE_SET_ID
ego_rl_blend_rule_attr_groups ego_rl_user_rules_b RULE_ID
ego_rl_blend_rule_attrs ego_rl_user_rules_b RULE_ID
ego_rl_blend_rule_lines ego_rl_user_rules_b RULE_ID
ego_rl_rule_att_groups ego_rl_user_rules_b RULE_ID
ego_rl_rule_bus_ents ego_rl_user_rules_b RULE_ID
ego_rl_user_rules_tl ego_rl_user_rules_b RULE_ID
ego_rl_rule_sub_expressions ego_rl_user_rules_b RULE_ID

Indexes

Index Uniqueness Tablespace Columns
EGO_RL_USER_RULES_B_N1 Non Unique Default RULE_SET_ID
EGO_RL_USER_RULES_B_U1 Unique Default RULE_ID