POR_AGENT_DOCUMENT_REQUESTS
POR_AGENT_DOCUMENT_REQUESTS stores and manages information about document requests initiated or processed by agents within the procurement workflow. This table captures metadata such as origins, workflow processing status, related request identifiers, tracking details, error messages, and full audit trail including creation and update information, supporting document traceability and compliance.
Details
-
Schema: FUSION
-
Object owner: POR
-
Object type: TABLE
-
Tablespace: POR_AGENT_DOCUMENT_REQUESTS
Primary Key
| Name | Columns |
|---|---|
|
POR_AGENT_DOCUMENT_REQUEST_PK |
DOCUMENT_REQUEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_REQUEST_ID | NUMBER | 18 | Yes | Unique identifier for the document request (Primary Key). | |
| EMAIL_MESSAGE_ID | NUMBER | 18 | References the associated email message containing the document request. | ||
| EMAIL_ATTACHMENT_ID | NUMBER | 18 | References the related email attachment. | ||
| DOCUMENT_TRACKER_ID | VARCHAR2 | 40 | Identifier for tracking the document through its processing lifecycle. | ||
| WORKFLOW_EXECUTION_NUMBER | VARCHAR2 | 200 | Identifier for the specific workflow execution associated with the document request. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| REQUISITION_HEADER_ID | NUMBER | 18 | Identifier for the requisition header related to the document request. | ||
| SENDER_PERSON_ID | NUMBER | 18 | Identifier of the person who sent or initiated the document request. | ||
| PROCESS_STATUS | VARCHAR2 | 50 | Status of the document processing. | ||
| ERROR_TEXT | CLOB | Detailed error message or information if the document processing failed. | |||
| RECEIVED_DATE_TIME | TIMESTAMP | The date and time when the document request was received by the system. | |||
| 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. | |
| 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 |
|---|---|---|---|
| POR_AGENT_DOCUMENT_REQUEST_PK | Unique | POR_AGENT_DOCUMENT_REQUEST_PK | DOCUMENT_REQUEST_ID |