E-NV: Unable To Set The ShowDetail Property Of The Range Class' Error For 'Microsoft Excel: ' (Doc ID 2228781.1)

Last updated on JANUARY 31, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

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)

Steps
-------
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms