My Oracle Support Banner

ORA-01427 Error When Creating A Content (Doc ID 1274203.1)

Last updated on JULY 03, 2019

Applies to:

Oracle Content Manager - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Error when creating Content from Content type where multiple versions exists:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT a.attribute_type_name attributename, c.content_type_name ctypename , (SELECT d.content_item_name FROMibc_citem_versions_tl d WHERE d.citem_version_id = nvl(b.subitem_version_id, (select ci.live_citem_version_id from ibc_content_items ci where ci.content_item_id = b.content_item_id)) AND d.language = c.language) CITEMNAME,(SELECT e.version_number FROM ibc_citem_versions_b e WHERE e.citem_version_id=nvl(b.subitem_version_id, (select ci.live_citem_version_id from ibc_content_items ci where ci.content_item_id = b.content_item_id))) VERUSED,(SELECT f.version_number FROM ibc_citem_versions_b f,ibc_content_items g WHERE f.content_item_id=b.content_item_id

STEPS
--------
Log on to the Content Application
1 - Create new Content type = Content Block + submit
2 - Create a new version of the Content Block + submit
3 - Create a new Content Type using the new Content Block + submit.
4 - Create Content based on Content block from step 3 + submit -> error

Cause

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
Symptoms
Cause
Solution
References


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