RA_INTERFACE_ERRORS_ALL
The RA_INTERFACE_ERRORS_ALL table stores information about interface data that failed the AutoInvoice validation step. Oracle Receivables uses the information in this table to generate the AutoInvoice Validation report. AutoInvoice identifies all errors for each transaction line, thus reducing multiple validation and correction cycles. The primary keys for this table are INTERFACE_LINE_ID, INTERFACE_SALESCREDIT_ID, and INTERFACE_DISTRIBUTION_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_LINE_ID | NUMBER | 18 | Identifies the interface line | ||
| INTERFACE_SALESCREDIT_ID | NUMBER | 18 | Identifies the sales credit | ||
| INTERFACE_DISTRIBUTION_ID | NUMBER | 18 | Identifies the distribution line | ||
| MESSAGE_TEXT | VARCHAR2 | 240 | Error message text | ||
| INVALID_VALUE | VARCHAR2 | 240 | The invalid value that failed validation | ||
| LINK_TO_LINE_ID | NUMBER | 18 | The INTERFACE_LINE_ID of the line to which this line that failed validation is linked | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| INTERFACE_CONTINGENCY_ID | NUMBER | 18 | Identifies the contingency | ||
| 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. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RA_INTERFACE_ERRORS_N1 | Non Unique | Default | INTERFACE_LINE_ID |
| RA_INTERFACE_ERRORS_N2 | Non Unique | Default | LINK_TO_LINE_ID |
| RA_INTERFACE_ERRORS_N3 | Non Unique | Default | MESSAGE_TEXT |