alfredorz
Reputable Poster
Hi JDE Friends,
I'm reaching out regarding an issue encountered when Receipt Routing PO (P43250) where sometimes the lines do not close to status 999 as expected. We have IBM Db2 database.
In the debug log, we've identified that the issue lies with is for user decimal separator configuration. When the user has a comma (",") configured as their decimal separator, as SELECT SQL operation fails with the error "Numeric value out of range". However, when the decimal separator is set to a dot, works fine.
We are on version 9.2.6.3 tools, we've come across Bug 18686466 in Oracle Support, titled "Multiple Partial Receipts (P4312) and Incorrect Purchase Order Status (Doc ID 1677865.1)". However, after update tools, the problem persists.
As a temporary workaround, we've been execute a database update, I'm considering implementing an Orchestrator solution with LEX to address this issue more efficiently.
I would greatly aprpreciate any insights or suggestions on how to resolve this issue.
Thanks a lot!
Best regards.
I'm reaching out regarding an issue encountered when Receipt Routing PO (P43250) where sometimes the lines do not close to status 999 as expected. We have IBM Db2 database.
In the debug log, we've identified that the issue lies with is for user decimal separator configuration. When the user has a comma (",") configured as their decimal separator, as SELECT SQL operation fails with the error "Numeric value out of range". However, when the decimal separator is set to a dot, works fine.
We are on version 9.2.6.3 tools, we've come across Bug 18686466 in Oracle Support, titled "Multiple Partial Receipts (P4312) and Incorrect Purchase Order Status (Doc ID 1677865.1)". However, after update tools, the problem persists.
As a temporary workaround, we've been execute a database update, I'm considering implementing an Orchestrator solution with LEX to address this issue more efficiently.
I would greatly aprpreciate any insights or suggestions on how to resolve this issue.
Thanks a lot!
Best regards.