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 NOVEMBER 22, 2019

Applies to:

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

Changes

Cause

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