My Oracle Support Banner

EAP: Match Workbench - Business Units Prompt Values Different For Search Operators "Equal To" And "In" (Doc ID 2860738.1)

Last updated on APRIL 12, 2022

Applies to:

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


After setting up Business Unit security and also configuring the "in" value under Search fields Configuration (under Payables Search Criteria), Business Units Prompt values are different for search operators "equal to" and "in".


The issue can be reproduced at will with the following steps:

    1. Enable BU Security (Set Up Financial/Supply Chain > Security > Activate Row Level Security).

        -  Permission List Level Security: Business Unit, SetID, Pay cycle are checked.

    2. Modify the delivered setup in the Search Fields Configuration for AP_MTCH_WB (Use SP_BU_AP_CLSVW instead of SP_BU_AP_NONVW in BU Prompt Table1).

    3. Enable the "in" option under Search Fields Configuration (Accounts Payable > Review Accounts Payable Info > Payables Search Criteria > Search Fields Configuration > AP_MTCH_WB).

    4. Apply Security setups (Set Up Financial/Supply Chain > Security> Apply Security setups).

    5. Go to Match Workbench Page (Accounts Payable > Review Accounts Payable Info > Vouchers > Match Workbench).

       - Business Unit prompt for “equal to” shows 8 values (correct).

       - But in the case of the "in" search operator the Lookup button launches a secondary page SRCH_BULIST_SEC. This page is designed using the view SP_BU_AP_NONVW and this doesn't have any security and as a result all the BUs are getting listed (87, in this case).

NOTE: In the <images, examples, video > and/or the attached document, user details/company name/address/email/ telephone number all represent a fictitious sample from the Oracle Demo Vision Database.

Any similarity to actual companies or actual persons, living or dead, is purely coincidental and is in no way intentional on the part of Oracle



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

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