PCDDMAND Fails To Fetch Record
(Doc ID 2754494.1)
Last updated on MARCH 03, 2021
Applies to:Oracle Banking Payments - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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:
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 = ?";
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