[Home] [Help] [Dependency Information]
Object Name: | IGC_CBC_INTERFACE_EXCEPTIONS |
---|---|
Object Type: | TABLE |
Owner: | IGC |
FND Design Data: | IGC.IGC_CBC_INTERFACE_EXCEPTIONS |
Subobject Name: | |
Status: | VALID |
IGC_CBC_INTERFACE_EXCEPTIONS stores temporary data pertaining to errors that were generated during the commitment budgetary control module's open interface data load validation. Prior to the start of the open interface data load validation, the data from the previous load is deleted from the table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGC_CBC_INTERFACE_EXCEPS_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
PERIOD_NAME
SET_OF_BOOKS_ID |
IGC_CBC_INTERFACE_EXCEPS_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
CBC_JE_LINE_NUM
SET_OF_BOOKS_ID |
IGC_CBC_INTERFACE_EXCEPS_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CBC_JE_BATCH_ID | NUMBER | (15) | Journal entry batch defining column | |
CBC_JE_LINE_NUM | NUMBER | (15) | Yes | Journal entry line number |
RESULT_CODE | VARCHAR2 | (3) | Error code of data validation | |
PERIOD_SET_NAME | VARCHAR2 | (15) | Accounting calendar name | |
PERIOD_NAME | VARCHAR2 | (15) | System-generated accounting period name | |
QUARTER_NUM | NUMBER | (15) | Quarter number of accounting period | |
PERIOD_YEAR | NUMBER | (15) | Accounting period year | |
PERIOD_NUM | NUMBER | (15) | Accounting period number | |
SET_OF_BOOKS_ID | NUMBER | (15) | Accounting books defining column |
Cut, paste (and edit) the following text to query this object:
SELECT CBC_JE_BATCH_ID
, CBC_JE_LINE_NUM
, RESULT_CODE
, PERIOD_SET_NAME
, PERIOD_NAME
, QUARTER_NUM
, PERIOD_YEAR
, PERIOD_NUM
, SET_OF_BOOKS_ID
FROM IGC.IGC_CBC_INTERFACE_EXCEPTIONS;
IGC.IGC_CBC_INTERFACE_EXCEPTIONS does not reference any database object
IGC.IGC_CBC_INTERFACE_EXCEPTIONS is referenced by following:
|
|
|