My Oracle Support Banner

Import Performance: Create Index To Update OZF_ORDER_GROUP_PROD Set Last_Update_Date (Doc ID 2388785.1)

Last updated on MARCH 28, 2019

Applies to:

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

Symptoms

On : 12.2.5 version, Transaction Entry

When attempting to run Order Import Process the following error occurs.

ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character to number conversion error

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Reports, Request
3. Run > Order Management
4. Observe: ORA-06502: PL/SQL: numeric or value error: character to number conversion error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot determine why this is causing an issue with the OZF Table.

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.