Search Results pa_event_type_ous_all




Overview
Explore in AI Chat

Overview

The PA_EVENT_TYPE_OUS_ALL table is a core data object within the Oracle E-Business Suite Projects (PA) module, specifically for versions 12.1.1 and 12.2.2. It serves as the repository for operating unit-specific configuration and control data for Event Types. In Oracle Projects, Event Types are used to classify and manage different kinds of project-related occurrences, such as milestones, deliverables, or meetings. This table's primary role is to enable the definition and customization of Event Type attributes at the individual operating unit level, supporting a multi-org implementation structure. It acts as a child table to the base Event Types definition, allowing for granular financial and tax rules to be applied based on the organizational context.

Key Information Stored

The table stores configuration parameters that link an Event Type to a specific operating unit (ORG_ID). While the full column list is not detailed in the provided metadata, the foreign key relationships indicate the nature of the critical data stored. The EVENT_TYPE column links back to the master definition in PA_EVENT_TYPES. The ORG_ID column ties the configuration to a specific operating unit via the PA_IMPLEMENTATIONS_ALL table. A significant column is OUTPUT_VAT_TAX_ID, which stores a reference to a value-added tax (VAT) code from the AR_VAT_TAX_ALL_B table, allowing for the assignment of specific tax rules to event types on a per-operating-unit basis. This structure facilitates the enforcement of organization-specific financial policies and compliance requirements for project events.

Common Use Cases and Queries

A primary use case is the setup and maintenance of tax applicability for project billing events across different legal entities or geographies. Administrators use this table to ensure that when an event is recorded on a project within a given operating unit, the correct VAT treatment is applied for invoicing. For reporting, it is crucial for generating analyses of event types segmented by operating unit. A common query pattern involves joining this table to the master event types table to retrieve a complete list of configured events for a specific organization.

SELECT pet.event_type,
       pet.name,
       petou.org_id,
       petou.output_vat_tax_id
FROM pa_event_types pet,
     pa_event_type_ous_all petou
WHERE pet.event_type = petou.event_type
AND petou.org_id = :p_org_id;

Another critical use case is during data migration or integration, where scripts must populate or validate operating-unit-specific event type settings to ensure financial consistency.

Related Objects

  • PA_EVENT_TYPES: The parent table for master Event Type definitions. Joined via PA_EVENT_TYPE_OUS_ALL.EVENT_TYPE = PA_EVENT_TYPES.EVENT_TYPE.
  • PA_IMPLEMENTATIONS_ALL: Provides the operating unit context. Joined via PA_EVENT_TYPE_OUS_ALL.ORG_ID = PA_IMPLEMENTATIONS_ALL.ORG_ID.
  • AR_VAT_TAX_ALL_B: The Receivables table storing VAT tax codes. Joined via PA_EVENT_TYPE_OUS_ALL.OUTPUT_VAT_TAX_ID = AR_VAT_TAX_ALL_B.VAT_TAX_ID to determine the applicable tax rule.

These relationships underscore the table's integral position in linking project management functionality (event types) with financial and organizational structures (tax codes, operating units).