My Oracle Support Banner

Contact Copy Record Triggers Error When Field "Mr/Ms" Has Value - SBL-DBC-00111 - ORA-00957 - SBL-DAT-00418 (Doc ID 2053892.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Siebel CRM - Version 8.1.1.11.16 [IP2013] and later
Information in this document applies to any platform.

Symptoms

Description of the issue: When user is trying to copy a record from contacts using control B combination, records with "Ms/Mrs" field not null are not copying and display error message SBL-DBC-00111.

Reproducible Steps:
1. Login into Application(NON PROD or PROD)
2. Click on Contacts View
3. Select Contact Lists
4. Select All Contacts Across Organizations
5. Select any contact with "Mr/Ms" field not null
6. Press Control + B on your Keyboard
7. In the Copied contact, select same "Mr/Ms" field value of that of Parent contact "Mr/Ms"
8. Provide First & Last Name
9. Press Control + S for saving contact
10. Should Display error message below:
- - -
[1] An error has occurred writing to a record.

Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111)
[2] ORA-06550: line 64, column 7:
PL/SQL: ORA-00957: duplicate column name
ORA-06550: line 44, column 2:
PL/SQL: SQL Statement ignored
- - -

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.