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:
- UBR_UER_SUMMARY_ID — surrogate primary key and the column behind unique index PA_UBR_UER_SUMM_ACCT_U1.
- ACCOUNT_SEGMENT, COST_CENTER_SEGMENT, PROJECT_ID, GL_PERIOD_NAME, GL_PERIOD_START_DATE — the composite business-key candidate defined by unique index PA_UBR_UER_SUMM_ACCT_U2, uniquely identifying a summary row per project, account, cost center, and GL period.
- UBR_UER_CODE — classifies the row within the UBR/UER framework.
- UBR_BAL_PREV_PERIOD_DR, UER_BAL_PREV_PERIOD_CR — prior-period opening balances for unbilled receivable (debit) and unearned revenue (credit).
- DELTA_UBR, DELTA_UER — period-over-period movement amounts.
- UNBILLED_RECEIVABLE_DR, UNEARNED_REVENUE_CR — resulting period balances posted on each side.
- PROCESS_FLAG, ZERO_BALANCE_FLAG, MULTI_COST_CENTER_FLAG — processing and exception indicators controlling which rows are transferred or suppressed.
- REQUEST_ID — identifies the concurrent program run that produced the row.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
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.
-
The PA_UBR_UER_SUMM_ACCT table stores summary for Unbilled Receivable and Unearned Revenue.
-
View: APFV_AP_INVOICE_LINES 12.2.2
Business View
APPS.APFV_AP_INVOICE_LINES·↳ AP_INVOICE_LINES_ALL·Explore AP module →
-
The PA_UBR_UER_SUMM_ACCT table stores summary for Unbilled Receivable and Unearned Revenue.
-
AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
-
APPS.AP_INVOICE_LINES_INTERFACE_V·↳ AP_AWT_GROUPS·↳ AP_DISTRIBUTION_SETS·↳ AP_INVOICES_INTERFACE·Explore AP module →
-
View: AP_INVOICE_LINES_V 12.2.2
APPS.AP_INVOICE_LINES_V·↳ AP_AWT_GROUPS·↳ AP_DISTRIBUTION_SETS_ALL·↳ AP_INVOICES_ALL·Explore AP module →
-
AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
-
View: AP_INVOICE_LINES_V 12.1.1
APPS.AP_INVOICE_LINES_V·↳ AP_AWT_GROUPS·↳ AP_DISTRIBUTION_SETS_ALL·↳ AP_INVOICES_ALL·Explore AP module →
-
Information used to create one or more invoice distributions
-
Information used to create one or more invoice distributions
-
APPS.AP_INVOICE_LINES_INTERFACE_V·↳ AP_AWT_GROUPS·↳ AP_DISTRIBUTION_SETS·↳ AP_INVOICES_INTERFACE·Explore AP module →
-
VIEW: APPS.PA_UBR_UER_PROJ_V 12.2.2
-
VIEW: APPS.PA_UBR_UER_PROJ_V 12.1.1
-
VIEW: APPS.PA_UBR_UER_ACCT_V 12.1.1
-
VIEW: APPS.PA_UBR_UER_ACCT_V 12.2.2
-
View: PA_UBR_UER_PROJ_V 12.1.1
This view is being used for reporting purpose in UBR and UER.This is UBR UER Project summary view
APPS.PA_UBR_UER_PROJ_V·↳ GL_PERIOD_STATUSES·↳ PA_CURRENCY·↳ PA_IMPLEMENTATIONS_ALL·Explore PA module →
-
View: PA_UBR_UER_PROJ_V 12.2.2
This view is being used for reporting purpose in UBR and UER.This is UBR UER Project summary view
APPS.PA_UBR_UER_PROJ_V·↳ GL_PERIOD_STATUSES·↳ PA_CURRENCY·↳ PA_IMPLEMENTATIONS_ALL·Explore PA module →
-
View: PA_UBR_UER_ACCT_V 12.1.1
This view is being used for reporting purpose in UBR and UER.This is UBR UER Accounting summary view
APPS.PA_UBR_UER_ACCT_V·↳ GL_PERIOD_STATUSES·↳ PA_CURRENCY·↳ PA_IMPLEMENTATIONS_ALL·Explore PA module →
-
View: PA_UBR_UER_ACCT_V 12.2.2
This view is being used for reporting purpose in UBR and UER.This is UBR UER Accounting summary view
APPS.PA_UBR_UER_ACCT_V·↳ GL_PERIOD_STATUSES·↳ PA_CURRENCY·↳ PA_IMPLEMENTATIONS_ALL·Explore PA module →