[Home] [Help] [Dependency Information]
Object Name: | OKC_ACTIONS_B |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_ACTIONS_B |
Subobject Name: | |
Status: | VALID |
An Action is some event of significance in the business process. It is of two types �Action Based� or �Date Based�. Example for action based could be �Contract Signing�, �Contract Renewal� etc. These actions may result in database operation (update, insert, delete). Example for date based could be arrival of a date of significance like �10 days before Contract Expiry�. An Action is the first step in the process of ACTION -> CONDITION -> OUTCOME. When Action happens, a set of Conditions are evaluated, and if they evaluate to true, then one or more Outcomes are executed.
An Action will have a set of Action Attributes (stored in OKC_ACTION_ATTRIBUTES_B) that defines the data items to be collected and placed on the queue when an occurrence of an Action is detected. The actual values for each instance of an Action occurrence are kept in OKC_ACTION_ATT_VALS.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_ACTIONS_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
ID
ZD_EDITION_NAME |
OKC_ACTION_B_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
CORRELATION
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | System generated Unique Identifier. Generated from sequence OKC_ACTIONS_S1. Also primary key of the table. | |
CORRELATION | VARCHAR2 | (384) | Yes | Unique identifier of the action. Used to identify messages on the queue. It is a textual representation of action for example KSIGN for 'Contract Signed' action, KTERM is for 'Contract Terminated' action. |
ENABLED_YN | VARCHAR2 | (3) | Yes | Indicates whether the action is enabled. Valid values Y or N. |
FACTORY_ENABLED_YN | VARCHAR2 | (3) | Yes | Indicates whether the action was enabled when shipped. Valid values Y or N. Not used. |
ACN_TYPE | VARCHAR2 | (30) | Yes | Type of action. Valid values ABA (Action based Action) or DBA (Date based Action). |
COUNTER_ACTION_YN | VARCHAR2 | (3) | Yes | Indicates whether the action is related to Counters. Valid values Y or N. |
SYNC_ALLOWED_YN | VARCHAR2 | (3) | Yes | Indicates whether the action will execute outcomes synchronously. Valid values Y or N. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column. | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
APPLICATION_ID | NUMBER | Owning Application Identifier | ||
SEEDED_FLAG | VARCHAR2 | (3) | Indicates if action is seeded. | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, CORRELATION
, ENABLED_YN
, FACTORY_ENABLED_YN
, ACN_TYPE
, COUNTER_ACTION_YN
, SYNC_ALLOWED_YN
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, APPLICATION_ID
, SEEDED_FLAG
, ZD_EDITION_NAME
FROM OKC.OKC_ACTIONS_B;
OKC.OKC_ACTIONS_B does not reference any database object
OKC.OKC_ACTIONS_B is referenced by following:
|
|
|