[Home] [Help] [Dependency Information]
Object Name: | QP_INTERFACE_ERRORS |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.QP_INTERFACE_ERRORS |
Subobject Name: | |
Status: | VALID |
QP_INTERFACE_ERRORS stores errors that occur during the bulk import of pricing objects.
Scope: public
Product: QP
Display Name: Interface Errors
Category: BUSINESS_ENTITY QP_PRICE_LIST
Category: BUSINESS_ENTITY QP_PRICE_QUALIFIER
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QP_INTERFACE_ERRORS_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | ERROR_ID |
QP_INTERFACE_ERRORS_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
REQUEST_ID
ORIG_SYS_HEADER_REF ORIG_SYS_LINE_REF ORIG_SYS_PRICING_ATTR_REF |
QP_INTERFACE_ERRORS_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
REQUEST_ID
ORIG_SYS_HEADER_REF ORIG_SYS_QUALIFIER_REF |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ERROR_ID | NUMBER | Yes | Not Null, System generated. | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column. | |
CREATION_DATE | DATE | Yes | Standard who column. | |
CREATED_BY | NUMBER | Yes | Standard who column. | |
REQUEST_ID | NUMBER | Standard who column. | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard who column. | ||
PROGRAM_ID | NUMBER | Standard who column. | ||
PROGRAM_UPDATE_DATE | DATE | Standard who column. | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column. | ||
ENTITY_TYPE | VARCHAR2 | (30) | The entity type uploaded eg: 'PRL' | |
TABLE_NAME | VARCHAR2 | (30) | The error occurred while populating this table. | |
COLUMN_NAME | VARCHAR2 | (80) | In the case of attribute level error the corresponding attribute name is populated here | |
ERROR_MESSAGE | VARCHAR2 | (240) | The description of the Error. | |
ORIG_SYS_LINE_REF | VARCHAR2 | (50) | The combination of ORIG_SYS_HEADER_REF, ORIG_SYS_LINE_REF, ORIG_SYS_PRICING_ATTR_REF is the primary key of the equivalent of the pricing attribute table of the external system from where the price data is loaded. | |
ORIG_SYS_PRICING_ATTR_REF | VARCHAR2 | (50) | The combination of ORIG_SYS_HEADER_REF, ORIG_SYS_LINE_REF, ORIG_SYS_PRICING_ATTR_REF is the primary key of the equivalent of the pricing attribute table of the external system from where the price data is loaded. | |
ORIG_SYS_HEADER_REF | VARCHAR2 | (50) | The combination of ORIG_SYS_HEADER_REF, ORIG_SYS_LINE_REF, ORIG_SYS_PRICING_ATTR_REF is the primary key of the equivalent of the pricing attribute table of the external system from where the price data is loaded. | |
ORIG_SYS_QUALIFIER_REF | VARCHAR2 | (50) | The unique identification of the equivalent of the Qualifier table in the external system from where the data is imported. |
Cut, paste (and edit) the following text to query this object:
SELECT ERROR_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ENTITY_TYPE
, TABLE_NAME
, COLUMN_NAME
, ERROR_MESSAGE
, ORIG_SYS_LINE_REF
, ORIG_SYS_PRICING_ATTR_REF
, ORIG_SYS_HEADER_REF
, ORIG_SYS_QUALIFIER_REF
FROM QP.QP_INTERFACE_ERRORS;
QP.QP_INTERFACE_ERRORS does not reference any database object
QP.QP_INTERFACE_ERRORS is referenced by following:
|
|
|