When Creating New Entity with Entity Type of Read-Only, Get BRON Generic Stats SQL Rollback Error in Entity View in Non-Base Language (Doc ID 2124149.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 trying to create and save a non-complete entity view when logged in with non-base language, the following error is encountered:

ERROR
-----------------------
COM Stmt=INSERT INTO PS_SCC_ENTITY_VW_L(SCC_ENTITY_ID,SCC_ENT_VIEW_ID,LANGUAGE_CD,SCC_ENT_VIEW_NAME,SCC_ENTITY_DESCR) VALUES(:1,:2,:3,:4,:5)
Bind-1 type=2 length=25 value=SCC_ENTITY_20141215104742
Bind-2 type=2 length=24 value=SCC_EVIEW_20150306180132
Bind-3 type=2 length=3 value=ENG
Bind-4 type=2 length=7 value=compact
Bind-5 type=2 length=7 value=compact
Rollback

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login in other than base language.
2. Navigate to Set Up SACR > System Administration > Entity > Entity Registry and create new entity with Entity Type 'Read Only' and save it.
3. After saving, select action Edit Entity View and insert a new row. Enter Entity View Name and choose a subset of fields available to be viewable.
4. Click OK twice and Save.

BUSINESS IMPACT
-----------------------------------
The issue has the following business impact:
Due to this issue, users cannot implement feature to allow Generic Stats to be exchanged with the Dutch Governement (Baseregister, BRON).

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