Search Results region_appl_name




Overview
Explore in AI Chat

Overview

The AK_CUSTOM_REGIONS_VL view in the APPS schema is a reporting and integration object within the Oracle E-Business Suite AK (Common Modules — Application Object Library extensions) product family. It exposes customization definitions applied at the region level of the Oracle EBS Forms-based customization framework, resolving region-level customizations to their owning customization, target region, and application context. In EBS 12.1.1 and 12.2.2, the object is documented in the ETRM repository as a VALID VIEW owned by APPS, and it serves as the primary relational interface for querying which properties have been customized for a given region.

Because the view joins translation tables and restricts the language to USERENV('LANG'), it is a "_VL" (translated view) object: it returns only the rows matching the session language, presenting region and customization names and descriptions in the user's installed language. This makes it suitable for concurrent programs, XML Publisher reports, and diagnostic queries that must display user-facing labels rather than internal codes.

Underlying Base Objects

Per ETRM metadata, AK_CUSTOM_REGIONS_VL is defined over the following documented base objects:

The joins resolve customization codes, region codes, and application identifiers across these objects, using USERENV('LANG') for all translation tables so that only the session-language rows participate.

Key Columns

Common Use Cases and Queries

The most frequent use is locating customizations by region name — for example, when auditing why a specific region behaves differently from its seed definition:

SELECT region_name,
       customization_name,
       property_name,
       property_varchar2_value
FROM   apps.ak_custom_regions_vl
WHERE  UPPER(region_name) LIKE UPPER('%:region_name%');

A second scenario enumerates every region-level customization for a given application, useful during upgrade or patch impact analysis:

SELECT region_appl_short_name,
       region_code,
       customization_name,
       property_name,
       property_varchar2_value
FROM   apps.ak_custom_regions_vl
WHERE  region_appl_short_name = 'FND'
ORDER  BY region_code, property_name;

Because the view already applies language filtering and resolves application short names, it is the preferred source for reports, diagnostic scripts, and interfaces needing to present customization data in user-readable form without joining the underlying AK tables manually.