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 JULY 10, 2020

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:

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

 


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.

 

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.