Search Results prc

The PA_PRC_CONVERSION_RULES table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Project Accounting (PA) module, specifically designed to manage and enforce currency conversion rules for project-related financial transactions. This table plays a pivotal role in ensuring accurate and consistent currency conversions across multi-currency projects, enabling organizations to comply with accounting standards and financial reporting requirements. Below is a detailed breakdown of its purpose, structure, and functionality.

Purpose and Context

In Oracle EBS, the Project Accounting module handles financial transactions across projects, tasks, and activities, often involving multiple currencies. The PA_PRC_CONVERSION_RULES table stores predefined rules that dictate how currency conversions should be performed for project-related amounts, such as revenue, costs, and budgets. These rules ensure that conversions adhere to corporate policies, accounting standards (e.g., GAAP, IFRS), and regulatory requirements. The table is tightly integrated with other PA and General Ledger (GL) tables, such as PA_PROJECTS_ALL, GL_PERIODS, and GL_DAILY_RATES, to facilitate seamless currency conversions.

Key Columns and Structure

The PA_PRC_CONVERSION_RULES table includes the following key columns:

CONVERSION_RULE_ID: A unique identifier for each conversion rule.
PROJECT_ID: Links the rule to a specific project in PA_PROJECTS_ALL.
FROM_CURRENCY and TO_CURRENCY: Define the source and target currencies for conversion.
CONVERSION_TYPE: Specifies the conversion method (e.g., Spot, Corporate, User-defined).
RATE_TYPE: References the rate type from GL_DAILY_RATES (e.g., 'Corporate', 'Spot').
START_DATE_ACTIVE and END_DATE_ACTIVE: Define the rule's validity period.
ENABLED_FLAG: Indicates whether the rule is active or inactive.
CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY: Standard Oracle audit columns.

Functionality and Integration

The table's primary function is to provide a centralized repository for currency conversion rules, which are applied during:

Project Invoicing: Converting revenue amounts from project currency to functional or reporting currency.
Cost Processing: Translating cost transactions (e.g., labor, expenses) into the project's functional currency.
Budgeting and Forecasting: Ensuring consistency in budget amounts across currencies.
Financial Reporting: Supporting multi-currency reports in Oracle Financial Analyzer or OTBI.

The rules are enforced through Oracle's currency conversion engine, which leverages the GL_DAILY_RATES table for exchange rates. Integration with the GL module ensures that converted amounts align with the organization's ledger currency and accounting periods.

Customization and Extensions

Organizations can extend the functionality of PA_PRC_CONVERSION_RULES by:

Creating custom conversion types via Oracle's Descriptive Flexfields (DFFs).
Using APIs (e.g., PA_CURRENCY_PUB) to programmatically manage rules.
Integrating with third-party rate providers for real-time exchange rates.

Conclusion

The PA_PRC_CONVERSION_RULES table is a cornerstone of Oracle EBS Project Accounting, ensuring accurate and auditable currency conversions. Its structured design, integration with core modules, and flexibility for customization make it indispensable for multinational organizations managing multi-currency projects. Proper configuration and maintenance of this table are essential for financial compliance and operational efficiency.

