Hi .. I was trying to set-up new migration job to update CUSTOMER_INFO_ADDRESS View for changes in address and postcode values. This supposed to update around 17000+ records so i choose to use Procedure “INSERT_OR_UPDATE” from csv file.As soon as i run the job i am getting below error. I did investigated further into this and noticed actual issue is - Address column value holds multiple comma seperators, which seems to be root cause of this. Is there any way i can mitigate this issue without removing extra commas from address value ? if i add double quotes around this column value, do you think this will insert double quotes also in data ?double quotes Start time - 19-JAN-2024 11:13:18 CS_SJCB_POSTCODE_CHANGE_MIG - Execution No 0 Insert into CUSTOMER_INFO_ADDRESS_TAB failed - ORA-20111: CustomerInfo.FND_RECORD_NOT_EXIST: The Customer Info does not exist. (Error caused by line: 2)File Path: DATAMIG (F:/DATAMIG2)File Name: CS_SJCB_POSTCODE_CHANGE_test2.csvFile Location: OnServerChar S
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.