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 FEBRUARY 13, 2024

Applies to:

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

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