PFT 8.1.2.0 .0 Static Table Driver Does Not Save Coefficient
(Doc ID 3068833.1)
Last updated on JANUARY 31, 2025
Applies to:
Oracle Financial Services Profitability Management - Version 8.1.2 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Symptoms
On PFT 8.1.2.0.0 version, you are facing issue in the Static Table Driver while using the coefficient upload functionality.
The Excel you are trying to upload contains approximately 120000 rows.
Once the upload is done and while clicking on Save / Apply, you have came across two issues:
1) Sometimes it shows only the first 2000 rows that were present in Excel, with no value in coefficient field.
2) After clicking on Save / Apply, it takes more than 1 hour but the changes are yet not applied.
pftapp.log shows below error:
[30-10-24 04:37:16,386 GMT AM] [DEBUG] [WEB] Connection got successfully for pft infodom: INFODOM
[30-10-24 04:37:16,386 GMT AM] [INFO ] [WEB] importDataFromExcel->query query for excel updated::{ call STATIC_TABLEID_EXCEL_IMPORT(?,?,?,?) }
[30-10-24 04:37:16,422 GMT AM] [INFO ] [WEB] importDataFromExcel->Only numbers accepted for Coefficient::1714,ALM FTP,76599,Miscellaneous Expenses,60,Toll,4.0000000000000002E-4
Steps To Reproduce:
1. Go to Rule Specification > Static Table Driver
2. Click Add to create new definition.
3. Select Leaf and Product, then click on Coefficient
4. In the Coefficient window, select Import and Upload File.
5. Coefficient is not saved.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |