EAP: PMT_DISP_BT Goes to No Success Due To FG Security For Single Security Rule Assigned To Multiple Roles

(Doc ID 2201894.1)

Last updated on NOVEMBER 08, 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

Issue Statement:
--------------------
PMT_DISP_BT process is failing with SQL error when Multiple Security Rules are assigned to a single User Id.
AND
Financial Gateway->process payment->payment Dispatch
SQL error occurred on opening the payment dispatch page


Steps:
----------
Step 1: FG Security option is switched on based on Role.
Step 2: Create a Rule with PMT_SOURCE field.
Step 3: Tag the Rule APEX to two roles
Step 4: Tag the 2 Roles to a user
Step 5: Schedule payment dispatch Batch process
Step 6: PMT_DISP_BT process goes to No success
Step 7: Error occurred
  
Error:
---------
Error Position: 295 Return: 907 - ORA-00907:
missing right parenthesis Failed SQL stmt: UPDATE PS_PMT_DETAIL_TBL SET
PMTRUNINSTANCE = 9, IN_PROCESS_FLG = 'Y' , PMT_STATUS = 'SC', PMT_LAST_STATUS
= 'L' WHERE PMTRUNINSTANCE = 0 AND PMT_STATUS = 'L' AND IN_PROCESS_FLG = 'N'
AND PYMNT_DT BETWEEN TO_DATE('2016-05-05','YYYY-MM-DD') AND
TO_DATE('2016-05-05','YYYY-MM-DD')AND
(((PMT_SOURCE = 'AP' OR (PMT_SOURCE = 'AP' OR PMT_SOURCE='EX')PMT_SOURCE = 'EX')))


Second error
------------------
Financial Gateway->process payment->payment Dispatch

SQL error in Exec. (2,280) PMT_INQUIRY.CHARTS.GenerateChart.OnExecute Name:
PopulateDataSet PCPC:14679
Statement 201
Called from PMT_INQUIRY.CHARTS.GenerateChart.OnExecute Name:GenerateChart
Statement: 15
Called from PMT_INQUIRY.Activate Statement: 49

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