Search Results per_solution_api




Overview
Explore in AI Chat

Overview

PER_SOLUTION_API is a public PL/SQL API packaged in the APPS schema that provides the supported programmatic interface for creating, maintaining, and removing "solution" records within Oracle E-Business Suite. In Oracle HRMS terminology a solution is a named remedy or resolution associated with a help desk or incident tracking process, allowing application users to record the action taken to resolve a reported problem and to reuse that resolution for similar incidents. The package therefore belongs to the family of HR/Kanban-style reference data APIs that expose controlled DML against the underlying PER_SOLUTIONS table, rather than requiring direct inserts, updates, or deletes by custom code or data conversion scripts. Because the interface is classified as a public API and is validated as VALID against the APPS schema, it may be called safely from custom PL/SQL, concurrent programs, and other Oracle HRMS products across both the 12.1.1 and 12.2.2 release streams.

Key Procedures and Functions

The ETRM metadata documents three procedures exposed by this package:

  • CREATE_SOLUTION — Inserts a new solution into the PER_SOLUTIONS repository. It is the entry point for registering a resolution definition that can subsequently be attached to incidents or references.
  • UPDATE_SOLUTION — Modifies the attributes of an existing solution record, such as its descriptive text or effective information, without requiring a direct update to the base table.
  • DELETE_SOLUTION — Removes a solution that is no longer required, applying whatever validation and date-tracking logic the API enforces to preserve referential and historical integrity.

Because the metadata excerpt does not reproduce parameter signatures, the precise argument lists are not restated here; implementers should read the package specification in the database (for example, via DESCRIBE PER_SOLUTION_API or the DBA_SOURCE view) before coding a call.

Tables Accessed

The documented table referenced through APPS synonyms is PER_SOLUTIONS, which stores the solution master records themselves. This is the sole base table attributed to the package's documented operations; CREATE_SOLUTION inserts into it, UPDATE_SOLUTION changes existing rows, and DELETE_SOLUTION removes or logically retires them. Additional standard Oracle HRMS support objects such as HR_API and the SYS.STANDARD package are listed as dependencies and provide the common error-handling, key-flexfield validation, and date-effectivity utilities used by Oracle HR APIs, but they are not the transactional tables of interest.

Usage Notes

PER_SOLUTION_API is invoked whenever solution reference data must be maintained in a supported manner. Typical callers include Oracle Help Desk and incident-management forms, data migration or setup scripts that load resolution catalogs, and custom concurrent programs that bulk-load solution information during implementation. The dependency report shows that PER_SOLUTION_API is referenced by itself (recursive internal calls) and by no other documented package, so it is effectively a standalone API rather than a subroutine reused across Oracle HRMS modules. Custom code should call only the documented CREATE, UPDATE, and DELETE procedures and should always supply the required context, since the package performs the validation, WHO-column population, and error propagation expected of a public Oracle API. Direct DML against PER_SOLUTIONS is unsupported and risks bypassing the integrity checks enforced by this package.