eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IBY.IBY_TRANSACTION_ERRORS

Object Details

Object Name:	IBY_TRANSACTION_ERRORS
Object Type:	TABLE
Owner:	IBY
FND Design Data:	IBY.IBY_TRANSACTION_ERRORS
Subobject Name:
Status:	VALID

IBY_TRANSACTION_ERRORS stores any errors encountered during payment processing validations.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_TRANSACTION_ERRORS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ERROR_ID
IBY_TRANSACTION_ERRORS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CALLING_APP_ID PAY_PROC_TRXN_TYPE_CODE
IBY_TRANSACTION_ERRORS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID TRANSACTION_TYPE
IBY_TRANSACTION_ERRORS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ERROR_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ERROR_ID	NUMBER	(15)	Yes	System generated primary key
TRANSACTION_TYPE	VARCHAR2	(30)	Yes	Transaction type. Values from the lookup IBY_TRANSACTION_TYPES include DOCUMENT_PAYABLE, PAYMENT, and PAYMENT_INSTRUCTION.
TRANSACTION_ID	NUMBER	(15)	Yes	Transaction Identifier
ERROR_CODE	VARCHAR2	(30)	Yes	Error code for failed transaction. If ERROR_TYPE is BANK, this is a bank-specific error code.
ERROR_DATE	DATE		Yes	Date on which the error occurred
ERROR_STATUS	VARCHAR2	(30)	Yes	Whether the error is still active, that is, the error still applies, passed, or overridden. Values from the lookup IBY_TRANSACTION_ERROR_STATUSES include ACTIVE, PASSED, and OVERRIDDEN. The last two values only apply to validation errors.
CALLING_APP_DOC_UNIQUE_REF1	VARCHAR2	(100)		Source product''s first unique document payable Identifier
OVERRIDE_ALLOWED_ON_ERROR_FLAG	VARCHAR2	(1)	Yes	Y or N flag specifying whether this validation error can be overridden by the payment administrator. Some validation errors are fatal and the condition causing the error must be corrected so the payment instruction can be validated successfully. By default, this flag is Y. For fatal errors, the Create Payment Instructions program sets this flag to N.
DO_NOT_APPLY_ERROR_FLAG	VARCHAR2	(1)	Yes	Y or N flag which only applies to errors on payment instructions. The value is N by default and only changes to Y if an administrator overrides the error. When a payment instruction is resubmitted to the Create Payment Instructions program and validations are applied, this error is not applied when the value is Y.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
CALLING_APP_ID	NUMBER	(15)		Source product Identifier
PAY_PROC_TRXN_TYPE_CODE	VARCHAR2	(100)		Payment processing transaction type striped by application
CALLING_APP_DOC_UNIQUE_REF2	VARCHAR2	(100)		Source product''s second unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF3	VARCHAR2	(100)		Source product''s third unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF4	VARCHAR2	(100)		Source product''s fourth unique document payable Identifier
CALLING_APP_DOC_UNIQUE_REF5	VARCHAR2	(100)		Source product''s fifth unique document payable Identifier
ERROR_TYPE	VARCHAR2	(30)		Type of error. Values from the lookup IBY_TRANSACTION_ERROR_TYPES include VALIDATION and BANK.
ERROR_MESSAGE	VARCHAR2	(255)		Error message for failed transaction. If ERROR_TYPE is BANK, this is a bank-specific error code.
VALIDATION_SET_CODE	VARCHAR2	(30)		Identifier of the validation set that was violated if ERROR_TYPE is VALIDATION.
PASS_DATE	DATE			Date on which the validation set that gave rise to this error was passed. This column is not be populated if the DO_NOT_APPLY_ERROR_FLAG is Y.
OVERRIDE_JUSTIFICATION	VARCHAR2	(255)		Justification for overriding validation error. This column is only populated if the DO_NOT_APPLY_ERROR_FLAG is Y.
OVERRIDE_DATE	DATE			Date on which the error was overridden. This column is only populated if the DO_NOT_APPLY_ERROR_FLAG is Y.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_ERROR_ID
,      TRANSACTION_TYPE
,      TRANSACTION_ID
,      ERROR_CODE
,      ERROR_DATE
,      ERROR_STATUS
,      CALLING_APP_DOC_UNIQUE_REF1
,      OVERRIDE_ALLOWED_ON_ERROR_FLAG
,      DO_NOT_APPLY_ERROR_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
,      CALLING_APP_ID
,      PAY_PROC_TRXN_TYPE_CODE
,      CALLING_APP_DOC_UNIQUE_REF2
,      CALLING_APP_DOC_UNIQUE_REF3
,      CALLING_APP_DOC_UNIQUE_REF4
,      CALLING_APP_DOC_UNIQUE_REF5
,      ERROR_TYPE
,      ERROR_MESSAGE
,      VALIDATION_SET_CODE
,      PASS_DATE
,      OVERRIDE_JUSTIFICATION
,      OVERRIDE_DATE
FROM IBY.IBY_TRANSACTION_ERRORS;

Dependencies

[top of page]

IBY.IBY_TRANSACTION_ERRORS does not reference any database object

IBY.IBY_TRANSACTION_ERRORS is referenced by following:

IBY: IBY_TRANSACTION_ERRORS#