XLA_BALANCE_STATUSES

This table contains the status of the balance for a code combination identifier and allows the simultaneous execution of the balance calculation, the balance recreation and the balance synchronization.

Details

Schema: FUSION
Object owner: XLA
Object type: TABLE
Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
XLA_BALANCE_STATUSES_PK	APPLICATION_ID, LEDGER_ID, CODE_COMBINATION_ID, BALANCE_SOURCE_CODE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
APPLICATION_ID	NUMBER		18	Yes	Functional area within a software suite of products. For example, Financials or Payroll.
LEDGER_ID	NUMBER		18	Yes	Self-contained accounting information set for single or multiple legal or management entities.
CODE_COMBINATION_ID	NUMBER		18	Yes	Account code combination identifier.
BALANCE_SOURCE_CODE	VARCHAR2	1		Yes	Indcates whether is supporting reference balance (A) or third party control balance.
BALANCE_STATUS_CODE	VARCHAR2	1		Yes	Code identifies the status of balance period: A: available for balance calculation. B : balance is currently processed by the recreation function in the second phase of the recreation. C: balance is currently processed by the recreation function; the recalculation phase is completed. : balance is currently processed by the open period function. : balance is currently processed by the recreation function during the rebuild of the balances. R: balance is currently processed by the recreation function in the first phase of the recreation. S: balance is currently processed by the balance synchronization function.
EFFECTIVE_PERIOD_NUM	NUMBER		18	Yes	Effective period number of the latest period for which the opening of the balances has been completed successfully for the ledger, application and balance source.
RECREATE_PARTY_TYPE_CODE	VARCHAR2	1			Abbreviated name that indicates the type of the recreated party.
RECREATE_PARTY_ID	NUMBER		18		Identifier of the recreated party.
RECREATE_PARTY_SITE_ID	NUMBER		18		Identifier of recreated party site.
BALANCING_SEGMENT	VARCHAR2	25		Yes	Key flexfield: balancing segment.
NATURAL_ACCOUNT_SEGMENT	VARCHAR2	25		Yes	Natural account segment from the accounting flexfield.
ACCOUNT_TYPE	VARCHAR2	1		Yes	Classification of whether an account segment value of an account distribution is an asset, liability, equity, revenue or expense account.
WARNING_FLAG	VARCHAR2	1			Used by the Balance Recreation. The recreation of this balance status has not been completed by a previous Recreation request. The next Recreation request will complete the task but will end with a warning.
RECREATE_EFFECTIVE_PERIOD_NUM	NUMBER		18		Used by the Balance Recreation to resume the task of a previous request that ended with a failure
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index	Uniqueness	Tablespace	Columns
XLA_BALANCE_STATUSES_U1	Unique	Default	APPLICATION_ID, LEDGER_ID, CODE_COMBINATION_ID, BALANCE_SOURCE_CODE