This topic describes the maintenance for Oracle FLEXCUBE Universal Banking.

Upload Source Maintenance

Maintain the source code as EXTSYS for Party Services to identify it as an external source system in the Upload Source Maintenance screen.

EXTSYS is an example source system name used throughout this document.

The source code name can be maintained against the key externalSource for the application obpy-party-handoff-services.

1. On Home screen, specify CODSORCE, and click Next arrow.
   The Upload Source Maintenance screen displays.

   Figure 1-1 Upload Source Maintenance

   
   

   
   Description of "Figure 1-1 Upload Source Maintenance"

   
   

Upload Source Preferences MaintenanceFor the defined source system (EXTSYS) and module ST, maintain the source preference record with recommended key values as shown below in the Upload Source Preferences Maintenance screen.

1. Post upload status - Authorized
2. On Override - Ignore
3. On Error - Reject
4. On Repairable Exception - Reject
5. On Queue Exception – Reject

2. On Home screen, specify CODUPLDM, and click Next arrow.
   The Upload Source Preferences Maintenance screen displays.

   Figure 1-2 Upload Source Preferences Maintenance

   
   

   
   Description of "Figure 1-2 Upload Source Preferences Maintenance"

   
   

External System Maintenance

Maintain the external system EXTSYS for Party Services in the External System Maintenance screen.

3. On Home screen, specify GWDETSYS, and click Next arrow.
   The External System Maintenance screen displays.

   Figure 1-3 External System Maintenance

   
   

   
   Description of "Figure 1-3 External System Maintenance"

   
   

External System Functions

Maintain the following function access rights in the External System Functions screen for the external system.

Table 1-1 External System Functions - Parameter Setup

Function	Action
STGCIF	NEW
STGCIF	UNLOCK
STGCIF	AUTHORIZE
STQCIF	VIEW
STVCIF	VIEW
STGKYCMN	NEW
STGKYCMN	UNLOCK
STGKYCMN	DELETE
STGKYCMN	AUTHORIZE
ACQABLQY	VIEW
STGCRCAD	NEW
STGCRCAD	UNLOCK
STGCRCAD	AUTHORIZE
STGCRCAD	VIEW

4. On Home screen, specify GWDETFUN, and click Next arrow.
   The External System Functions screen displays.

   Figure 1-4 External System Functions

   
   

   
   Description of "Figure 1-4 External System Functions"

   
   

Static Type Maintenance

Maintain the following static maintenance are required for type CIF_ID_TYPE in the Static Type Maintenance screen.

Table 1-2 Static Type Maintenance - Parameter Setup

Type Name	Type Value
AADHAR	AADHAR
DRIVING LICENSE	DLS
PASSPORT	PPT
VOTERID	VOTERID

The same type values are to be maintained as the sub_entity_code in Party Services → Maintenance → Entity for the entitycode ITY.

Note:

Refer to Oracle Banking Party Configuration User Guide for more details on Entity Maintenance.

5. On Home screen, specify CODTYPES, and click Next arrow.
   The Static Type Maintenance screen displays.

   Figure 1-5 Static Type Maintenance

   
   

   
   Description of "Figure 1-5 Static Type Maintenance"

   
   

KYC Type Maintenance

Maintain a KYC Type as KYC_ PURPOSE with a value as “Commercial” in the Static Type Maintenance screen. The same value has to be maintained in the Party properties table (obpy_properties) key KYC_TYPE_PURPOSE.

Similarly, maintain a KYC Type as KYC_PURPOSE_CRP with values like CORPORATE, SMB, and SME to indicate the reason for Customer Onboarding.

6. On Home screen, specify STDKYCTP, and click Next arrow.
   The KYC Type Maintenance screen displays.

   Figure 1-6 KYC Type Maintenance

   
   

   
   Description of "Figure 1-6 KYC Type Maintenance"

   
   

Customer Prefix MaintenanceMaintain the below customer Prefix1 in Customer Prefix Maintenance screen.

• Capt.
• Dr.
• Er.
• Major.
• Miss.
• Mr.
• Mrs.
• Ms.

The same values as sub_entity_code are to be maintained in Party Services → Maintenance → Entity for the entitycode SAL.

7. On Home screen, specify STDCUPRT, and click Next arrow.
   The Customer Prefix Maintenance screen displays.

   Figure 1-7 Customer Prefix Maintenance

   
   

   
   Description of "Figure 1-7 Customer Prefix Maintenance"

   
   

Location MaintenanceMaintain the required location codes. The same needs to be maintained in Location Maintenance screen available in Party.

8. On Home screen, specify STDCULOE, and click Next arrow.
   The Location Maintenance screen displays.

   Figure 1-8 Location Maintenance

   
   

   
   Description of "Figure 1-8 Location Maintenance"

   
   

Employer Maintenance

Maintain the employer codes in the Employer Maintenance screen. The same code has to be maintained in Party Services → Maintenance → Organization.

9. On Home screen, specify SMDEMPMT, and click Next arrow.
   The Employer Maintenance screen displays.

   Figure 1-9 Employer Maintenance

   
   

   
   Description of "Figure 1-9 Employer Maintenance"

   
   

