My Oracle Support Banner

OBCL : LFDFEECL - No Data Available For Payment Type LOV (Doc ID 2901174.1)

Last updated on OCTOBER 12, 2022

Applies to:

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

Symptoms

On : 14.6.0.0.0 version, Implementation Support

ACTUAL BEHAVIOR
---------------
OBCL : LFDFEECL - No Data available for Payment Type LOV

Patchset : 14.6.0.0.0 | Maintenance Line

In Fee Class Maintenance Screen - LFDFEECL, No data available in the Payment Type LOV.

EXPECTED BEHAVIOR
-----------------------
System should populate the Payment Type LOV without any issue.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open LFDFEECL Screen.
2. Fill the mandatory fields and then click on Payment type search.
3. System didn't populate the necessary data.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users can't able to view and set the payment type.

Analysis
-------------------------

As per our analysis, The LOV is trying to fetch the data from 'tctm_fee_component_pymnt_type' view table, which is missing.
But in the actual table - 'lbzm_fee_component_pymnt_type', we have payment type data.

Kindly release the view script for the same.

Changes

Modified the LOV query for LOV_PAYMENTTYPE in CSTB_LOV_INFO to LBTM_FEE_COMPONENT_PYMNT_TYPE table 

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
Changes
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.