We’re trying to get the migration done and we have an structure like this as a CSV:CSV - source fileAfter we finish the first job which is the creation of the table with this data, there’s no error. The error comes after we execute the second job which is the one that migrates data, I get this error:ORA-20124: Error.NULLVALUE: Field [BUSINESS_UNIT_ID] is mandatory for Business Unit Relation and requires a value. Here is what’s been done:To test we only try to migrate one of the rows, the one with POS_CODE=’50000008’ The attribute string we get is: COMPANY_ID=ABCPOS_CODE=50000008POSITION_TITLE=ASSISTANT MANAGERVALID_FROM=2023-06-22-21.29.22VALID_TO=9999-12-31-00.00.00TIME_FORMAT=Minute by minuteASSIGNED_PROTECTED=FALSEEXCLUDE_FROM_EXPORT=FALSEEXCLUDE_FROM_ORG_CHART=FALSEDEFAULT_ACCESS_EXTENSION=FALSEEXPORT_EMPLOYEES=FALSESTRUCT_BU_ID=781BUSINESS_UNIT_TYPE_DB=COMPANY Here the job execution that throws the error: and the migration job is defined like this:
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.