Search Results obj_status_list_id




Overview
Explore in AI Chat

Overview

The PA_OBJ_STATUS_LISTS table is a core data structure within the Oracle E-Business Suite Projects module (PA). It functions as a mapping or assignment table, central to the configuration of status management for project objects. Its primary role is to store the defined relationships between specific project objects—such as Change Impact (CI) types—and the status lists that govern their valid lifecycle states. This table enables the modular and reusable application of predefined status workflows to different entities within the Projects application, ensuring consistent status tracking and validation across the system.

Key Information Stored

The table's structure is designed to manage these assignments through a minimal set of key columns. The primary identifier is the OBJ_STATUS_LIST_ID, a unique system-generated key for each assignment record. The table's purpose is realized through its foreign key columns, which link to the objects and status lists. Based on the provided metadata, a critical foreign key is PCB_CI_TYPE_ID, which references the PA_CI_TYPES_B table. This column stores the identifier for a Change Impact type, thereby assigning a status list to that specific CI object type. The PST_STATUS_LIST_ID column holds the identifier for the status list being assigned, which references a parent record within the PA_OBJ_STATUS_LISTS table itself or a related status list master table.

Common Use Cases and Queries

This table is primarily accessed for configuration validation and reporting on status list assignments. A common administrative use case is to verify which status lists are applied to specific Change Impact types to ensure proper setup. For troubleshooting, one might query for orphaned records or validate assignments before deploying configuration changes. A typical reporting query would join this table to PA_CI_TYPES_B to list all CI types and their associated status lists.

  • Sample SQL: To retrieve all status list assignments for CI types:
    SELECT ctl.name ci_type_name, osl.pst_status_list_id
    FROM pa_obj_status_lists osl, pa_ci_types_b ctl
    WHERE osl.pcb_ci_type_id = ctl.ci_type_id;
  • Use Case: Identifying unassigned CI types by performing an outer join between PA_CI_TYPES_B and PA_OBJ_STATUS_LISTS.

Related Objects

The PA_OBJ_STATUS_LISTS table maintains defined relationships with other key objects in the Projects schema, as documented in the ETRM metadata.

  • Primary Key: POT_PK on the column OBJ_STATUS_LIST_ID.
  • Foreign Keys (Referencing):
    • PA_CI_TYPES_B: Linked via the column PCB_CI_TYPE_ID. This is the primary documented relationship, tying status lists to Change Impact types.
    • Self-Reference: The column PST_STATUS_LIST_ID references the OBJ_STATUS_LIST_ID column within the same PA_OBJ_STATUS_LISTS table, indicating a hierarchical or derived relationship between status list assignments.
  • Table: PA_OBJ_STATUS_LISTS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_OBJ_STATUS_LISTS,  object_name:PA_OBJ_STATUS_LISTS,  status:VALID,  product: PA - Projects ,  description: This table stores the assignments of status lists to project objects. ,  implementation_dba_data: PA.PA_OBJ_STATUS_LISTS , 

  • Table: PA_OBJ_STATUS_LISTS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_OBJ_STATUS_LISTS,  object_name:PA_OBJ_STATUS_LISTS,  status:VALID,  product: PA - Projects ,  description: This table stores the assignments of status lists to project objects. ,  implementation_dba_data: PA.PA_OBJ_STATUS_LISTS , 

  • View: PA_CI_TYPES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_TYPES_V,  object_name:PA_CI_TYPES_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_CI_TYPES_V , 

  • View: PA_CI_TYPES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CI_TYPES_V,  object_name:PA_CI_TYPES_V,  status:VALID,  product: PA - Projects ,  description: This view is used to display the details of the control item type, in the Update Control Item Type page. ,  implementation_dba_data: APPS.PA_CI_TYPES_V ,