Search Results pa_alloc_gl_lines_u1

Overview

PA.PA_ALLOC_GL_LINES is a transactional table in the Oracle EBS Projects (PA) schema that stores the allocation source lines associated with General Ledger accounts. Each row defines one source line within an allocation rule, identifying the GL account (via a code combination) whose balance will be used as an allocation source, the percentage of that balance to include, and whether the balance is added or subtracted. It is the mechanism by which Oracle Projects builds the pool of costs or revenue to be spread across allocation targets defined for the same rule.

The object resides in the APPS_TS_TX_DATA tablespace with PCT FREE 10, a configuration typical of transaction-level data. In Oracle EBS 12.1.1 and 12.2.2 the table is registered in FND Design Data as PA.PA_ALLOC_GL_LINES and its definition is consistent across both releases.

Heuristically, the FK topology classifies this table as satellite-leaning. All records depend on a parent allocation rule, and there is no independent business key that would justify treating it as a hub. In a Data Vault model this table is best represented as a satellite of the allocation rule hub, keyed by the combination of RULE_ID and LINE_NUM, with descriptive attributes such as SOURCE_CCID, SUBTRACT_FLAG and SOURCE_PERCENT.

Key Information Stored

The table contains ten documented columns. The most important are:

• RULE_ID (NUMBER, mandatory) — Allocation rule identification number. Part of the primary key and the leading column of both indexes. It is a foreign key to PA.PA_ALLOC_RULES_ALL.
• LINE_NUM (NUMBER, mandatory) — Line number of the source line within the rule. The second component of the primary key, providing sequence and uniqueness within a rule.
• SOURCE_CCID (NUMBER) — Code combination identifier for the GL account used as the allocation source. It is a foreign key to GL.GL_CODE_COMBINATIONS.
• SUBTRACT_FLAG (VARCHAR2) — Indicates whether the GL account balance is subtracted. A value of Y means the balance is subtracted from the pool; otherwise it is added. It is the trailing column of the non-unique index PA_ALLOC_GL_LINES_N1.
• SOURCE_PERCENT (NUMBER) — The percentage of the account balance to be considered for the source line.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns recording insert and update attribution and timestamps.

Two indexes are documented. PA_ALLOC_GL_LINES_U1 is the UNIQUE index on (RULE_ID, LINE_NUM) in APPS_TS_TX_IDX and serves as the business-key candidate underpinning the primary key PA_ALLOC_GL_LINES_PK. PA_ALLOC_GL_LINES_N1 is a NONUNIQUE index on (RULE_ID, SUBTRACT_FLAG), supporting retrieval of source lines filtered by add/subtract behaviour within a rule. The user search term pa_alloc_gl_lines_u1 refers to the unique index on the primary key columns.

Common Use Cases and Queries

The primary use case is inspecting or reporting the source composition of an allocation rule. A typical query joins this table to PA_ALLOC_RULES_ALL to obtain rule names and to GL_CODE_COMBINATIONS to resolve the source account segments:

SELECT l.RULE_ID,
       l.LINE_NUM,
       l.SOURCE_CCID,
       l.SUBTRACT_FLAG,
       l.SOURCE_PERCENT
FROM   PA.PA_ALLOC_GL_LINES l
WHERE  l.RULE_ID = :rule_id
ORDER  BY l.LINE_NUM;

Additional scenarios include validating that source percentages total the expected amount per rule, identifying rules that use subtraction accounts, and tracing allocation output back to its input lines. The unique index PA_ALLOC_GL_LINES_U1 enforces uniqueness of the rule/line pair; a query by RULE_ID can leverage this index for efficient retrieval.

Related Objects

The following objects are directly related through documented foreign keys and dependencies:

• PA.PA_ALLOC_RULES_ALL — Parent table of allocation rules; joined on RULE_ID. This is the source of all rule-level attributes.
• GL.GL_CODE_COMBINATIONS — GL account code combinations referenced by SOURCE_CCID.
• PA.PA_ALLOC_RUN_GL_DET — References this table via RULE_ID; holds allocation run detail lines for GL accounts.
• PA.PA_ALLOC_GL_LINES# — The database trigger or internal dependent object on this table.

Together these objects form the allocation-source subsystem within Oracle Projects, where source lines defined here are consumed by allocation runs to generate the GL detail and, ultimately, journal entries.