R12 - XML Publisher Data Definition JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO XDO_DS_DEFINITIONS_VL (Doc ID 1570873.1)

Last updated on MAY 05, 2017

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On Oracle Applications R12


When attempting to create new data definition via 'XML Publisher -> Data Definition',
the following error occurs:

 oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO XDO_DS_DEFINITIONS_VL(APPLICATION_SHORT_NAME,DATA_SOURCE_CODE,DATA_SOURCE_STATUS,START_DATE,DATA_SOURCE_NAME,DESCRIPTION,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12)".
...
...
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01779: cannot modify a column which maps to a non key-preserved table


The issue can be reproduced at will with the following steps:
1. Migrate EBS R12 from Solaris platform to Linux-x86 platform.
2. Create a new data definition via 'XML Publisher -> Data Definition'.
3. The error is produced.

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