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_AE_HEADERS_LOGS

Object Details

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

This table stores information from xla_ae_headers_gt which would have otherwise got lost after session expiry. This table gets 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	Comments
AE_HEADER_ID	NUMBER	(15)	XLA journal entry header defining column
LEDGER_ID	NUMBER	(15)	Accounting books defining column
EVENT_ID	NUMBER	(15)	Business event identifier
EVENT_TYPE_CODE	VARCHAR2	(30)	Business event type code
ACCOUNTING_ENTRY_STATUS_CODE	VARCHAR2	(30)	Accounting entry status code
BALANCE_TYPE_CODE	VARCHAR2	(1)	Balance type code
FUNDS_STATUS_CODE	VARCHAR2	(30)	Funds status code
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 AE_HEADER_ID
,      LEDGER_ID
,      EVENT_ID
,      EVENT_TYPE_CODE
,      ACCOUNTING_ENTRY_STATUS_CODE
,      BALANCE_TYPE_CODE
,      FUNDS_STATUS_CODE
,      PHASE
,      CREATION_DATE
FROM PSA.PSA_XLA_AE_HEADERS_LOGS;

Dependencies

[top of page]

PSA.PSA_XLA_AE_HEADERS_LOGS does not reference any database object

PSA.PSA_XLA_AE_HEADERS_LOGS is referenced by following:

APPS: PSA_XLA_AE_HEADERS_LOGS