PO_PDOI_PROGRESS
PO_PDOI_PROGRESS contains the information of the state of Purchasing Document Import Jobs. It is used to make Purchasing Document Import job restartable from the point of failure.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PO_PDOI_PROGRESS_PK |
PROGRESS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROGRESS_ID | NUMBER | Yes | Primary key column (To identify unique records in the table). | ||
| PDOI_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| SEQ_NUM | NUMBER | Sequence number of PDOI Audit. Sequence of invoke within request, will select record with max SEQ_NUM for REQUEST_ID. | |||
| PROCESSING_ID | NUMBER | Processing id of a PDOI process. Required for defaulting global record variable. | |||
| PROCESSING_ROUND_NUM | NUMBER | Round number of a PDOI process. Required for defaulting global variable. | |||
| PROCESS_STAGE | VARCHAR2 | 30 | Stage of a process. Used for defaulting the API from where job has to restart. Values of stages (COMPLETED, POSTPROCESS,MAINPROCESS,DISTRIBUTIONS,SCHEDULES, ATTRIBUTES,LINES,ORGASSIGN,HEADERS,PREPROCESS). | ||
| ALL_HEADERS_PROCESSED_FLAG | VARCHAR2 | 1 | All Header Processed Flag used to identify header records processed in each iteration of batch processing | ||
| IOI_BATCH_ID | NUMBER | Batch Id genertaed in pre processing and used in item import ess request | |||
| ITEM_PROCESSING_ROUND_NUM | NUMBER | Round number of a Item Import process. Required for defaulting global variable. | |||
| 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 |
|---|---|---|---|
| PO_PDOI_PROGRESS_U1 | Unique | Default | PROGRESS_ID |
| PO_PDOI_PROGRESS_U2 | Unique | Default | PDOI_REQUEST_ID, SEQ_NUM |