My Oracle Support Banner

Querying A Price List Gives Error: ORA-01722: Invalid Number (Doc ID 2452370.1)

Last updated on SEPTEMBER 22, 2023

Applies to:

Oracle Advanced Pricing - Version 12.2.6 and later
Information in this document applies to any platform.


Problem Statement
When attempting to re-query a newly created Price List, the following error occurs.


ORA-1722: invalid number
FRM-40505: ORACLE error: unable to perform query.

Steps to Reproduce

  1. Login to Oracle Applications
  2. Go to Oracle Pricing Manager Responsibility
  3. Navigate to Price Lists > Price List Setup
  4. Create a Price List and Save
  5. Re-query the price list created. Above error appears on the screen.


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.