CML_ONLINE_ALLOCATION_REQS
This table stores information regarding online submission of allocation processes. This will help maintain an audit trail of online submissions and also help to avoid multiple runs for same set of parameters.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CML_ONLINE_ALLOC_REQS_PK |
RUN_ID, TRADE_OPERATION_ID, TRADE_OPERATION_CHARGE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
RUN_ID | NUMBER | 18 | Yes | Unique identifier for allocation submission from the UI. | |
TRADE_OPERATION_ID | NUMBER | 18 | Yes | Surrogate ID FK to trade operation for which online allocation is submitted. | |
TRADE_OPERATION_CHARGE_ID | NUMBER | 18 | Yes | Surrogate ID FK to trade operation charge line for which online allocation is submitted. | |
TIMEOUT | NUMBER | 9 | Yes | Number of Seconds this request will block another request if not finished. Default value is 180. | |
STATUS | VARCHAR2 | 30 | Yes | Online Allocation Process Status. A - Active E - Error B - Blocked and Canceled S - Completed Successfully W - Completed With Warnings X - Expired | |
BLOCKING_RUN_ID | NUMBER | 18 | Run ID of online request which blocked this request from running. | ||
BLOCKING_REQUEST_ID | NUMBER | 18 | Request ID of the background process which blocked this request from running. | ||
TIMEOUT_RUN_ID | NUMBER | 18 | If this process is marked in X (expired) due to timeout, Run_ID of the process that does this. Online processes never stop batch processes from running. | ||
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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CML_ONLINE_ALLOC_REQS_PK | Unique | Default | RUN_ID, TRADE_OPERATION_ID, TRADE_OPERATION_CHARGE_ID |