[Home] [Help] [Dependency Information]
Object Name: | OKL_SIF_RET_ERRORS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_SIF_RET_ERRORS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Various details about errors returned by the external pricing engine like the error message, XML tag
for which error was thrown etc. are stored here. Reference to the stream interface return header is
also stored here.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Auto-generated by Headstart Utilities | |
ID | NUMBER | Yes | Primary key column | |
ERROR_CODE | VARCHAR2 | (80) | Error code returned from the pricing engine. | |
DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
TAG_ATTRIBUTE_NAME | VARCHAR2 | (150) | XML tag value for which error occurred. | |
TAG_NAME | VARCHAR2 | (1000) | Name | |
SIR_ID | NUMBER | Yes | Foreign key to table OKL_SIF_RETS | |
ERROR_MESSAGE | VARCHAR2 | (240) | Error message returned from the pricing engine. | |
TAG_ATTRIBUTE_VALUE | VARCHAR2 | (80) | XML tag value for which error occurred. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
STREAM_INTERFACE_ATTRIBUTE01 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE02 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE03 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE04 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE05 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE06 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE07 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE08 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE09 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE10 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE11 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE12 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE13 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE14 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE15 | VARCHAR2 | (450) | Generic attribute for extensions. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, ERROR_CODE
, DESCRIPTION
, TAG_ATTRIBUTE_NAME
, TAG_NAME
, SIR_ID
, ERROR_MESSAGE
, TAG_ATTRIBUTE_VALUE
, OBJECT_VERSION_NUMBER
, STREAM_INTERFACE_ATTRIBUTE01
, STREAM_INTERFACE_ATTRIBUTE02
, STREAM_INTERFACE_ATTRIBUTE03
, STREAM_INTERFACE_ATTRIBUTE04
, STREAM_INTERFACE_ATTRIBUTE05
, STREAM_INTERFACE_ATTRIBUTE06
, STREAM_INTERFACE_ATTRIBUTE07
, STREAM_INTERFACE_ATTRIBUTE08
, STREAM_INTERFACE_ATTRIBUTE09
, STREAM_INTERFACE_ATTRIBUTE10
, STREAM_INTERFACE_ATTRIBUTE11
, STREAM_INTERFACE_ATTRIBUTE12
, STREAM_INTERFACE_ATTRIBUTE13
, STREAM_INTERFACE_ATTRIBUTE14
, STREAM_INTERFACE_ATTRIBUTE15
, CREATED_BY
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKL_SIF_RET_ERRORS_V;
|
|
|