Results for “aso_quote_status_transitions”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ASO_QUOTE_STATUS_TRANSITIONS is a configuration table in the ASO (Order Capture) module of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. It stores the transition rules that govern how a quote may move from one status to another within the Oracle Quoting and Order Capture workflow. Each row defines a permitted edge in the quote status lifecycle, identifying the originating status and the destination status and indicating whether that transition is enabled, user-maintainable, or driven by a list of values. The table therefore acts as the metadata backbone for status-change validation performed by the quoting engine.

Under the heuristic Data Vault classification mined from its foreign key structure, ASO_QUOTE_STATUS_TRANSITIONS is best modelled as a link table. It resolves a many-to-many relationship between quote statuses, connecting two references to the same status dimension (ASO_QUOTE_STATUSES_B) through the FROM_STATUS_ID and TO_STATUS_ID columns. This classification is a modeling suggestion only; the table is physically a standard EBS transactional/configuration entity with WHO audit columns and a security group reference.

Key Information Stored

The table carries 38 documented columns. The most significant are:

• TRANSITION_ID — the surrogate primary key, enforced by ASO_QUOTE_STATUS_TRANS_PK and also carried by the unique index ASO_QUOTE_STATUS_TRANSITIONS_U. This is the column users typically search for when locating a specific transition rule.
• FROM_STATUS_ID — the status from which a transition originates; a foreign key to ASO_QUOTE_STATUSES_B.
• TO_STATUS_ID — the status to which a transition is permitted; a foreign key to ASO_QUOTE_STATUSES_B.
• ENABLED_FLAG — controls whether the transition is active and permitted at runtime.
• LOV_DRIVEN_FLAG — indicates whether the transition is presented or selected through a list of values.
• USER_MAINTAINABLE_FLAG — indicates whether the end user may perform the transition manually.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, scoping the row to a security group for multi-org and access control.
• OBJECT_VERSION_NUMBER — the optimistic locking token used by the EBS framework.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — the standard EBS descriptive flexfield and descriptive columns.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — WHO audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program audit columns.

The unique index on TRANSITION_ID confirms it as the sole documented business-key candidate; there is no documented natural unique key on the FROM/TO status pair, though logically that pair defines the rule.

Common Use Cases and Queries

Typical uses include troubleshooting quote status transitions, verifying that a status change is enabled, and reporting on the configured status lifecycle. A common lookup returns the permitted destinations from a given status:

• Query by primary key: SELECT * FROM ASO.ASO_QUOTE_STATUS_TRANSITIONS WHERE transition_id = :p_transition_id;
• List enabled transitions from a status: SELECT to_status_id FROM ASO.ASO_QUOTE_STATUS_TRANSITIONS WHERE from_status_id = :p_from AND enabled_flag = 'Y';
• Join to status descriptions via ASO_QUOTE_STATUSES_B on both FROM_STATUS_ID and TO_STATUS_ID.
• Filter by security group to restrict to the appropriate operating scope.

Related Objects

• ASO_QUOTE_STATUSES_B — referenced twice, via FROM_STATUS_ID and TO_STATUS_ID, providing the status definitions at each end of a transition.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for access scoping.
• ASO_QUOTE_HEADERS_ALL — quote headers whose status values are governed by these transitions.
• ASO_QUOTE_LINES_ALL — quote lines affected by status changes.
• ASO_QUOTE_STATUSES_TL — translated status names joined through ASO_QUOTE_STATUSES_B for reporting.
• Oracle Quoting forms and the Order Capture public APIs, which validate status changes against this rule set.