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 MARCH 14, 2018

Applies to:

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

Symptoms

ISSUE:

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.

REPLICATION STEPS:

     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.

ACTUAL RESULTS:

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.

EXPECTED BEHAVIOR:

The Approver Profile look-up view should display unique valid values at all times.

 

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