My Oracle Support Banner

EEX 9.2: Fatal SQL Error Message at EX_EXP_LIST_FL.RelatedAction:DeleteReportHandlers in MSSQL Databases When Deleting Expense Report in Fluid After Implementing Patch 34409527 (Doc ID 2916620.1)

Last updated on JANUARY 03, 2023

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

A Fatal SQL Error Message is being triggered by the system when trying to delete an existing Expense Report in the Fluid My Expense Reports page (Panel and Component EX_EXP_LIST_FL) in an MSSQL Database Platform.

This takes place after the codeline changes introduced by <Bug 34409527> - (EX: EXPENSE REPORT DUPLICATE LINE FLAG NOT REMOVED EVEN AFTER SIMILAR EXPENSE REPORT IS DELETED), delivered in FSCM 9.2 Image #46, have been applied.

REPLICATION STEPS:

    1.- Have an FSCM 9.2 Online Application on MSSQL Database Platform, with Patch 34409527 installed
    2.- Log into the FSCM 9.2 Online Application as an Expenses User
    3.- Navigate to: Set Up Financials/Supply Chain > Install > Installation Options > Expenses
    4.- Ensure that the 'Duplicate Review Required' check-box is selected
    5.- Go to the Employee Self Service Fluid Homepage
    6.- Click on the Expenses Tile
    7.- Click on the My Expense Reports Tile
    8.- Go to the Pending filter, and select an existing transaction
    9.- From the Related Actions feature, select the option of 'Delete Report'
    10.- The system throws the following Message:
              " Are you sure to delete Expense Report 0000000XXX ? This action cannot be reversed. "
    11.- Click on YES button
    12.- The system throws an Error Message

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

ERROR MESSAGE:

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.