To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Is there a way to sort date type columns by default?Summary: Is there a way to sort date type columns by default? We want to sort this column with the DD/MM/YY format but by default we can only sort it by MM/DD/YY, if we … -
Conditional Formatting to display field in redHi, In the PO template if the amount -
Auto Refresh a BIP ReportSummary: How to refresh a BIP report after a certain period of time? Content (please ensure you mask any confidential information): HI, We want to show a report on a Dis…
-
DFF in the BICC extract for PO_LINES_ALL. We have DFF in PO_LINES_ALL.DFF in the BICC extract for PO_LINES_ALL. We have DFF in PO_LINES_ALL. The DFF's are BI Enabled. But these DFFs do not appear in the BICC extract Data Store. Can you ple…
-
How to get Amount in Words in Arabic language in excel template with Saudi currencySummary: I have total eg: 21113.75 and it should show in output arabic of 'Twenty-One Thousand One Hundred Thirteen Saudi Riyals And Seventy-Five Halala'. I am able to g…
-
Guidance for selecting PVOs for BICC extractSummary: We are using Oracle Business Intelligence Cloud Connector (BICC) to extract transactional data & load it into external tables using Informatica Cloud Services. …
-
What are the tables or SQL query to fetch ESS job name, Report name, Report path detailsHi Team, I have requirement to develop custom SQL query to fetch details like All ESS Job names, Display names, Report names, Report paths etc. I have used tables like E…
-
Is there a Workforce Management - Position Event Real Time Subject Area?Summary: There is currently a Subject Area for Workforce Management - Position Real Time selectable when creating an Analysis in OTBI. This Subject Area shows the max ef… -
Query to get Contract Financial SummarySummary: Dear All, I'm need a report that gets data from the following table in the Contract Financial Summary. What are the oracle tables or Views to get this data from… -
Scheduled BI Publisher reportSummary: Does a scheduled report need re-scheduling if its underlying BI Publisher template or data model is changed after the scheduling starts? Content (please ensure …
-
-
Manage Address Formats GrayedoutHi Team, I am unable to edit or view Manage Address Formats as this is grayed out . Please let me know if I am missing something ? I am searching this from Setup and Mai…
-
Replacement for FscmTopModelAM.ItemCostDailyAM.ItemCostDailyPVOSummary: With the loss of data availability for this PVO in 24A (see Document 2998181.1 (oracle.com)) our PECSV files are coming back with 0 rows, i.e. the table is no l… -
i want sql query to find business days differnece between two datesSummary: I want a query in sql to get businees days between two dates E.g i have two dates of differnet tables the gap is of 15 days or may be 7 days or may be 30 i want… -
SQL Query to extract all details related to data roles and security profiles designedSummary: Need an SQL query for creating a data model and subsequent BIP report, to extract the details of all the data roles and also the security profiles like Person, …
-
BIP Bursting is not delivered the emails to DLsSummary: Bursting emails from a BIP report are not delivered to any of the email ID's part of DL list, even though the Report Job History/Output & Delivery section indic…
-
List for all OTBI subject areas/dimensions (as of 23C)Summary: Does anyone have a complete list of all OTBI subject areas/dimensions for creating ad hoc queries? Content (required): Version (include the version you are usin… -
How can we secure/hide the Reports and Analytics Panel Tab on a given page?Summary: Requirement is to secure the Reports and Analytics Panel Tab on certain pages to certain roles or in one case hide it completely. How do we do so. Content (requ…
-
I am not able to see few terminated PPRs in iby_pay_service_requests tableSummary: Some of the terminated PPRs in the iby_pay_service_requests table are not visible to me. Does this table lack any security or data access? Despite the fact that…
-
Looking for SQL query for Duty Role to Job Role mappingSummary: We have a couple of job roles and child duty roles and privileges assigned to the same job role. Can someone help me with SQL to fetch the same as we need to co…
-
How tables are joined for a View ObjectSummary: Is there any document or Oracle Cloud Application embedded method to figure out how the Database Tables are joined for a View Object? Content (required): Versio…
-
Report for Users Activity in Oracle Fusion - Audit ReportSummary: I would like to know if there is any report to see user's login date and time for audit purposes. Content (required): We would like to know when the users login…
-
Table that holds ESS Job Display nameSummary: Hi We are trying to create a bip to fetch ESS job details. we looked into ess tables for display name but looks like they store only short name. fusion_ora_ess.…
-
Request for Oracle User Access ReportSummary: Hi all, Thank you in advance for your help and support. I have a question regarding Oracle user access. Is it possible for us to extract a report that provides …
-
Privileges required to view output on a custom version of a seeded reportSummary: Privileges required to view the output of the Import Project Budget report when a custom copy of the seeded report has been created (relevant to any seeded repo… -
How can i connect to Essbase in PowerBISummary: We used oracle fusion cloud and able to connect to Essbase using Smartview in Microsoft Excel but when i try to connect to PowerBI using url it gives me error. …
-
How to download SSH Private Key uploaded in Upload Center?Summary: We need to download the SSH Private Key which was uploaded in the Upload Center of BI Administration. How to download it? Content (required): We need to downloa…
-
Request for Information Notification disappears in the Things to FinishSummary: Request for Information Notification disappears in the Things to Finish Content (required): Hi, We have an issue where the PR approver request for information. …
-
Custom BI report for ESS job historySummary: Hello All, I would like to know if there is a way to create a custom BI report for monitoring ESS job submitted by specific users. I have the below tables, howe…
-
Tracking bounced back emails Print Receivables TransactionsAR invoices need to be delivered through email to customer email ID. Is there any tracking mechanism to monitor the bounce back? So that, a valid email address can be ob…