Search Results jl_co_gl_trx

Overview

JL_CO_GL_TRX is a Latin America Localizations (JL) table that stores third-party transaction records representing General Ledger entries posted from multiple source systems, specifically for accounts that require NIT (tax identification number) tracking. The table functions as a staging and audit repository that links posted GL journal activity to the Colombian and broader Latin American statutory reporting requirements built into Oracle E-Business Suite. It is populated by concurrent programs registered under the JL_CO_GL_CONC_CTRL control table and is essential for generating fiscal reports that must reconcile GL balances with third-party documentation.

From a dimensional modeling perspective, the metadata's heuristic Data Vault classification for this object is link. This is consistent with its structure: it resolves relationships between several reference entities—NIT records, GL code combinations, sets of books, and JE batch/line identifiers—rather than acting as a standalone hub of a single business concept or as a descriptive satellite. Modelers should treat JL_CO_GL_TRX as a transaction-level link table that captures the association between GL journal lines and third-party NIT identities within a defined reporting period.

Key Information Stored

The table is documented with 26 columns in ETRM 12.2.2. The surrogate primary key is TRANSACTION_ID, defined by the JL_CO_GL_TRX_PK constraint. Business-key candidates include the combination of JE_HEADER_ID and JE_LINE_NUM, which uniquely identifies the source GL journal line, and the pairing of PERIOD_NAME with JE_BATCH_ID for batch-level grouping.

TRANSACTION_ID – Surrogate primary key for each third-party transaction record.
NIT_ID – Foreign key to JL_CO_GL_NITS, identifying the third party associated with the account.
PROCESS_ID – Foreign key to JL_CO_GL_CONC_CTRL, tracking the concurrent process that generated the record.
SET_OF_BOOKS_ID – Foreign key to GL_SETS_OF_BOOKS_11I, identifying the ledger.
CODE_COMBINATION_ID – Foreign key to GL_CODE_COMBINATIONS, identifying the accounting flexfield.
JE_BATCH_ID – Foreign key to GL_JE_BATCHES, identifying the source journal batch.
JE_HEADER_ID and JE_LINE_NUM – Foreign reference to GL_JE_LINES, pinpointing the original journal line.
PERIOD_YEAR, PERIOD_NUM, and PERIOD_NAME – Accounting period identifiers used for reporting segmentation.
ACCOUNTING_DATE – The GL accounting date of the source transaction.
CURRENCY_CODE – Currency of the entered amounts.
ENTERED_DR / ENTERED_CR and ACCOUNTED_DR / ACCOUNTED_CR – Entered and accounted debit/credit amounts.
CATEGORY, DOCUMENT_NUMBER, and SUBLEDGER_DOC_NUMBER – Journal category and source document references for traceability.

Common Use Cases and Queries

The primary use case is statutory third-party reporting for NIT-required accounts. A typical reconciliation query joins to GL_CODE_COMBINATIONS and JL_CO_GL_NITS to produce NIT-level transaction listings per period:

Reconciling GL journal activity against third-party NIT records for tax and fiscal reporting.
Auditing which concurrent process (PROCESS_ID) loaded a given set of transactions.
Extracting period-level debit/credit balances by NIT and account for regulatory submissions.
Drill-back queries from JL-CO-GL-TRX to the originating JE batch, header, and line records.

A representative query pattern selects TRANSACTION_ID, NIT_ID, ACCOUNT_CODE, PERIOD_NAME, ACCOUNTED_DR, and ACCOUNTED_CR, joining to JL_CO_GL_NITS on NIT_ID and filtering by SET_OF_BOOKS_ID and PERIOD_NAME.

Related Objects

JL_CO_GL_NITS – joined on NIT_ID; holds third-party NIT master data.
JL_CO_GL_CONC_CTRL – joined on PROCESS_ID; concurrent program control records.
GL_CODE_COMBINATIONS – joined on CODE_COMBINATION_ID; accounting flexfield definitions.
GL_SETS_OF_BOOKS_11I – joined on SET_OF_BOOKS_ID; ledger definitions.
GL_JE_BATCHES – joined on JE_BATCH_ID; source journal batches.
GL_JE_LINES – joined on JE_HEADER_ID and JE_LINE_NUM; source journal lines.

