Search Results jl_co_gl_conc_ctrl_u1

Overview

In Oracle E-Business Suite 12.1.1 and 12.2.2, JL.JL_CO_GL_CONC_CTRL is a control table in the JL (Oracle Financials for Global Consolidation / Transfer to GL) schema that governs the execution of the Third Party Balances concurrent program. Each row represents a single run of that program for a given set of books and accounting period. The table acts as a state machine: a row is inserted with STATUS equal to NULL when processing begins, then updated to 'P' (or 'U') on successful completion, 'E' on Oracle error, or 'R' when a reversal is performed. The BALANCE_CALCULATED column records the resolved calculated balance, giving the control record a small amount of descriptive payload alongside its status flags.

From a data modeling perspective, the mined foreign-key structure is hub-leaning. PROCESS_ID is the sole primary key column and is referenced by JL_CO_GL_CONC_ERRS and JL_CO_GL_TRX, indicating that this table functions as a parent/hub against which detail records attach. SET_OF_BOOKS_ID is a foreign key to GL_SETS_OF_BOOKS_11I, and REVERSED_PROCESS_ID is a self-referencing foreign key back to this same table. Although the documentation excerpt does not explicitly cite the Data Vault classification, the structure is that of a business-hub with an optional self-link for reversal tracking. It is best modeled as a hub, not a satellite.

Key Information Stored

The documented physical schema contains 11 columns. The most significant are:

• PROCESS_ID (NUMBER(15), PK): Concurrent request or process identifier. This is the surrogate primary key and also the unique business-key candidate via the unique index JL_CO_GL_CONC_CTRL_U1.
• SET_OF_BOOKS_ID (NUMBER(15), FK): GL Set of Books / ledger identifier linked to GL_SETS_OF_BOOKS_11I.
• PERIOD_NAME (VARCHAR2(15)): Accounting period for which the run applies.
• STATUS (VARCHAR2): Processing state — NULL for unstarted/error, 'U' updated, 'P' processed, 'E' error, 'R' reversed, per the documented comments.
• BALANCE_CALCULATED (VARCHAR2): The calculated balance value produced by the run.
• REVERSED_PROCESS_ID (NUMBER(15), FK): References this table, populated when the process is reversed.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN: Standard Who audit columns capturing creation and last-update metadata.

Common Use Cases and Queries

Administrators and support analysts query this table to diagnose failed or incomplete Third Party Balances runs, to confirm whether a period has been processed or reversed, and to trace the reversal chain. A typical lookup for pending or errored processes:

SELECT PROCESS_ID, SET_OF_BOOKS_ID, PERIOD_NAME, STATUS, BALANCE_CALCULATED
FROM JL.JL_CO_GL_CONC_CTRL
WHERE STATUS IN ('E') OR STATUS IS NULL;

A reversal trace resolves the self-referencing link:

SELECT a.PROCESS_ID, a.REVERSED_PROCESS_ID, b.PERIOD_NAME
FROM JL.JL_CO_GL_CONC_CTRL a, JL.JL_CO_GL_CONC_CTRL b
WHERE a.REVERSED_PROCESS_ID = b.PROCESS_ID;

Reconciliation reporting aggregates run counts and status distributions per set of books and period, while joins to the detail tables JL_CO_GL_TRX and JL_CO_GL_ERRS expose the transactions and error rows created under each PROCESS_ID.

Related Objects

• JL_CO_GL_TRX.PROCESS_ID: Detail transaction rows created by each process run.
• JL_CO_GL_CONC_ERRS.PROCESS_ID: Error records linked to a failed process run.
• JL_CO_GL_CONC_CTRL (self-reference via REVERSED_PROCESS_ID): Reversal lineage.
• GL_SETS_OF_BOOKS_11I: Referenced through SET_OF_BOOKS_ID.
• JL_CO_GL_CONC_CTRL#: The underlying base table object documented as dependent on this table.