We have the same requirement. We have an invoice description that contains critical references that we need to display in separate columns. The invoice description is one column in OTBI. How do we get it to separate out into a column per data item as separated by commas.

We experience this limitation as well and would welcome a way of increasing the limits.

Oh you guys are good...

Hi All, Can I ask if you agree with this, can you put a thumbs up at the top of the page so oracle will take it forward for us please? 😁 Thanks Dawn

I just did but it didnt list the parameters which is what i need as well. We have to replicate them in the DEV environments each time they are refreshed however it is difficult to see what parameters are against each process and a report would really help. Thanks Dawn

This has caused multiple problems for us as well including processes not running; notifications not being issued and interfaces not working

When it gets into Excel, you have to click Wrap Text button after highlighting all data to remove this and then you can manipulate your data

Hi Venkat, Thank you for the suggestion which did place a ranking against the records however it has ranked the latest one as number 1 lol which means I would need to find the highest number rather than all the 1's. I have tried the filter to the last 1 however it then only brings back one record for one person rather than…

Hi Richard, Thank you for the suggestion as it does have the SA name in it. I am sure it will help. Dawn

HI both Thank you for your responses. I don't have access to the table you mention Richard, but I appreciate the thought. Kind regards Dawn

Hi Amrita, Thank you for the solution as I do think it will work once I get my reports to accept the filter on the ranking. I will let you know one way or the other but thank you for the work. Kind regards Dawn😊

Hi Amrita, What the screenshot doesnt show is that there is a prompt for the periods covered which narrows the fields down to include others. It is not showing the full 10 plus other as displayed in the top table. Thanks Dawn

Hi Gaurav I have tried the solutions however neither worked. Any further ideas please? Dawn