[Home] [Help] [Dependency Information]
Object Name: | RG_DSS_REQUESTS |
---|---|
Object Type: | TABLE |
Owner: | RG |
FND Design Data: | RG.RG_DSS_REQUESTS |
Subobject Name: | |
Status: | VALID |
RG_DSS_REQUESTS stores information about the extraction and load requests. Each record stores one extract/load request: the name of the program (PROGRAM_TYPE), the parameters of the program, the location of the output file (FILE_SPEC), and the current status of the request (STATUS_FLAG).
The valid statuses are 'P' for Extracting, 'N' for New, 'L' for Loading, 'D' for Loaded, 'C' for Cancel, 'H' for Launched, and 'E' for Error.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RG_DSS_REQUESTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
RG_DSS_REQUESTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PROGRAM_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROGRAM_TYPE | VARCHAR2 | (1) | Yes | Program type (Segment, Balances, Hierarchy, Currency, Rates, or Calendar) |
REQUEST_ID | NUMBER | (15) | Yes | The request identifier of the current extract or load request |
CONCURRENT_REQUEST_ID | NUMBER | (15) | Yes | Concurrent request identifier of the extraction run |
STATUS_FLAG | VARCHAR2 | (1) | Yes | Status of the extraction request (Extracting, New, Loading, Loaded, Cancel, Launched, Error) |
LEVEL_CODE | VARCHAR2 | (1) | Extraction level (Summary or Detail) | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
FILE_SPEC | VARCHAR2 | (240) | Location of the extraction file | |
EXTRACTION_START_DATE | DATE | Start time of the extraction process | ||
EXTRACTION_END_DATE | DATE | End time of the extraction process | ||
LOAD_START_DATE | DATE | Start time of the load process | ||
LOAD_END_DATE | DATE | End time of the load process | ||
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Key flexfield structure number | |
LEDGER_ID | NUMBER | (15) | Ledger defining column | |
FROM_PERIOD | VARCHAR2 | (15) | From period | |
TO_PERIOD | VARCHAR2 | (15) | To period | |
BALANCE_TYPE | VARCHAR2 | (4) | Balance Type | |
BUDGET_VERSION_ID | NUMBER | (15) | Budget version defining column | |
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | Encumbrance defining column (-1 - total of all encumbrances, -2 - for all encumbrances) | |
TEMPLATE_ID | NUMBER | (15) | Summary template defining column (-1 - for all summary templates) | |
DAY_OF_PERIOD | NUMBER | (15) | Day of period to be used (-1 - for last day in each period) | |
HIERARCHY_ID | NUMBER | (15) | Hierarchy defining column | |
PERIOD_YEAR | NUMBER | (15) | Accounting period year |
Cut, paste (and edit) the following text to query this object:
SELECT PROGRAM_TYPE
, REQUEST_ID
, CONCURRENT_REQUEST_ID
, STATUS_FLAG
, LEVEL_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, FILE_SPEC
, EXTRACTION_START_DATE
, EXTRACTION_END_DATE
, LOAD_START_DATE
, LOAD_END_DATE
, CHART_OF_ACCOUNTS_ID
, LEDGER_ID
, FROM_PERIOD
, TO_PERIOD
, BALANCE_TYPE
, BUDGET_VERSION_ID
, ENCUMBRANCE_TYPE_ID
, TEMPLATE_ID
, DAY_OF_PERIOD
, HIERARCHY_ID
, PERIOD_YEAR
FROM RG.RG_DSS_REQUESTS;
RG.RG_DSS_REQUESTS does not reference any database object
RG.RG_DSS_REQUESTS is referenced by following:
|
|
|