My Oracle Support Banner

Prefix column format change in CS Batch (Doc ID 2785995.1)

Last updated on JUNE 27, 2021

Applies to:

Oracle Financial Services Customer Screening - Version 8.0.8 and later
Information in this document applies to any platform.


User want column TITL_NM size to be changed .

Since V_SALUTATION is mapped to titl_nm and V_SALUTATION contains more than 5 character value

Steps to reproduce :

Step 1 : Login to CS Application as Admin User

Step 2 : Check the column size of titl_nm of CUST table and mapping to v_salutation

Expected result :

Titl_nm column size must be increased to accomodate the values in v_salutation.

Actual result :

CUST. TITL_NM column length has VARCHAR2(5) but expected VARCHAR2(30)




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.