If Base Language Different Than User Profile When SCC_USERREG_CREATEACCT Web Service Enabled, Get Error ORA-00957: Duplicate Column Name (Doc ID 2040201.1)

Last updated on OCTOBER 05, 2016

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.

Symptoms

When using Service Operation SCC_USERREG_CREATEACCT to create Peoplesoft users, along with multi language pack enabled and PSOPRDEFN_LANG used as related language record for PSOPRDEFN, the following error is encountered:

ERROR
-----------------------
ORA-00957: duplicate column name
  Statement: insert into psoprdefn_lang (oprid,oprdefndesc,LANGUAGE_CD, LANGUAGE_CD) VALUES (:1,:2,:3, :4).

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Configure Integration Broker.
2. Publish the web service SCC_USERREG.
3. Kick off the service operation SCC_USERREG_CREATEACCT.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot log in with new user profile account.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms