ORA-00904: "A"."MULTITEXT31": INVALID IDENTIFIER; When Running Advanced Search Using Multitext (Doc ID 2221084.1)

Last updated on JUNE 05, 2017

Applies to:

Oracle Agile Product Collaboration - Version 9.3.4.0 and later
Information in this document applies to any platform.

Symptoms

When Running Advanced Search using Multitext the following error occurs.

ERROR
-----------------------
ORA-00904: "A"."MULTITEXT70". invalid identifier

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
(Make sure you have the following setup in Java Client)
1. Log on to Java Client with admin rights
2. Select the Admin tab> Data Setting> Classes
3. Select Change Orders class, set Enabled to Yes
4. Select User Interface Tabs
5. Double Click Page Two, make sure Visible Yes
6. Double Click MultiText31, set Visible Yes

(Web Client Advance Search)
7. Log on to Web Client
8. Create an advance Search
9. Search Criteria: Changes, ECO, Object Search
10. Attribute: Approver Action Operator: Contains Value: Approved Join: Add
11. Attribute: MultiText31 Operator: Does Not Contain Value: xx
12. Click on Search button

Receive error: ORA-00904: "A"."MULTITEXT31": invalid identifier

change Operator to: ( receive the same error )
13. Attribute: MutiText31 Operator: Does Not Start With Value: xx

change Operator to: ( receive the same error )
14. Attribute: MutiText31 Operator: Not Like Value: xx

Receive error: ORA-00904: "A"."MULTITEXT31": invalid identifier

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run advanced search

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