WEBLIB_QUERY.ISCRIPT1.FieldFormula.IScript_ToExcel -- will not default to .xlsx --
Our current environment is-
- HCM 8.9 (MP 11)
- FSCM 9.1 (MP10)
- PTools 8.52.17
- DB - Oracle 11.0.2.3
- Windows 2008 R2 (64-bit)
I have been researching without much luck, an issue I am having with WEBLIB_QUERY.ISCRIPT1.FieldFormula.IScript_ToExcel. It keeps reverting to .xls. With the output displaying the error message -- "#### (# designates number of rows) Query Result Set too Large (50,546). Result of SQL Fetch is over the maximum....."
After running a query with 500,000 rows and attemtping to Download to Excel to test the new .xlsx functionality. It will NOT alow me to download. The attempt to download keeps returning to [Read Only] Compatability Mode.