EAP: Email Payment Advice Page Does Not Show Paycycle Sequence Number When User ID Row Level Security Enabled For Paycycle (Doc ID 2990604.1)

Last updated on DECEMBER 04, 2023

Applies to:

Symptoms

On Email Payment Advice page, No PayCycle Seq Num is available if Row level Security enabled at User ID level security for Paycycle.

Setup:
1. Go to  Suppliers > Supplier Information > Add/Update  > Add/Update Supplier ,, Open a Supplier
2  Go to Location(tab) > Click on Payables Link > Enable Email Payment Advice , enter Email ID and Select Payment method(s)
3. Go to Banking > Bank Accounts > External Accounts, Open a Bank Account
4. Go to Payment Method(tab) , make sure the Payment Method selected on supplier page should be settle by Paycycle

Steps:
1. Go to Accounts Payable > Vouchers > Add/Update > Voucher
2. Create a voucher for same supplier and Bank Account and Payment Method
3. Pay the Voucher using Paycycle.
4. Once the Paycycle completes, Go to Accounts Payable > Payments> Pay Cycle > Processing > Email Payment Advice
5. Select the Paycycle from which voucher was paid and the Paycycle Sequence Number.
               --- Both the values are available in prompts.
6. Go to Set Up Financials/Supply Chain > Security > Activate Row-level Security
7. Enable Row level Security –  User ID Level Security and Select Paycycle in Secured Fields.
8. Save the page
9. Go to Set Up Financials/Supply Chain > Security > Pay Cycle By User ID
10. Add one row in Accessing Pay Cycles with the Paycycle from which voucher was paid.
11. Go to Set Up Financials/Supply Chain > Security > Apply Security Setups
12. Run the process.
13. Go to Accounts Payable > Payments> Pay Cycle > Processing > Email Payment Advice
14. Select the same Paycycle again from which voucher was paid and the Paycycle Sequence Number.

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.