My Oracle Support Banner

Inactivate The Supplier Contact User Account Gives Message ORA-01722: Invalid Number (Doc ID 1926762.1)

Last updated on MARCH 21, 2019

Applies to:

Oracle Supplier Lifecycle Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On Release 12.2.3 version, Supplier Profile Management

When attempting to inactivate the Supplier Contact user account from the 'Supplier Management Administrator' responsibility,
the following error occurs.

ERROR
You have encountered an unexpected error. Please contact the system administrator for assistance.

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)

STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Click on Contact Directory
2. Click on update icon for a contact
3. Select an inactive date in user account information
4. Click the Apply button - >>  Error is shown:
   You have encountered an unexpected error. Please contact the system administrator for assistance.


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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.