Search Results pa_fund_mrc_upg_excep




Overview
Explore in AI Chat

Overview

The PA_FUND_MRC_UPG_EXCEP table is a specialized technical table within the Oracle E-Business Suite (EBS) Projects (PA) module. Its primary role is to act as a log or staging area for recording exceptions encountered during a specific system process: the upgrade of funding data for Multiple Reporting Currencies (MRC). MRC functionality allows organizations to maintain and report financial data in more than one functional currency. This table is critical for administrators and technical consultants during or following an upgrade to EBS releases 12.1.1 or 12.2.2, as it captures errors that prevent the successful migration of project funding information into the MRC reporting structures, ensuring data integrity and providing a clear audit trail of upgrade issues.

Key Information Stored

While the full column list is not detailed in the provided metadata, the foreign key relationships and the table's purpose define its core data elements. It stores records for each funding transaction that failed to upgrade correctly into MRC. Key columns logically include a unique exception identifier, references to the source data (PROJECT_FUNDING_ID linking to PA_PROJECT_FUNDINGS), and the accounting context (SET_OF_BOOKS_ID linking to GL_SETS_OF_BOOKS_11I). Crucially, it will contain columns describing the nature of the exception, such as an error code or message, a timestamp, and potentially the specific batch or upgrade run identifier. This structure allows for systematic identification and reconciliation of problematic funding records post-upgrade.

Common Use Cases and Queries

The primary use case is post-upgrade diagnostics and cleanup. After running an MRC upgrade for Projects funding data, administrators must query this table to assess the upgrade's success and resolve any errors. Common SQL patterns involve joining to related project tables to get meaningful descriptive information for troubleshooting.

  • Identifying Exceptions: SELECT * FROM pa.pa_fund_mrc_upg_excep WHERE set_of_books_id = :sob_id;
  • Reporting Exceptions with Project Details: A query joining to PA_PROJECT_FUNDINGS and PA_PROJECTS_ALL to list failed funding records by project name and number.
  • Cleanup and Re-processing: Once the root cause of an exception is fixed (e.g., a data correction in the source funding table), the corresponding record in this exception table is typically deleted or marked as resolved, often as part of a scripted re-submission process for the upgrade.

Related Objects

This table sits at the intersection of Projects and General Ledger MRC functionality. Its key relationships, as documented, are:

  • PA_PROJECT_FUNDINGS: This is the primary source table for the funding data being upgraded. The PROJECT_FUNDING_ID foreign key links each exception directly to the specific funding record that caused the error.
  • GL_SETS_OF_BOOKS_11I: The SET_OF_BOOKS_ID foreign key ties the exception to the specific ledger (set of books) context, which is central to MRC processing.

It is also intrinsically related to the underlying MRC upgrade engine and the suite of PA_MRC_* tables that store the converted multi-currency project data. The table is typically accessed via custom diagnostic scripts rather than standard application user interfaces.

  • Table: PA_FUND_MRC_UPG_EXCEP 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_FUND_MRC_UPG_EXCEP,  object_name:PA_FUND_MRC_UPG_EXCEP,  status:VALID,  product: PA - Projects ,  description: The PA_FUND_MRC_UPG_EXCEP table maintains all the exceptions got during funding up gradation in MRC. ,  implementation_dba_data: PA.PA_FUND_MRC_UPG_EXCEP , 

  • Table: PA_FUND_MRC_UPG_EXCEP 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_FUND_MRC_UPG_EXCEP,  object_name:PA_FUND_MRC_UPG_EXCEP,  status:VALID,  product: PA - Projects ,  description: The PA_FUND_MRC_UPG_EXCEP table maintains all the exceptions got during funding up gradation in MRC. ,  implementation_dba_data: PA.PA_FUND_MRC_UPG_EXCEP , 

  • Table: PA_PROJECT_FUNDINGS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECT_FUNDINGS,  object_name:PA_PROJECT_FUNDINGS,  status:VALID,  product: PA - Projects ,  description: Incremental amounts of allocated funds from agreements to projects and tasks ,  implementation_dba_data: PA.PA_PROJECT_FUNDINGS , 

  • Table: PA_PROJECT_FUNDINGS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECT_FUNDINGS,  object_name:PA_PROJECT_FUNDINGS,  status:VALID,  product: PA - Projects ,  description: Incremental amounts of allocated funds from agreements to projects and tasks ,  implementation_dba_data: PA.PA_PROJECT_FUNDINGS ,