OBCL - Customer Category Field Should Be Mandatory In Customer Maintenance Screen (OLDCUSMT) (Doc ID 2909184.1)

Last updated on NOVEMBER 15, 2022

Applies to:

Symptoms

On : 14.6.0.1.0 version, Implementation Support

ACTUAL BEHAVIOR
---------------
OBCL - Customer Category field should be mandatory in Customer Maintenance Screen (OLDCUSMT)

14.6.0.1.0 ..... Maintenance line

Customer Category field should be mandatory in Customer Maintenance Screen (OLDCUSMT), currently it is possible to save & authorize the record without defining Customer Category. While trying to process loan contract (OLDTRONL) for the customer not able to get customer number in Counterparty LOV. It is possible to get said customer only if Customer category defined in customer maintenance screen.

OLTM_customer is view on SYTM_STTM_CUSTOMER and sttm_core_customer and customer Category is coming from OLDCUSMT .
So in case we are not giving customer category ,then by default system is picking UNDEFINED from view (NVL(sy.CUSTOMER_CATEGORY,'UNDEFINED') CUSTOMER_CATEGORY) .
Due to this we are unable to pick customer in OLDTRONL .


EXPECTED BEHAVIOR
-----------------------
Customer Category field should be mandatory in Customer Maintenance Screen (OLDCUSMT).

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login OLDCUSMT Screen.
2. See the Customer Category field, showing not mandatory field.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users can't able to pick customer in OLDTRONL .

Changes

1. Modified the View: olvw_product_categories in such a way that even if the Category is not Maintained as UNDEFINED in OLDCSCAG Screen, it will display
the Customer in OLDTRONL.
2. Added validation in OLDCUSMT Screen to check Customer Category is not blank while saving. 

Cause

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