Bill Presentment Architecture (BPA) Line View (ARBPA_CUSTOMER_TRX_LINE) Giving ORA-01722: Invalid Number Error

(Doc ID 1681282.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Bill Presentment Architecture - Version 12.1.3 and later
Information in this document applies to any platform.


Seeded Line BPA view is not displaying the data, even there is data present for many invoices.
It continues to run a long time, then returns no rows.

When you set the Org Context, before running, you recieve the following error:

ORA-01722: invalid number
01722. 00000 - "invalid number"


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