https://community.oracle.com/products/oracleanalytics/discussion/comment/69670#Comment_69670 Hi @User_A_AJ, Can you please try to get the output with RTF / PFD/ CSV using RTF template to see if it is working fine? Just pull all the columns that you have in the query into the RTF and see if it is bringing all expected…

https://community.oracle.com/products/oracleanalytics/discussion/26612/bi-publisher-report-leaving-out-duplicates Hi @Anna A, If you filter your query for a specific person (who is having duplicates) and try to execute both query & the report. Do both produce same result set? Also are the numbers of columns same for both…

https://community.oracle.com/products/oracleanalytics/discussion/comment/69648#Comment_69648 Hi @Kauan_Bohn, Thank you very much for sharing! It'll be very useful. Thank you.

https://community.oracle.com/products/oracleanalytics/discussion/26604/how-to-check-list-of-scheduled-or-standard-notification-jobs-scheduled-in-oracle-fusion-for-each-mod Hi @cvidhya, Welcome to the Oracle Analytics Community! Please look at the following Oracle docs which might be useful for initial understanding and a…

Much needed feature. Upvoted.

This will be very useful feature and will add so much values. Upvoted.

https://community.oracle.com/products/oracleanalytics/discussion/26581/calculating-percentage-for-each-row-based-on-the-column-total-in-otbi-report Hi @Elavarasan S, Welcome to the Oracle Analytics Community! Can you please check if the aggregation level has been set-up for the measure in the pivot table like below? Hope…

https://community.oracle.com/products/oracleanalytics/discussion/26584/security-context-for-custom-subject-areas Hi @User_FCECH, Please take a look into the following note which might be useful for the initial understanding.…

https://community.oracle.com/products/oracleanalytics/discussion/26558/the-field-search-for-subject-areas-does-not-work Hi @SERGIO BARRETO, It seems there were some issue with column search but it has been fixed in 24 R3 version. Please see details in the following Oracle note.…

https://community.oracle.com/products/oracleanalytics/discussion/comment/69512#Comment_69512 Hi @Ivony Ann Paula Salango, Thanks for the details. I would recommend you to go one step at a time to see if it is working or is it not working when you are adding other reports etc. Sometimes the results comes from cache and…

https://community.oracle.com/products/oracleanalytics/discussion/26549/how-to-transfer-report-files-in-csv-format-via-ess-job-to-sftp-server Hi @User_QI9MI, Welcome to the Oracle Analytics Community! You can use eText template and deliver the file as a text file and the data can be stored as comma delimited inside that…

Very helpful information. Thanks for sharing @SteveF-Oracle!

https://community.oracle.com/products/oracleanalytics/discussion/26548/could-someone-please-let-me-know-which-tables-store-the-information-about-courses-offerings Hi @Nikhilesh Reddy P, Welcome to the Oracle Analytics Community. Please take a look into the following Oracle Doc which will give all the tables details.…

https://community.oracle.com/products/oracleanalytics/discussion/26508/how-to-create-custom-bicc-pvo-creation-in-fusion Hi @Prabhjeet Kaur, Can you please check the following Oracle docs which might be useful. https://support.oracle.com/knowledge/Oracle%20Cloud/2233767_1.html…

Very helpful information. Thanks for sharing @Benjamin Arnulf-Oracle & @Wayne Van Sluys!

Fully agree with @philipgodfrey, it'll add so much values. Upvoted.

Very helpful information. Thanks for sharing @SteveF-Oracle & @Timothy Dickinson!

It'll be a great feature to have which will be very useful. Upvoted.

Hi @Muhammad_Saad, Please find below the prompt for last 3 months using the above logic. https://us.v-cdn.net/6037859/uploads/05XXO35NPGEQ/accounting-period-last-3-months-pmt.catalog Hope this help. Thank you.

It'll be a great feature to have which will be very useful. Upvoted.