My Oracle Support Banner

ORA-01722 Error Occurs When Running Relationship Search With Agile SDK Program (Doc ID 2244023.1)

Last updated on MAY 19, 2020

Applies to:

Oracle Agile PLM Framework - Version to [Release 9.3]
Information in this document applies to any platform.


When running Relationship Search with Agile SDK program developed using Agile API, below error occurs:


ORA-01722: invalid number

Steps to Reproduce

  1. Login to Java Client as admin user, enable Document Subclass, name it as 'Test Case' (APIName: TestCase).
  2. 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.
  3. Login to Web Client, and create a Part. Add word 'lemon' to Description Field.
  4. Goto Relationships tab, add a 'Test Case' object.
  5. Open the added 'Test Case' object. Update the Page Three.List 06 attribute value to 'x'.
  6. Create a few more parts by following the steps 3-5.
  7. Configure Relationship search with following criteria:
    "[Relationships.Test Case.Test Case Details.List06] in 'x' And [TitleBlock.Description] Contains 'lemon'"
  8. In Web Client, run Relationship search. Confirm that the result returns.
  9. Run sample SDK program with below code. Gets the error  




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.