Skip to main content
Solved

Sales Contract Migration Error

  • Jun 10, 2026 6:46 AM UTC
  • 2 replies
  • 59 views
Hero (Partner)
Forum|alt.badge.img+11

Getting an Error when migrating Sales Contract Header. 

Insert into SALES_CONTRACT_TAB failed - ORA-20110: SalesContract.CONWINPROBERR: Win Probability must be within the range 0 - 100. (Error caused by line: 26)

PLANNED_START_DATE=2006-04-17-00.00.00
PLANNED_FINISH_DATE=2027-04-01-00.00.00
WIN_PROB=100
CUSTOMER_ID=XYZ

Am i missing anything?

Best answer by Makede

Hi ​@FPayab 

the value for field WIN_PROB must be between 0 and 1
While the value is shown in the client as percentage value, it will be saved as absolute value in the database

Here you can see an example. In the client you have a win probability of 100%. But in the database the field WIN_PROB has the value 1

So please try with value 1 instead of 100

Best regards
Martina
 

 

View original

2 replies

FlorianTauber
Hero (Partner)
Forum|alt.badge.img+6
  • FlorianTauber
  • Hero (Partner)
  • Jun 10, 2026 6:52 AM UTC

Hi, 

for WIN_PROB = 100 % use 1 as value; for 20% = 0,2 etc..

KR

Regards, Florian from FLEXiCODE
    Hero (Employee)
    Forum|alt.badge.img+12
    • Makede
    • Hero (Employee)
    • Answer
    • Jun 10, 2026 6:58 AM UTC

    Hi ​@FPayab 

    the value for field WIN_PROB must be between 0 and 1
    While the value is shown in the client as percentage value, it will be saved as absolute value in the database

    Here you can see an example. In the client you have a win probability of 100%. But in the database the field WIN_PROB has the value 1

    So please try with value 1 instead of 100

    Best regards
    Martina
     

     

      Terms & ConditionsAccessibility statement