Create your own Repository

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