Search Results pa_res_formats_b

Overview

The PA_RES_FORMATS_B table is a core setup and reference table within the Oracle E-Business Suite Projects module. It serves as the master repository for all valid resource formats, which are essential for planning and managing project resources. A resource format defines the structure for how a resource's time is measured and reported, such as by hours, days, or weeks. This table's primary role is to provide a standardized list of these formats, ensuring consistency in resource planning, assignment, and reporting across all projects. It is a foundational object that supports the configuration of resource classes and types, and its definitions are referenced in key project setup and transaction tables.

Key Information Stored

The table's primary key is the unique identifier, RES_FORMAT_ID. Each record is further defined by its relationships to other resource setup entities through foreign key columns, primarily RESOURCE_CLASS_ID and RES_TYPE_ID, which link to the PA_RESOURCE_CLASSES_B and PA_RES_TYPES_B tables, respectively. While the provided metadata does not list all descriptive columns, a typical implementation includes columns for controlling the format's precision, unit of measure, and active status. The corresponding translation table, PA_RES_FORMATS_TL, stores the language-specific name and description for each RES_FORMAT_ID, enabling multilingual support.

Common Use Cases and Queries

This table is central to queries involving resource planning setup and validation. A common use case is generating a list of all active resource formats available for a specific resource class or type during project definition. For instance, when setting up a project's default planning resource format, the application validates the selected value against this table. Administrators may query it to audit setup or troubleshoot issues with resource assignments. A typical reporting query would join the base table with its translation table to retrieve meaningful names:

• SELECT b.RES_FORMAT_ID, tl.NAME, b.RESOURCE_CLASS_ID FROM PA_RES_FORMATS_B b, PA_RES_FORMATS_TL tl WHERE b.RES_FORMAT_ID = tl.RES_FORMAT_ID AND tl.LANGUAGE = USERENV('LANG');

Another critical use is validating data integrity in transactional data, ensuring that resource assignments reference a valid and currently active resource format.

Related Objects

PA_RES_FORMATS_B has defined relationships with several key objects in the Projects schema, as documented by its foreign key constraints. It is a parent table referenced by transactional and setup tables:

• PA_RESOURCE_CLASSES_B & PA_RES_TYPES_B: These are parent tables. The RESOURCE_CLASS_ID and RES_TYPE_ID in PA_RES_FORMATS_B reference them, defining the class and type for which the format is valid.
• PA_PLAN_RL_FORMATS: References RES_FORMAT_ID, linking resource formats to specific planning resource lists.
• PA_PROJECTS_ALL: Referenced twice for project-level defaults via the PROJ_REQ_RES_FORMAT_ID and PROJ_ASGMT_RES_FORMAT_ID columns, which define the default format for requested and assigned resources on a project.
• PA_RES_FORMATS_TL: The dependent translation table where RES_FORMAT_ID is the foreign key to the base table's primary key.