Search Results pa_fp_txn_currencies




Overview
Explore in AI Chat

Overview

The PA_FP_TXN_CURRENCIES table is a core data structure within the Oracle E-Business Suite Projects (PA) module, specifically for the Financial Planning and Budgeting functionality in releases 12.1.1 and 12.2.2. It serves as a master repository defining the permissible transaction currencies for a project's financial plan. Its primary role is to enforce and maintain the set of currencies in which project costs, revenues, and commitments can be planned and budgeted. By storing this relationship, the table ensures that financial planning transactions adhere to the predefined currency rules established for a specific project, financial plan type, and version, thereby maintaining data integrity and supporting multi-currency project management.

Key Information Stored

The table's structure centers on linking a project's financial planning context to specific currency codes. The primary key, FP_TXN_CURRENCY_ID, uniquely identifies each record. The most critical foreign key columns define the planning context: PROJECT_ID links to PA_PROJECTS_ALL, FIN_PLAN_TYPE_ID to PA_FIN_PLAN_TYPES_B, and FIN_PLAN_VERSION_ID to PA_BUDGET_VERSIONS. The PROJ_FP_OPTIONS_ID provides a link to the project's financial planning options. The core data point is the TXN_CURRENCY_CODE, which stores the code (from FND_CURRENCIES) of a currency approved for planning transactions within the defined context. This setup allows a single project to have different sets of plannable currencies for different plan types or versions.

Common Use Cases and Queries

A primary use case is validating available currencies during the creation of budget lines or forecast entries within a financial plan. System processes query this table to ensure the entered transaction currency is valid. For reporting and analysis, administrators often query it to audit or list the currency setup for projects. A typical query to retrieve all plannable currencies for a specific project and plan version would be:

  • SELECT pfptc.txn_currency_code, fc.name
  • FROM pa_fp_txn_currencies pfptc,
  • fnd_currencies fc
  • WHERE pfptc.project_id = :p_project_id
  • AND pfptc.fin_plan_version_id = :p_version_id
  • AND pfptc.txn_currency_code = fc.currency_code;

Another common scenario involves troubleshooting, where checking for the existence of a currency record is a first step if users encounter errors stating a currency is not plannable for a project.

Related Objects

As indicated by its foreign keys, PA_FP_TXN_CURRENCIES has strong dependencies on several fundamental PA tables. It is a child table to PA_PROJECTS_ALL (projects), PA_PROJ_FP_OPTIONS (planning options), PA_FIN_PLAN_TYPES_B (plan types), and PA_BUDGET_VERSIONS (budget/plan versions). Its relationship with FND_CURRENCIES validates the currency code against the application's master list. This table is referenced by financial planning transaction tables (e.g., PA_BUDGET_LINES, PA_FP_COMMITMENT_TXNS) to validate currency codes. It is integral to the financial planning engine and is typically maintained via the Oracle Projects application interface rather than direct DML.

  • Table: PA_FP_TXN_CURRENCIES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_FP_TXN_CURRENCIES,  object_name:PA_FP_TXN_CURRENCIES,  status:VALID,  product: PA - Projects ,  description: This table stores the plannable transaction currencies for a project. ,  implementation_dba_data: PA.PA_FP_TXN_CURRENCIES , 

  • Table: PA_FP_TXN_CURRENCIES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_FP_TXN_CURRENCIES,  object_name:PA_FP_TXN_CURRENCIES,  status:VALID,  product: PA - Projects ,  description: This table stores the plannable transaction currencies for a project. ,  implementation_dba_data: PA.PA_FP_TXN_CURRENCIES , 

  • Table: PA_FIN_PLAN_TYPES_B 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_FIN_PLAN_TYPES_B,  object_name:PA_FIN_PLAN_TYPES_B,  status:VALID,  product: PA - Projects ,  description: This table stores the various plan types for financial plans. ,  implementation_dba_data: PA.PA_FIN_PLAN_TYPES_B , 

  • Table: PA_FIN_PLAN_TYPES_B 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_FIN_PLAN_TYPES_B,  object_name:PA_FIN_PLAN_TYPES_B,  status:VALID,  product: PA - Projects ,  description: This table stores the various plan types for financial plans. ,  implementation_dba_data: PA.PA_FIN_PLAN_TYPES_B , 

  • Table: PA_PROJ_FP_OPTIONS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJ_FP_OPTIONS,  object_name:PA_PROJ_FP_OPTIONS,  status:VALID,  product: PA - Projects ,  description: This table stores the default financial planning options for a project, plan type or plan version. ,  implementation_dba_data: PA.PA_PROJ_FP_OPTIONS , 

  • Table: PA_PROJ_FP_OPTIONS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJ_FP_OPTIONS,  object_name:PA_PROJ_FP_OPTIONS,  status:VALID,  product: PA - Projects ,  description: This table stores the default financial planning options for a project, plan type or plan version. ,  implementation_dba_data: PA.PA_PROJ_FP_OPTIONS , 

  • Table: PA_BUDGET_VERSIONS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BUDGET_VERSIONS,  object_name:PA_BUDGET_VERSIONS,  status:VALID,  product: PA - Projects ,  description: Versions of project budgets ,  implementation_dba_data: PA.PA_BUDGET_VERSIONS , 

  • Table: PA_BUDGET_VERSIONS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BUDGET_VERSIONS,  object_name:PA_BUDGET_VERSIONS,  status:VALID,  product: PA - Projects ,  description: Versions of project budgets ,  implementation_dba_data: PA.PA_BUDGET_VERSIONS , 

  • View: PA_FP_WEBADI_CONTENTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WEBADI_CONTENTS_V,  object_name:PA_FP_WEBADI_CONTENTS_V,  status:VALID,  product: PA - Projects ,  description: This view is used for data to be downloaded to excel sheet for Financial Planning. ,  implementation_dba_data: APPS.PA_FP_WEBADI_CONTENTS_V , 

  • View: PA_FP_WEBADI_CONTENTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WEBADI_CONTENTS_V,  object_name:PA_FP_WEBADI_CONTENTS_V,  status:VALID,  product: PA - Projects ,  description: This view is used for data to be downloaded to excel sheet for Financial Planning. ,  implementation_dba_data: APPS.PA_FP_WEBADI_CONTENTS_V , 

  • Table: PA_PROJECTS_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL , 

  • Table: PA_PROJECTS_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL , 

  • View: PA_FP_WEBADI_NON_PERIODIC_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WEBADI_NON_PERIODIC_V,  object_name:PA_FP_WEBADI_NON_PERIODIC_V,  status:VALID,  product: PA - Projects ,  description: This view is used in Financial Planning to download non-periodic budget/forecast data into Excel Spreadsheet. ,  implementation_dba_data: APPS.PA_FP_WEBADI_NON_PERIODIC_V , 

  • View: PA_FP_WEBADI_NON_PERIODIC_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_FP_WEBADI_NON_PERIODIC_V,  object_name:PA_FP_WEBADI_NON_PERIODIC_V,  status:VALID,  product: PA - Projects ,  description: This view is used in Financial Planning to download non-periodic budget/forecast data into Excel Spreadsheet. ,  implementation_dba_data: APPS.PA_FP_WEBADI_NON_PERIODIC_V ,