My Oracle Support Banner

ECM: Fatal PeopleCode Sql Error on External Transactions Page When Bank ID Prompt is Clicked (Doc ID 2202467.1)

Last updated on FEBRUARY 05, 2019

Applies to:

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

Symptoms

Clicking on External Bank ID prompt of External Transactions page triggers the following error message.

ERROR:
"A fatal Peoplecode SQL error occurred.Please consult your system log for details."

STEPS:
1. Enable FG Security option at Role level for Bank ID Nbr and Payment Source.
2. Create three different rules and assign these rules to three different roles assigned to three different users.
    Rule 1:  PMT_SOURCE = AP
    Rule 2:  PMT_SOURCE = EX
    Rule 3:  BANK_ID_NBR in(list of bank IDs)
3. Assign Rule 1 to User1, Rule 2 to User 2 and Rule 3 to User 3.
4. Login with User 4 who is not assigned to any of the above rules and navigate to Financial Gateway > Payments > Review Payments page which gives above error.

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
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.