Skip to main content
Question

Mig job - Org units error

  • November 14, 2024
  • 5 replies
  • 39 views

Forum|alt.badge.img+4

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)
  • 1142 replies
  • November 14, 2024

@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+4
  • Author
  • Do Gooder (Customer)
  • 9 replies
  • November 14, 2024

 


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • 9 replies
  • November 14, 2024

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+4
  • Author
  • Do Gooder (Customer)
  • 9 replies
  • November 19, 2024

Does anyone have an answer to this? thank you

 


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • 9 replies
  • November 19, 2024
sorry thought i had pasted this..
 

 


Reply


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