Can you please provide more information on your query? What modules this is related to and any screen shots from application UI that can help the community to better answer your query. Thanks.

I think this is happening because data is not getting refreshed post WR cancellation as the assignment records are deleted: Frequently Asked Questions @Ravi Guddanti-Oracle , Do you have some inputs here, please? Fusion HCM Analytics - Frequently Asked Questions — Oracle Analytics Thanks.

Upvoted !!!!

I haven't seen this anywhere. Would be interesting to get the SQL behind this view. But I assume this will be a restricted object and may not be available publicly. Hi @Raghavendra Raghunath-Oracle , Hope you are doing well, Can you please help if it is possible to get the query behind BIPUBLISHER_V? Thanks.

It should work right. It will display the data only for entered DFF based on expense type other one will be blank. Can you give it a try once? Thanks.

Hi Marc, Just trying to understand your requirement a bit more in details. You have different reports or only a single report that sends data 50 times per day to a single SFTP? or is this not the case? can you please elaborate a bit more? Thanks.

I don't think there is a way to generate this list in BIP. But you can check the data lineage sheet available on below thread: HCM OTBI subject areas to database lineage mapping spreadsheet — Cloud Customer Connect Thanks.

Below should help: Bi Publisher - add x days to a date element in rtf template — Oracle Analytics Thanks.

You can use concat to achieve this. Check an example on below: How create a column by concatenating multiple columns in otbi — Cloud Customer Connect Thanks.

Is it possible to share a screen shot of what you are seeing and what is your expectation? Do you want to concatenate the data in two columns and display it as one? Thanks.

Hi SM, Can you please let me know the details of the product? Is it a standalone BIP or part of Fusion SaaS? Also, let me know the complete steps that you have followed. Thanks.

Hi, This is not the correct forum. Please post your query under REST API category under customer connect: HCM REST APIs — Cloud Customer Connect Also, a short answer is no to your query. Thanks.

This seems more like a question compared to an idea. Are you requesting for product enhancement or asking a question. Also, this forum is specific to Oracle analytics. For taleo related queries, you can post them on cloud customer connect. Thanks.

Hi Padma, Ideas are basically enhancement requests which are raised for product enhancement or to overcome a product limitation. For general consultative queries, you should post it in normal discussion forum. As your query is related to OTBI, you can post it on below category:…

I haven't seen any solution for this yet i.e. to keep the formatting as number and preserving the leading zero's. As per below MOS doc, it is currently the limitation: BI PUBLISHER : Leading Zeroes Are Truncated When The Report Is Of Excel Format (Doc ID 760041.1) Thanks.

Can you please share the solution with community so that it will be helpful for anyone looking for a similar answer in future? Thanks.

Hi Jeff, Is this more related to querying the complete BPM information using OTBI or the changes that has happened (audit of changes)? Thanks.

Is this a question or an enhancement request? Thanks.

Hi Shravani, What I have observed is that not all the dates point to refresh/upgrade dates. Because sometimes it carries the date from the environment where the report was last saved. As normal user can't make any changes in seeded OTBI reports, so it is Oracle only. Thanks.

Even we have been asked recently to provide the audit information for successful delivery of email to each individual recipient. This is a much needed enhancement. Thanks.