Search Results edit_flag

Overview

PA_STRUCT_TASK_EDIT_V is a Projects (PA) module database view in Oracle E-Business Suite 12.1.1 and 12.2.2. As documented in the ETRM metadata, its purpose is to select all the attributes of a structure version and a task version. The description carries an explicit qualifier stating that the object is intended "for future use," which is a significant signal regarding its status and reliability.

The view is not a standard, actively maintained reporting object. It exposes a blended row set that unifies structural WBS information with task-level information, driven by the OBJECT_TYPE discriminator inherited from the PA_PROJ_ELEMENTS table. The user's search term "edit_flag" corresponds to a logical concept embedded within the view text rather than a physical column named EDIT_FLAG. Specifically, the view computes an editability indicator through the function call PA_PROJ_ELEMENTS_UTILS.CHECK_EDIT_TASK_OK, which accepts the project identifier, the parent structure version identifier, and a global structure version identifier derived from PA_PROJ_ELEMENTS_UTILS.GETGLOBALSTRUCVERID. This computed value occupies the position where an edit flag would be expected, determining whether a given task or structure element is currently editable.

Because the ETRM metadata documents the object as "Not implemented in this database," the view may not exist as a compiled object in every environment. Its presence is therefore environment-dependent, and any integration or reporting dependency on it should be validated against the target instance before use.

Underlying Base Objects

The ETRM metadata records no documented referenced base objects. However, the published view text reveals the underlying tables through its column aliases and joins. The principal tables participating in the definition include:

• PPE, corresponding to PA_PROJ_ELEMENTS, supplying element attributes such as PROJ_ELEMENT_ID, PROJECT_ID, OBJECT_TYPE, ELEMENT_NUMBER, NAME, DESCRIPTION, STATUS_CODE, PRIORITY_CODE, MANAGER_PERSON_ID, CARRYING_OUT_ORGANIZATION_ID, INC_PROJ_PROGRESS_FLAG, LINK_TASK_FLAG, and RECORD_VERSION_NUMBER.
• PPVS, representing the structure version table (PA_PROJ_STRUCTURE_VERSIONS), contributing VERSION_NUMBER, NAME, LATEST_EFF_PUBLISHED_FLAG, and PUBLISHED_DATE.
• PPV and PPV2, representing element version records, supplying ELEMENT_VERSION_ID, DISPLAY_SEQUENCE, PARENT_STRUCTURE_VERSION_ID, WBS_LEVEL, WBS_NUMBER, and RECORD_VERSION_NUMBER.
• PPVSCH, the scheduling extension, contributing MILESTONE_FLAG, CRITICAL_FLAG, SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE, ESTIMATED_START_DATE, ESTIMATED_FINISH_DATE, ACTUAL_START_DATE, and PEV_SCHEDULE_ID.
• POR, an object relationship table, contributing OBJECT_ID_FROM1, OBJECT_TYPE_FROM, RELATIONSHIP_TYPE, RELATIONSHIP_SUBTYPE, OBJECT_RELATIONSHIP_ID, and RECORD_VERSION_NUMBER.
• Lookup and reference tables: FL1 through FL6 for meaning translations, PAPF for person name and work telephone, HOU for organization name, PPA for project segment and name, PST for structure type class code, PPS2 for project status name, PT for service type, work type, and chargeability attributes, and PWT for work type name.

Key Columns

The view exposes a wide attribute set. The identifier columns ELEMENT_VERSION_ID, PROJ_ELEMENT_ID, PROJECT_ID, and PARENT_STRUCTURE_VERSION_ID anchor each row. The OBJECT_TYPE column acts as the discriminator that shapes the DECODE expressions used for the display number and name, resolving either the element number and name for PA_TASKS or the version number and name for PA_STRUCTURES.

The computed editability expression, driven by CHECK_EDIT_TASK_OK and GETGLOBALSTRUCVERID, serves as the effective edit flag. The summary indicator is derived from IS_SUMMARY_TASK_OR_STRUCTURE. Scheduling columns include MILESTONE_FLAG, CRITICAL_FLAG, and the start and finish date fields. Approval and publication status are represented by STATUS_CODE, PROJECT_STATUS_NAME, LATEST_EFF_PUBLISHED_FLAG, and PUBLISHED_DATE. Additional task attributes include SERVICE_TYPE_CODE, CHARGEABLE_FLAG, BILLABLE_FLAG, and RECEIVE_PROJECT_INVOICE_FLAG. Multiple RECORD_VERSION_NUMBER columns from each participating table support optimistic locking behavior.

Common Use Cases and Queries

Given the "future use" designation and its status as not implemented, this view is best treated as a diagnostic or exploratory object rather than a supported reporting source. A representative query to inspect editability is:

• SELECT project_id, wbs_number, element_version_id, DECODE(ppe_object_type,'PA_STRUCTURES','Y','PA_TASKS', PA_PROJ_ELEMENTS_UTILS.IS_SUMMARY_TASK_OR_STRUCTURE(element_version_id)) ...

More practically, the underlying tables and the utility functions PA_PROJ_ELEMENTS_UTILS.CHECK_EDIT_TASK_OK and GETGLOBALSTRUCVERID should be queried directly when building supported customizations, ensuring compatibility across 12.1.1 and 12.2.2 environments where this view may be absent.