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
Hi IFS Community,I am a new bee to IFS, appreciate all the help that I get from IFS community :).To give brief details about the task I am working around -Creating a new event/ event action to check for ext_inc_inv_head_tab.Invoice_recipient (External supplier invoices table column - Invoice_recipient). if the ext_inc_inv_head_tab.PO_REFERENCE column has one or more purchase order numbers and the ext_inc_inv_head_tab.Invoice_recipient column value is null or * , then look for buyer_code using PURCHASE_ORDER_API.GET_BUYER_CODE(ORDER_NO). Get the buyer_code (first value only if multiple Po exists) and update ext_inc_inv_head_tab.Invoice_recipient value with PURCHASE_ORDER_API.GET_BUYER_CODE(ORDER_NO) value. points to note here is - if already valid name exists in ext_inc_inv_head_tab.Invoice_recipient column then dont need any changes, if Invoice_recipient is null or * then it should be updated with first available buyer_code value.I did some work around PLSQL script that works well
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.