My Oracle Support Banner

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

Last updated on MARCH 26, 2019

Applies to:

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


When Running Advanced Search using Multitext the following error occurs.

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

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

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


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.