B.5 Configure FTP Model Dimension from PCD
To configure the FTP Model Dimension from PCD, follow these steps:
- Navigate to the Member screen and configure the FTP Model Dimension.
- The list of Standard Process can be selected using the DIMENSION Management Member screen. This allows user to map a Standard Process to a product.
- Click Add and configure the Model Definition by selecting the
appropriate product values in the FTP PRODUCT field and PRODUCT CODE along with the
UDFs.
Note:
The FTP_UDF columns should be configured in the ofsaaws.properties file as follows:columns_mapping=customerType~CUSTOMER_TYPE;bookType~BOOK_TYPE
Here, you can provide any logical name for FTP_UDF. However, the logical name given for each FTP_UDF should be mapped to the physical column in the fsi_pm_generated_instrmts
Additional columns are not processed if not configured in the
ofsaaws.properties
file. - Create a Profitability curve with Transfer Price Driver as Real Time Calculation enabled. Submit and approve the Curve.
- Navigate to RM Summary screen and create a New Deal for the same Product for which the Profitability Curve with Real Time option for Transfer Price is created.
- The Transfer Pricing screen has an FTP Product Dimension drop-down. The entries entered in the Member screen according to the product will be visible in the drop-down list.
- After selecting the drop-down, the User-Defined Term section is enabled with the UDF’s given in the Member screen.
- You can configure the values for the available as required.
- When you click Compute FTP button, the FTP Pricing gets invoked and Transfer FTP Rate is calculated.
- Parallelly, the table FSI_PM_GENERATED_INSTRMTS in the FTP Atomic Schema gets populated with the calculated values and user-provided values for the UDFs.
Note:
The following entry is seeded with the FTP Model Dimension information. If you modify the FTP Model Dimension ID or name, then this entry should be updated to the respective Dimension ID.select * from setup_master where v_component_value =
'6778'