Dayalan Punniyamoorthy Blog

ラベル Data Auditing の投稿を表示しています。 すべての投稿を表示
ラベル Data Auditing の投稿を表示しています。 すべての投稿を表示

2025年1月30日木曜日

Extracting Notes and Attachments from Cells in Oracle Cloud EPM Using Groovy!

Lets explore on how to extract cell notes and attachments from Oracle Cloud EPM using Groovy scripting. 



This blog walks through retrieving Entity and Cost Center descendants, querying financial data, and identifying cells with notes or file attachments.

The script dynamically iterates through each combination, loads a data grid, and logs key findings after finding the cell Notes and Attachment if any. 

Suppression rules ensure efficient execution, while error handling prevents failures. Ideal for auditing financial data and ensuring compliance.