Lookup Type: PA_PRC_BUDGET_TYPES 12.2.2
product: PA - Projects , meaning: Pa Prc Budget Types , description: Budget Type Codes ,
Concurrent Program: PABISUMS 12.1.1
execution_filename: pa_bis_summary.summarize_bis , product: PA - Projects , user_name: PABISUMS , description: PRC: Refresh OBIS Summary Amounts , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PAPAYIMP 12.2.2
execution_filename: PA_PAY_INTERFACE.INTERFACE_PAY , product: PA - Projects , user_name: PAPAYEXE , description: PRC: Process Payroll Actuals Executable , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: PA_PRC_BUDGET_TYPES 12.1.1
product: PA - Projects , meaning: Pa Prc Budget Types , description: Budget Type Codes ,
Concurrent Program: PABISUMS 12.2.2
execution_filename: pa_bis_summary.summarize_bis , product: PA - Projects , user_name: PABISUMS , description: PRC: Refresh OBIS Summary Amounts , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Lookup Type: CC_EXCP 12.2.2
product: PA - Projects , meaning: Cross Charge Accounting Exceptions , description: Cross Charge Accounting Exceptions ,
Concurrent Program: PACCINTG_XML 12.1.1
product: PA - Projects , user_name: PRC: Generate Capitalized Interest Transactions (XML) , description: PRC: Generate Capitalized Interest Transactions , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: OKEDPDRF 12.1.1
product: PA - Projects , user_name: PRC: Relieve Project Deliverable Demand , description: PRC: Relieve Project Deliverable Demand , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PACCINTG_XML 12.2.2
product: PA - Projects , user_name: PRC: Generate Capitalized Interest Transactions (XML) , description: PRC: Generate Capitalized Interest Transactions , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PACCINTG 12.2.2
execution_filename: PACCINTG , product: PA - Projects , user_name: PACCINTG , description: Generate Capitalized Interest , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: PAPWPRI 12.2.2
execution_filename: PA_PWP_INVOICE_REL.Release_Invoice , product: PA - Projects , user_name: PAPWPRIEX , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PAXCCBLR 12.2.2
execution_filename: PAXCCBLR , product: PA - Projects , user_name: PAXCCBLR , description: Borrowed and Lent Amounts Distribution , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: OKEDPDRF 12.2.2
product: PA - Projects , user_name: PRC: Relieve Project Deliverable Demand , description: PRC: Relieve Project Deliverable Demand , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PAPAYEXC 12.2.2
product: PA - Projects , user_name: PRC: Process Payroll Actuals Exception Report , description: PRC: Process Payroll Actuals Exception Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PARRGLB_CUT_OFF_DATE 12.1.1
execution_filename: pa_rep_util_setup.set_flag_cut_off_records , product: PA - Projects , user_name: PARRGLB_CUT_OFF_DATE , description: PA: Set Cut Off Flag , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PAINIACT 12.2.2
execution_filename: PA_ACTIONS_PUB.RUN_ACTION_CONC_PROCESS , product: PA - Projects , user_name: Initiate Project Deliverable Actions , description: Initiate Project Deliverable Actions , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PARRSAVL 12.2.2
execution_filename: PA_RESOURCE_PVT.Refresh_res_availability , product: PA - Projects , user_name: PARRSAVL , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PAINIACT 12.1.1
execution_filename: PA_ACTIONS_PUB.RUN_ACTION_CONC_PROCESS , product: PA - Projects , user_name: Initiate Project Deliverable Actions , description: Initiate Project Deliverable Actions , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PAXCCBLR 12.1.1
execution_filename: PAXCCBLR , product: PA - Projects , user_name: PAXCCBLR , description: Borrowed and Lent Amounts Distribution , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: PAXICGNS 12.1.1
execution_filename: PAXICGNS , product: PA - Projects , user_name: PAXICGNS , description: Intercompany Invoice Generation report for a Single Project , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: PACCINTG 12.1.1
execution_filename: PACCINTG , product: PA - Projects , user_name: PACCINTG , description: Generate Capitalized Interest , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: PAPWPRI 12.1.1
execution_filename: PA_PWP_INVOICE_REL.Release_Invoice , product: PA - Projects , user_name: PAPWPRIEX , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PAXICGNR 12.1.1
execution_filename: PAXICGNR , product: PA - Projects , user_name: PAXICGNR , description: Intercompany Invoice Generation report for a Range Project , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: PARRSAVL 12.1.1
execution_filename: PA_RESOURCE_PVT.Refresh_res_availability , product: PA - Projects , user_name: PARRSAVL , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PACCBL 12.1.1
execution_filename: PACCBL , product: PA - Projects , user_name: PACCBL , description: PRC: Distribute Borrowed and Lent Amounts , argument_method: Database fetch , enabled: Yes , execution_method: Spawned ,
Concurrent Program: PACCBL 12.2.2
execution_filename: PACCBL , product: PA - Projects , user_name: PACCBL , description: PRC: Distribute Borrowed and Lent Amounts , argument_method: Database fetch , enabled: Yes , execution_method: Spawned ,
Concurrent Program: PARRGLB_CUT_OFF_DATE 12.2.2
execution_filename: pa_rep_util_setup.set_flag_cut_off_records , product: PA - Projects , user_name: PARRGLB_CUT_OFF_DATE , description: PA: Set Cut Off Flag , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PAXICGNR 12.2.2
execution_filename: PAXICGNR , product: PA - Projects , user_name: PAXICGNR , description: Intercompany Invoice Generation report for a Range Project , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: PAXICGNS 12.2.2
execution_filename: PAXICGNS , product: PA - Projects , user_name: PAXICGNS , description: Intercompany Invoice Generation report for a Single Project , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: COST_EXCP 12.2.2
product: PA - Projects , meaning: Costing Exceptions , description: Costing Exceptions ,
Lookup Type: REV_EXCP 12.2.2
product: PA - Projects , meaning: Revenue Exceptions , description: Revenue Exceptions ,
Table: PA_PRC_CONVERSION_RULES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PRC_CONVERSION_RULES, object_name:PA_PRC_CONVERSION_RULES, status:VALID, product: PA - Projects , description: PA_PRC_CONVERSION_RULES is the table for PRC feature , implementation_dba_data: PA.PA_PRC_CONVERSION_RULES ,
Concurrent Program: PAPERACTRULES_XML 12.2.2
product: PA - Projects , user_name: PRC: Perform Action Rules (XML) , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PAXTRTRX_XML 12.2.2
product: PA - Projects , user_name: PRC: Transaction Import (XML) , description: Transaction Import , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PAXTRTRX_XML 12.1.1
product: PA - Projects , user_name: PRC: Transaction Import (XML) , description: Transaction Import , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PARCPRJR_XML 12.1.1
product: PA - Projects , user_name: PRC: Maintain Project Resources (XML) , description: Maintain Project Resources , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PAXALGAT_XML 12.1.1
product: PA - Projects , user_name: PRC: Generate Allocations Transactions (XML) , description: Generate Allocations Transactions , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PARCPRJR_XML 12.2.2
product: PA - Projects , user_name: PRC: Maintain Project Resources (XML) , description: Maintain Project Resources , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Table: PA_PRC_ASSIGNMENTS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PRC_ASSIGNMENTS, object_name:PA_PRC_ASSIGNMENTS, status:VALID, product: PA - Projects , description: PA_PRC_ASSIGNMENTS is the table store PRC conversion rules by project , implementation_dba_data: PA.PA_PRC_ASSIGNMENTS ,
Table: PA_PRC_CONVERSION_RULES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PRC_CONVERSION_RULES, object_name:PA_PRC_CONVERSION_RULES, status:VALID, product: PA - Projects , description: PA_PRC_CONVERSION_RULES is the table for PRC feature , implementation_dba_data: PA.PA_PRC_CONVERSION_RULES ,
Concurrent Program: PAXARPVD_XML 12.1.1
product: PA - Projects , user_name: ADM: Validate Purge Batches (XML) , description: PRC: Validate Purge Batches , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PAXARPVD_XML 12.2.2
product: PA - Projects , user_name: ADM: Validate Purge Batches (XML) , description: PRC: Validate Purge Batches , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: FNDRSSUB740 12.2.2
product: PA - Projects , user_name: Request Set PRC: Generate Utilization , description: Generate Utilization , argument_method: Database fetch , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PAACCPB 12.2.2
product: PA - Projects , user_name: PRC: Create Accounting - OLD -- Do not use , description: Create Accounting Program , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: PAXACRTA_XML 12.2.2
product: PA - Projects , user_name: PRC: Refresh Transaction Summary Amounts (XML) , description: Refresh Transaction Summary Amounts , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PAXCPGAL_XML 12.2.2
product: PA - Projects , user_name: PRC: Generate Asset Lines for a Range of Projects (XML) , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PAXALRAT_XML 12.2.2
product: PA - Projects , user_name: PRC: Release Allocations Transactions (XML) , description: Release Allocations Transactions , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PAXACMPT_XML 12.2.2
product: PA - Projects , user_name: PRC: Update Project Summary Amounts (XML) , description: Update Project Summary Amounts , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PAXACRPT_XML 12.2.2
product: PA - Projects , user_name: PRC: Refresh Project Summary Amounts (XML) , description: Refresh Project Summary Amounts , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Table: PA_PRC_ASSIGNMENTS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PRC_ASSIGNMENTS, object_name:PA_PRC_ASSIGNMENTS, status:VALID, product: PA - Projects , description: PA_PRC_ASSIGNMENTS is the table store PRC conversion rules by project , implementation_dba_data: PA.PA_PRC_ASSIGNMENTS ,