My Oracle Support Banner

EAP: Error on Email Payment Advice Page if Pay Cycle is Express Check or Restart - Either the Pay Cycle Doesn't Exist OR You Are Not Authorized to Use it. (7015,186) (Doc ID 2909947.1)

Last updated on NOVEMBER 17, 2022

Applies to:

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

Symptoms

When Row Level Security (Permission List Level Security) is turned on for Business Unit, SetID, and Pay Cycle, two issues occur on the E-mail Payment Advice page when the Pay Cycle specified is either Express Check (XPCnnn) or Restart (RSTnnn)

ISSUE 1
If an Express Check Pay Cycle is entered on the E-mail Payment Advice page, receive the following error:

This error should not be displayed since the Pay Cycle by Permission List page is setup with Pay Cycle = XPC (Express Check), which is used to include all available Express Check Pay Cycles.

However, if the specific Express Check Pay Cycle (XPCnnn) is entered on the Pay Cycle by Permission List, the above error does not occur. Should not have to enter each individual Express Check Pay Cycle on the Pay Cycle by Permission List page since Pay Cycle = XPC is already specified.

ISSUE 2
A specific Express Check Pay Cycle (XPCnnn) is setup on the Pay Cycle by Permission List page.

If Pay Cycle = XPCnnn is entered on the E-mail Payment Advice page, when clicking on the magnifying glass for the Seq Num, the Look Up Seq Num page displays all available Pay Cycle Sequence Numbers, regardless of the Row Level Security setup. Page should be filtered to only display those Seq Numbers that the Payment Advice User ID has access to based upon the Permission List Level Security setup for Bank SetID and Business Unit.

STEPS
1. Navigate to PeopleTools > Security > User Profiles > User Profiles
    a. User ID = WWWW is setup with Permission Lists of Primary = XXXXXXXXX and Row Security = XXXXXXXXX
    b. User ID = YYY is setup with Permission Lists of Primary = ZZZZZZZZ and Row Security = ZZZZZZZZ
2. Navigate to Set Up Financials/Supply Chain > Security > Activate Row-level Security
3. On the Security Options page
    a. Select Permissions List Level Security
    b. Secured Fields = Business Unit, SetID, and Pay Cycle
4. Navigate to Set Up Financials/Supply Chain > Security > Unit by Permission List
5. On the Business Unit Security by Permission List page
    a. Primary Permission List = XXXXXXXXX / Business Unit = AAAAA
    b. Primary Permission List = ZZZZZZZZ / Business Unit = BBBBB
6. Navigate to Set Up Financials/Supply Chain > Security > TableSet by Permission List
7. On the TableSet Security by Permission List page
    a. Primary Permission List = XXXXXXXXX / SetID = CCCCC
    b. Primary Permission List = ZZZZZZZZ / SetID = CCCCC
8. Navigate to Set Up Financials/Supply Chain > Security > Pay Cycle by Permission List
    a. Primary Permission List = XXXXXXXXX / Pay Cycle = XPC and RST
    b. Primary Permission List = ZZZZZZZZ / Pay Cycle = XPC and RST
9. Navigate to Set Up Financials/Supply Chain > Security > Apply Security Setups
10. Run Apply Security Setups
11. Navigate to Suppliers > Supplier Information > Add/Update > Add/Update Supplier
12. Display Supplier ID = UUUUUU
13. On the Supplier > Location page, click the Payables link
14. On the Payables Options page, under Payment Notification
      a. Check the box for Enable Email Payment Advice
      b. Specify an Email ID
      c. Payment Method = System Check
15. Log in a User ID WWWW
16. Navigate to Accounts Payable > Vouchers > Add/Update > Regular Entry
17. Add a Voucher for Business Unit = AAAAA, Supplier ID = UUUUUU
18. On the Voucher > Payments page, click on Express Payment
19. On the Express Payment page, click Create Payment
20. Pay Cycle = XPC0NN
21. Complete the Pay Cycle
22. Navigate to Accounts Payable > Payments > Pay Cycle Processing > Email Payment Advice
23. On the Email Payment Advice page, click on the magnifying glass for Pay Cycle
24. On the Look Up Pay Cycle page, select XPC0NN
25. Above error is received
26. On the Pay Cycle by Permission List page for Primary Permission List = XXXXXXXXX, add Pay Cycle = XPC0NN
27. Run Apply Security Setups
28. On the Email Payment Advice page, click on the magnifying glass for Pay Cycle
29. On the Look Up Pay Cycle page, select XPC0NN
30. Error no longer received
31. Click the magnifying glass for Seq Num
32. On the Look Up Seq Num page, able to see all available Pay Cycle Sequence Numbers, regardless of the Row Level Security setup
33. Expected to see only the Pay Cycle Sequence Number which belongs to Business Unit = AAAAA
34. All the other Pay Cycle Sequence Numbers displayed belong to Business Unit = BBBBB. This is verified by querying the table, PYMNT_VCHR_XREF for PAY_CYCLE = XPC0NN. There is one row displayed for Business Unit = AAAAA and the rest of the rows are for Business Unit = BBBBB.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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