Search Results pa_parameters




Overview
Explore in AI Chat

Overview

The PA_PARAMETERS table is a core reference table within the Oracle E-Business Suite Projects (PA) module. It serves as a repository for system-defined variables that are integral to the AutoAccounting engine. AutoAccounting is a critical financial feature that automatically determines the accounting flexfield combinations (e.g., account numbers) for project-related transactions, such as revenue, cost, and invoice amounts, based on predefined rules and functions. The parameters stored in this table act as the fundamental building blocks or tokens used within those rules and functions, enabling dynamic and configurable account derivation.

Key Information Stored

The table's primary purpose is to define and catalog each available parameter. Its key column is the PARAMETER_ID, which serves as the unique system identifier and primary key. While the provided metadata does not list all columns, typical columns in such a reference table would include a PARAMETER_NAME (a short code or key) and a DESCRIPTION explaining the parameter's purpose. These parameters represent specific pieces of data from the transaction or project context, such as Project ID, Task ID, Expenditure Type, Employee Organization, Customer ID, or Revenue Category. The table essentially provides a lookup of all valid variables that can be referenced when constructing AutoAccounting logic.

Common Use Cases and Queries

The primary use case is the configuration and troubleshooting of AutoAccounting setups. Functional consultants define rules in the PA_RULES table that utilize these parameters to map business conditions to specific accounting segments. Common queries involve listing all available parameters or examining which parameters are used in specific accounting functions or rules.

  • Listing All System Parameters: SELECT parameter_id, parameter_name, description FROM pa.pa_parameters ORDER BY parameter_name;
  • Finding Rules Using a Specific Parameter: SELECT r.rule_name FROM pa.pa_rules r WHERE r.key_parameter_id = (SELECT parameter_id FROM pa.pa_parameters WHERE parameter_name = 'PROJECT_ID');
  • Reporting on Parameter Usage: Joining to related tables like PA_FUNCTION_PARAMETERS or PA_RULE_PARAMETERS to see where each parameter is actively deployed within the AutoAccounting framework.

Related Objects

As indicated by the foreign key relationships, PA_PARAMETERS is centrally linked to the core AutoAccounting setup tables. The PA_RULES table references it via KEY_PARAMETER_ID to define the primary context for a rule. The PA_FUNCTION_PARAMETERS and PA_RULE_PARAMETERS tables reference it to specify which parameters are required or used by specific AutoAccounting functions and rule details, respectively. Direct modification of this table is strongly discouraged; parameters are typically defined and maintained by the application seed data and setup processes. Understanding its relationship to these configuration tables is essential for diagnosing account generation issues.

  • Table: PA_PARAMETERS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PARAMETERS,  object_name:PA_PARAMETERS,  status:VALID,  product: PA - Projects ,  description: System-defined variables for use with AutoAccounting functions or rules ,  implementation_dba_data: PA.PA_PARAMETERS , 

  • Table: PA_PARAMETERS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PARAMETERS,  object_name:PA_PARAMETERS,  status:VALID,  product: PA - Projects ,  description: System-defined variables for use with AutoAccounting functions or rules ,  implementation_dba_data: PA.PA_PARAMETERS , 

  • Table: PA_FUNCTION_PARAMETERS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_FUNCTION_PARAMETERS,  object_name:PA_FUNCTION_PARAMETERS,  status:VALID,  product: PA - Projects ,  description: System-defined parameters available as input values for AutoAccounting functions ,  implementation_dba_data: PA.PA_FUNCTION_PARAMETERS , 

  • Table: PA_RULES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RULES,  object_name:PA_RULES,  status:VALID,  product: PA - Projects ,  description: Implementation-defined formulas for deriving Accounting Flexfield segment values using AutoAccounting ,  implementation_dba_data: PA.PA_RULES , 

  • Table: PA_RULE_PARAMETERS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RULE_PARAMETERS,  object_name:PA_RULE_PARAMETERS,  status:VALID,  product: PA - Projects ,  description: Parameters used by AutoAccounting rules that use SQL statements ,  implementation_dba_data: PA.PA_RULE_PARAMETERS , 

  • Table: PA_RULE_PARAMETERS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RULE_PARAMETERS,  object_name:PA_RULE_PARAMETERS,  status:VALID,  product: PA - Projects ,  description: Parameters used by AutoAccounting rules that use SQL statements ,  implementation_dba_data: PA.PA_RULE_PARAMETERS , 

  • Table: PA_FUNCTION_PARAMETERS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_FUNCTION_PARAMETERS,  object_name:PA_FUNCTION_PARAMETERS,  status:VALID,  product: PA - Projects ,  description: System-defined parameters available as input values for AutoAccounting functions ,  implementation_dba_data: PA.PA_FUNCTION_PARAMETERS , 

  • Table: PA_RULES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RULES,  object_name:PA_RULES,  status:VALID,  product: PA - Projects ,  description: Implementation-defined formulas for deriving Accounting Flexfield segment values using AutoAccounting ,  implementation_dba_data: PA.PA_RULES ,