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_BC_ACCOUNTING_ERRORS

Object Details

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

This table stores information from xla_accounting_errors. Since this table is commited autonomously information from xla_accounting_errors can be displayed in the 'Budgetary Control Results Report' which would have been otherwise lost in case of an error situation due to rollbacks.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_ID	NUMBER	(15)		Business event identifier
ENTITY_ID	NUMBER	(15)		Entity identifier
APPLICATION_ID	NUMBER	(15)	Yes	Application identifier
AE_HEADER_ID	NUMBER	(15)		XLA journal entry header defining column
AE_LINE_NUM	NUMBER	(15)		XLA journal entry line defining column
TRANSACTION_DATE	DATE			Transaction date
MESSAGE_NUMBER	NUMBER	(9)		Message number
MESSAGE_NAME	VARCHAR2	(30)		Message name
ENCODED_MESSAGE	VARCHAR2	(2000)		Encoded message
ERROR_SOURCE_CODE	VARCHAR2	(30)		Error source code
LEDGER_ID	NUMBER	(15)	Yes	Accounting books defining column
LEGAL_ENTITY_ID	NUMBER	(15)		Legal entity identifier
DOCUMENT_REFERENCE	VARCHAR2	(240)		Document reference
BATCH_REFERENCE	VARCHAR2	(240)		Batch reference
LINE_REFERENCE	VARCHAR2	(240)		Line reference
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
XLA_ERROR_FLAG	VARCHAR2	(1)		XLA Error flag

Query Text

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


SELECT EVENT_ID
,      ENTITY_ID
,      APPLICATION_ID
,      AE_HEADER_ID
,      AE_LINE_NUM
,      TRANSACTION_DATE
,      MESSAGE_NUMBER
,      MESSAGE_NAME
,      ENCODED_MESSAGE
,      ERROR_SOURCE_CODE
,      LEDGER_ID
,      LEGAL_ENTITY_ID
,      DOCUMENT_REFERENCE
,      BATCH_REFERENCE
,      LINE_REFERENCE
,      CREATION_DATE
,      XLA_ERROR_FLAG
FROM PSA.PSA_BC_ACCOUNTING_ERRORS;

Dependencies

[top of page]

PSA.PSA_BC_ACCOUNTING_ERRORS does not reference any database object

PSA.PSA_BC_ACCOUNTING_ERRORS is referenced by following:

APPS: PSA_BC_ACCOUNTING_ERRORS