EEX 9.2: Error Message (268,91) When Trying To Access The Expenses WorkCenter Due To Query EX_TOP_SPENDER In MSSQL Platform (Doc ID 2080035.1)

Last updated on MARCH 16, 2016

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Microsoft Windows x64 (64-bit)

Symptoms

ISSUE:

Users are getting an Error Message (268,91) when trying to access the Expenses Top Spender Query/Pagelet (EX_TOP_SPENDER) through means of the Expenses WorkCenter.

This seems to be an issue specific to MicroSoft SQL Server Databases.

REPLICATION STEPS:

     - Log into the FSCM Online Application as User VP1 for an environment using MicroSoft SQL Server Database Platform
     - Navigate to: Travel and Expenses > Expense WorkCenter
     - The User receives the (268,91) Error Message

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGE:

     " Generic error while executing the Query datasource. (268,91) PT_PGPACKAGE.PT_PGInformation.OnExecute Name:GetAllDimensionValues PCPC:68123 Statement:1215
       Called from:PTPG_WORKREC.FUNCLIB.FieldFormula Name:ViewerPageActivate Statement:2225
       Called from:PTPG_PGVIEWER.Activate Statement:1 "

BUSINESS IMPACT:

Users are unable to successfully open and review the Expenses WorkCenter functionality.

EXPECTED BEHAVIOR:

Regardless of which Database Platform is being used, (Oracle, DB2, MSSQL, Unix, etc...), the Expenses WorkCenter should be available to all Users with the proper access.

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