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_EVENTS_LOGS

Object Details

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

This table stores information from xla_events_gt which would have otherwise got lost after session expiry. The table is populated if the following conditions are met:
1. Budgetary Control Enabled.
2. Profile 'PSA Debug Mode' is set to Yes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_NUMBER	NUMBER	(15)		Line number
ENTITY_ID	NUMBER	(15)		Entity identifier
APPLICATION_ID	NUMBER	(15)		Application identifier
LEDGER_ID	NUMBER	(15)	Yes	Accounting books defining column
ENTITY_CODE	VARCHAR2	(30)		Entity code
SOURCE_ID_INT_1	NUMBER	(15)		Source identifier (number)
SOURCE_ID_CHAR_1	VARCHAR2	(30)		Source identifier (char)
EVENT_ID	NUMBER	(15)		Business event identifier
EVENT_CLASS_CODE	VARCHAR2	(30)		Business event class code
EVENT_STATUS_CODE	VARCHAR2	(1)		Business event status code
PROCESS_STATUS_CODE	VARCHAR2	(1)		Process status code
REFERENCE_NUM_1	NUMBER			Additional reference (number)
REFERENCE_CHAR_1	VARCHAR2	(240)		Additional reference (char)
ON_HOLD_FLAG	VARCHAR2	(1)		On hold flag
TRANSACTION_DATE	DATE			Transaction date
BUDGETARY_CONTROL_FLAG	VARCHAR2	(1)		Budgetary control flag
PHASE	VARCHAR2	(30)		Phase
CREATION_DATE	DATE			Standard who column - date when this row was created.

Query Text

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


SELECT LINE_NUMBER
,      ENTITY_ID
,      APPLICATION_ID
,      LEDGER_ID
,      ENTITY_CODE
,      SOURCE_ID_INT_1
,      SOURCE_ID_CHAR_1
,      EVENT_ID
,      EVENT_CLASS_CODE
,      EVENT_STATUS_CODE
,      PROCESS_STATUS_CODE
,      REFERENCE_NUM_1
,      REFERENCE_CHAR_1
,      ON_HOLD_FLAG
,      TRANSACTION_DATE
,      BUDGETARY_CONTROL_FLAG
,      PHASE
,      CREATION_DATE
FROM PSA.PSA_XLA_EVENTS_LOGS;

Dependencies

[top of page]

PSA.PSA_XLA_EVENTS_LOGS does not reference any database object

PSA.PSA_XLA_EVENTS_LOGS is referenced by following:

APPS: PSA_XLA_EVENTS_LOGS