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

Last updated on NOVEMBER 14, 2016

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms