Results for “cost_center_segment”

50+ results




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

Overview

The PA_UBR_UER_SUMM_ACCT table is a Projects (PA) module table within the Oracle E-Business Suite 12.1.1 and 12.2.2 schemas that stores summarized balances for Unbilled Receivable (UBR) and Unearned Revenue (UER). It acts as the aggregation layer for the recurring revenue recognition and billing cycle, capturing period-over-period movements in unbilled receivables and unearned revenue at the combination of project, cost center, and account segment level. When the Unbilled Receivable and Unearned Revenue generation process runs, summarized opening balances, period deltas, and resulting account balances are written to this table, enabling downstream General Ledger transfers and reconciliation reporting.

From a Data Vault modeling perspective, the heuristic classification for this object is satellite-leaning. Its single foreign key to PA_PROJECTS_ALL, combined with period-stamped, descriptive balance attributes (GL_PERIOD_NAME, GL_PERIOD_START_DATE, DELTA_UBR, etc.), is characteristic of a satellite capturing descriptive measures tied to a business key over time rather than a hub or link. This is a modeling suggestion only; in native EBS it functions as a transactional summary table.

Key Information Stored

The table contains 22 columns. The most significant, grounded in the documented schema, are:

Common Use Cases and Queries

Typical uses include reconciling unbilled receivable and unearned revenue balances for a given GL period, investigating period-over-period swings, and tracing summary rows back to the concurrent request that generated them.

To retrieve current UBR/UER balances for a project and period:

  • SELECT PROJECT_ID, GL_PERIOD_NAME, UNBILLED_RECEIVABLE_DR, UNEARNED_REVENUE_CR FROM PA_UBR_UER_SUMM_ACCT WHERE PROJECT_ID = :p_project AND GL_PERIOD_NAME = :p_period;

To identify movers between periods, filter on DELTA_UBR or DELTA_UER where the absolute value exceeds a threshold. To reconcile a batch, isolate rows by REQUEST_ID. Filtering on ZERO_BALANCE_FLAG = 'N' and PROCESS_FLAG supports exception reporting and cleanup of stale summaries.

Related Objects

  • PA_PROJECTS_ALL — the only documented foreign key relationship; join on PA_UBR_UER_SUMM_ACCT.PROJECT_ID = PA_PROJECTS_ALL.PROJECT_ID.
  • GL_PERIODS / GL ledgers — joins on GL_PERIOD_NAME and GL_PERIOD_START_DATE supply period context for reporting.
  • PA_UNBILLED_RECEIVABLE / UER detail tables and the Unbilled Receivable and Unearned Revenue generation concurrent program — the source of the summarized rows.
  • FND_CONCURRENT_REQUESTS — join on REQUEST_ID to trace the originating process run.

These relationships make the table a key bridge between Projects billing data and General Ledger balances.