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

TABLE: RG.RG_DSS_REQUESTS

Object Details
Object Name: RG_DSS_REQUESTS
Object Type: TABLE
Owner: RG
FND Design Data: TableRG.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RG_DSS_REQUESTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
RG_DSS_REQUESTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROGRAM_TYPE
Columns
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
Query Text

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;

Dependencies

[top of page]

RG.RG_DSS_REQUESTS does not reference any database object

RG.RG_DSS_REQUESTS is referenced by following:

SchemaRG
ViewRG_DSS_REQUESTS#