OSS_BULK_PROCESSING_ERRORS
Subscription DML transactions that cause the backend process to terminate unexpectedly are captured in this table. The information stored here is used to quarantine the affected records within the transaction, allowing the DML operation to proceed while excluding the error records from further processing.
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: DEFAULT
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ORA_ERR_NUMBER$ | NUMBER | Oracle Error Number logged by the Oracle Error logging feature. | |||
| ORA_ERR_MESG$ | VARCHAR2 | 4000 | Oracle Error message logged by the Oracle Error logging feature. | ||
| ORA_ERR_ROWID$ | ROWID | ROWID of the error row logged by the Oracle Error logging feature. | |||
| ORA_ERR_OPTYP$ | VARCHAR2 | 2 | Type of the error logged by the Oracle Error logging feature. e.g. I - Insert, D - Delete, U - Update. | ||
| ORA_ERR_TAG$ | VARCHAR2 | 4000 | Identifies the tag for the logged error. The tag is concatenated string of request_id and the sql name in the error. | ||
| BILL_LINE_ID | NUMBER | 18 | Identifier for Bill Line Id. | ||
| BILL_LINE_PUID | VARCHAR2 | 120 | PUID for Bill Lines. | ||
| BILL_INSTANCE_NUMBER | NUMBER | 18 | Bill Instance Number. | ||
| SUBSCRIPTION_ID | NUMBER | 18 | Subscription identifier in Subscription Management. | ||
| SUBSCRIPTION_NUMBER | VARCHAR2 | 120 | PUID for Subscription. | ||
| SUBSCRIPTION_PRODUCT_ID | NUMBER | 18 | Subscription product identifier in Subscription Management. | ||
| PRODUCT_ASSOCIATION_ID | NUMBER | 18 | Product Association identifier in Subscription Management. | ||
| CHARGE_ID | NUMBER | 18 | Field used to capture charge id of product. | ||
| DOCUMENT_ID | NUMBER | 18 | Source document in RMCS. | ||
| DOCUMENT_LINE_ID | NUMBER | 18 | Source document line in RMCS. | ||
| DOCUMENT_SUB_LINE_ID | NUMBER | 18 | Source document sub line in RMCS. | ||
| 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. |