Error "ORA-01438: Value Larger Than Specified Precision" When Attempting To Share Cart (Doc ID 563469.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle iStore - Version 11.5.10.2 to 12.1.1 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
"Checked for relevance on 29-Mar-2011"


Symptoms

On iStore, when trying to share a cart or Quote with other users, it errors out with the following message:

Exception: ORA-01438: value larger than specified precision allowed for
this column dans la procédure SAVERECIPIENTS_V2 du package
IBE_QUOTE_SAVESHARE_V2_PVT
oracle.apps.jtf.base.resources.FrameworkException: ORA-01438: value
larger than specified precision allowed for this column dans la
procédure SAVERECIPIENTS_V2 du package IBE_QUOTE_SAVESHARE_V2_PVT


ERROR
Exception: ORA-01438: value larger than specified precision allowed for
this column dans la procédure SAVERECIPIENTS_V2 du package
IBE_QUOTE_SAVESHARE_V2_PVT
oracle.apps.jtf.base.resources.FrameworkException: ORA-01438: value
larger than specified precision allowed for this column dans la
procédure SAVERECIPIENTS_V2 du package IBE_QUOTE_SAVESHARE_V2_PVT

Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Logged into iStore Customer UI as a user.
2. Clicked on a site
3. Added an item to cart.
4. Click share Cart button to Share the Cart from the Shopping cart page.
get error

Business Impact:
Due to this issue, users cannot share cart.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms