Search Results pa_system_linkages_pk

Overview

The PA_SYSTEM_LINKAGES table is a core reference table within the Oracle E-Business Suite Projects module (PA). It defines the master list of system-defined categories, known as System Linkage Functions, which classify expenditure types and govern the transactional processing logic for project-related costs and commitments. These classifications are fundamental to the financial and operational behavior of expenditure items, determining how they are accounted for, allocated, and reported. The table's integrity is enforced by the primary key PA_SYSTEM_LINKAGES_PK, and its data is referenced extensively throughout the Projects application to ensure consistent processing rules are applied across transactions, from expenditure entry to cost collection and revenue generation.

Key Information Stored

While the provided metadata does not list specific columns, the documented foreign key relationships and description indicate the table's critical data elements. The central column is the SYSTEM_LINKAGE_FUNCTION, a code representing a specific classification such as Labor, Overhead, or Material. Another key column is APPLICATION_ID, which links to FND_APPLICATION to identify the owning module. The table also includes a self-referencing foreign key on COST_CREDIT_FUNCTION_CODE, suggesting a hierarchical or related relationship between different linkage functions, potentially for cost and credit pairing logic. Each row defines a discrete processing category that dictates the applicable accounting, validation, and integration rules for any expenditure type assigned to it.

Common Use Cases and Queries

The primary use case is the setup and maintenance of expenditure types within the Projects module. When defining an expenditure type in PA_EXPENDITURE_TYPES, a System Linkage Function from this table must be assigned, which then controls the item's behavior. Common queries involve listing all available system linkages for setup purposes or identifying the classification of specific expenditure types for troubleshooting transaction processing. For instance, to find all expenditure types classified as 'Labor', a join is performed: SELECT pet.expenditure_type, psl.system_linkage_function FROM pa_expenditure_types pet, pa_system_linkages psl WHERE pet.system_linkage_function = psl.system_linkage_function AND psl.system_linkage_function = 'LABOR';. Reporting use cases include analyzing cost distribution by transaction class or validating that expenditure groupings (PA_EXPENDITURE_GROUPS_ALL) contain logically consistent transaction types.

Related Objects

As evidenced by the extensive foreign key relationships, PA_SYSTEM_LINKAGES is a pivotal parent table for numerous transactional and setup entities within Projects and related modules like Grants Accounting (GMS). Key dependent objects include:

• PA_EXPENDITURE_TYPES: Core reference joined on SYSTEM_LINKAGE_FUNCTION.
• PA_EXPENDITURE_ITEMS_ALL: Transactional data linked via SYSTEM_LINKAGE_FUNCTION.
• PA_ALLOC_RULES_ALL: Uses linkage codes for both TARGET_EXP_TYPE_CLASS and OFFSET_EXP_TYPE_CLASS.
• PA_TRANSACTION_SOURCES: Joined on SYSTEM_LINKAGE_FUNCTION to define valid sources.
• PA_RESOURCE_MAPS & PA_RESOURCE_TXN_ATTRIBUTES: Reference SYSTEM_LINKAGE_FUNCTION for resource assignment rules.
• GMS_ENCUMBRANCE_GROUPS_ALL: Grants Accounting table linked via SYSTEM_LINKAGE_FUNCTION.
• PA_PROJECT_ASSIGNMENTS: References EXPENDITURE_TYPE_CLASS, which is typically derived from this table.

These relationships underscore the table's role as the definitive source for transaction classification logic.