My Oracle Support Banner

Hold Source Activity Report ORA-01722: invalid number (Doc ID 2054383.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, Transaction Control


OEXOHHSA module: Hold Source Activity Report has errored out.

ERROR
-----------------------
Enter Password:
ORA-01722: invalid number
==> select ht . meaning hold_type , hs . creation_date apply_date , hr . creation_date release_date , h . name hold_name , hs . hold_entity_code object_type_code , ot . meaning object_type , hs . hold_entity_code2 object_type_code2 , ot2 . meaning object
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: invalid number
==> select ht . meaning hold_type , hs . creation_date apply_date , hr . creation_date release_date , h . name hold_name , hs . hold_entity_code object_type_code , ot . meaning object_type , hs . hold_entity_code2 object_type_code2 , ot2 . meaning object




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run OEXOHHSA module: Hold Source Activity Report

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use this report.

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.