PO_ONLINE_REPORT_TEXT
Contains information about the purchasing documents that fail the approval, cancel or final-close submission checks. There is one record in this table for each error detected during the submission check. Each row includes the error that was detected and the document entity that the error is associated with.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PO_ONLINE_REPORT_TEXT_PK |
ONLINE_REPORT_ID, SEQUENCE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ONLINE_REPORT_ID | NUMBER | 18 | Yes | Online report unique identifier | |
| ENCODED_MESSAGE | VARCHAR2 | 2000 | Additional message in encoded format | ||
| 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. | |
| SEQUENCE | NUMBER | Yes | Sequence of the online report message | ||
| 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. | ||
| 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_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| TEXT_LINE | VARCHAR2 | 4000 | Online report message | ||
| LINE_NUM | NUMBER | Requisition or purchase order line that message references | |||
| SHIPMENT_NUM | NUMBER | Purchase orders shipment that message references | |||
| DISTRIBUTION_NUM | NUMBER | Requisition or purchase order distribution that message references | |||
| QUANTITY | NUMBER | No longer used | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or 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. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | PROGRAM_NAME | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | PROGRAM_APP_NAME | ||
| MESSAGE_TYPE | VARCHAR2 | 1 | Indicates whether this message is a warning ('W'), alert ('A') or an error ('E' or null). | ||
| SEGMENT1 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| DISTRIBUTION_TYPE | VARCHAR2 | 25 | Distribution Type | ||
| VERSION_ID | NUMBER | 18 | VERSION_ID | ||
| XCC_DATA_SET_ID | NUMBER | 18 | Data set id for the rows processed by XCC engine | ||
| MESSAGE_NAME | VARCHAR2 | 40 | Message Name |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PO_ONLINE_REPORT_TEXT_N1 | Non Unique | Default | VERSION_ID |
| PO_ONLINE_REPORT_TEXT_N2 | Non Unique | Default | SEQUENCE, REQUEST_ID |
| PO_ONLINE_REPORT_TEXT_U1 | Unique | Default | ONLINE_REPORT_ID, SEQUENCE |