Search Results delete_dm_model

Overview

APPS.AMS_DM_MODEL_PVT is a private PL/SQL package within the Oracle E-Business Suite Marketing (AMS) schema that provides the core business logic layer for Oracle Marketing data mining models. In EBS 12.1.1 and 12.2.2, this package encapsulates the model lifecycle management functions that support the creation, validation, modification, expiry, and build orchestration of data mining models used for customer segmentation, predictive scoring, and targeted campaign execution.

The package is classified as a PVT (private) API, meaning it is intended for internal consumption by other marketing packages rather than direct invocation by external applications or customer extensions. It acts as the transactional engine beneath the public AMS_DMMODEL_PUB layer, mediating between the user interface, concurrent build processes, and the underlying data model tables. Its status is documented as VALID, and it resides in the APPS schema alongside the standard EBS public and private API stack.

Key Procedures and Functions

The package exposes twenty documented procedures and functions that span the full data mining model management domain:

• CHECK_DM_MODEL_ITEMS — validates the items or attributes associated with a data mining model.
• LOCK_DM_MODEL — acquires a lock on a model record, preventing concurrent modification during critical operations.
• CREATE_DM_MODEL — inserts a new data mining model definition, populating the model base and translation tables.
• UPDATE_DM_MODEL — modifies an existing model definition.
• DELETE_DM_MODEL — removes a model and its dependent configuration records.
• VALIDATE_DM_MODEL_REC and VALIDATE_DM_MODEL — perform record-level and full-model validation before persistence or activation.
• VALIDATE_NEXT_STATUS — verifies that a status transition is legal according to the status order rules.
• EXPIRE_MODELS and UNEXPIRE_MODEL — manage model lifecycle expiration and reactivation.
• WF_REVERT — reverses a workflow-driven state change during build processing.
• PROCESS_BUILD_SUCCESS — handles post-build completion logic, updating model status and performance records.
• HANDLE_PREVIEW_REQUEST — supports preview scoring of a model before full deployment.
• COPY_MODEL — duplicates an existing model definition as the basis for a new model.
• WF_BUILD — initiates the workflow-triggered build process for a model.
• CANCEL_BUILD_REQUEST — terminates an in-progress or pending build request.
• HANDLE_DATA_SELECTION_CHANGES and HANDLE_DATA_SOURCE_CHANGES — propagate changes to the model's source data selection and data source definitions.
• SEEDEDDATASOURCE — manages seeded data source definitions delivered with the application.

Tables Accessed

The package reads and writes the primary data mining model tables, including AMS_DM_MODELS_ALL_B and its translation table AMS_DM_MODELS_ALL_TL, along with the AMS_DM_MODELS_ALL_B_S sequence. Configuration and selection metadata is managed through AMS_DM_SOURCE, AMS_DM_TARGETS_B, AMS_DM_TARGET_SOURCES, AMS_DM_IMP_ATTRIBUTES, and AMS_LIST_SELECT_ACTIONS. Model performance and lift metrics are tracked in AMS_DM_PERFORMANCE and AMS_DM_LIFT. Status transitions rely on AMS_USER_STATUSES_B and AMS_STATUS_ORDER_RULES, while ancillary references include AMS_ACT_PRODUCTS and AMS_CUSTOM_SETUPS_B. DUAL is used for single-row operations.

Usage Notes

AMS_DM_MODEL_PVT is invoked indirectly through package dependencies rather than directly by end users. It is referenced by AMS_DMMODEL_PUB, the public API surface, and by the wrapper packages AMS_DM_MODEL_PVT_W and AMS_DM_MODEL_PVT_W. Additional consumer packages include AMS_ADV_FILTER_PVT, AMS_DM_SCORE_PVT, AMS_LISTACTION_PVT, AMS_LIST_SRC_FIELD_PVT, and AMS_WFMOD_PVT. It depends on FND_API for the standard EBS API framework and on AMS_CPYUTILITY_PVT for copy utilities. Customizations should target the public AMS_DMMODEL_PUB interface; direct calls to this private package risk breakage across patches and are not supported.