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: AR.RA_INTERFACE_ERRORS_ALL

Object Details

Object Name:	RA_INTERFACE_ERRORS_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.RA_INTERFACE_ERRORS_ALL
Subobject Name:
Status:	VALID

The RA_INTERFACE_ERRORS_ALL table stores information about interface data that failed the AutoInvoice validation step. Oracle Receivables uses the information in this table to generate the AutoInvoice Validation report. AutoInvoice identifies all errors for each transaction line, thus reducing multiple validation and correction cycles.
.
Please refer to the appendix of the Oracle Receivables User Guide or online help for more detailed information on Open Interface table columns, including import validation and destination columns.
.
The primary keys for this table are INTERFACE_LINE_ID, INTERFACE_SALESCREDIT_ID, and INTERFACE_DISTRIBUTION_ID.
Scope: public
Product: AR
Lifecycle: active
Display Name: AR Interface Errors
Category: BUSINESS_ENTITY AR_INVOICE
Category: BUSINESS_ENTITY AR_DEBIT_MEMO
Category: BUSINESS_ENTITY AR_CREDIT_MEMO

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RA_INTERFACE_ERRORS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INTERFACE_LINE_ID
RA_INTERFACE_ERRORS_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	LINK_TO_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_LINE_ID	NUMBER	(15)	Yes	Identifies the interface line
INTERFACE_SALESCREDIT_ID	NUMBER	(15)		Identifies the sales credit
INTERFACE_DISTRIBUTION_ID	NUMBER	(15)		Identifies the distribution line
MESSAGE_TEXT	VARCHAR2	(2000)		Error message text
INVALID_VALUE	VARCHAR2	(240)		The invalid value that failed validation
LINK_TO_LINE_ID	NUMBER	(15)		The INTERFACE_LINE_ID of the line to which this line that failed validation is linked
ORG_ID	NUMBER	(15)		Organization identifier
INTERFACE_CONTINGENCY_ID	NUMBER	(15)		Identifies the contingency

Query Text

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


SELECT INTERFACE_LINE_ID
,      INTERFACE_SALESCREDIT_ID
,      INTERFACE_DISTRIBUTION_ID
,      MESSAGE_TEXT
,      INVALID_VALUE
,      LINK_TO_LINE_ID
,      ORG_ID
,      INTERFACE_CONTINGENCY_ID
FROM AR.RA_INTERFACE_ERRORS_ALL;

Dependencies

[top of page]

AR.RA_INTERFACE_ERRORS_ALL does not reference any database object

AR.RA_INTERFACE_ERRORS_ALL is referenced by following:

AR: RA_INTERFACE_ERRORS_ALL#