Customer Segment Maintenance

Maintain the different values for Customer Segment in Customer Segment Maintenance screen. The same code has to be maintained for the entity code SEG in Services → Maintenance → Entity.

10. On Home screen, specify STDSEGMT, and click Next arrow.
    The Customer Segment Maintenance screen displays.

    Figure 1-10 Customer Segment Maintenance

    
    

    
    Description of "Figure 1-10 Customer Segment Maintenance"

    
    

Customer Category Maintenance

Maintain the following Customer categories in FLEXCUBE Universal Banking screen. The same values need to be maintained or replicated in Core Maintenance - Customer Category, which can be input as Party Sub Type during the Party onboarding.

11. On Home screen, specify STDCSCAG, and click Next arrow.
    The Customer Category Maintenance screen displays.

    Figure 1-11 Customer Category Maintenance

    
    

    
    Description of "Figure 1-11 Customer Category Maintenance"

    
    

Party Amendment

Gateway Amendment Maintenance

In FLEXCUBE Universal Banking, the amendment should be allowed field-wise for an operation code. Below is the list of samples required amendment fields in FLEXCUBE Universal Banking.

Customer Modification

• External System and Origin System: EXTSYS
• Source Operation: ModifyCustomer
• Service Name: FCUBSCustomerService
• Operation Code: ModifyCustomer
• For each node, set New, Delete, and All Records as Y

