Customers Workbench: Getting Ora-01722 When Searching For AR Customers

(Doc ID 1384421.1)

Last updated on MARCH 02, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


Upgraded from 11i to 12.1.3.

Attempting to access customer through Customer Self-Service form and receive the following error:

Exception Details.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM
(select p.party_id, p.party_name, certification.meaning
certification_level_meaning ,registrystatus.meaning registry_meaning,p.status party_status
from hz_parties p, hz_party_sites ps, fnd_territories_vl terr,
fnd_lookup_values partytype, fnd_lookup_values certification
,fnd_lookup_values registrystatus
where p.party_type in ('PERSON', 'ORGANIZATION')
and registrystatus.lookup_code = p.status
and ps.party_id(+) = p.party_id
and ps.identifying_address_flag(+) = 'Y'
and terr.territory_code(+) =
and partytype.view_application_id = 222
and partytype.lookup_type = 'PARTY_TYPE'
and partytype.language = userenv('LANG')
and partytype.lookup_code = p.party_type
and certification.view_application_id(+) = 222
and certification.lookup_type(+) = 'HZ_PARTY_CERT_LEVEL'
and certification.language(+) = userenv('LANG')
and certification.lookup_code(+) = p.certification_level
and registrystatus.lookup_type = 'HZ_CPUI_REGISTRY_STATUS'
and registrystatus.language = userenv('LANG')) QRSLT WHERE (party_type =
'&PARTY_TYPE' and party_status='A' and exists
( select null from HZ_CUSTOMER_PARTY_FIND_V hpfv where hpfv.org_per_number
= qrslt.party_number and hpfv.CUSTOMER_NUMBER = '&CUSTOMER_NUMBER' ))
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-01722: 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