DBA Data[Home] [Help] [Dependency Information]

TABLE: AR.AR_ARCHIVE_CONTROL

Object Details
Object Name: AR_ARCHIVE_CONTROL
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
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
Query Text

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;

Dependencies

[top of page]

AR.AR_ARCHIVE_CONTROL does not reference any database object

AR.AR_ARCHIVE_CONTROL is referenced by following:

SchemaAR
ViewAR_ARCHIVE_CONTROL#