Search Results po_asl_status_rules




Overview
Explore in AI Chat

Overview

PO_ASL_STATUS_RULES is a Purchasing (PO) module reference table that defines the business rules governing the status transitions and permissible actions for records held in the Approved Supplier List (ASL). In Oracle E-Business Suite 12.1.1 and 12.2.2, the ASL is the authoritative registry of suppliers, supplier sites, and sourcing rules that have been qualified for procurement activity. The status assigned to an ASL entry — for example, Active, Inactive, Pending, or Disqualified — determines whether purchase orders, sourcing documents, or blanket agreements may be created against that supplier. PO_ASL_STATUS_RULES supplies the configuration layer that sits behind those determinations, allowing the application to enforce which actions are legal for a given combination of status and business rule.

From a data modeling perspective, the ETRM metadata classifies this object heuristically as standalone, indicating that it participates in no foreign key relationships to other tables within the mined schema. In Data Vault terms, this classification suggests the table behaves as a small reference or lookup set rather than a hub, link, or satellite. It is best treated as a static configuration entity whose rows are seeded and maintained by the application rather than by transactional activity.

Key Information Stored

The table contains 12 documented columns. The most significant are:

  • STATUS_ID — Identifier of the ASL status to which the rule applies; part of the composite primary key.
  • BUSINESS_RULE — The named rule or action category being governed; the second component of the composite primary key.
  • ALLOW_ACTION_FLAG — A Yes/No indicator specifying whether the associated action is permitted for the given status and rule combination.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording who created and last modified each row and when.
  • REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program context columns that identify the request and program responsible for the most recent insert or update, which is particularly relevant given that this table is typically populated by seeding concurrent programs during implementation.

The surrogate primary key is defined by the constraint PO_ASL_STATUS_RULES_PK over (BUSINESS_RULE, STATUS_ID). Because the primary key is composed of these two business-meaningful attributes, there is no separate system-generated identifier; the pair itself constitutes the unique business key, and each combination of status and business rule may appear at most once.

Common Use Cases and Queries

Typical uses of this table fall into configuration validation, troubleshooting, and reporting. Buyers and implementation teams query it to confirm which actions remain available for a supplier whose ASL status has changed. A representative query returns all permitted rules for a specific status:

  • SELECT status_id, business_rule, allow_action_flag FROM po.po_asl_status_rules WHERE status_id = :p_status_id AND allow_action_flag = 'Y';
  • SELECT business_rule, allow_action_flag FROM po.po_asl_status_rules WHERE status_id = :p_status_id ORDER BY business_rule;

Support analysts also use it to diagnose why the application blocks an action against an inactive or disqualified supplier, since the absence of an enabled rule explains the restriction. Reporting extracts frequently join this table to status lookup data to produce a matrix of statuses against allowable actions for audit or configuration documentation purposes. Because the table is small and slowly changing, it is a good candidate for caching in custom concurrent programs that validate ASL activity in bulk.

Related Objects

Although the mined metadata records no foreign keys for this table, it is functionally coupled to the core ASL objects in the PO schema:

  • PO_APPROVED_SUPPLIER_LIST — The ASL header table whose STATUS_ID values are interpreted using the rules defined here.
  • PO_ASL_STATUSES — The status definition table supplying the STATUS_ID values referenced by the rules.
  • PO_ASL_DOCUMENTS and PO_ASL_ATTRIBUTES — Related ASL detail tables whose permitted operations depend on the governing status rules.
  • PO_ASL_ACTIONS — The executable actions against ASL records that the ALLOW_ACTION_FLAG column authorizes or suppresses.
  • PO_SUPPLIER_ENTRY_STATUS and supplier-site setup tables — Used together with the ASL when determining overall supplier eligibility.

Custom reports and validations should treat PO_ASL_STATUS_RULES as the authoritative configuration source for ASL action eligibility across both release 12.1.1 and 12.2.2.