[Home] [Help] [Dependency Information]
Object Name: | AR_ARCHIVE_CONTROL |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_ARCHIVE_CONTROL |
Subobject Name: | |
Status: | VALID |
The AR_ARCHIVE_CONTROL table stores historical data for Archive and Purge submissions. Each Archive and Purge process inserts a record into this table. For example, if you run Archive-Preview, Oracle Receivables creates one record for each control module, selection and validation process, archive, and so on.
.
All records that are associated with a particular run have the same value in the ARCHIVE_ID column and are distinguished by the REQUEST_ID column. As each step in the archive process begins, Receivables inserts a record and updates the STATUS column with R for running. When the step is finished, Receivables updates the STATUS column with C for complete, and inserts a new record with a status of R for the next step of the process.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
TRANSACTION_MODE | VARCHAR2 | (1) | Archive run parameter | |
TRANSACTION_TYPE | VARCHAR2 | (1) | Archive run parameter | |
TRANSACTION_PERIOD | VARCHAR2 | (15) | Archive run parameter | |
OPEN_RECEIVABLES | VARCHAR2 | (1) | Archive run parameter | |
POSTABLE | VARCHAR2 | (1) | Archive run parameter | |
ARCHIVE_LEVEL | VARCHAR2 | (1) | Archive run parameter | |
NUMBER_OF_PROCESSES | NUMBER | Archive run parameter | ||
COMMIT_SIZE | NUMBER | Archive run parameter | ||
STATUS | VARCHAR2 | (1) | Archive run parameter | |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
COMMENTS | VARCHAR2 | (240) | Comments | |
ARCHIVE_ID | VARCHAR2 | (15) | Identifier of the archive process |
Cut, paste (and edit) the following text to query this object:
SELECT CREATION_DATE
, CREATED_BY
, TRANSACTION_MODE
, TRANSACTION_TYPE
, TRANSACTION_PERIOD
, OPEN_RECEIVABLES
, POSTABLE
, ARCHIVE_LEVEL
, NUMBER_OF_PROCESSES
, COMMIT_SIZE
, STATUS
, REQUEST_ID
, COMMENTS
, ARCHIVE_ID
FROM AR.AR_ARCHIVE_CONTROL;
AR.AR_ARCHIVE_CONTROL does not reference any database object
AR.AR_ARCHIVE_CONTROL is referenced by following:
|
|
|