My Oracle Support Banner

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 DECEMBER 20, 2019

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

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


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