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
Best answer by Prabhath Sameera
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,