Search Results get_seg_val




Overview
Explore in AI Chat

Overview

PA_UBR_UER_SUMM_PKG is an Oracle Projects package in the APPS schema that generates Unbilled Receivables (UBR) and Unearned Revenue (UER) summary balances. It consolidates draft revenue and draft invoice data across one or more operating units and produces summarized accounting entries that reconcile project billing activity against the general ledger. The package header identifies the source as PABLUBRB.pls (version 120.2, last updated 2010/12/16), which places it within the Oracle Projects billing and revenue reporting family used in Oracle EBS 12.1.1 and 12.2.2.

The core routine iterates over each organization returned from PA_IMPLEMENTATIONS, initializes environment context for that operating unit, and then processes draft revenues and draft invoices to build the summary balance records. The package is classified as OTHER (not a public API), meaning it is intended for internal concurrent program use rather than direct customer invocation.

Key Procedures and Functions

  • CREATE_UBR_UER_SUMMARY_BALANCE — Main entry point. Accepts a from/to project number range, a GL period name, and a request ID, loops over organizations, and drives the overall summary generation process. It commits at completion.
  • INITIALIZE — Sets up session-level globals for a given organization, including GL end date, chart of accounts ID, and set of books ID, resolved from GL_PERIOD_STATUSES and PA_IMPLEMENTATIONS.
  • PROCESS_DRAFT_REVENUES — Processes unbilled/unearned revenue side of the summary from draft revenue records.
  • PROCESS_DRAFT_INVOICES — Processes the corresponding draft invoice side so revenue and billing are aligned.
  • PROCESS_UBR_UER_SUMMARY — Aggregates and writes the combined summary balances to the UBR/UER summary tables.
  • GET_SEG_VAL — Resolves an individual GL account segment value, used to build the accounting flexfield combination for summarized entries.
  • GET_GL_PERIOD_NAME — Returns the GL period name associated with a given date or context.
  • GET_GL_START_DATE — Returns the start date of the relevant GL period.
  • GET_INV_GL_HEADER_ID_LINE_NUM — Retrieves the GL header ID and line number for invoice-related journal entries.
  • GET_REV_GL_HEADER_ID_LINE_NUM — Retrieves the GL header ID and line number for revenue-related journal entries.

Tables Accessed

The package reads project setup and implementation context from PA_IMPLEMENTATIONS, PA_IMPLEMENTATIONS_ALL, and PA_PROJECTS_ALL. Draft revenue and invoice detail comes from PA_DRAFT_REVENUES_ALL, PA_DRAFT_INVOICES_ALL, and the temporary work table PA_DRAFT_REV_INV_TEMP. Receivables detail is drawn from RA_CUSTOMER_TRX_LINES_ALL and RA_CUST_TRX_LINE_GL_DIST_ALL. GL integration uses GL_CODE_COMBINATIONS, GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LINES, and GL_PERIOD_STATUSES for period validation and account derivation. Output is stored in PA_UBR_UER_SUMM_ACCT and its child table PA_UBR_UER_SUMM_ACCT_S.

Usage Notes

This package is invoked almost exclusively through a concurrent program that passes a project number range and GL period. It is referenced by five other packages, indicating it is consumed by downstream Oracle Projects processes rather than called by end users. Developers investigating get_seg_val should note that segment resolution depends on G_coa_id being correctly initialized by INITIALIZE; failures in organization setup or missing period status rows will prevent correct account derivation. Debug tracing is available when the PA_DEBUG_MODE profile option is set to Y.