Search Results amw_data_import

Overview

The APPS.AMW_LOAD_KEY_ACC_DATA package body is a component of the Oracle E-Business Suite environment supporting the Audit Management Workbench (AMW), a module within the Enterprise Risk and Compliance Management (ERM) family. Its primary business function is to load key account data and associated risk-and-control records from the AMW_KEY_ACC_INTERFACE staging table into the production AMW tables. The package implements a bulk import facility, historically associated with the import function identifier AMW_DATA_IMPORT, which is validated against the user's menu-function and responsibility assignments before processing.

The package is classified as OTHER in the ETRM metadata, indicating it is not a public API exposed for external callers, but rather an internal loader invoked through the AMW application flow. It reads records from the interface table, performs validation and privilege checks, and writes the validated records into the destination associations tables while simultaneously recording error messages back onto the interface rows so that failed records can be corrected and reprocessed.

Key Procedures and Functions

• CREATE_KEY_ACC_ASSOC — The principal loading routine. It reads records from AMW_KEY_ACC_INTERFACE and creates the corresponding key account association records. It is responsible for the primary insert-or-update logic against the destination tables and for updating the interface rows with error messages when validation or production inserts fail.
• UPDATE_INTERFACE_WITH_ERROR — A helper routine that writes error information (such as an error message and the associated table name) back to the interface record. This supports the standard AMW correction-and-retry cycle, allowing users to identify and fix rejected rows.
• CREATE_AMW_KEY_ACC_ASSOC — A companion creation routine that handles the actual construction of the AMW key account association entries, separating association creation logic from the interface-reading logic in CREATE_KEY_ACC_ASSOC.
• CHECK_FUNCTION — A validation routine that verifies the calling user has access to the import menu function. It uses the Has_Import_Privilege function logic, joining FND_RESPONSIBILITY, FND_COMPILED_MENU_FUNCTIONS, and related FND tables to confirm the user's responsibility includes the import function before permitting data to be loaded.

Tables Accessed

• AMW_KEY_ACC_INTERFACE — The staging table read by the package; source of incoming key account data.
• AMW_ACCT_ASSOCIATIONS and AMW_ACCT_ASSOCIATIONS_S — The destination association tables where validated records are inserted or updated.
• FND_RESPONSIBILITY, FND_RESP_FUNCTIONS, FND_COMPILED_MENU_FUNCTIONS, and FND_FORM_FUNCTIONS — Security tables used by CHECK_FUNCTION and Has_Import_Privilege to confirm the user's responsibility grants access to the import function.
• FND_USER and DUAL — Support tables used for user identification and cursor constructs.

Usage Notes

The package is invoked as part of the AMW key account import process, typically triggered from an AMW application form or a concurrent program that first stages data in AMW_KEY_ACC_INTERFACE. Before processing, the package calls CHECK_FUNCTION to confirm that the signed-in user's responsibility includes the AMW_DATA_IMPORT function; users lacking this privilege are rejected with an appropriate message. Because the package relies on FND_GLOBAL.USER_ID and FND_GLOBAL.CONC_LOGIN_ID, it behaves correctly when executed both online and from a concurrent manager session. After loading, failed interface rows remain flagged with error messages for correction and retry, while successfully loaded rows may be deleted from the interface based on profile settings.