E-NV: Unable To Set The ShowDetail Property Of The Range Class' Error For 'Microsoft Excel: '
Last updated on MARCH 12, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
nVision layouts with manual grouping of rows error out with the following message:
'Excel interface exception [E:\pt85512b-retail\peopletools\src\psnxl\gridapp.cpp:3803] Unable to set the ShowDetail property of the Range class' Error for 'Microsoft Excel: '. (28,160)
The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Navigate to Reporting Tools > PS/nVision > Define Report Request (Define ReportBook)
3. Run a report
4. Notice the error in Process Monitor.
This error can also occur if a formula is inadvertently placed in an intersection of layout definition criteria that also includes an nPlosion option.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms