Search Results $15979 to ksh




The FA_MC_CONVERSION_RATES table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical component of the Fixed Assets (FA) module, specifically designed to support multi-currency conversion functionality. This table stores exchange rates used to convert asset values, depreciation, and other financial data from the functional currency to reporting or secondary currencies. Below is a detailed summary of its structure, purpose, and usage within Oracle EBS.

Purpose and Context

In a multi-org, multi-currency environment, organizations often need to report asset values in currencies other than their functional currency. The FA_MC_CONVERSION_RATES table facilitates this by storing exchange rates required for such conversions. It is tightly integrated with Oracle's Global Accounting Engine (GAE) and supports compliance with international accounting standards like IFRS and GAAP, which may mandate reporting in multiple currencies.

Table Structure

The table consists of key columns that define the conversion rates:
  • CONVERSION_ID: A unique identifier for each conversion rate entry.
  • FROM_CURRENCY: The source currency code (e.g., USD, EUR).
  • TO_CURRENCY: The target currency code for conversion.
  • CONVERSION_TYPE: The rate type (e.g., Corporate, Spot, User-defined).
  • CONVERSION_DATE: The effective date of the exchange rate.
  • CONVERSION_RATE: The actual exchange rate value.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE: Audit columns tracking record creation/modification.

Integration with Fixed Assets

The table is referenced by the Fixed Assets module during:
  • Asset Additions/Adjustments: When assets are acquired or adjusted, their cost is converted to reporting currencies using rates from this table.
  • Depreciation Calculations: Depreciation expenses are recalculated in secondary currencies using stored rates.
  • Financial Reporting: Asset balances and transactions are reported in multiple currencies for statutory or management reporting.

Data Population

Rates can be populated via:
  • Manual Entry: Users input rates directly into the table or through Oracle forms.
  • Automated Feeds: Integration with Oracle Daily Rates or third-party systems for periodic rate updates.
  • Open Interface Tables: Rates can be imported using FA_MC_CONV_RATES_INTERFACE.

Key Considerations

  • Rate Consistency: Rates must align with those in GL_DAILY_RATES to ensure consistency across modules.
  • Historical Rates: The table supports historical rate storage, enabling retrospective reporting.
  • Audit Requirements: Changes to rates may require audit trails for compliance.

Performance and Maintenance

For optimal performance:
  • Indexes on FROM_CURRENCY, TO_CURRENCY, and CONVERSION_DATE are recommended.
  • Purge obsolete rates periodically to maintain efficiency.

Conclusion

