Search Results validate_org_ids

Overview

APPS.PO_R12_CAT_UPG_VAL_PVT is a private (PVT) PL/SQL package belonging to the Oracle Purchasing module in Oracle E-Business Suite 12.1.1 and 12.2.2. It supports the Release 12 catalog upgrade initiative, whose purpose is to migrate and reorganize purchasing catalog data into the Oracle iProcurement and Purchasing schema model introduced at Release 12. The package name indicates a validation (VAL) role within the R12 catalog upgrade (R12_CAT_UPG) family, complementing peer packages such as PO_R12_CAT_UPG_PVT that perform the actual data movement.

The package is declared with AUTHID CURRENT_USER and, as the naming convention implies, is intended for internal use by the catalog upgrade framework rather than as a public, customer-facing API. Its central responsibility is to validate the staged catalog data—organizations, headers, lines, and the four action types—before the upgrade process commits those records. The header comment references an obsolete snapshot exception (g_SNAPSHOT_TOO_OLD, error -1555), indicating the package was originally designed to handle long-running validation against a consistent read image.

Key Procedures and Functions

The package exposes seven documented procedures, all of which are validation routines:

• VALIDATE_ORG_IDS — Validates the organizational units involved in a batch of catalog upgrade data, accepting a batch identifier, a batch size, and a validate-only mode flag.
• VALIDATE_HEADERS — Validates a single header record passed by reference, using the PO_R12_CAT_UPG_PVT.record_of_headers_type structure, so that errors and warnings can be returned to the caller.
• VALIDATE_LINES — Validates a single line record passed by reference using the PO_R12_CAT_UPG_PVT.record_of_lines_type structure.
• VALIDATE_CREATE_ACTION — Validates the data associated with a create action prior to processing.
• VALIDATE_ADD_ACTION — Validates the data associated with an add action prior to processing.
• VALIDATE_UPDATE_ACTION — Validates the data associated with an update action prior to processing.
• VALIDATE_DELETE_ACTION — Validates the data associated with a delete action prior to processing. This is the procedure most commonly located by searches for the term "validate_delete_action".

Each action-validation procedure accepts a single p_validate_only_mode parameter defaulting to FND_API.G_FALSE, which controls whether the routine performs a pure validation pass without applying changes. This pattern is characteristic of the pre-processing stage of the upgrade.

Tables Accessed

The package reads reference and transactional data from several APPS synonyms during validation, including:

• HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL, HR_LOCATIONS_ALL, HR_LOCATIONS_ALL_TL — used to verify that operating units and locations referenced by catalog upgrade rows are valid and active.
• MTL_SYSTEM_ITEMS, MTL_ITEM_CATEGORIES, MTL_ITEM_REVISIONS, MTL_CATEGORIES, MTL_CATEGORY_SET_VALID_CATS, MTL_DEFAULT_CATEGORY_SETS — used to validate items, categories, category sets, and item-category assignments carried in the upgrade payload.
• AP_TERMS, AP_TERMS_TL — payment terms validation.
• FND_CURRENCIES, FND_LANGUAGES, FINANCIALS_SYSTEM_PARAMS_ALL — currency, language, and financials system parameter validation.

Usage Notes

PO_R12_CAT_UPG_VAL_PVT is an internal component and is not documented for direct customer invocation. It is invoked by the Release 12 catalog upgrade framework, generally from concurrent programs orchestrated by the upgrade driver, and it is referenced by at least one other package in the same family. The validate-only mode flag supports a dry-run pass so that data problems can be reported before any irreversible changes are made. Custom code should not call this package directly; the documented public APIs of the catalog upgrade family should be used instead.