ORA-00947: not enough values" When Trying to Duplicate Existing Templates in R12.2+ (Doc ID 1906953.1)

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.

Symptoms

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

Changes

 Ugrade/Fresh Install of 12.2+

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