Search Results aso_apr_rule_groups_b_pk

Overview

The table ASO_APR_RULE_GROUPS_B is a historical data object within the Oracle E-Business Suite (EBS) Order Capture (ASO) module. According to the official ETRM documentation, this table is designated as obsolete and was not utilized in the 11i release. In the context of later versions, such as 12.1.1 and 12.2.2, its presence is a legacy artifact from earlier application architectures. The table's intended purpose was to serve as the base table for storing rule group definitions, which are logical collections of approval rules used to govern the order workflow. However, its functionality was superseded by other application components, rendering the table non-operational in the referenced EBS versions.

Key Information Stored

Given the table's obsolete status, its columns are not actively populated or maintained by the application in versions 12.1.1 and 12.2.2. The primary documented structural element is the primary key column, ASO_APR_RULE_GROUP_ID, which would have uniquely identified each rule group. The table also contains a foreign key column, AK_OBJECT, linking to the AK_OBJECTS table. This relationship suggests the table was originally designed to integrate with the Oracle Application Object Library's generic object management framework. No other column definitions are provided in the available metadata, consistent with an object that is no longer implemented.

Common Use Cases and Queries

There are no active use cases for this table in Oracle EBS 12.1.1 or 12.2.2, as it is explicitly noted as not implemented. Technical consultants and DBAs should not develop new code, integrations, or reports that reference this table. Any existing data found within it is vestigial and should not be relied upon for business logic. Sample queries are not applicable for operational purposes. The only relevant query would be for diagnostic or cleanup activities to confirm its lack of active data, such as: SELECT COUNT(*) FROM ASO_APR_RULE_GROUPS_B; A result of zero is expected in a properly maintained instance.

Related Objects

The ETRM documentation specifies several foreign key relationships, which outline the table's former position in the data model. These relationships are also legacy but are important for understanding potential dependencies in customizations or data analysis.

• Primary Key: ASO_APR_RULE_GROUPS_B_PK on column ASO_APR_RULE_GROUP_ID.
• Foreign Key References:
  • From ASO_APR_RULE_GROUPS_TL: The translation table (TL) for multilingual support, joined via ASO_APR_RULE_GROUP_ID.
  • From ASO_APR_RULE_GRP_MEMBER: A table that would have associated individual rules with a group, joined via ASO_APR_RULE_GROUP_ID.
• Foreign Key Reference To:
  • To AK_OBJECTS: The base table (B) references AK_OBJECTS via the AK_OBJECT column.

All related tables, including the translation and member tables, share the same obsolete status and are not part of the active approval rule engine in the specified EBS releases.