Results for “resource_format_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_RESOURCE_FORMAT_RANKS is a reference table in the Oracle Projects (PA) schema that stores the system-defined ranking of resource formats used when mapping transaction attributes to resources in a resource list. It resides in the PA schema and is fully valid in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The table supports the resource mapping engine that assigns incoming project transactions — such as labor, expense, or usage items — to the correct resource based on the format of the transaction attribute and the transaction class under which the mapping occurs.

Structurally, PA_RESOURCE_FORMAT_RANKS behaves as a link table in a Data Vault modeling sense, as the heuristic classification derived from its foreign key structure indicates. It bridges two reference entities — PA_RESOURCE_FORMATS and PA_SYSTEM_LINKAGES — and carries a descriptive ranking attribute (RANK) that qualifies the relationship. This means the table is not a transactional fact store but a resolution rule set: it tells the application which format preference to apply, and in what priority, when several candidate formats could apply to the same transaction class.

Key Information Stored

The documented physical schema contains eight columns. The most significant are:

• RESOURCE_FORMAT_ID — Part of the composite primary key; references PA_RESOURCE_FORMATS and identifies the resource format being ranked.
• TXN_CLASS_CODE — Part of the composite primary key; references PA_SYSTEM_LINKAGES and identifies the transaction class (for example, expenditure type or cost transaction category) to which the ranking applies.
• RANK — The ranking value that determines the precedence of the format when the mapping engine selects among multiple candidates.
• LAST_UPDATE_DATE and LAST_UPDATED_BY — Standard audit columns capturing when and by whom the row was last modified.
• CREATION_DATE and CREATED_BY — Standard audit columns capturing row creation.
• LAST_UPDATE_LOGIN — Audit column identifying the application login session of the last update.

The surrogate-style uniqueness is enforced by the primary key constraint PA_RESOURCE_FORMAT_RANKS_PK over (RESOURCE_FORMAT_ID, TXN_CLASS_CODE), which is also reflected in the unique index PA_RESOURCE_FORMAT_RANKS_U1. Because the PK is composed of the two foreign keys rather than a generated sequence, the business key and the physical key coincide: one ranking may exist per format per transaction class.

Common Use Cases and Queries

Administrators and technical consultants query this table most often to understand why a given transaction was mapped to a particular resource format, and to verify that ranking rules were seeded correctly after cloning or patching. Typical reporting includes extracting all rankings for a transaction class in priority order:

• Resolving mapping precedence: SELECT resource_format_id, txn_class_code, rank FROM pa_resource_format_ranks WHERE txn_class_code = :class ORDER BY rank;
• Diagnosing missing or duplicated resource assignments by joining ranks against PA_RESOURCE_FORMATS to obtain format names.
• Confirming upgrade or patch impact by diffing RANK values before and after a release, using the audit columns.
• Data reconciliation during migration or multi-org consolidation, verifying that every expected format/class pair exists.

Because the content is system-defined, direct DML is generally discouraged; changes should be delivered through the supported resource-list configuration and mapping functionality.

Related Objects

• PA_RESOURCE_FORMATS — Joined on PA_RESOURCE_FORMAT_RANKS.RESOURCE_FORMAT_ID = PA_RESOURCE_FORMATS.RESOURCE_FORMAT_ID; supplies the format definition.
• PA_SYSTEM_LINKAGES — Joined on PA_RESOURCE_FORMAT_RANKS.TXN_CLASS_CODE = PA_SYSTEM_LINKAGES.TXN_CLASS_CODE; supplies the transaction class meaning.
• PA_RESOURCE_LISTS / resource list assignment tables — Consume the ranking indirectly when building a resource list.
• PA_RESOURCE_FORMAT_RANKS_PK / _U1 — Constraint and unique index enforcing uniqueness.