R12 - XML Publisher Data Definition JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO XDO_DS_DEFINITIONS_VL
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.
On Oracle Applications R12
When attempting to create new data definition via 'XML Publisher -> Data Definition',
the following error occurs:
## 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.
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