12. On Home screen, specify GWDAMDMT, and click Next arrow.
    The Gateway Amendment Maintenance screen displays.

    Figure 1-12 Gateway Amendment Maintenance

    
    

    
    Description of "Figure 1-12 Gateway Amendment Maintenance"

    
    

    Node: STTMS_CUSTOMER

    • ACCESS_GROUP
    • ADDRESS_LINE1
    • ADDRESS_LINE2
    • ADDRESS_LINE3
    • ADDRESS_LINE4
    • CIF_STATUS
    • COUNTRY
    • CUSTOMER_CATEGORY
    • CUSTOMER_NAME1
    • CUSTOMER_NAME2
    • CUST_CLASSIFICATION
    • CUST_GROUP
    • FULL_NAME
    • KYC_DETAILS
    • KYC_REF_NO
    • LANGUAGE
    • LOCAL_BRANCH
    • NATIONALITY
    • PINCODE
    • SHORT_NAME
    • SHORT_NAME2
    • UNIQUE_ID_NAME
    • UNIQUE_ID_VALUE

    Node: STTMS_CUSTOMER__A

    • ADDRESS_LINE1
    • ADDRESS_LINE2
    • ADDRESS_LINE3
    • COUNTRY
    • CUSTOMER_NAME1
    • JOINT_VENTURE
    • KYC_DETAILS
    • KYC_REF_NO
    • LANGUAGE
    • NATIONALITY
    • PINCODE
    • UNIQUE_ID_NAME
    • UNIQUE_ID_VALUE

    Node: STTMS_CUST_DOMESTIC

    • ACCOMODATION
    • DEPENDENT_CHILDREN
    • DEPENDENT_OTHERS
    • EDUCATIONAL_STATUS
    • MARITAL_STATUS
    • MOTHER_MAIDEN_NAME
    • SPOUSE_EMP_STATUS
    • SPOUSE_NAME
    • STTMS_CUST_PERSONAL
    • BIRTH_COUNTRY
    • CUSTOMER_NO
    • CUSTOMER_PREFIX
    • CUSTOMER_PREFIX1
    • CUSTOMER_PREFIX2
    • CUST_COMM_MODE
    • DATE_OF_BIRTH
    • D_ADDRESS1
    • D_ADDRESS2
    • D_ADDRESS3
    • D_ADDRESS4
    • D_COUNTRY
    • D_PINCODE
    • E_MAIL
    • FAX
    • FAX_ISD_NO
    • FIRST_NAME
    • HOME_TEL_ISD
    • HOME_TEL_NO
    • LAST_NAME
    • LEGAL_GUARDIAN
    • MIDDLE_NAME
    • MINOR
    • MOBILE_NUMBER
    • MOB_ISD_NO
    • PASSPORT_NO
    • PLACE_OF_BIRTH
    • PPT_EXP_DATE
    • PPT_ISS_DATE
    • P_ADDRESS1
    • P_ADDRESS2
    • P_ADDRESS3
    • P_ADDRESS4
    • P_COUNTRY
    • P_NATIONAL_ID
    • P_PINCODE
    • RESIDENT_STATUS
    • SEX
    • TELEPHONE
    • TEL_ISD_NO
    • US_RES_STATUS
    • VST_US_PREV

    Node: STTMS_CUST_PERSONAL__A

    • CUST_COMM_MODE
    • E_MAIL
    • FAX
    • FAX_ISD_NO
    • MOBILE_NUMBER
    • MOB_ISD_NO
    • TELEPHONE
    • TEL_ISD_NO
    • STTMS_CUST_PROFESSIONAL
    • CCY_PERS_INCEXP
    • CREDIT_CARDS
    • DESIGNATION
    • EMPLOYER
    • EMPLOYMENT_STATUS
    • EMPLOYMENT_TENURE
    • E_ADDRESS1
    • E_ADDRESS2
    • E_ADDRESS3
    • E_ADDRESS4
    • E_COUNTRY
    • E_EMAIL
    • E_TELEPHONE
    • HOUSE_VALUE
    • INSURANCE
    • LOAN_PAYMENT
    • OTHER_EXPENSES
    • OTHER_INCOME
    • PINCODE
    • PREV_DESIGNATION
    • PREV_EMPLOYER
    • RENT
    • RETIREMENT_AGE
    • SALARY
    • SALARY_FREQ

    KYC Modification

    • External System and Origin System: EXTSYS
    • Source Operation: STDKYCMN_MODIFY
    • Service Name: FCUBSSTService
    • Operation Code: ModifyKYCDetails
    • For each node, set New, Delete, and All Records as Y

    Node: STTMS_KYC_COMPL_AUDIT_DTL

    • ACTIVITY_STP_CD
    • ACTIVITY_STP_CD_REASON
    • CB_RESPONSE
    • CB_RESPONSE_DATE
    • CIS_NUMBER
    • DAIRY_NOTE
    • NAME
    • STR_DATE
    • STR_RAISED
    • STR_REF_NO

    Node: STTMS_KYC_CORPORATE

    • ACC_PURPOSE
    • ACC_SOLICITED
    • ACC_SOLICITED_DATE
    • ANNUAL_TURNOVER
    • APPROVER_COMMENTS
    • AUDIT_DATE
    • BORROW_ACC_GRP
    • BUSINESS_APPROVAL
    • BUSINESS_NATURE
    • COMPANY_TYPE
    • COMPLIANCE_CLEARANCE
    • EMPLOYEE_NUMBER
    • FUNDS_SOURCE
    • GROUP_NAME
    • INTRODUCER_DTL
    • KYC_AMTS_CCY
    • KYC_COMMENTS
    • KYC_NXT_REVIEW_DATE
    • LOCAL_ABROAD_BRN
    • OTHR_COMPANY_TYPE
    • OTHR_SALARY_MODES
    • PARENT_CMPNY_COUNTRY
    • SALARY_MODE

    Node: STTMS_KYC_CORP_CLIENT

    • COUNTRIES
    • PAYMENT_MODE

    Node: STTMS_KYC_CORP_KEYPERSONS

    • ADDRESS
    • ADDRESS_COUNTRY
    • BIRTH_COUNTRY
    • DATE_OF_BIRTH
    • ISD_CODE
    • NATIONALITY
    • OWNERSHIP_TYPE
    • PLACE_OF_BIRTH
    • POSITION_OR_TITLE
    • RELATIONSHIP
    • SHARE_HOLDING
    • TAX_CNTRY
    • TEL_NO
    • TIN

    Node:STTMS_KYC_CORP_SUPPLIER

    • COUNTRIES
    • SETTLEMENT_MODE

    Node:STTMS_KYC_FINANCIAL

    • BANK_ADDRESS
    • COUNTRY
    • KYC_AMTS_CCY

    Node:STTMS_KYC_MASTER

    • CRS_TYPE
    • KYC_DESC
    • RISK_LEVEL

    Node:STTMS_KYC_MGMNT_DTL

    • DESIGNATION

    Node: STTMS_KYC_RETAIL

    • ACC_PURPOSE
    • ACC_TYPE
    • APPROVER_COMMENTS
    • BIRTH_COUNTRY
    • BIRTH_DATE
    • BIRTH_PLACE
    • BUSINESS_INCOME
    • DECLARED
    • FAX_ISD_NO
    • FAX_NO
    • HOME_ADDR_COUNTRY
    • HOME_COUNTRY_ADDR
    • INVESTMENT_INCOME
    • KYC_AMTS_CCY
    • KYC_COMMENTS
    • KYC_NXT_REVIEW_DATE
    • LOCAL_ADDR
    • LOCAL_ADDR_COUNTRY
    • MOBILE_TEL_NO
    • MOB_ISD_NO
    • NATIONALITY
    • OFFICE_TEL_NO
    • OFF_TEL_ISD_NO
    • OTHR_ACC_PURPOSE
    • OTHR_INCOME_SOURCES

    Node:STTMS_KYC_SHARE_HOLDERS

    • ADDRESS
    • CITY
    • COUNTRY
    • HOLDING

    Node:STTMS_KYC_TXN_DETAILS

    • COUNTRIES
    • COUNTRY_PURPOSE
    • MAX_COUNT
    • PURPOSE
    • SINGLE_MAX_AMT
    • TOTAL_AMT

    Node:STTMS_KYC_TXN_PRODUCTS

    • MONTHLY_AMT
    • NO_OF_TXN_MONTHLY
    • RATING

    Note:

    Additional fields may be present keeping future scope/assumptions.