These relationships make JL_CO_GL_TRX a central link for tracing Latin American localization GL data from third-party identity through to the originating journal entry.

Table: JL_CO_GL_TRX 12.2.2
owner:JL, object_type:TABLE, fnd_design_data:JL.JL_CO_GL_TRX, object_name:JL_CO_GL_TRX, status:VALID, product: JL - Latin America Localizations , description: Third Party Transaction Table Containing Posted Transactions Of GL From Different Sources For NIT Required Accounts , implementation_dba_data: JL.JL_CO_GL_TRX ,
Table: JL_CO_GL_TRX 12.1.1
owner:JL, object_type:TABLE, fnd_design_data:JL.JL_CO_GL_TRX, object_name:JL_CO_GL_TRX, status:VALID, product: JL - Latin America Localizations , description: Third Party Transaction Table Containing Posted Transactions Of GL From Different Sources For NIT Required Accounts , implementation_dba_data: JL.JL_CO_GL_TRX ,
VIEW: JL.JL_CO_GL_TRX# 12.2.2
owner:JL, object_type:VIEW, object_name:JL_CO_GL_TRX#, status:VALID,
SYNONYM: APPS.JL_CO_GL_TRX 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JL_CO_GL_TRX, status:VALID,
VIEW: JL.JL_CO_GL_TRX# 12.2.2
SYNONYM: APPS.JL_CO_GL_TRX 12.1.1
owner:APPS, object_type:SYNONYM, object_name:JL_CO_GL_TRX, status:VALID,
APPS.JL_CO_GL_NIT_MANAGEMENT SQL Statements 12.1.1
APPS.JL_CO_GL_NIT_MANAGEMENT SQL Statements 12.2.2
Table: JL_CO_GL_NITS 12.1.1
owner:JL, object_type:TABLE, fnd_design_data:JL.JL_CO_GL_NITS, object_name:JL_CO_GL_NITS, status:VALID, product: JL - Latin America Localizations , description: Third Party Master Table , implementation_dba_data: JL.JL_CO_GL_NITS ,
Table: JL_CO_GL_NITS 12.2.2
owner:JL, object_type:TABLE, fnd_design_data:JL.JL_CO_GL_NITS, object_name:JL_CO_GL_NITS, status:VALID, product: JL - Latin America Localizations , description: Third Party Master Table , implementation_dba_data: JL.JL_CO_GL_NITS ,
PACKAGE: APPS.JL_CO_GL_NIT_MANAGEMENT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:JL_CO_GL_NIT_MANAGEMENT, status:VALID,
APPS.JL_JLCOGLNE_XMLP_PKG SQL Statements 12.1.1
Table: JL_CO_GL_CONC_CTRL 12.2.2
owner:JL, object_type:TABLE, fnd_design_data:JL.JL_CO_GL_CONC_CTRL, object_name:JL_CO_GL_CONC_CTRL, status:VALID, product: JL - Latin America Localizations , description: Third Party Control Table Containing Log For Every Submission Of 'Generate Third Party Balances' Concurrent Program , implementation_dba_data: JL.JL_CO_GL_CONC_CTRL ,
PACKAGE: APPS.JL_CO_GL_NIT_MANAGEMENT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:JL_CO_GL_NIT_MANAGEMENT, status:VALID,
PACKAGE BODY: APPS.JL_JLCOGLNE_XMLP_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JL_JLCOGLNE_XMLP_PKG, status:VALID,
APPS.JL_JLCOGLNE_XMLP_PKG SQL Statements 12.2.2
Table: JL_CO_GL_CONC_CTRL 12.1.1
owner:JL, object_type:TABLE, fnd_design_data:JL.JL_CO_GL_CONC_CTRL, object_name:JL_CO_GL_CONC_CTRL, status:VALID, product: JL - Latin America Localizations , description: Third Party Control Table Containing Log For Every Submission Of 'Generate Third Party Balances' Concurrent Program , implementation_dba_data: JL.JL_CO_GL_CONC_CTRL ,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.JL_JLCOGLNE_XMLP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JL_JLCOGLNE_XMLP_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
TABLE: JL.JL_CO_GL_TRX 12.1.1
owner:JL, object_type:TABLE, fnd_design_data:JL.JL_CO_GL_TRX, object_name:JL_CO_GL_TRX, status:VALID,
12.2.2 FND Design Data 12.2.2
12.1.1 FND Design Data 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.JL_CO_GL_MG_MEDIA_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JL_CO_GL_MG_MEDIA_PKG, status:VALID,
PACKAGE BODY: APPS.JL_CO_GL_MG_MEDIA_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JL_CO_GL_MG_MEDIA_PKG, status:VALID,
PACKAGE BODY: APPS.JL_CO_GL_NIT_MANAGEMENT 12.2.2
TABLE: JL.JL_CO_GL_TRX 12.2.2
owner:JL, object_type:TABLE, fnd_design_data:JL.JL_CO_GL_TRX, object_name:JL_CO_GL_TRX, status:VALID,
PACKAGE BODY: APPS.JL_CO_GL_NIT_MANAGEMENT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JL_CO_GL_NIT_MANAGEMENT, status:VALID,
Table: GL_JE_LINES 12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_JE_LINES, object_name:GL_JE_LINES, status:VALID, product: GL - General Ledger , description: Journal entry lines , implementation_dba_data: GL.GL_JE_LINES ,
Table: GL_JE_LINES 12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_JE_LINES, object_name:GL_JE_LINES, status:VALID, product: GL - General Ledger , description: Journal entry lines , implementation_dba_data: GL.GL_JE_LINES ,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.JL_CO_GL_NIT_MANAGEMENT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JL_CO_GL_NIT_MANAGEMENT, status:VALID,
PACKAGE BODY: APPS.JL_CO_GL_NIT_MANAGEMENT 12.1.1
Table: GL_JE_BATCHES 12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_JE_BATCHES, object_name:GL_JE_BATCHES, status:VALID, product: GL - General Ledger , description: Journal entry batches , implementation_dba_data: GL.GL_JE_BATCHES ,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
Table: GL_JE_BATCHES 12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_JE_BATCHES, object_name:GL_JE_BATCHES, status:VALID, product: GL - General Ledger , description: Journal entry batches , implementation_dba_data: GL.GL_JE_BATCHES ,
PACKAGE BODY: APPS.JL_JLCOGLNE_XMLP_PKG 12.2.2
PACKAGE BODY: APPS.JL_JLCOGLNE_XMLP_PKG 12.1.1
Table: GL_SETS_OF_BOOKS_11I 12.1.1
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_SETS_OF_BOOKS_11I, object_name:GL_SETS_OF_BOOKS_11I, status:VALID, product: GL - General Ledger , description: Set of books definitions , implementation_dba_data: GL.GL_SETS_OF_BOOKS_11I ,
Table: GL_SETS_OF_BOOKS_11I 12.2.2
owner:GL, object_type:TABLE, fnd_design_data:SQLGL.GL_SETS_OF_BOOKS_11I, object_name:GL_SETS_OF_BOOKS_11I, status:VALID, product: GL - General Ledger , description: Set of books definitions , implementation_dba_data: GL.GL_SETS_OF_BOOKS_11I ,
APPS.JL_CO_GL_MG_MEDIA_PKG SQL Statements 12.2.2
APPS.JL_CO_GL_MG_MEDIA_PKG SQL Statements 12.1.1
APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on JL_CO_GL_TRX 12.1.1
APPS.JL_JLCOGLNE_XMLP_PKG dependencies on JL_CO_GL_TRX 12.2.2
APPS.JL_JLCOGLNE_XMLP_PKG dependencies on JL_CO_GL_TRX 12.1.1
APPS.JL_CO_GL_MG_MEDIA_PKG dependencies on JL_CO_GL_TRX 12.2.2