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 and later
Information in this document applies to any platform.


On : 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


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

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