Results for “gl_shares_activity_u1”

10 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GL.GL_SHARES_ACTIVITY is a General Ledger table in Oracle E-Business Suite that stores stock split and stock dividend information entered through the Common Stock form. Each row represents a single corporate activity affecting a ledger's common stock position, capturing the activity type (Split or Dividend), the date on which the activity occurred, and the quantitative parameters of that activity — either the split ratio (from/to) for stock splits or the dividend percentage for stock dividends. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, is owned by the GL schema, and carries the FND Design Data reference SQLGL.GL_SHARES_ACTIVITY. Its status is VALID in the ETRM repository.

From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign-key structure is satellite-leaning. This should be treated as a modeling suggestion rather than a definitive architectural statement: the table holds descriptive, attributable state about stock activity keyed by a composite business key, with a foreign-key reference outward to the ledger dimension. It is not a hub of independent business entities, nor a pure link resolving many-to-many relationships between hubs; its natural fit is as a satellite attached to a ledger hub, carrying the measurable and descriptive attributes of each stock event.

Key Information Stored

The table contains 27 documented columns. The most significant are:

  • LEDGER_ID (NUMBER(15), mandatory) — the ledger defining column, identifying which ledger the stock activity applies to. This is also the documented foreign-key reference outward from the table.
  • ACTIVITY_DATE (DATE, mandatory) — the date on which the split or dividend activity occurred.
  • ACTIVITY_TYPE_CODE (VARCHAR2(30), mandatory) — the type of activity, either Split or Dividend.
  • SPLIT_RATIO_FROM (NUMBER(15)) — the numerator of the stock split ratio.
  • SPLIT_RATIO_TO (NUMBER(15)) — the denominator of the stock split ratio.
  • DIVIDEND_PERCENT (NUMBER) — the stock dividend percentage applied.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard Who columns providing audit lineage.
  • CONTEXT (VARCHAR2(150)) — the descriptive flexfield context column.
  • ATTRIBUTE1 through ATTRIBUTE15 (VARCHAR2(150) each) — descriptive flexfield segments for customer-defined extensions.

The documented primary key is GL_SHARES_ACTIVITY_PK (LEDGER_ID, ACTIVITY_DATE, ACTIVITY_TYPE_CODE). The unique index GL_SHARES_ACTIVITY_U1 — the object referenced in the search term — carries the identical column list (LEDGER_ID, ACTIVITY_DATE, ACTIVITY_TYPE_CODE) on tablespace APPS_TS_TX_IDX. Because the primary key and the unique index are composed of the same three columns, that triplet is the business-key candidate: a ledger may record at most one activity of a given type on a given date. There is no separate single-column surrogate key; the composite triplet effectively serves as both the business key and the enforcement key.

Common Use Cases and Queries

Typical reporting scenarios include reconstructing the chronological history of stock splits and dividends for a ledger, verifying that split ratios produce the expected share-count restatement, and auditing dividend percentages over a fiscal period. A representative query joins the table to its ledger reference and filters on the business key:

  • Listing all split activities for a ledger in date order: SELECT ACTIVITY_DATE, SPLIT_RATIO_FROM, SPLIT_RATIO_TO FROM GL.GL_SHARES_ACTIVITY WHERE LEDGER_ID = :ledger AND ACTIVITY_TYPE_CODE = 'Split' ORDER BY ACTIVITY_DATE;
  • Extracting dividend history: SELECT ACTIVITY_DATE, DIVIDEND_PERCENT FROM GL.GL_SHARES_ACTIVITY WHERE LEDGER_ID = :ledger AND ACTIVITY_TYPE_CODE = 'Dividend';
  • Confirming uniqueness against the business key by grouping on LEDGER_ID, ACTIVITY_DATE, and ACTIVITY_TYPE_CODE.
  • Reporting on flexfield extensions by selecting CONTEXT and the applicable ATTRIBUTEn columns for ledgers using descriptive flexfields.

Because the table is a satellite, it is best queried in a point-in-time or full-history pattern rather than joined into transactional sub-ledger accounting flows.

Related Objects

The documented relationship data identifies a foreign-key reference from GL.GL_SHARES_ACTIVITY.LEDGER_ID outward, meaning the table is dependent on the ledger definition it qualifies. The most significant related objects are:

  • GL.GL_LEDGERS — joined on LEDGER_ID; supplies the ledger name and context for each activity record.
  • GL.GL_SHARES_ACTIVITY_U1 — the unique index enforcing the business key (LEDGER_ID, ACTIVITY_DATE, ACTIVITY_TYPE_CODE).
  • GL_SHARES_ACTIVITY_PK — the primary key constraint over the same triplet.
  • GL.GL_SHARES — the companion table holding current common stock share balances, against which split and dividend activity is applied.
  • Common Stock form (GLXSTOCK) — the application form through which users enter the split and dividend records persisted here.
  • GL.GL_BALANCES — related ledger balance data used when restating equity in line with stock activity.