RP VARIANCE RULE QUERY PERFORMANCE
(Doc ID 2803846.1)
Last updated on SEPTEMBER 08, 2021
Applies to:Oracle FLEXCUBE Universal Banking - Version 12.3 and later
Information in this document applies to any platform.
The RP variance rule dynamic package is having the below query
FROM STTMS_ACCOUNT_BALANCE A, STTMS_CUST_ACCOUNT B
WHERE B.CUST_NO=P_CUSTOMER_NO AND A.CUST_AC_BRN = B.BRANCH_CODE AND A.CUST_AC_BRN=GLOBAL.CURRENT_BRANCH AND ROWNUM = 1;
DEBUG.PR_DEBUG('CO','FAILED WHILE SELECTING DATA FROM STTMS_ACCOUNT_BALANCE FOR CUSTOMER ' || P_CUSTOMER_NO);
Package copks_rule_gen is used for generating dynamic package based on RP rule, above query is coming in that dynamic package.
The above query does not have the account number in where condition due to which the cost of query is high.
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