Search Results xla_transaction_entities
The XLA_TRANSACTION_ENTITIES
table is a critical component of Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically within the Subledger Accounting (SLA) module. It serves as a repository for transactional entity information, acting as a bridge between subledger transactions and their corresponding accounting entries. This table is part of Oracle's eXtensible Accounting Architecture (XLA), which provides a standardized framework for accounting event processing and journal entry generation across various subledgers (e.g., Payables, Receivables, Assets).
### **Key Functions of XLA_TRANSACTION_ENTITIES**
1. **Entity Identification**:
The table uniquely identifies subledger transaction entities (e.g., invoices, payments, asset additions) by storing an APPLICATION_ID
(identifying the EBS module) and an ENTITY_CODE
(defining the transaction type). Each entity is assigned a unique ENTITY_ID
, which links to related accounting events in XLA_EVENTS
and journal entries in XLA_AE_HEADERS
.
2. **Transaction Context Storage**:
It stores contextual metadata about transactions, such as:
- SOURCE_ID_INT_1
and SOURCE_ID_CHAR_1
: Internal and character-based identifiers for the source transaction (e.g., invoice ID).
- LEDGER_ID
: The accounting ledger associated with the transaction.
- SECURITY_ID_INT_1
: Used for data security (e.g., operating unit).
3. **Event Processing Support**:
The table facilitates event processing by maintaining relationships between transactions and their accounting events. For example, when an invoice is validated in Payables, a record is created in XLA_TRANSACTION_ENTITIES
, which is later referenced during accounting event generation.
4. **Integration with Subledgers**:
Subledger modules (e.g., AP, AR, FA) populate this table during transaction posting. The APPLICATION_ID
column ties the entity to its source module (e.g., 200 for Payables, 222 for Assets).
### **Key Columns and Their Significance**
| **Column** | **Description** |
|--------------------------|-------------------------------------------------------------------------------|
| APPLICATION_ID
| EBS module identifier (e.g., 200 for AP, 222 for FA). |
| ENTITY_CODE
| Transaction type (e.g., 'AP_INVOICES' for Payables invoices). |
| ENTITY_ID
| Unique identifier for the transaction entity. |
| LEDGER_ID
| Links to GL_LEDGERS
for accounting context. |
| SOURCE_ID_INT_1
| Transaction ID (e.g., invoice_id in AP). |
| SECURITY_ID_INT_1
| Operating unit or other security attribute. |
| CREATION_DATE
| Timestamp of entity creation. |
### **Technical Workflow**
1. **Transaction Creation**:
When a subledger transaction (e.g., an invoice) is created, the module inserts a row into XLA_TRANSACTION_ENTITIES
with relevant identifiers.
2. **Event Generation**:
During accounting event processing (e.g., invoice validation), SLA references this table to fetch entity details and generate accounting entries in XLA_EVENTS
.
3. **Journal Entry Posting**:
The ENTITY_ID
links the transaction to its journal entries in XLA_AE_HEADERS
, ensuring traceability.
### **Common Use Cases**
- **Troubleshooting**: Querying this table helps diagnose missing accounting entries by tracing ENTITY_ID
to source transactions.
- **Data Purge**: Used in SLA purge processes to identify obsolete entities.
- **Custom Reporting**: Joins with XLA_EVENTS
or subledger tables (e.g., AP_INVOICES
) for audit reports.
### **Conclusion**
The XLA_TRANSACTION_ENTITIES
table is foundational to Oracle EBS SLA, ensuring seamless integration between subledger transactions and their accounting outcomes. Its structured design supports auditability, security, and compliance, making it indispensable for financial reporting and reconciliation in EBS 12.1.1 and 12.2.2.
-
Table: XLA_TRANSACTION_ENTITIES
12.2.2
owner:XLA, object_type:TABLE, fnd_design_data:XLA.XLA_TRANSACTION_ENTITIES, object_name:XLA_TRANSACTION_ENTITIES, status:VALID, product: XLA - Subledger Accounting , description: The table XLA_ENTITIES contains information about sub-ledger document or transactions. , implementation_dba_data: XLA.XLA_TRANSACTION_ENTITIES ,
-
Table: XLA_TRANSACTION_ENTITIES
12.1.1
owner:XLA, object_type:TABLE, fnd_design_data:XLA.XLA_TRANSACTION_ENTITIES, object_name:XLA_TRANSACTION_ENTITIES, status:VALID, product: XLA - Subledger Accounting , description: The table XLA_ENTITIES contains information about sub-ledger document or transactions. , implementation_dba_data: XLA.XLA_TRANSACTION_ENTITIES ,
-
APPS.OKL_PERD_STATUS_PVT dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.FA_DELETION_PVT dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.FUN_RECON_RPT_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.AP_PURGE_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.LNS_DISTRIBUTIONS_PUB dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.FV_FACTS_TRX_REGISTER dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.FV_GTAS_GL_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.XLA_ACCOUNTING_PUB_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.JA_JAINCTRB_XMLP_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.OKL_PERD_STATUS_PVT dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.XLA_TRANSFER_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.AP_PURGE_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.XLA_UPGRADE_PUB dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.FV_UTILITY dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.XLA_PERIOD_CLOSE_EXP_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.PSA_BC_XLA_PVT dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.AP_FUNDS_CONTROL_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.XLA_MULTIPERIOD_ACCOUNTING_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.PSA_AP_BC_PVT dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.CST_RECEIPTACCRUALPEREND_PVT dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.FII_AP_INV_LINES_F_C dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.XLA_TB_REPORT_PVT dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.IGC_CBC_GL_FC_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.XLA_UPG_VERIFICATION_PUB dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.XLA_TRANSFER_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.AP_APXTRSWP_XMLP_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.FUN_RECON_RPT_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.AP_ACCTG_DATA_FIX_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.IGC_CBC_GL_FC_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.XLA_UPG_VERIFICATION_PUB dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.PSA_UTILS dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.XLA_FSAH_INT_PVT dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.FV_GTAS_TRX_REGISTER dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.ARP_PROCESS_HEADER dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.FA_DELETION_PUB dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.JA_CN_AR_RBD_EXPORT_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.2.2
-
APPS.PSA_BC_XLA_PVT dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.XLA_AE_LINES_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.FA_ASSET_TRACE_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.XLA_ACCOUNTING_PUB_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.ZX_AP_POPULATE_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.1.1
-
APPS.JA_CN_CFS_CLT_SLA_PKG dependencies on XLA_TRANSACTION_ENTITIES
12.1.1