Search Results pqh_gl_interface_pk

Overview

PQH_GL_INTERFACE is an Oracle EBS interface table owned by the HR schema and delivered as part of the PQH (Public Sector HR) product family. It serves as the staging entity through which budget and commitment information is collected and formatted for posting to the General Ledger. In the context of Oracle EBS 12.1.1 and 12.2.2, the table acts as a bridge between Public Sector HR budgeting constructs and Oracle Financials, holding rows that carry the debit and credit amounts, accounting dates, and account code combinations required to create journal entries in GL.

The ETRM metadata classifies PQH_GL_INTERFACE as standalone under the heuristic Data Vault analysis, meaning it does not behave as a dependent satellite of a single parent entity. From a modeling perspective, this suggests the table is best treated as a hub-like interface record keyed on its own surrogate identifier, with several outbound references to budgetary, costing, and award entities rather than a strict hierarchical dependency.

Key Information Stored

The table contains 24 documented columns. The surrogate primary key is GL_INTERFACE_ID, enforced by the unique index PQH_GL_INTERFACE_PK, which is the sole documented business-key candidate. The most significant columns include:

GL_INTERFACE_ID — surrogate primary key uniquely identifying each interface record.
BUDGET_VERSION_ID and BUDGET_DETAIL_ID — link the record to the budget version and the specific budget detail line being posted.
PERIOD_NAME — the accounting period the entry targets.
CODE_COMBINATION_ID — the GL account code combination for the posting line.
POSTING_TYPE_CD — indicates the nature of the posting (for example, budget or commitment).
CURRENCY_CODE, AMOUNT_DR, and AMOUNT_CR — the currency and debit/credit amounts.
ACCOUNTING_DATE and POSTING_DATE — the accounting and posting dates for the transaction.
COST_ALLOCATION_KEYFLEX_ID — reference to the costing allocation key flexfield record.
STATUS and ADJUSTMENT_FLAG — control flags governing processing state and whether the row represents an adjustment.
PROJECT_ID, TASK_ID, AWARD_ID, and EXPENDITURE_TYPE — project and grant context for the entry.
Standard audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE.

Common Use Cases and Queries

Typical scenarios include reconciling budget and commitment postings, verifying that interface rows have been consumed by GL, and diagnosing posting failures indicated by STATUS. A common query retrieves unposted entries for a given period:

SELECT GL_INTERFACE_ID, PERIOD_NAME, CODE_COMBINATION_ID,
       AMOUNT_DR, AMOUNT_CR, STATUS
FROM   HR.PQH_GL_INTERFACE
WHERE  PERIOD_NAME = :period
AND    STATUS = 'NEW';

Reporting usages include summarising debit and credit activity by account, tracking adjustment entries via ADJUSTMENT_FLAG, and joining to budget details to analyse postings by budget version.

Related Objects

The documented foreign keys establish these significant relationships:

PQH_BUDGET_DETAILS — referenced through BUDGET_DETAIL_ID, the source of the budget line being posted.
PAY_COST_ALLOCATION_KEYFLEX — referenced through COST_ALLOCATION_KEYFLEX_ID, providing costing allocation context.
IGF_AW_AWARD_ALL — referenced through AWARD_ID, supplying grant and award information.
Oracle General Ledger interface equivalents (GL_INTERFACE) — the downstream consumer of validated rows.
Project and task entities referenced through PROJECT_ID and TASK_ID.

These relationships position PQH_GL_INTERFACE as the convergence point between Public Sector HR budgeting, costing, and grant award data prior to GL posting.

Table: PQH_GL_INTERFACE 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PQH.PQH_GL_INTERFACE, object_name:PQH_GL_INTERFACE, status:VALID, product: PQH - Public Sector HR , description: Interface entity containing budget and commitment information used to post to GL , implementation_dba_data: HR.PQH_GL_INTERFACE ,
INDEX: HR.PQH_GL_INTERFACE_PK 12.2.2
owner:HR, object_type:INDEX, object_name:PQH_GL_INTERFACE_PK, status:VALID,
Table: PQH_GL_INTERFACE 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PQH.PQH_GL_INTERFACE, object_name:PQH_GL_INTERFACE, status:VALID, product: PQH - Public Sector HR , description: Interface entity containing budget and commitment information used to post to GL , implementation_dba_data: HR.PQH_GL_INTERFACE ,
INDEX: HR.PQH_GL_INTERFACE_PK 12.1.1
owner:HR, object_type:INDEX, object_name:PQH_GL_INTERFACE_PK, status:VALID,
TABLE: HR.PQH_GL_INTERFACE 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PQH.PQH_GL_INTERFACE, object_name:PQH_GL_INTERFACE, status:VALID,
TABLE: HR.PQH_GL_INTERFACE 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PQH.PQH_GL_INTERFACE, object_name:PQH_GL_INTERFACE, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
eTRM - PQH Tables and Views 12.2.2
description: This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process. ,
eTRM - PQH Tables and Views 12.1.1
description: This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process. ,
eTRM - PQH Tables and Views 12.2.2
description: This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process. ,
eTRM - PQH Tables and Views 12.1.1
description: This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process. ,