Additional Processes
In addition to the basic business processes, you will use two other processes:
Currency Conversion application engine (to convert currencies).
Audit Utility (to audit your setup).
Currency Conversion Engine
Data is migrated into PeopleSoft EPM Warehouse from various sources, with amounts denominated in different currencies. Prior to running your PeopleSoft Financial Services Industry applications, you may want to use the Currency Conversion application engine to convert currency amounts in the data warehouse tables from/to base currency amounts to/from transaction amounts. These conversions can occur at any time, using user-defined conversion parameters.
You may need to run the Currency Conversion application engine at three points:
Prior to running PeopleSoft Financial Services Industry applications in the instrument tables (FI_INSTR_F00, FI_IBAL_R00, and FI_ISTATUS), where the applications access their balance amounts for processing.
After running PeopleSoft Financial Services Industry applications in the PF (performance) Journal table (PF_JRNL), which is the central point through which all PeopleSoft Financial Services Industry application output data must pass to get to the PF Ledger table.
This converts:
Break fund fixed charges in base currencies, needing conversion to transaction currencies (in the FI_IBFCHRG_R00 table).
Break fund economic loss calculations that are in transaction currencies only, because they are based on cash flows that use transaction currencies.
These need to be converted to the base currencies (in the FI_IBFCHRG_R00 table).
Fixed funds transfer pricing adjustments in base amounts only, needing conversion to transaction currencies (in the FTP_CALC_IN_F00, FTP_CALC_AC_F00, and FTP_CALC_PS_F00 tables).
When you run PeopleSoft Funds Transfer Pricing on forecasted pools, conversion may need to occur after running the Portfolio Forecast application engine, which populates the FI_POOLBAL_R00 table with pool amounts stated in transaction currency, if the forecast which generated the pools was currency-specific.
Audit Utility
The Audit Utility identifies metadata errors in the PeopleSoft Financial Services Industry environment and applications. The Audit Utility does not need to be set up in a jobstream and can be run at any time. Any problems identified by the Audit Utility may require assistance from a software developer or data warehouse administrator. The information provided typically helps a systems person resolve issues.
You can run the Audit Utility for any or all PeopleSoft Financial Services Industry applications. For each of your selections, the Audit Utility checks that there are no problems with the business rules.