Search Results aso_dependency_mappings_pk

Overview

The ASO_DEPENDENCY_MAPPINGS table is a core repository within the Oracle E-Business Suite (EBS) Order Capture (ASO) module, specifically for releases 12.1.1 and 12.2.2. It is a technical configuration table that stores dependency mappings for defaulting triggers. Its primary role is to define and manage the conditional relationships and data dependencies that govern how attribute values are automatically defaulted or derived during the order entry and configuration processes. By maintaining these mappings, the table ensures that complex defaulting logic is executed in the correct sequence and only when prerequisite conditions are met, which is fundamental for accurate and efficient order configuration and pricing.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is documented as DEPENDENCY_ID, which uniquely identifies each dependency mapping rule. Based on its described purpose, the table typically stores information that links a triggering event or source attribute to one or more target attributes that require defaulting. This likely includes columns to define the source object (e.g., item, pricing attribute), the target object, the dependency condition or rule, and the sequence of execution. The data stored is essential for the runtime engine that processes defaulting logic within the Order Capture flows.

Common Use Cases and Queries

The primary use case for this table is the administration and troubleshooting of defaulting behavior in complex configurable products and pricing setups. For instance, an administrator may need to analyze why a specific attribute is not being defaulted correctly. A common query would involve selecting mappings by a specific DEPENDENCY_ID or by a source object type to understand the chain of dependencies. Sample SQL patterns include auditing the existing mappings or identifying dependencies for a particular item class.

• Audit all dependency mappings: SELECT dependency_id, <other_columns> FROM aso.aso_dependency_mappings;
• Investigate a specific mapping: SELECT * FROM aso.aso_dependency_mappings WHERE dependency_id = <value>;

Direct manipulation of this table is not standard practice; configuration is typically performed via the Order Capture application's administrative interfaces or related APIs to maintain data integrity.

Related Objects

ASO_DEPENDENCY_MAPPINGS is intrinsically linked to other objects in the ASO schema that manage defaulting rules and configuration logic. It is a foundational table for the defaulting trigger mechanism. Key related objects include the ASO_DEFAULTING_TRIGGERS table, which likely stores the master definition of the triggers themselves, and the ASO_DEPENDENCY_MAPPINGS_PK primary key constraint. The table's functionality is also exposed and consumed by various PL/SQL packages within the ASO module responsible for processing order configuration and pricing workflows. Changes or extensions to defaulting logic would involve coordinated updates across these related objects.