My Oracle Support Banner

PCDDMAND Fails To Fetch Record (Doc ID 2754494.1)

Last updated on MARCH 03, 2021

Applies to:

Oracle Banking Payments - Version 14.4.0.0.0 and later
Information in this document applies to any platform.

Goal

When trying to fetch a record from screen PCDDMAND/PCSDMAND system is freezing.

As per our analysis the issue is because of a query that returns huge number of rows because the join condition is missing:

DebtorMandateViewDao.java
String MANDATE_ID_SELECT = "SELECT B.MANDATE_ID, B.CUST_NO FROM PCTM_DEBTOR_MANDATE B, PMTMS_CUSTOMER A WHERE B.CUST_NO IN (SELECT A.CUSTOMER_NO FROM STTM_CORE_CUSTOMER A WHERE NVL(IS_FORGOTTEN, 'N') = 'N' AND (A.ACCESS_GROUP IS NOT NULL AND EXISTS(SELECT 1 FROM STVW_USER_ACCESS B WHERE B.USER_ID = ? AND B.ACCESS_GROUP = A.ACCESS_GROUP)) OR A.ACCESS_GROUP IS NULL) AND B.HOST_CODE = ?";
 

Solution

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