Lets discover on find out how to extract cell
notes and attachments from Oracle Cloud EPM utilizing Groovy
scripting.
This weblog walks via retrieving Entity and Value Heart descendants, querying
monetary information, and figuring out cells
with notes or file attachments.
The script dynamically iterates via every mixture,
hundreds a information
grid, and logs key findings after discovering the cell Notes and Attachment if any.
Suppression guidelines guarantee environment friendly execution, whereas
error dealing with prevents failures. Best for auditing monetary information and making certain compliance.
CAUTION NOTE : Works nicely for a small set of information, not an excellent answer for big database.
What
The Script Does?
- Retrieves
all descendant entities and price facilities.
Queries monetary information for every mixture.- Extracts notes and attachments from monetary information.
- Logs vital findings for assessment.
- Handles errors gracefully with out stopping execution.
Retrieve All Entity Descendants & All Value Heart Descendants:
Finds
all descendants of Complete Entity utilizing the IDescendants()
perform.
The
technique getEvaluatedMembers(expression, dice) dynamically retrieves members
primarily based on the dice’s construction.
Instance
output for Entity:
If Complete Entity has two predominant sub-entities
entityDescendants
= [“Entity_A”, “Entity_B”, “Entity_C”, …]
Instance
output for Value Heart :
costCenterDescendants
= [“CC_1001”, “CC_1002”, “CC_1003”, …]
Iterating
By way of Entities and Value Facilities
Loop
Over Every Entity
Iterates
over every entity retrieved earlier & Logs the entity being
processed.
Loop
Over Every Value Heart
Iterates
via every price heart for the present entity. This leads to Entity
× Value Heart mixtures being processed.
Querying
the Knowledge for the Present Entity and Value Heart
setPov(…) → Defines static members
for the question.
- Situation: ‘Forecast’
- Model: ‘Working’
- Yr: ‘FY25’
- Different
metadata picks like ‘FY25’, ‘EIC_999’, and so forth.
addColumn(…) → Defines dynamic
columns for the question.
- Contains entity
and costCenter, permitting information retrieval per mixture.
addRow(‘ILvl0Descendants(Internet Earnings)’)
→ Retrieves all level-0 accounts underneath “Internet Earnings”.
Suppression Settings → Guarantee lacking
or invalid information does not break execution.
Supported suppression strategies –
Processing
the Retrieved Knowledge
The question outcomes are saved in a grid
object.
dataCellIterator() iterates via all
information cells retrieved.
If a cell isn’t empty, it checks for:
- Cell
Notes
(feedback left on a cell) - Attachments (recordsdata
uploaded within the kind)
If notes or attachments exist, they’re logged
for assessment.
This prevents one unhealthy entity or price heart from stopping the complete execution.
If an error happens, the script logs the difficulty and continues
processing different members.
Confirms
the script has efficiently iterated via all entity-cost heart
mixtures.
The whole script is right here.
Logs from the rule right here,
The Rule logs the pov the place the Cell Word and Attachment is discovered.
Hope this was helpful, comfortable days within the Cloud!!!
