My Oracle Support Banner

OBPM: Not All The Vostro And Nostro Account Are Showing Under The Function ID PMDCYCOR- LOV (Doc ID 2956664.1)

Last updated on JULY 04, 2023

Applies to:

Oracle FLEXCUBE Universal Banking - Version 14.6.0.0.0 and later
Information in this document applies to any platform.

Goal

On : 14.6.0.0.0 version, Production Support-SET


Not all the vostro and nostro account are showing under the account number list of value PMDCYCOR.
Please find below the query for the LOV:
SELECT AC_GL_NO cust_ac_no, AC_GL_DESC cust_ac_name, BRANCH_CODE, AC_GL_CCY from pmtb_account where ((AC_GL_CCY = ? AND (('O' = ? AND AC_CLASS = '1') OR ('T' = ? AND AC_CLASS = '6'))) OR (AC_CLASS = '7')) AND auth_stat = 'A' AND AC_GL_REC_STATUS = 'O' AND CUST_NO IN (SELECT CUSTOMER_NO FROM PMTM_CUSTOMER WHERE CUSTOMER_TYPE = 'B') AND Host_Code = Global.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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.