TBS Utilities crashing with error ORA-01722 when processing Custom Attributes (Doc ID 1921136.1)

Last updated on FEBRUARY 22, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Symptoms

 When users run the TBS Utilities and try to process Custom Attributes:


Open TBS Utilities > Custom Attributes
     Click the New button
     Got the following error messages:

A database error has occurred. Please contact your support personnel
     Database error code: 1722
     Database error message:
     Select error: ORA-01722: número inválido

Error Number 39.
     Error text = Error accessing external object property value_label.
     Window/Menu/Object = w_customized_attributes.
     Script = pfc_postopen.
     Line in Script = 24.

The information entered does not pass validation and must be
     corrected before changes can be saved.
     Close without saving changes .... Yes

Error Number 21.
     Error text = Bad runtime function reference.
     Window/Menu/Object = w_customized_attributes.
     Script = pfc_postopen.
     Line in Script = 24.

... and system closes.


Any processing related to Custom Attributes causes the TBS Utilities to err and close.
Error messages or lack of may vary.

Cause

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