Search Results g_extract_obj

Overview

AK_UPLOAD_GRP is a group-type PL/SQL package in the Oracle E-Business Suite Application Object Library (AK) module, owned by the APPS schema. It belongs to the Oracle EBS extensibility and customisation framework, closely associated with the AK (Application Kit) attribute and setup data upload utilities used during implementation, cloning, and patch application. The package supports bulk upload of application setup and configuration data into an Oracle EBS environment. Its internal global variables reveal its operating model: G_UPDATE_MODE, G_NO_CUSTOM_UPDATE, G_COMPARE_UPDATE, G_NON_SEED_DATA, G_UPLOAD_DATE, G_GEN_DATE, and G_EXTRACT_OBJ. These flags govern whether an upload updates all rows or only non-customised rows, whether a comparison is performed before update, whether only non-seed (customer) data is processed, and which extract object is being loaded. This reflects a controlled, rule-driven loader rather than a simple bulk insert.

Key Procedures and Functions

The documented public interface exposes exactly one procedure, declared in the package specification as UPLOAD. It accepts an update mode input and returns an OUT parameter carrying the return status. The update mode determines the loader's behaviour with respect to the global variables described above — in particular whether customised records are protected from overwrite and whether existing records are compared prior to update. The OUT status parameter allows the caller to detect success or failure and to react accordingly, which is essential when UPLOAD is driven from a concurrent program or a batch script. No other procedures or functions are documented at the specification level; any additional private routines live in the package body and are not part of the supported interface.

Tables Accessed

The ETRM metadata records two referenced source objects accessed through APPS synonyms. PLITBLM is an Oracle EBS table used by the PL/SQL file I/O utility (FND_FILE / UTL_FILE-style buffering) and is referenced because the upload process reads staged input records from a file before applying them to target setup tables. V$SESSION is the dynamic performance view used to interrogate session state; within this package it supports runtime context checks such as identifying the active session, environment, and user during an upload run. The actual customer-data target tables are resolved dynamically at runtime by the extract object identifier (G_EXTRACT_OBJ), which is why they are not enumerated as static references in the metadata.

Usage Notes

AK_UPLOAD_GRP is typically invoked in the context of Oracle EBS setup data migration — for example, loading attributes, descriptive flexfield definitions, or application kit metadata exported from a source instance. Because it protects customised data by default (G_NO_CUSTOM_UPDATE is initialised FALSE but is designed to be flipped to TRUE for non-custom updates), it is used in controlled patch and clone scenarios where only seed or only non-seed data should be affected. The package is referenced by eight other packages, indicating it is an internal dependency of the AK upload subsystem rather than a direct end-user API. It is not associated with any Oracle Forms screen in the documented metadata; invocation is expected through concurrent programs or custom PL/SQL wrappers. In Oracle EBS 12.1.1 and 12.2.2, callers should treat the package specification as stable and the body as subject to change, and should always inspect the returned status value before committing. Direct invocation outside the supported AK upload flow is not recommended.