ORA-00947: not enough values" When Trying to Duplicate Existing Templates in R12.2+
Last updated on DECEMBER 20, 2016
Applies to:BI Publisher (formerly XML Publisher) - Version 12.2 to 12.2 [Release 12.2]
Information in this document applies to any platform.
On Oracle Applications 12.2.1 version, Bills/Routings Reports,
when attempting to create a duplicate template of the f '‘Standard Operation Report (XML)’ from payment administrator, the following error occurs:
java.sql.SQLSyntaxErrorException: ORA-00947: not enough values
The issue can be reproduced at will with the following steps:
1. (XML Publisher Administrator -> Home -> Templates).
2. Search for any existing template (for example search with Code as PAYUS%).
3. Of the Templates fetched, try to Duplicate one of them.
4. Try to save the Copy of template details by pressing Apply.
The issue has the following business impact:
Due to this issue, users cannot create a duplicate template of an existing template
Ugrade/Fresh Install of 12.2+
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