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 laterInformation 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 |