WIP Move Transaction Worker (WIP_MOVPROC_PRIV.MOVE_WORKER) Failing After Upgrade
(Doc ID 2652094.1)
Last updated on MARCH 27, 2020
Applies to:Oracle Work in Process - Version 12.2.8 and later
Information in this document applies to any platform.
WIP Move Transaction Worker. (WIP_MOVPROC_PRIV.MOVE_WORKER) failing with ORA-06502: PL/SQL: numeric or value error: character to number conversion error after upgrade from 12.2.5 to 12.2.8. After checking fnd_concurrent_requests we found a parameter argument1 (representing p_group_id) is being called with decimal values, e.g. 15675453.000000. Before upgrade, this value would be 15675453 and it would work fine.
Please note: decimal separator in our territory and thus in our system is comma (,) and not dot (.). This is probably why it is failing when calling wip_movproc_priv,move_worker. There is p_group_id number there. We assume the problem is in wictms.ppc.
WIP Move Transaction Worker. (WIP_MOVPROC_PRIV.MOVE_WORKER) Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1.
1. Running WICTWS concurrent program.
2. The above error is found in the concurrent log.
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