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 MAY 08, 2023

Applies to:

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

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