Results for “psb_excel2_pvt”

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

Overview

PSB_EXCEL2_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (E-Business Suite Table and API Repository) metadata as a PVT (private) API. It belongs to the Oracle Public Sector Budgeting (PSB) product family, sometimes marketed as part of Oracle Labor Distribution and Budgeting functionality. The package encapsulates the server-side logic required to transfer budget data staged in an external Microsoft Excel worksheet into the native PSB budgeting tables. In practice, PSB provides users with a spreadsheet-based budgeting interface, allowing budget analysts to prepare position, element, and FTE-based budget lines offline and then upload them into the application for validation and commit. PSB_EXCEL2_PVT serves as the processing engine behind that upload path.

Key Procedures and Functions

The package exposes a single documented procedure, Move_To_PSB. This procedure is the workhorse routine that reads worksheet data identified by an export identifier and moves it into the PSB budgeting schema. It follows the standard Oracle EBS API invocation convention: it accepts an API version, an initialization message list flag, a commit flag, a validation level, and standard output parameters for return status, message count, and message data. In addition to those standard parameters, it receives an p_export_id that identifies the specific exported worksheet set to be processed, an p_import_worksheet_type indicating the nature of the worksheet being imported, and tolerance-related parameters that control acceptable differences between amount and percentage values (p_amt_tolerance_value_type, p_amt_tolerance_value, p_pct_tolerance_value_type, and p_pct_tolerance_value). These tolerance settings allow the upload process to accept minor rounding or allocation variances rather than rejecting an entire worksheet. The procedure is documented as returning its outcome through the standard FND_API return status and message stack, enabling callers to interrogate errors consistently with other EBS APIs.

Tables Accessed

The package references a broad set of PSB tables through APPS synonyms. Worksheet staging and structure are represented by PSB_WORKSHEETS, PSB_WORKSHEETS_I, PSB_WS_LINES, PSB_WS_ACCOUNT_LINES, PSB_WS_ELEMENT_LINES, PSB_WS_FTE_LINES, and PSB_WS_COLUMNS_I; these hold the raw spreadsheet content as imported. Reference and configuration data come from PSB_BUDGET_PERIODS, PSB_BUDGET_YEAR_TYPES, PSB_PAY_ELEMENTS, PSB_PAY_ELEMENT_RATES, PSB_SERVICE_PACKAGES, and PSB_SERVICE_PACKAGES_S. Position and assignment data are sourced from PSB_POSITIONS and PSB_POSITION_ASSIGNMENTS. Together these tables allow the procedure to resolve worksheet rows against valid budget periods, valid pay elements and their rates, valid service packages, and existing positions and assignments before committing budget records.

Usage Notes

PSB_EXCEL2_PVT is a private package, meaning it is intended for internal use by other PSB packages rather than direct invocation by customers or third-party developers. The ETRM metadata records that it is referenced by one other package in the PSB schema, which typically exposes the public-facing API or concurrent program that orchestrates the worksheet upload. In Oracle EBS 12.1.1 and 12.2.2, this upload is normally triggered from the Public Sector Budgeting responsibility through the worksheet import function or an associated concurrent program. The procedure's commit and validation-level parameters give the calling layer control over transactional scope, and its tolerance parameters let implementations accommodate organizational rounding conventions. Custom code should not call this package directly; instead, customers should use the documented public API or the standard budgeting responsibility. Note that the historical search term "power point 200" is unrelated to this object, which concerns Excel worksheet upload rather than presentation software.