Solved

ORDER_QUOTATION_LINE Migration Job

  • 22 June 2021
  • 2 replies
  • 64 views

Userlevel 2
Badge +2

hello 

i have this error when starting my job 

“Insert into ORDER_QUOTATION_LINE_TAB failed - ORA-20124: Error.NULLVALUE: Field [PROBABILITY_TO_WIN] is mandatory for Order Quotation Line and requires a value. (Error caused by line: 2)

PROBABILITY_TO_WIN is not null in my file  and i also try to give default value but still have error

plz help

icon

Best answer by Prabhath Sameera 22 June 2021, 12:17

Hi TAHER

Please check for a column called “line item no” which is set as the ‘1’ in the provided CSV file.
The line item no should be set as ‘0’ for the non-package part. 
Once you set the line item no as ‘0’ it should work for Execute job.

If you set it as ‘1’ then code search the package component logic and it can’t find the 
PROBABILITY_TO_WIN attribute value which is mandatory for Order Quotation Line.
 
Please check this works for you.

Thanks & Regards,
Sameera.

View original

2 replies

Userlevel 3
Badge +3

Hi TAHER

Please check for a column called “line item no” which is set as the ‘1’ in the provided CSV file.
The line item no should be set as ‘0’ for the non-package part. 
Once you set the line item no as ‘0’ it should work for Execute job.

If you set it as ‘1’ then code search the package component logic and it can’t find the 
PROBABILITY_TO_WIN attribute value which is mandatory for Order Quotation Line.
 
Please check this works for you.

Thanks & Regards,
Sameera.

Userlevel 2
Badge +2

thnx to answer 

that error pass but now “SINGLE_OCC_ADDR_FLAG”  raise error but i cant find this field in file mapping  section 

will u help me plz

Reply