Error Creating Supplement History Information for Access Service Request (ASR) Order; java.sql.SQLException: ORA-01403: no data found ORA-06512: at "ASAP.SP_INSERT_ASR_SUPPHISTORY" (Doc ID 2165808.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

MetaSolv Solution version 6.2.1.1005.b6 running with ASR version ASR 52.0.0.b29

An "ORA-01403: no data found" error is received while creating the Supplement History information for an ASR order.  Evidence of the problem is logged in appserverlog.xml file, but not in the ${SERVER_NAME}.mss.log or appserverlog_ASR52.xml files.  Below are images of the errors as well as its text.

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