My Oracle Support Banner

WIP Mass Load Completes In Warning When ICX: Numeric Characters Is Set To 10.000,00 (Doc ID 2798391.1)

Last updated on NOVEMBER 21, 2022

Applies to:

Oracle Work in Process - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.10 version,

When running WIP Mass Load program observe the program is ending in warning. The program performs the role of importing the data properly.

Expect not to see the warning.

What is working
-----------------------
If profile ICX: Numeric characters is set to 10,000.00 format there is no warning
If profile ICX: Numeric characters is set to 10.000,00 format there is warning

Program log shows
-----------------------
For warning the program log shows
Enter Password:
ORA-01722: invalid number
select wjsi . source_code , nvl ( ood . organization_code , wjsi . organization_code ) organization_code , wjsi . job_name job_name , ml3 . meaning job_type , nvl ( MSI.SEGMENT1 , ' ' ) description , msi . inventory_item_id , wjsi . start_quantity ,
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: invalid number
select wjsi . source_code , nvl ( ood . organization_code , wjsi . organization_code ) organization_code , wjsi . job_name job_name , ml3 . meaning job_type , nvl ( MSI.SEGMENT1 , ' ' ) description , msi . inventory_item_id , wjsi . start_quantity ,


The issue can be reproduced at will with the following steps:
1. [R] Manufacturing and Distribution Manager
2. Run WIP Mass Load program
3. observe behavior


Changes

 

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
Changes
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.