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
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
+6Hi,
for WIN_PROB = 100 % use 1 as value; for 20% = 0,2 etc..
KR
Hi
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
