Skip to main content
Solved

ORDER_QUOTATION_LINE Migration Job


Forum|alt.badge.img+4

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

Best answer by Prabhath Sameera

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
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

Forum|alt.badge.img+4

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.


Forum|alt.badge.img+4
  • Author
  • Sidekick
  • 7 replies
  • June 22, 2021

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings