A PDF Output can be password protected for sure. Need to check if this can be done in Excel too. You may refer links (for PDF Password protected file in links below) Dynamic password :…

You should be able to derive this based on current date

Ok would re-check. Thanks Ashish

But there must be a setup done to link Dashboard Prompt with BI Parameter. Do you have then snapshot ? Kind Regards Ashish

Thanks Vikram for your inputs. Unfortunately SR isn't a available option (Self-learning purpose) Wondering if you have a worked out (step-by-step guide with screenshots embedded) which you would like to share ( please hide customer centric details in case you choose to share one). Thanks in Advance! Kind Regards Ashish

Yes to all the points mentioned with one addition info: We also have an option of submitting BIP Reports via Payroll Flow Patterns and there is an option of : 1. Using a Value Set Display Format under Flow Parameters (it currently is allows association with Lookup Code, but I believe there could be ray of hope there. Not…

Yes to all the points mentioned with one addition info: We also have an option of submitting BIP Reports via Payroll Flow Patterns and there is an option of : 1. Using a Value Set Display Format under Flow Parameters (it currently is allows association with Lookup Code, but I believe there could be ray of hope there. Not…

Hmmm. Have you raised an SR yet. Do you want to have the Report embedded within Dashboard Only. You might even explore submission via ESS Jobs (It allows using PVO which stands for Parameter View Objects which allows selection from drop down list.. just check whether a PVO for Person_number exists.. one cant create Custom…

Thanks Jagadish for the response, but you have used a OTBI Analysis instead of a BI Report. Do you have something similar which utilizes BI Report Kind Regards Ashish

Hi Suveer, Did you got a chance to have a look at 'Oracle Business Intelligence Publisher' option under Setup and Maintenance->Manage Audit Policies Refer attached image Kind Regards Ashish

Hi Suveer, Aren't the details getting captured under the (More->History) option which is there once you navigate to the Report Location. As an alternative, how about capturing the invoke time from the consuming system. Kind Regards Ashish

Yes. That's the easiest option available. When you schedule the program the default extension is .txt ( so do check if that works at the consumer end). And even if the consuming application is only comfortable with .dat extension then do the following: a) Get the .txt file from Cloud HCM as is b) Migrate via some mechanism…

Hi Suveer, Which one of the below is your requirement: a) Are you only looking for a file extension (.DAT) b) Are you looking for a specific pipe delimited format file c) Both a) and b) d) Anything else. I am asking these questions as while there isn't a direct way of generating .Dat extension file in HCM Cloud Application…

Hi Julian, I raised an SR and the support team gave a workaround. I have made a document out of it and sharing this across for the benefit of other community members. Thanks Ashish

 Hi Julian, So how do we ensure that user picks the correct format. User in differen countries would have different way of looking at Date formats and if they enter a incorrect value it would error. Is there a feature we can have something like 'Enter Date in YYYY-MM-DD' on that field (Grayed Out). Regarding the second…

Hi Julian, This gives me the current system date on the Prompt, but can we have a date picker. Also i had a chance to look at the Service Anniversary Summary and Detail Report and couple of questions i have are : a) Why does the report says an error when we click on Results tab (adjacent to Criteria) it works fine when ran…

Hi friends, Any pointers? Thanks Ashish

Hi Wade, Thanks for replying, but am looking for multiple data-sets. The one you are referring to is the most commonly known and widely used calssic single data-set example which I am aware of am looking for a multi data-set example Thanks Ashish

BI Administrator BI Author and BI Consumer are the three roles They have spate options Read Write and Full Control to be chosen. Additinally you should always archive the Reports you create so that you have a local copy even if it is lost in upgrade you can unarchive and start working/using Thanks Ashish

Hi, Did you tried creating a seperate data set and use some query like Select :<xdo_var> as lang_session from dual ; I tried for username and it works perfectly fine.