My Oracle Support Banner

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

Last updated on SEPTEMBER 24, 2023

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.


 Upgrade/Fresh Install of 12.2+


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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