Skip to main content
Question

FNDMIG Error on migrating Sales Quotation Lines-IFS 24R2

  • March 10, 2026
  • 3 replies
  • 21 views

Forum|alt.badge.img+2

Hi all,

I am getting below error when migrating data to ORDER_QUOTATION_LINE using FNDMIG job.

Even when there is a value assigned to the field ‘BASE_SALE_UNIT_PRICE’ i get this error.

Have you experienced this before?

Any ideas or thoughts on how to resolve this would be much appreciated!

“ORA-01407: cannot update ("LORA1APP"."ORDER_QUOTATION_LINE_TAB"."BASE_SALE_UNIT_PRICE") to NULL”

 

Thank you!

Disna M.

3 replies

Fikret
Do Gooder (Employee)
Forum|alt.badge.img+3
  • Do Gooder (Employee)
  • March 10, 2026

Hey Disna,

at first glance, I would have said that in your mapping, the field is either not mapped or the source field is empty. But you say there is already a value in it.

Otherwise, I would open the method list attributes in the method list and check the relevant field.


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Partner)
  • March 11, 2026

@Fikret Thanks for the reply!

Here is the Method List Attributes for the BASE_SALE_UNIT_PRICE.

Do you think  the Flags should be modified?

 

Thank you!

Disna M


Fikret
Do Gooder (Employee)
Forum|alt.badge.img+3
  • Do Gooder (Employee)
  • March 11, 2026

YOu can try it. So deactivate the on modify and run the Job again.
But I would say it should remain, so that the field can be updated.
ANd you have to ansure that you hava value other than NULL in your legacy file.