Supply Chain Management - PSFT (MOSC)

MOSC Banner

Question regarding Price Tolerances

edited Sep 4, 2019 5:00AM in Supply Chain Management - PSFT (MOSC) 3 commentsAnswered

What is the difference between having a Unit Price Tolerance of 99999999.99999 vs 99999999.00000?  We've come across issues where if an item's tolerance is 99999999.0000 it will cause PO_POCREATE to go to No Success, but when updated to 99999999.99999 it runs successfully.  Would like to know what the difference is.  Thanks for any information!

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2/LINUXX8664] SQL0413N Overflow occurred during numeric data type conversion. SQLSTATE=22003

(SQLSTATE 22003) -413

Failed SQL stmt: UPDATE PS_PO_POB_SHP_T5 SET UNIT_PRC_TOL_BSE = ROUND(((((MULTIPLY_ALT(UNIT_PRC_TOL_BSE, RATE_MULT))) / ( RATE_DIV))), 5) WHERE PROCESS_INSTANCE = 15024 AND UNIT_PRC_TOL_BSE <> 99999999.99999

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

PSFT SCM Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center