OBIEE 12C Delivery Attachment Note

Question

Hi, I'm new to OBIEE. I have to add the yellow highlighted disclaimer to over 300 ibot agents e-mail attachment notes. Is there any way to bulk update them via updating any XML file or DB tables? I have already checked S_NQ_JOB & S_NQ_JOB_PARAM but they do not have the "attachment note" content shown anywhere. Any help would be highly appreciated.

Pranyt · Answer

https://community.oracle.com/tech/apps-infra/discussion/comment/16806545#Comment_16806545

Thank you very much.

Gianni Ceresa · Answer

That piece of text is stored inside the agent in the catalog. You should find it if you read the XML of the agent.

Catalog Manager does have a search & replace option, just keep in mind there isn't an "undo" function: once you did replace something, it's replaced. This means you should take a backup of your backup of your catalog first, because you never know ....