Search Results create_key_acc_assoc




Overview
Explore in AI Chat

Overview

AMW_LOAD_KEY_ACC_DATA is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Application Management Workbench (AMW) family of objects, a module associated with the management and administration of application accounts, responsibilities, and their associated key account mappings. The package serves as a data-loading and validation utility responsible for creating and maintaining key account associations between AMW account structures and the underlying interface and base tables that store account-to-key relationships. The package is classified as an OTHER API, meaning it is not a public, formally supported business API but rather an internal or utility package invoked by concurrent processing, forms, or dependent package logic. Its status is documented as VALID across Oracle EBS 12.1.1 and 12.2.2. The documented metadata confirms four callable program units and a defined set of AMW and FND tables, indicating that the package bridges key account interface records with persisted association records while performing function-level security checks against Oracle Applications responsibility and function metadata.

Key Procedures and Functions

  • CREATE_KEY_ACC_ASSOC — Creates a key account association record. This is the primary routine for transforming incoming interface data into a persisted association, writing to the base AMW_ACCT_ASSOCIATIONS table and its related structures.
  • CREATE_AMW_KEY_ACC_ASSOC — A companion creation routine, likely handling the AMW-specific variant of association creation or generating the corresponding association identifier and supporting row in the _S (sequence/primary key) table.
  • UPDATE_INTERFACE_WITH_ERROR — Records error information back onto the interface table row when validation or association creation fails, providing the error-handling path for the load process and enabling downstream review and correction.
  • CHECK_FUNCTION — Performs a validation check against Oracle Applications function and responsibility metadata, used to control or restrict the load based on function-level access. This supports secured or conditional execution of the loading logic.

No parameter lists are documented in the ETRM metadata; the descriptions above reflect the documented program unit names and their evident roles within the load-and-validate workflow.

Tables Accessed

  • AMW_KEY_ACC_INTERFACE — The staging/interface table from which key account data is loaded and onto which errors are written.
  • AMW_ACCT_ASSOCIATIONS — The base table holding the final key account association records created by the package.
  • AMW_ACCT_ASSOCIATIONS_S — The sequence/primary key table supporting unique identifier generation for associations.
  • FND_COMPILED_MENU_FUNCTIONS, FND_FORM_FUNCTIONS, FND_RESPONSIBILITY, FND_RESP_FUNCTIONS, FND_USER — Standard Oracle Application Object Library security tables, read to validate responsibility, function, and user context within CHECK_FUNCTION and related logic.
  • DUAL — Used for single-row selection and sequence/identity value retrieval.

Usage Notes

The package is typically invoked indirectly rather than through direct user action. It is most likely called from an AMW concurrent program or a supporting form that loads key account data from the interface table into the base association tables, or from a dependent AMW package. Because it is classified as an OTHER API and referenced by zero other documented packages, custom code should avoid direct invocation unless the interface and association loading sequence is fully understood. When errors occur during loading, UPDATE_INTERFACE_WITH_ERROR ensures the source rows remain traceable. In 12.1.1 and 12.2.2 the object remains VALID; no differences in behavior are documented between the two releases.