EEX 9.2: Approver Profile Look-Up View (EX_PROF_ACT_VW) At Approver List Page Showing Duplicate Rows For Same Value
(Doc ID 2373753.1)
Last updated on APRIL 10, 2019
Applies to:PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
A problem has been detected when using the Approver Profile look-up icon at the Approver List page (EX_APPRVR_LIST), which uses the delivered SQL View and Statement:
SELECT APPROVER_PROFILE, DESCR FROM PS_EX_PROF_ACT_VW A WHERE SETID=:1 AND APPR_TRANS_TYPE=:2 ORDER BY APPROVER_PROFILE
Bind-1 type=2 length=5 value=SHARE
Bind-2 type=2 length=2 value=ER
When reviewing the obtained results, if one Approver Profile has multiple effective dated rows in its configuration, there will be the same amount of Approver Profiles with the same value being displayed.
1.- Log into the FSCM Online Application as User ID VP1
2.- Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Management > Approval Setup > Approver Profile
3.- Open existing Approver Profile for Pre Pay Auditor, add a new effective dated row for 01-01-2000, and save the changes
4.- Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Management > Approval Setup > Approver List
5.- Open the configuration for Business Unit US001, Expense Reports, and Approver Type Pre Pay Auditor
6.- Click on the Approver Profile look-up icon
7.- Notice that there are two identical rows for Pre Pay Auditor value
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.
The fact that the search results display multiple duplicate rows with the same Approver Profile value confuses the Users, which do not know if selecting one over the other would have any impact.
The Approver Profile look-up view should display unique valid values at all times.
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