EAP: E-mail Payment Advice Page Does Not Display Pay Cycle If Row Security Not Populated on the User Profile (Doc ID 2967050.1)

Last updated on AUGUST 09, 2023

Applies to:

Symptoms

Permission List Level Security is turned on for Business Unit, SetID, and Pay Cycle. However, on the User Profiles page under Permission Lists, the Row Security field is not populated.

User 1 creates a Pay Cycle with Email Payment Advice checked. User 1 pays the Vouchers using the Pay Cycle just created and only executes the Pay Cycle through Payment Creation. User 1 logs out of the system. User 2 completes User 1's Pay Cycle to the end, running Email Payment Advice and Print Checks.

User 2 displays the E-mail Payment Advice page. After entering the Pay Cycle that User 1 created and clicking the magnifying glass for Seq Num, User 2 is not able to see the Pay Cycles that User 1 created even though security is setup at the Permission List Level and not the User ID Level. User 2 has the same Pay Cycle Permission List Security setup as User 1.

Even if User 1 displays the E-mail Payment Advice page and enters the Pay Cycle that User 1 created, User 1 is also not able to see the Seq Num.

However, if the Row Security field is populated on the User Profiles page under Permission Lists, both User 1 and User 2 can see the Seq Num for the Pay Cycle that User 1 created.

The following bugs have already been applied:
  • <Bug 34064561> - AP: UNABLE TO RUN EMAIL PAYMENT ADVICE IF PAY CYCLE IS EXPRESS CHECK OR RESTART
  • <Bug 34826212> - AP: EMAIL PAYMENT ADVICE PAGE ONLY DISPLAYS PAY CYCLES BY USER ID AND NOT PERMISSION LIST AFTER APPLYING BUG 34064561

STEPS
1. Navigate to Suppliers > Supplier Information > Add/Update > Add/Update Supplier
2. Display Supplier ID = UUUUUU
3. On the Supplier > Location page, click the Payables link
4. 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

5. Navigate to Accounts Payable > Payments > Pay Cycle Processing > Payment Selection Criteria
    a. Create Pay Cycle = OOO
    b. Preferences page has the Email Payment Advice box checked
    c. Source / BU page has Business Unit = AAAAA
    d. Bank / Method page has Bank = CCCCC, Account = CHCK, Payment Method = System Check

6. Navigate to PeopleTools > Security > User Profiles > User Profiles > General page
    a. User ID = WWW is setup with Permission Lists of Process Profile = XXXXXXXXX, Primary = XXXXXXXXX, and Row Security is blank
    b. User ID = YYY is setup with Permission Lists of Process Profile = ZZZZZZZZ, Primary = ZZZZZZZZ, and Row Security is blank

7. Navigate to Set Up Financials/Supply Chain > Security > Activate Row-level Security
8. On the Security Options page
    a. Select Permissions List Level Security
    b. Secured Fields = Business Unit, SetID, and Pay Cycle

9. Navigate to Set Up Financials/Supply Chain > Security > Unit by Permission List
10. 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 and AAAAA

11. Navigate to Set Up Financials/Supply Chain > Security > TableSet by Permission List
12. On the TableSet Security by Permission List page
      a. Primary Permission List = XXXXXXXXX / SetID = CCCCC
      b. Primary Permission List = ZZZZZZZZ / SetID = CCCCC

13. Navigate to Set Up Financials/Supply Chain > Security > Pay Cycle by Permission List
      a. Primary Permission List = XXXXXXXXX / Pay Cycle = OOO, XPC, RST
      b. Primary Permission List = ZZZZZZZZ / Pay Cycle = OOO, XPC, RST

14. Navigate to Set Up Financials/Supply Chain > Security > Apply Security Setups
15. Run Apply Security Setups
16. Log in as User ID YYY
17. Navigate to Accounts Payable > Vouchers > Add/Update > Regular Entry
18. Add a Voucher for Business Unit = AAAAA, Supplier ID = UUUUUU, Bank = CCCCC, Account = CHCK, Payment Method = CHK
19. Navigate to Accounts Payable > Payments > Pay Cycle Processing > Pay Cycle Manager
20. Display Pay Cycle = OOO
      a. Run Payment Selection & Creation
      b. Click Refresh
      c. Status = Approved
21. Sign out of the system
22. Log in as User ID WWW
23. Navigate to Accounts Payable > Payments > Pay Cycle Processing > Pay Cycle Manager
24. Complete Pay Cycle = OOO
      a. Run Email Payment Advice
      b. Run Print Checks

25. Navigate to Accounts Payable > Payments > Pay Cycle Processing > Email Payment Advice
26. On the Email Payment Advice page, click on the magnifying glass for Pay Cycle
27. On the Look Up Pay Cycle page, select OOO
28. Click the magnifying glass for Seq Num
29. On the Look Up Seq Num page, see the message -- No matching values were found.
30. Expected to see the Pay Cycle Sequence Number for the Pay Cycle that WWW just completed since Pay Cycle security is turned on by Permission List and not by User ID
31. On the User Profiles > General page for User ID = WWW, under Permission Lists, populate the Row Security field with XXXXXXXXX
32. On the Email Payment Advice page for Pay Cycle = OOO, click on the magnifying glass for Seq Num
33. Pay Cycle Sequence Number for the Pay Cycle that WWW completed for YYY is now being displayed
34. Log in as User ID YYY
35. On the Email Payment Advice page, click on the magnifying glass for Pay Cycle
36. On the Look Up Pay Cycle page, select OOO
37. Click the magnifying glass for Seq Num
38. On the Look Up Seq Num page, see the message -- No matching values were found.
39. Expected to see the Pay Cycle Sequence Number since YYY create the Pay Cycle
40. On the User Profiles > General page for User ID = YYY, under Permission Lists, populate the Row Security field with ZZZZZZZZ
41. On the Email Payment Advice page for Pay Cycle = OOO, click on the magnifying glass for Seq Num
42. Pay Cycle Sequence Number for the Pay Cycle that YYY created is now being displayed 

Changes

Cause

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