Skip to main content
Question

Mig job - Org units error

  • Nov 14, 2024 10:35 AM UTC
  • 5 replies
  • 104 views

Forum|alt.badge.img+6

HI, I have been trying to migrate data into the Organisation Units screen and im getting the below error, even though it has a value in the temp table. 

ORA-20124: Error.NULLVALUE: Field [SUP_ORG_CODE] is mandatory for Company Org and requires a value.

 

select * FROM IFSAPP.IC_BTG_ORG_UNIT_LOAD_TAB

 

Please help?

Thanks

Stacy

5 replies

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • Nov 14, 2024 1:35 PM UTC

​@SPierpoint Stacy, can you also show a screenshot of the Source Mapping? Just to make sure that SUP_ORG_CODE is mapped correctly.

It would be also usefull to show the line in the Execute Migration Job → the one that throws the error (for this you need to make sure you didn’t activate the delete errors rule).


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Customer)
  • Nov 14, 2024 1:42 PM UTC

 


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Customer)
  • Nov 14, 2024 1:43 PM UTC

Its worth noting when adding the detail to the method list, the source mapping populates automatically, but it did not include this field, even though its mandatory which i don’t understand. I added it in and have made so many different changes to the field to test it but it still doesnt recognise it. 

Thank you for your help


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Customer)
  • Nov 19, 2024 9:57 AM UTC

Does anyone have an answer to this? thank you

 


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Customer)
  • Nov 19, 2024 9:59 AM UTC
sorry thought i had pasted this..