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

VIEW: APPS.OKL_SIF_RET_ERRORS_V

Object Details
Object Name: OKL_SIF_RET_ERRORS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_SIF_RET_ERRORS_V
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.OKL_SIF_RET_ERRORS_V references the following:

SchemaAPPS
SynonymOKL_SIF_RET_ERRORS
APPS.OKL_SIF_RET_ERRORS_V is referenced by following:

SchemaAPPS
PL/SQL PackageOKL_SRM_PVT - show dependent code
Package BodyOKL_SRM_PVT - show dependent code