Error JBO-27122 When Trying To Add An Item To Existing New Item Request (NIR)

(Doc ID 1603802.1)

Last updated on APRIL 02, 2018

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Oracle Engineering - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem

Create New Item Request on single item has option to create new NIR or Add to existing NIR. If Add to Existing NIR option is chosen, unable to specify the NIR name. An exception is raised with a message oracle.jbo.SQLStmtException: JBO-27122.

Error

JBO-27122: SQL error during statement preparation.

Statement:SELECT *
FROM
(SELECT change_notice,
change_name,
change_mgmt_type_code,
change_id,
eec.organization_id,
status_type,
approval_status_type,
change_id AS allowed_chg_id,
change_order_type_id,
oav.organization_code,
status_code
FROM eng_engineering_changes eec,
org_access_view oav
WHERE eec.organization_id =oav.organization_id
AND oav.responsibility_id = fnd_profile.value('RESP_ID')
AND oav.resp_application_id = fnd_profile.value('RESP_APPL_ID')) QRSLT
WHERE (change_mgmt_type_code = :1
AND EXISTS
(SELECT 1
FROM eng_change_subjects ecs
WHERE ecs.change_id =QRSLT.change_id
AND change_line_id IS NOT NULL
AND entity_name ='EGO_CATALOG_GROUP')
AND change_order_type_id = :2
AND pk1_value = :3);
AND ( UPPER(CHANGE_NOTICE) LIKE UPPER(:4)
AND (CHANGE_NOTICE LIKE :5 OR CHANGE_NOTICE LIKE :6 OR CHANGE_NOTICE LIKE :7 OR CHANGE_NOTICE LIKE :8)
AND ORGANIZATION_ID = :9 ))

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

Steps

The issue can be reproduced at will with the following steps:
1. Create an Item and try to Add to existing NIR

Changes

 

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