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: IPA.IPA_APIS_INTERFACE_ERRORS

Object Details

Object Name:	IPA_APIS_INTERFACE_ERRORS
Object Type:	TABLE
Owner:	IPA
FND Design Data:	IPA.IPA_APIS_INTERFACE_ERRORS
Subobject Name:
Status:	VALID

Table to store Exceptions by the Asset placed in Service interface Process

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
INTERFACE_ID	NUMBER	(10)	Identifier of the record in table IFA_ASSET_INTERFACE for which error messages are generated
BATCH_NAME	VARCHAR2	(60)	Identifier of the batch in table IFA_ASSET_INTERFACE for which error message are generated
PROJECT_ID	NUMBER	(10)	Project Id of the Asset not successfuly processed by the Place in Service Process
PROJECT_ASSET_ID	NUMBER	(10)	Project Asset Id of the Asset not successfully processed by the Place in Service Process
DATE_PLACED_IN_SERVICE	DATE		Date Placed In Service of the Asset not successfully processed by the Place in Service Process
ASSET_STATUS	VARCHAR2	(20)	Status of the Asset not successfully processed by the Place in Service Process
ERROR_MESSAGE	VARCHAR2	(2000)	Reason why the Asset could not be placed into Service

Query Text

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


SELECT INTERFACE_ID
,      BATCH_NAME
,      PROJECT_ID
,      PROJECT_ASSET_ID
,      DATE_PLACED_IN_SERVICE
,      ASSET_STATUS
,      ERROR_MESSAGE
FROM IPA.IPA_APIS_INTERFACE_ERRORS;

Dependencies

[top of page]

IPA.IPA_APIS_INTERFACE_ERRORS does not reference any database object

IPA.IPA_APIS_INTERFACE_ERRORS is referenced by following:

APPS: IPA_APIS_INTERFACE_ERRORS