EEX 9.2 Fluid Ex Report Approval Shows Incorrect Old Transaction Risk (Doc ID 3064973.1)

Last updated on DECEMBER 23, 2024

Applies to:

Symptoms

A problem has been detected when an expense report is copied into a new report using the Fluid Expense UI, the old transaction flag on Expense Header does not get reset properly when the expense date is changed on the new report. As a result, when the supervisor views the report in Fluid Approvals, the report appears with Exceptions and Risks indicator which is misleading

Steps to reproduce the isssue:

1.- Log into the FSCM Online Application Expenses user
2.- Employee Self Service - Expenses Tile
2.- Tile Expenses - My Expenses Reports
3.- My Expense Reports - Not Submitted
Select one Old Expense and Copy to New Report
4.- Review the information on the DB
Query
SELECT A.OLDER_TRANSACTION, A.* FROM PS_EX_SHEET_HDR A WHERE SHEET_ID ='0000000000';
SELECT B.OLDER_TRANSACTION,B.* FROM PS_EX_SHEET_LINE B WHERE SHEET_ID ='0000000000';
SELECT C.* FROM PS_EX_RISK_ER_DTL C WHERE SHEET_ID ='0000000000';
5.- Update the expense Details
Edit expense date and Add the Received – the errors are resolved
Submit for approval
6.- Review the information on the DB after submit
Query
SELECT A.OLDER_TRANSACTION, A.* FROM PS_EX_SHEET_HDR A WHERE SHEET_ID ='0000000000';
SELECT B.OLDER_TRANSACTION,B.* FROM PS_EX_SHEET_LINE B WHERE SHEET_ID ='0000000000';
SELECT C.* FROM PS_EX_RISK_ER_DTL C WHERE SHEET_ID ='0000000000';
7.- Login like a approval and going to Exceptions and Risks
8.- ISSUE: when the supervisor views the report in Fluid Approvals, the report appears with Exceptions and Risks indicator which is misleading

Cause

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