Search Results pa_resource_format_ranks




Overview
Explore in AI Chat

Overview

The PA_RESOURCE_FORMAT_RANKS table is a system-defined reference table within the Oracle E-Business Suite Projects (PA) module. Its primary role is to establish a predefined ranking order for different resource formats. This ranking is a critical component of the resource mapping logic used when processing project transactions, such as expenditure items. The system utilizes this ranking to determine the most appropriate resource from a project's resource list when mapping a transaction's attributes, ensuring accurate cost collection and accounting. It functions as a junction table, linking resource formats (PA_RESOURCE_FORMATS) to transaction class codes (PA_SYSTEM_LINKAGES) to define a precedence hierarchy for each transaction type.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two columns that also serve as foreign keys to related reference tables. The data stored is essentially a set of ranked associations between these two entities.

  • RESOURCE_FORMAT_ID: A foreign key column referencing PA_RESOURCE_FORMATS.RESOURCE_FORMAT_ID. This identifies a specific resource format, such as Person, Job, or Organization.
  • TXN_CLASS_CODE: A foreign key column referencing PA_SYSTEM_LINKAGES.TXN_CLASS_CODE. This identifies the class of transaction, such as 'Labor', 'Expense Report', or 'Usage', for which the ranking is applicable.

The combination of these two columns for a given transaction class implies a specific rank, with lower numerical values typically indicating higher precedence. The table itself does not contain an explicit "RANK" column; the rank is inferred by the system from the defined relationships and possibly the order of records or underlying logic.

Common Use Cases and Queries

The primary use case is during the auto-resolution of resources for project transactions. When an expenditure item is imported or created, the system consults this ranking to determine whether to map the transaction to a specific person, a job, a role, or another format based on the available data. For troubleshooting or reporting on resource mapping rules, database queries against this table are essential.

A common SQL pattern retrieves the ranked list of resource formats for a specific transaction class, joining to the reference tables for descriptive information:

SELECT sl.txn_class_code,
       rf.resource_format_name,
       rf.resource_format_id
FROM pa_resource_format_ranks rfr,
     pa_resource_formats rf,
     pa_system_linkages sl
WHERE rfr.resource_format_id = rf.resource_format_id
  AND rfr.txn_class_code = sl.txn_class_code
  AND sl.txn_class_code = 'Labor' -- Example for Labor transactions
ORDER BY ...; -- Ordering may be based on an implicit sequence or rule

This query helps administrators understand the mapping hierarchy. Direct data manipulation (DML) on this table is strongly discouraged as it is system-defined; customizations should be handled through approved APIs or setup menus.

Related Objects

PA_RESOURCE_FORMAT_RANKS is centrally connected to two key reference tables via foreign key constraints, forming the core of the resource mapping setup.

  • PA_RESOURCE_FORMATS: References via PA_RESOURCE_FORMAT_RANKS.RESOURCE_FORMAT_ID = PA_RESOURCE_FORMATS.RESOURCE_FORMAT_ID. This table defines the valid resource format types (e.g., Person, Job, Team, Role).
  • PA_SYSTEM_LINKAGES: References via PA_RESOURCE_FORMAT_RANKS.TXN_CLASS_CODE = PA_SYSTEM_LINKAGES.TXN_CLASS_CODE. This table defines valid transaction class codes that categorize project expenditures and other transactions.

This table is indirectly related to core transaction tables like PA_EXPENDITURE_ITEMS and PA_RESOURCE_LIST_MEMBERS, as the ranking logic defined here directly influences data in those tables during transaction processing.

  • Table: PA_RESOURCE_FORMAT_RANKS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RESOURCE_FORMAT_RANKS,  object_name:PA_RESOURCE_FORMAT_RANKS,  status:VALID,  product: PA - Projects ,  description: System-defined ranking of resource formats used when mapping transaction attributes to resources in a resource list ,  implementation_dba_data: PA.PA_RESOURCE_FORMAT_RANKS , 

  • Table: PA_RESOURCE_FORMAT_RANKS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RESOURCE_FORMAT_RANKS,  object_name:PA_RESOURCE_FORMAT_RANKS,  status:VALID,  product: PA - Projects ,  description: System-defined ranking of resource formats used when mapping transaction attributes to resources in a resource list ,  implementation_dba_data: PA.PA_RESOURCE_FORMAT_RANKS , 

  • Table: PA_RESOURCE_FORMATS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RESOURCE_FORMATS,  object_name:PA_RESOURCE_FORMATS,  status:VALID,  product: PA - Projects ,  description: System-defined valid resource transaction attribute combinations ,  implementation_dba_data: PA.PA_RESOURCE_FORMATS , 

  • Table: PA_RESOURCE_FORMATS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RESOURCE_FORMATS,  object_name:PA_RESOURCE_FORMATS,  status:VALID,  product: PA - Projects ,  description: System-defined valid resource transaction attribute combinations ,  implementation_dba_data: PA.PA_RESOURCE_FORMATS , 

  • Table: PA_SYSTEM_LINKAGES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_SYSTEM_LINKAGES,  object_name:PA_SYSTEM_LINKAGES,  status:VALID,  product: PA - Projects ,  description: System-defined categories that classify expenditure types and determine how expenditure items of each type are processed ,  implementation_dba_data: PA.PA_SYSTEM_LINKAGES , 

  • Table: PA_SYSTEM_LINKAGES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_SYSTEM_LINKAGES,  object_name:PA_SYSTEM_LINKAGES,  status:VALID,  product: PA - Projects ,  description: System-defined categories that classify expenditure types and determine how expenditure items of each type are processed ,  implementation_dba_data: PA.PA_SYSTEM_LINKAGES ,