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: PSA.PSA_XLA_ACCOUNTING_ERRORS

Object Details

Object Name:	PSA_XLA_ACCOUNTING_ERRORS
Object Type:	TABLE
Owner:	PSA
Subobject Name:
Status:	VALID

Table to store SLA accounting errors

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSA_XLA_ACCOUNTING_ERRORS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTITY_CODE SOURCE_ID_INT_1 SOURCE_ID_INT_2 SOURCE_ID_INT_3 SOURCE_ID_INT_4
PSA_XLA_ACCOUNTING_ERRORS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEDGER_ID APPLICATION_ID ENTITY_ID EVENT_ID EVENT_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNTING_ERROR_ID	NUMBER	(15)	Yes	Accounting Error Sequence Identifier
APPLICATION_ID	NUMBER	(15)		Application Identifier
LEDGER_ID	NUMBER	(15)		Ledger Identifier
ENTITY_CODE	VARCHAR2	(30)		SLA Entity Code
ENTITY_ID	NUMBER	(15)		SLA Entity Identifier
EVENT_DATE	DATE			SLA Eevent Date
EVENT_ID	NUMBER	(15)		Event Identifier
TRANSACTION_NUMBER	VARCHAR2	(240)		Transaction Number
AE_HEADER_ID	NUMBER	(15)		SLA AE Header Identifier
AE_LINE_NUM	NUMBER	(15)		SLA AE Line Number
SOURCE_ID_INT_1	NUMBER	(15)		Source ID INT 1
SOURCE_ID_INT_2	NUMBER	(15)		Source ID INT 2
SOURCE_ID_INT_3	NUMBER	(15)		Source ID INT 3
SOURCE_ID_INT_4	NUMBER	(15)		Source ID INT 4
SOURCE_ID_CHAR_1	VARCHAR2	(240)		Source ID Char 1
SOURCE_ID_CHAR_2	VARCHAR2	(240)		Source ID Char 2
SOURCE_ID_CHAR_3	VARCHAR2	(240)		Source ID Char 3
SOURCE_ID_CHAR_4	VARCHAR2	(240)		Source ID Char 4
MESSAGE_CODE	VARCHAR2	(240)		Message Code
MESSAGE_NUM	NUMBER	(15)		Message Number
ENCODED_MSG	VARCHAR2	(2000)		Encoded Message
AUDSID	NUMBER	(15)		Aud System Identifier
CREATION_DATE	DATE			Creation Date
CREATED_BY	NUMBER	(15)		Created By User ID

Query Text

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


SELECT ACCOUNTING_ERROR_ID
,      APPLICATION_ID
,      LEDGER_ID
,      ENTITY_CODE
,      ENTITY_ID
,      EVENT_DATE
,      EVENT_ID
,      TRANSACTION_NUMBER
,      AE_HEADER_ID
,      AE_LINE_NUM
,      SOURCE_ID_INT_1
,      SOURCE_ID_INT_2
,      SOURCE_ID_INT_3
,      SOURCE_ID_INT_4
,      SOURCE_ID_CHAR_1
,      SOURCE_ID_CHAR_2
,      SOURCE_ID_CHAR_3
,      SOURCE_ID_CHAR_4
,      MESSAGE_CODE
,      MESSAGE_NUM
,      ENCODED_MSG
,      AUDSID
,      CREATION_DATE
,      CREATED_BY
FROM PSA.PSA_XLA_ACCOUNTING_ERRORS;

Dependencies

[top of page]

PSA.PSA_XLA_ACCOUNTING_ERRORS does not reference any database object

PSA.PSA_XLA_ACCOUNTING_ERRORS is referenced by following:

PSA: PSA_XLA_ACCOUNTING_ERRORS#