AR_SUM_REF_EVENT_HIST
The AR_SUM_REF_EVENT_HIST table temporarily stores the history of all AR business events that different transactional activities raise while the Refresh Receivables Transactions Summary Tables concurrent program is running. When the Refresh Receivables Transactions Summary Tables concurrent program completes, the concurrent program processes the business events. After processing the business events, the concurrent program then deletes the records from the AR_SUM_REF_EVENT_HIST table.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BUSINESS_EVENT_NAME | VARCHAR2 | 240 | Yes | Oracle internal use only. | |
| 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. | |
| EVENT_KEY | VARCHAR2 | 240 | Yes | Uniquely identifies a specific instance of a business event. | |
| PAYMENT_SCHEDULE_ID | NUMBER | 18 | Unique identifier of the payment schedule record of the transaction that raised the business event. | ||
| CUSTOMER_TRX_ID | NUMBER | 18 | Unique identifier of the transaction that raised the business event. | ||
| CASH_RECEIPT_ID | NUMBER | 18 | Unique identifier of the cash receipt that raised the business event. | ||
| RECEIVABLE_APPLICATION_ID | NUMBER | 18 | Unique identifier of the receivable applications record that raised the business event. | ||
| ADJUSTMENT_ID | NUMBER | 18 | Unique identifier of the adjustment that raised the business event. | ||
| HISTORY_ID | NUMBER | 18 | Unique identifier of the AR_TRX_SUMMARY_HIST record. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| 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_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| PROCESSED_FLAG | VARCHAR2 | 1 | Not currently used. |