AR_CONC_PROCESS_REQUESTS
The AR_CONC_PROCESS_REQUESTS table contains a list of Oracle Receivables AutoInvoice and Customer Merge concurrent requests that are or should be currently running. Because the AutoInvoice and Customer Merge programs can run multiple instances at the same time, the information in this table tells these programs which requests are current. For example, AutoInvoice might encounter an error or terminate abnormally. The corresponding row is marked with the request that is not current. A new run of AutoInvoice will mark that row again. . The primary key for this table is REQUEST_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_CONC_PROCESS_REQUESTS_PK |
REQUEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONCURRENT_PROGRAM_NAME | VARCHAR2 | 30 | Yes | Concurrent process name. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| 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. | |
| REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_CONC_PROCESS_REQUESTS_U1 | Unique | Default | REQUEST_ID |