My Oracle Support Banner

GL Is Not Available In The Network Account Field Of PYDONPRF Due To Wrong LOV Query (Doc ID 2851522.1)

Last updated on FEBRUARY 24, 2022

Applies to:

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

Symptoms

On : 14.5.0.0.0 version, Production Support

ACTUAL BEHAVIOR
---------------
GL is not available in the Network account Field of PYDONPRF due to wrong LOV query

1.Bank want to maintain the GL as a Network account in the PYDONPRF (Originated ACH Credit Transfer Preferences).
2.But the System is giving the following LOV query which includes the Host code.
3.The same needs to be removed .
4.I have mentioned the LOV query here;
SELECT AC_GL_NO FROM PMTBS_ACCOUNT WHERE ((ac_or_gl ='A'
and ac_class = '1') or ac_or_gl = 'G') AND ONCE_AUTH = 'Y' AND AC_GL_REC_STATUS = 'O' AND AUTH_STAT ='A'
and Host_Code='HOST_ML' ORDER BY AC_GL_NO


Cause

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
Symptoms
Cause
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.