My Oracle Support Banner

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 FEBRUARY 03, 2019

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

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.