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.
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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
