PON_IOT_LEARNING_RUNS
The scheduler program runs are logged in this table to track the movement of data between sourcing cloud and the IoT analytics. This would also record the learning triggers that were initiated by the sourcing cloud.
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PON_IOT_LEARNING_RUNS_PK |
RUN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RUN_ID | NUMBER | 18 | Yes | An identifier that is generated every time a new job is started. This is the primary key for this table. | |
| NO_OF_MONTHS | NUMBER | 18 | The number of months of data to extract when the extraction program is run | ||
| SCENARIO_WEIGHTS | VARCHAR2 | 100 | Indicates how similar a match is to the input item or service. | ||
| SIMILARITY_THRESHOLD | NUMBER | The functional criteria applied to the input data in supplier scenarios used for AI model training and providing supplier recommendations. | |||
| 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. | |
| RUN_TIMESTAMP | TIMESTAMP | The exact time when the extraction program was run. This is used to compute delta for the next run. | |||
| EXTRACTION_TYPE_CODE | VARCHAR2 | 30 | The type of extraction. Is it an incremental run or a full run. | ||
| BICC_REQUEST_ID | NUMBER | 18 | The enterprise scheduler request identifier that is captured from the BICC job that was run in the movement of data from fusion applications to IoT analytics application. | ||
| LEARNING_WORKFLOW_ID | VARCHAR2 | 36 | The reference of the work flow that is initiated in the IoT analytics application. | ||
| LEARNING_SCENARIO_ID | VARCHAR2 | 36 | The reference of the work flow scenario that is initiated in the IoT analytics application specifically for training and scoring a specific data set. | ||
| LEARNING_NOTIFY_ID | VARCHAR2 | 36 | The reference of the notify call that is initiated in the IoT analytics application specifically for training a specific data set. | ||
| LEARNING_NOTIFY_STATUS | VARCHAR2 | 30 | The status of notify call that is initiated in the IoT analytics application specifically for training a specific data set. | ||
| LEARNING_TRAINING_ID | VARCHAR2 | 36 | The reference of the training that is initiated in the IoT analytics application specifically for training a specific data set. | ||
| LEARNING_TRAINING_STATUS | VARCHAR2 | 30 | The status of training that is initiated in the IoT analytics application specifically for training a specific data set. | ||
| 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. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PON_IOT_LEARNING_RUNS_U1 | Unique | Default | RUN_ID |