https://community.oracle.com/products/oracleanalytics/discussion/comment/69859#Comment_69859 It'll be a great feature to have. Thank you very much @Jacques V.-Oracle !

https://community.oracle.com/products/oracleanalytics/discussion/comment/69849#Comment_69849 Hi @Amir Esteki, Have you submitted those flow from the front end? Also Have you tried searching by changing date or owner as mentioned in the steps? Thank you.

https://community.oracle.com/products/oracleanalytics/discussion/comment/69848#Comment_69848 It is not possible to restrict BI Publisher Data Models to specific tables. Please check the following Oracle Note: https://support.oracle.com/knowledge/Oracle%20Cloud/2819026_1.html Here are some ideas in the idea lab requesting…

Hi @AnushkaUrunkar, Ideally you need to do the Data Masking in your non-prod environment so that developers will not be able to see the sensitive real data. Here's a good read which can provide more information. https://docs.oracle.com/en-us/iaas/Content/fusion-applications/manage-security-data-masking.htm Hope this help.…

https://community.oracle.com/products/oracleanalytics/discussion/26690/access-to-tables Hi @AnushkaUrunkar, Welcome to the Oracle Analytics Community! It seems it is not possible to restrict BI Publisher Data Models to specific tables. Please check the following Oracle Note:…

https://community.oracle.com/products/oracleanalytics/discussion/26691/unable-to-view-vets4212-eeo1-output-in-otbi Hi @Amir Esteki, Welcome to the Oracle Analytics Community! Please note these reports ore not OTBI but BI Publisher Reports. Have you followed the instructions as mentioned above? Once you click the history it…

https://community.oracle.com/products/oracleanalytics/discussion/comment/69816#Comment_69816 Hi @User_AQJE3, Please reduce the zoom size of your browser and see if there's any betterment. Hope this help. Thank you.

Very helpful. Thanks for sharing @Anitha Ramarao-Oracle!

https://community.oracle.com/products/oracleanalytics/discussion/comment/69784#Comment_69784 Hi @Ivony Ann Paula Salango, Yes agree with you it is case sensitive. As a work around you can define the presentation variable and use either lower or upper function on that field and you have to use that particular case while…

https://community.oracle.com/products/oracleanalytics/discussion/26669/extract-ap-invoices-that-are-edited-after-approval-resubmitted-as-status-changes-arent-tracked Hi @Sulthan, Welcome to the Oracle Analytics Community! Can you please check the following Oracle Note?…

https://community.oracle.com/products/oracleanalytics/discussion/comment/69778#Comment_69778 Hi @Sumanth V -Oracle, This is very helpful. Thanks for sharing!

https://community.oracle.com/products/oracleanalytics/discussion/comment/69755#Comment_69755 Hi @Prabhjeet Kaur, Please check with Oracle support for their expert opinion and if possible please update here; it'll be useful for the knowledge and future reference. Thank you.

https://community.oracle.com/products/oracleanalytics/discussion/26663/why-does-the-value-for-customer-annual-reporting-is-changed-to-mixed-case Hi @Ivony Ann Paula Salango, Can you please change your prompt 'Subject COMED' to text instead of drop down values and then type 'Customer' to the prompt as a value and execute…

https://community.oracle.com/products/oracleanalytics/discussion/comment/69754#Comment_69754 Hi @mc, Thanks for the information. Can you please share your data model so that we can replicate in our instance to see if we are facing the same issue which will help to find potential solution. Thank you.

https://community.oracle.com/products/oracleanalytics/discussion/26656/bip-lov-not-returning-desired-value Hi @mc, Welcome to the Oracle Analytics Community! Quick Question: Are you passing the same date (:pEffectiveDate) for both the query? Also are there any other prompt or dependency while executing the LOV? Thank you.

https://community.oracle.com/products/oracleanalytics/discussion/26652/pivot-table-incorrect-total Hi @Donna Fazio, Welcome to the Oracle Analytics Community! Can you please check if the 'Aggregation Rule' has been set for the column in the Pivot table? Here is an example. Hope this help. Thank you.

Very helpful information. Thanks for sharing @Luis E. Rivas -Oracle!

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.