Search Results fix_ak_regionitems




Overview
Explore in AI Chat

Overview

The APPS.BIS_RG_FIX_AKFLEX_DATA package is a private, one-time-use migration utility in Oracle E-Business Suite. Its stated purpose, drawn directly from the package header comment, is to "move AK region flex field data for Report regions from Global Data Elements to BIS PM Viewer." The package operates with AUTHID CURRENT_USER rights, meaning its SQL statements execute under the privileges of the invoking schema rather than the definer, which is consistent with a corrective script intended to be run in a controlled administrative context.

The header identifies the initial creation date as 02-25-00 by user amkulkar, and the surviving source version (115.5, dated 2002/12/23) predates the 12.1.1 and 12.2.2 releases. Although the file is versioned and retained in the APPS schema, its comment block labels it a "Private package," indicating it was never intended as a general-purpose application programming interface. In practice it functions as a data remediation utility for the Oracle Application Framework (OAF) / AK (Application Kit) repository metadata that underpins Report Regions in the BIS Product Manager Viewer. The 12.1.1 ETRM registration classifies it as API classification "OTHER" with no dependent packages, confirming it is not part of a broader callable API surface.

Key Procedures and Functions

The package exposes two documented procedures, both declared with OUT parameters for a return code and a return status, following the standard EBS concurrent-style error signalling convention. No IN parameters are documented for either procedure.

  • FIX_AK_REGIONITEMS — Corrects the stored flex field metadata associated with AK region items for Report regions, relocating that configuration from the "Global Data Elements" scope into the BIS PM Viewer scope.
  • FIX_AK_REGIONS — Performs the equivalent corrective operation at the AK region level, updating the region definitions themselves so that the Report regions are correctly attributed to the BIS PM Viewer.

The two procedures together address the region header and its constituent items: FIX_AK_REGIONS aligns the parent region records, while FIX_AK_REGIONITEMS aligns the child item records. The naming and ordering imply that FIX_AK_REGIONS should be invoked first so that matching region identifiers exist before item-level rows are rewritten.

Tables Accessed

The ETRM metadata documents three tables referenced through APPS synonyms:

  • AK_REGIONS — Stores the region definitions for the AK/OAF metadata repository. This is the primary target of the region-level correction.
  • AK_REGION_ITEMS — Stores the individual items belonging to each region. This is the target of the item-level correction.
  • FND_FORM_FUNCTIONS — The Oracle Application Object Library table of registered form functions. It is referenced to resolve or validate the function/region ownership so the correct BIS PM Viewer context can be applied.

All three are accessed through APPS-owned synonyms, which is expected for a package compiled into the APPS schema.

Usage Notes

Because this is a private migration package with no documented concurrent program or form binding, it is not invoked during normal application runtime. Typical invocation is manual, by a DBA or technical consultant, from SQL*Plus or a similar tool while connected as the APPS user, using an anonymous PL/SQL block that calls the two procedures and captures the returned code and status. It would be run in response to a specific data defect affecting BIS Report Regions after an upgrade or patch.

Users searching for fix_ak_regionitems are most likely troubleshooting such a defect or auditing the package before removal. Two cautions apply: the package is labelled private and carries a pre-12.x copyright header, so it may be obsolete in 12.1.1 or 12.2.2 deployments and any use should be confirmed against current Oracle guidance and a validated backup; and, given the operations are data-rewriting in nature, it should be executed once, deliberately, and never as part of a repeated scheduled process.