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.
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Reporting & Analytics for Fusion Service
Discussion List
-
what Database table stores the Role Category informationSummary: need to fetch data describing that which user has what roles and its categories. we have used below tables for our custom query per_user_roles per_users , per_r… -
BI Publisher Report Issue -"Failed to load servlet/dmvalidate?_sTkn=dea4afb718b89c1d4df."Dear experts, In some of the Data Model (Fusion SaaS) , I am below error when I open the datamodel. "Failed to load servlet/dmvalidate?_sTkn=dea4afb718b89c1d4df." Also I… -
Getting XMLPGEN - 03111 : User requested cancel operation ERROR in BIP ReportI have built a Order Management Pricing Report (BIP Report) Getting "User requested cancel operation" Error in the Report. Attached the screenshot for the reference, if …
-
How to group the values using different columns in OTBI reportI want to create spearate column in the OTBI to get number of invoice count using supplier name, Invoice number and invoice creation date columns. I could be able to cre…
-
OTBI Analysis for for Performance DocumentsI need help/guidance in setting up an analysis filter to only pull the last 12 months of Performance Documents from the Workforce Performance - Performance Rating Real T…
-
Is the Workforce Learning - Learning Management Real Time subject area being deprecated, and when?Can you help me understand if this SA is being deprecated in OTBI or if it will remain? This Customer connect article seems to indicate it was announced in 2021 that it …
-
What if an instance has been created on analytics cloud instead of FAW ?Hi guys, What's the difference between creating an instance on Analytics Cloud and FAW on OCI ? What if some work has been done on an instance (let's say Instance 1) cre…
-
How to print an embedded dashboard pageSummary: When opening a dashboard through directly in the catalog, there is a gear in the top right that gives the ability to print out a dashboard page. When a dashboar…
-
recruiting events analyticsHello, I would like to have some analytics or dashboards for metrics regarding recruiting events and campaigns in Recruiting. Is there any predefined dashboard, or a way…
-
In which subject area I can find Site details to create an OTBI report?I need the following fields in my OTBI report related to site to know their subscription status: 1) Oracle Fusion Site Name 2) Oracle Fusion Site Number 3) Oracle Fusion…
-
How can I create a report BI of notifications sent by service request workflow?Summary: How can I create a report BI of notifications sent by service request workflow? Content (required): Currently we are dispatching a series of notifications throu…
-
Load Data from FAH(fusion Accounting Hub) to FAW, need more details?Summary: Data load from Fusion Accounting Hub(FAH -Fusion Applications) to FAW(Fusion Analytics warehouse) Content (please ensure you mask any confidential information):…
-
Cloud Bi Publisher - BIP bursting not sending emailsHi All, I am using Oracle Analytics Publisher and have built a report and associated data model, with a bursting query. I want to schedule the report to be sent to email…
-
How to export single offering of BICC for migration between instancesSummary: Ideally now we have have the bulk dump irrespective to specific offering that was modified exported and then imported to different instance. Content (required):…
-
How to rename BI Publisher excel output spreadsheet.(sheet1, Sheet2,...)Summary: Business needs to display Sheet1,Sheet2.... to different names when generating the output in Excel through BI Publisher. Content (required): Business needs to d…
-
Cannot open .xls output for a BI report with Excel Template when scheduling itHello, I have a report which uses an Excel Template and when executed it generates a .xls file. If I schedule this report then this .xls file is corrupted ie. user is no…
-
How to get user login history or user wise application usage of Oracle fusion applicationsHow to get user login history or user wise application usage of Oracle fusion applications
-
In which Fusion DB tables SaaS usage details are stored?We are trying to build an custom report similar to SaaS Service Usage Metrics Report for our Fusion instance. The report will need to display region wise/country wise li…
-
Deep Link/table for each task notification?Hi all, I need an SQL query or a deep link to get the link for the tasks in the BPM worklist like this: thanks.
-
How to select an employee's work email in OTBI and the worker will appear also if he doesnt have it?How to select an employee's work email in OTBI and in case he does not have such an email, it will display the employee without an email?
-
Can we get employee ID of salesperson in reportsHow can we get employee ID of salesperson in reports, From Opportunity, when we pull employee ID, its giving the employee ID of the Opportunity owner, but can we get emp…
-
SQL query to fetch employees holiday applied on during employees is on maternitySQL query to fetch employees holiday applied on during employees is on maternity
-
Additional Information for Leave PlansDear All, Unable to find table/column value of "Additional Information" field regards absence accrual details Kindly let us know/share the table or column details which …
-
How do I source: profile item id for spreadsheet loaderI'm trying to build a spreadsheet loader to load license and certifications specifically Responsible Manager which sits in Responsible Person Region in Skills and Qualif…
-
How to print space between currency symbol and priceHi, I have added the below formula in the rtf template to display the price along with the price currency code. Formula: Output $50 UNIT_PRICE & INVOICE_CURRENCY_CODE d…
-
How to integrate the analytics between Oracle Digital Assistant's skill and Oracle FusionSummary: So we have beautiful data in Oracle Digital Assistant and Oracle Fusion Service. We want to put them in the same dashboard. Content (please ensure you mask any … -
Bursting report in procedure call data setSummary: Content (please ensure you mask any confidential information): I have a requirement to insert/update the lookup code and print and deliver the PDF through email…
-
How to add new table extract in BICCSummary: Hi Experts, We noticed some tables are missing in BICC console and below table is an example. May i know if there is a way to extract the missing tables using B…
-
Can we hold the Oracle SFTP for the scheduled BI report jobsWe have few integrations directly using Oracle SFTP to send the file to various vendors. Wanted to check is there a way to hold the Oracle SFTP delivery alone for the sc…
-
Norwegian number format displaying as text in BI publisher excel outputHi, I have a report which displays Amount, Rate and QTY columns (In Norwegian number format i.e., Decimal separator as ',' and thousands separator as '.') as part of the…