Overview:
There is an old saying that “You never realize what
you have until it’s gone”. In our Oracle HCM Cloud world, data is something
that it’s importance may not feel worthy today but it will be very much
precious after some years. In any organization, we all have certain reports
that if the same values respective to the dates are available then we could
have achieved something new today. There will be some values which we don’t
keep a track of or it is not been store well so the report data will be
dynamic. We can download the reports and save it in our local driver respective
to the dates. But what if I say that, Oracle provides you already a repository
where you can create your own custom folder with proper security type and store
all the files and even a report can also be created where you can download the
stored files.
Procedures:
Step 1:- Create a bursting query
Enter the below bursting details in your query –
TEMPLATE |
Report template name |
LOCALE |
en-US |
OUTPUT_FORMAT |
Output type - (xlsx) |
DEL_CHANNEL |
Content Server - (WCC) |
PARAMETER1 |
Content Server name - FA_UCM_PROVISIONED |
PARAMETER2 |
Security Group - FAFusionImportExport |
PARAMETER3 |
Author of the file to be shown in Content Server |
PARAMETER5 |
Title of the file |
PARAMETER6 |
Output File name |
PARAMETER9 |
Custom metadata (Optional) |
PARAMETER10 |
Folder path to deliver files |
Run the bursting query and the selected file will get stored to the
desired path mentioned in the query.
To download back – the stored files. The below query can be used.
Once the report is created, the files can be downloaded by a single click. As shown below –
Creds: Samarpan Das