The FA_MC_CONVERSION_RATES table is indispensable for multi-currency asset management in Oracle EBS. Its design ensures accurate financial reporting across currencies while integrating seamlessly with core Fixed Assets processes. Proper configuration and maintenance of this table are essential for compliance and operational efficiency in global enterprises.

  • Concurrent Program: FAWIPSTAT 12.2.2

    product: OFA - Assets ,  user_name: FA CIP Statistics for the Central Statistical Office (KSH) (Hungary) ,  description: Shows Fixed Asset CIP Statistics information in a period range. ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAWIPSTAT 12.1.1

    product: OFA - Assets ,  user_name: FA CIP Statistics for the Central Statistical Office (KSH) (Hungary) ,  description: Shows Fixed Asset CIP Statistics information in a period range. ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAS955 12.1.1

    execution_filename: FAS955 ,  product: OFA - Assets ,  user_name: FAS955 ,  description: Budget-to-Actual Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FAS955 12.2.2

    execution_filename: FAS955 ,  product: OFA - Assets ,  user_name: FAS955 ,  description: Budget-to-Actual Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FALPEXPT 12.1.1

    execution_filename: FA_LPITEMS_EXPT_PKG.PAYMENT_ITEMS_TO_AP ,  product: OFA - Assets ,  user_name: FALPEXPT ,  description: Export Lease Payments to Payables ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Table: FA_MC_CONVERSION_RATES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_CONVERSION_RATES,  object_name:FA_MC_CONVERSION_RATES,  status:VALID,  product: OFA - Assets ,  description: Table to store the exchange rate information to convert assets from primary to reporting book ,  implementation_dba_data: FA.FA_MC_CONVERSION_RATES , 

  • Concurrent Program: FAS710 12.2.2

    execution_filename: FAS710 ,  product: OFA - Assets ,  user_name: FAS710 ,  description: Assets Not Assigned To Any Cost Center Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FALPEXPT 12.2.2

    execution_filename: FA_LPITEMS_EXPT_PKG.PAYMENT_ITEMS_TO_AP ,  product: OFA - Assets ,  user_name: FALPEXPT ,  description: Export Lease Payments to Payables ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Table: FA_MC_CONVERSION_RATES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_CONVERSION_RATES,  object_name:FA_MC_CONVERSION_RATES,  status:VALID,  product: OFA - Assets ,  description: Table to store the exchange rate information to convert assets from primary to reporting book ,  implementation_dba_data: FA.FA_MC_CONVERSION_RATES , 

  • Concurrent Program: FAS700 12.2.2

    execution_filename: FAS700 ,  product: OFA - Assets ,  user_name: FAS700 ,  description: Assets Not Assigned To Any Books Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FAS700 12.1.1

    execution_filename: FAS700 ,  product: OFA - Assets ,  user_name: FAS700 ,  description: Assets Not Assigned To Any Books Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FAS710 12.1.1

    execution_filename: FAS710 ,  product: OFA - Assets ,  user_name: FAS710 ,  description: Assets Not Assigned To Any Cost Center Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FAS955_XML 12.2.2

    product: OFA - Assets ,  user_name: Budget-to-Actual Report (XML) ,  description: Budget-to-Actual Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Lookup Type: FA_INS_CATEGORY 12.1.1

    product: OFA - Assets ,  meaning: FA INS CATEGORY ,  description: Insurance Categories , 

  • Concurrent Program: FAS955_XML 12.1.1

    product: OFA - Assets ,  user_name: Budget-to-Actual Report (XML) - Not Supported: Reserved For Future Use ,  description: Budget-to-Actual Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAS700_XML 12.2.2

    product: OFA - Assets ,  user_name: Assets Not Assigned To Any Books Listing (XML) ,  description: Assets Not Assigned To Any Books Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Table: FA_GROUP_DEPRN_DETAIL 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_GROUP_DEPRN_DETAIL,  object_name:FA_GROUP_DEPRN_DETAIL,  status:VALID,  product: OFA - Assets ,  description: Redundant - mirrors FA_DEPRN_DETAIL and exists purely to store information returned by the depreciation process. Would usually store depreciation charged to expense accounts identified in the distribution list of an asset - since group ass ,  implementation_dba_data: FA.FA_GROUP_DEPRN_DETAIL , 

  • Concurrent Program: FAMRCUPG3 12.2.2

    execution_filename: fa_mc_upg_balances_pkg.main_balances ,  product: OFA - Assets ,  user_name: FAMRCUPG3 ,  description: Transfer Balances To General Ledger ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: FAS700_XML 12.1.1

    product: OFA - Assets ,  user_name: Assets Not Assigned To Any Books Listing (XML) - Not Supported: Reserved For Future Use ,  description: Assets Not Assigned To Any Books Listing ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Table: FA_GROUP_DEPRN_RATES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_GROUP_DEPRN_RATES,  object_name:FA_GROUP_DEPRN_RATES,  status:VALID,  product: OFA - Assets ,  description: Contains the depreciation rates to be used when calculating the reserve amount to be transferred with an asset which is being moved out of a group. ,  implementation_dba_data: FA.FA_GROUP_DEPRN_RATES , 

  • Lookup Type: FA_INS_CATEGORY 12.2.2

    product: OFA - Assets ,  meaning: FA INS CATEGORY ,  description: Insurance Categories , 

  • Table: FA_GROUP_DEPRN_RATES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_GROUP_DEPRN_RATES,  object_name:FA_GROUP_DEPRN_RATES,  status:VALID,  product: OFA - Assets ,  description: Contains the depreciation rates to be used when calculating the reserve amount to be transferred with an asset which is being moved out of a group. ,  implementation_dba_data: FA.FA_GROUP_DEPRN_RATES , 

  • Table: FA_GROUP_DEPRN_DETAIL 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_GROUP_DEPRN_DETAIL,  object_name:FA_GROUP_DEPRN_DETAIL,  status:VALID,  product: OFA - Assets ,  description: Redundant - mirrors FA_DEPRN_DETAIL and exists purely to store information returned by the depreciation process. Would usually store depreciation charged to expense accounts identified in the distribution list of an asset - since group ass ,  implementation_dba_data: FA.FA_GROUP_DEPRN_DETAIL , 

  • Concurrent Program: FAMRCUPG3 12.1.1

    execution_filename: fa_mc_upg_balances_pkg.main_balances ,  product: OFA - Assets ,  user_name: FAMRCUPG3 ,  description: Transfer Balances To General Ledger ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Table: FA_MC_CONVERSION_HISTORY 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_CONVERSION_HISTORY,  object_name:FA_MC_CONVERSION_HISTORY,  status:VALID,  product: OFA - Assets ,  description: Table to store the conversion history of primary to reporting books ,  implementation_dba_data: FA.FA_MC_CONVERSION_HISTORY , 

  • Table: FA_MC_CONVERSION_HISTORY 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_CONVERSION_HISTORY,  object_name:FA_MC_CONVERSION_HISTORY,  status:VALID,  product: OFA - Assets ,  description: Table to store the conversion history of primary to reporting books ,  implementation_dba_data: FA.FA_MC_CONVERSION_HISTORY , 

  • Table: FA_MASS_ADDITIONS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASS_ADDITIONS,  object_name:FA_MASS_ADDITIONS,  status:VALID,  product: OFA - Assets ,  description: Information about assets that you want to automatically add to Oracle Assets from another system ,  implementation_dba_data: FA.FA_MASS_ADDITIONS , 

  • Table: FA_MASS_ADDITIONS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASS_ADDITIONS,  object_name:FA_MASS_ADDITIONS,  status:VALID,  product: OFA - Assets ,  description: Information about assets that you want to automatically add to Oracle Assets from another system ,  implementation_dba_data: FA.FA_MASS_ADDITIONS , 

  • Table: FA_PRODUCTION_INTERFACE 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_PRODUCTION_INTERFACE,  object_name:FA_PRODUCTION_INTERFACE,  status:VALID,  product: OFA - Assets ,  description: Production information to be uploaded into Oracle Assets ,  implementation_dba_data: FA.FA_PRODUCTION_INTERFACE , 

  • Table: FA_BOOK_CONTROLS_HISTORY 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOK_CONTROLS_HISTORY,  object_name:FA_BOOK_CONTROLS_HISTORY,  status:VALID,  product: OFA - Assets ,  description: Tracks changes to book setup information in Oracle Assets ,  implementation_dba_data: FA.FA_BOOK_CONTROLS_HISTORY , 

  • Table: FA_PRODUCTION_INTERFACE 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_PRODUCTION_INTERFACE,  object_name:FA_PRODUCTION_INTERFACE,  status:VALID,  product: OFA - Assets ,  description: Production information to be uploaded into Oracle Assets ,  implementation_dba_data: FA.FA_PRODUCTION_INTERFACE , 

  • Table: FA_ITF_IMPAIRMENTS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ITF_IMPAIRMENTS,  object_name:FA_ITF_IMPAIRMENTS,  status:VALID,  product: OFA - Assets ,  description: FA_ITF_IMPAIRMENTS table gets populated for any candidate assets to be impaired per the impairment transaction stored in FA_IMPAIRMENTS table. ,  implementation_dba_data: FA.FA_ITF_IMPAIRMENTS , 

  • Table: FA_EXT_INV_RETIREMENTS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_EXT_INV_RETIREMENTS,  object_name:FA_EXT_INV_RETIREMENTS,  status:VALID,  product: OFA - Assets ,  description: External invoice retirements. Identifies the source line(s) to be retired by a mass external retirement. ,  implementation_dba_data: FA.FA_EXT_INV_RETIREMENTS , 

  • Concurrent Program: FAGLTRN 12.1.1

    product: OFA - Assets ,  user_name: Transfer Journal Entries to GL - Assets ,  description: Report for the Accounting Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Table: FA_BUDGET_INTERFACE 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BUDGET_INTERFACE,  object_name:FA_BUDGET_INTERFACE,  status:VALID,  product: OFA - Assets ,  description: Capital budget information to be uploaded into Oracle Assets ,  implementation_dba_data: FA.FA_BUDGET_INTERFACE , 

  • Table: FA_BOOK_CONTROLS_HISTORY 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOK_CONTROLS_HISTORY,  object_name:FA_BOOK_CONTROLS_HISTORY,  status:VALID,  product: OFA - Assets ,  description: Tracks changes to book setup information in Oracle Assets ,  implementation_dba_data: FA.FA_BOOK_CONTROLS_HISTORY , 

  • Table: FA_PERIOD_MAPS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_PERIOD_MAPS,  object_name:FA_PERIOD_MAPS,  status:VALID,  product: OFA - Assets ,  description: Static information about period mapping; used by the Budget-To-Actual Report ,  implementation_dba_data: FA.FA_PERIOD_MAPS , 

  • Table: FA_EXT_INV_RETIREMENTS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_EXT_INV_RETIREMENTS,  object_name:FA_EXT_INV_RETIREMENTS,  status:VALID,  product: OFA - Assets ,  description: External invoice retirements. Identifies the source line(s) to be retired by a mass external retirement. ,  implementation_dba_data: FA.FA_EXT_INV_RETIREMENTS , 

  • Table: FA_PERIOD_MAPS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_PERIOD_MAPS,  object_name:FA_PERIOD_MAPS,  status:VALID,  product: OFA - Assets ,  description: Static information about period mapping; used by the Budget-To-Actual Report ,  implementation_dba_data: FA.FA_PERIOD_MAPS , 

  • File: OFAProduct_Dependencies.html 12.2.2

    product: OFA - Assets ,  size: 20.323 KBytes ,  file_type: HTML Report ,  description: OFAProduct_Dependencies.html is an html report that documentsexternal dependencies to tables and views in the OFA product. , 

  • Table: FA_GROUP_ASSET_DEFAULT 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_GROUP_ASSET_DEFAULT,  object_name:FA_GROUP_ASSET_DEFAULT,  status:VALID,  product: OFA - Assets ,  description: Defines accounts to be used for a group asset within a particular book. e.g. Expense account, reserve account etc. ,  implementation_dba_data: FA.FA_GROUP_ASSET_DEFAULT , 

  • Table: FA_ITF_IMPAIRMENTS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ITF_IMPAIRMENTS,  object_name:FA_ITF_IMPAIRMENTS,  status:VALID,  product: OFA - Assets ,  description: FA_ITF_IMPAIRMENTS table gets populated for any candidate assets to be impaired per the impairment transaction stored in FA_IMPAIRMENTS table. ,  implementation_dba_data: FA.FA_ITF_IMPAIRMENTS , 

  • Concurrent Program: FAGLTRN 12.2.2

    product: OFA - Assets ,  user_name: Transfer Journal Entries to GL - Assets ,  description: Report for the Accounting Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Table: FA_DEPRN_TAX_ENTITIES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_DEPRN_TAX_ENTITIES,  object_name:FA_DEPRN_TAX_ENTITIES,  status:VALID,  product: OFA - Assets ,  description: FA_DEPRN_TAX_ENTITIES table is used to store company-level information required by Japanese Depreciable Assets Tax Reports. ,  implementation_dba_data: FA.FA_DEPRN_TAX_ENTITIES , 

  • Table: FA_INV_INTERFACE 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_INV_INTERFACE,  object_name:FA_INV_INTERFACE,  status:VALID,  product: OFA - Assets ,  description: Open Interface table to Physical Inventory ,  implementation_dba_data: FA.FA_INV_INTERFACE , 

  • Table: FA_BUDGET_INTERFACE 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BUDGET_INTERFACE,  object_name:FA_BUDGET_INTERFACE,  status:VALID,  product: OFA - Assets ,  description: Capital budget information to be uploaded into Oracle Assets ,  implementation_dba_data: FA.FA_BUDGET_INTERFACE , 

  • Table: FA_TRANSACTION_INTERFACE 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_TRANSACTION_INTERFACE,  object_name:FA_TRANSACTION_INTERFACE,  status:VALID,  product: OFA - Assets ,  description: Interface table for uploading transactions to Assets ,  implementation_dba_data: FA.FA_TRANSACTION_INTERFACE , 

  • Table: FA_SUPER_GROUP_RULES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_SUPER_GROUP_RULES,  object_name:FA_SUPER_GROUP_RULES,  status:VALID,  product: OFA - Assets ,  description: Defines the depreciation rules to be followed when depreciating asset groups that are members of the super group. ,  implementation_dba_data: FA.FA_SUPER_GROUP_RULES , 

  • Table: FA_INV_INTERFACE 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_INV_INTERFACE,  object_name:FA_INV_INTERFACE,  status:VALID,  product: OFA - Assets ,  description: Open Interface table to Physical Inventory ,  implementation_dba_data: FA.FA_INV_INTERFACE , 

  • Table: FA_DEPRN_TAX_AUTHORITIES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_DEPRN_TAX_AUTHORITIES,  object_name:FA_DEPRN_TAX_AUTHORITIES,  status:VALID,  product: OFA - Assets ,  description: FA_DEPRN_TAX_AUTHORITIES table is used to store tax-authority-level information required by Japanese Depreciable Assets Tax Reports. ,  implementation_dba_data: FA.FA_DEPRN_TAX_AUTHORITIES ,