@Disna Marakkala , I'm suspecting that the issue with your DAY_SCHED_CODE value, you can insert/update record with the DAY_SCHED_CODE = C but when it comes to B, it gives you error on both insert/update, so it may be the limitation or business error that you can communicate with the product team.
Yes @Disna Marakkala , you may need to pass something related to FLAG.
Hi @stbjno , there is not limitation on number of rows in Excel Add-in.
Hi Disna, it seems like when you are updating the record some business error throws, so it is not related to the DMM tool. Please check with the date interval between VALID_FROM and VALID_TO and the DAY_SCHED_CODE. It seems you are trying to update wrong DAY_SCHED_CODE value between the given time intervals. Try to insert a record with the DAY_SCHED_CODE = B with these date intervals. You may get error when you are trying to insert this record as well.
You are welcome @Johannes Kopfer
If fetch condition is necessary, then you can keep that. but the CFV method should be like this to do the update.
So , could you please try by set the action as ‘Inloop’ and try to update a record?
As I checked, the fetch condition is not necessary and also for the CFV method, you selected the action as ‘NoExecution’. So may I know what is the purpose for it?
Have you done the configuration for the CFV method in the method list attributes?
In the above screenshots what is the custom field that you are trying to update?
As we checked, there may be some error with your environment database characters. If you have access to the database, please run this and check whether if you get this kind of value. SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER = 'NLS_NUMERIC_CHARACTERS'
Ok, we will check and get back to you. and also, can you please let us know which version of that environment?
so, you mean you could see this issue only one environment, right?
Hi Jascoetsee, As I checked your project basic data setup, seems there are no issues with your setup, and I could see that you are creating a project header based on a template project. Can I see your template project as well?
Hi,Thousand separator is automatically added when you are defining the installed environment. Can you please share your project basic data setup? and the steps you followed to define the installed environment?
Hi CherylLaus, any updates on it?
Nirogini, Is this a requirement in DMM? Not all files are linked by fields named the same so this seems an odd requirement? It seems an requirement, can you try that and let me know?
'Entity id(new)' is the name of the key field on your legacy table 2 definition, and 'Entity id' is the name of the key field on your legacy table 3 definition. It appears that the key field names in this case are mismatched. Could you try by changing the names as same name before attempting to transfer the records to the input container?
Can you share your mapping?
Can you provide the steps that you followed for joining the legacy tables? better with some screen shots?
Hello Disna, I looked at the specific situation you mentioned here on 23R1, but it appears to be working fine for me. Please try again, and if the issue still exists, could you add the steps you followed?
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.