Skip to main content

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

​@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).

 

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

Reply


Terms & ConditionsCookie settings