ORA-01722 Error Occurs When Running Relationship Search With Agile SDK Program
(Doc ID 2244023.1)
Last updated on JANUARY 24, 2024
Applies to:
Oracle Agile PLM Framework - Version 9.3.3.0 to 9.3.5.0 [Release 9.3]Information in this document applies to any platform.
Symptoms
When running Relationship Search with Agile SDK program developed using Agile API, below error occurs:
Error
ORA-01722: invalid number
Steps to Reproduce
- Login to Java Client as admin user, enable Document Subclass, name it as 'Test Case' (APIName: TestCase).
- Update Page Three tab name to 'Test Case Details', and enable List06 attribute. Add List(SimpleList), and create an list entry with value 'x'.
Also create a few more list entries. - Login to Web Client, and create a Part. Add word 'lemon' to Description Field.
- Goto Relationships tab, add a 'Test Case' object.
- Open the added 'Test Case' object. Update the Page Three.List 06 attribute value to 'x'.
- Create a few more parts by following the steps 3-5.
- Configure Relationship search with following criteria:
"[Relationships.Test Case.Test Case Details.List06] in 'x' And [TitleBlock.Description] Contains 'lemon'" - In Web Client, run Relationship search. Confirm that the result returns.
- Run sample SDK program with below code. Gets the error
Changes
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 |
Changes |
Cause |
Solution |
References |