Reporting and Analytics
Discussion List
-
Pivot TableSummary: Hi, I need help with a report format. Object 1: Contains Question IDs Object 2: Contains Question IDs and Response fields We have a table that includes Question…Anusha716 41 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to create custom PVO and add it in BICCSummary: How to create custom PVO and add it in BICC Content (required): How to create custom PVO and add it in BICC Version (include the version you are using, if appli…Vivek Gautam 3.5K views 7 comments 1 point Most recent by Surendra Majeti Reporting & Analytics for Fusion Service -
I need to Create a report on a Contact where I have created a custom field for their managerSummary: I am trying to generate a hierarchal report on contacts within an organization. I have created a "Manager" field that links to another contact in Sales. I want …
-
Corporate currency conversion in OTBI reportSummary: We have multi currency enabled in application. In the Opportunity UI user's select the currency as required and go through the pipeline process to book/close op…
-
Get the source system of a merged contact recordSummary: Is it possible to get the source system of a merged contact record? We're aiming to use it for reporting. If feasible, which table should be used? There is colu…
-
Customer Contact- Person Audit TableSummary: Dear Experts, We are seeking your valuable inputs to identify the Audit Tables that store information related to updates made to Customer -> Account -> Contacts…
-
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…Dhilip Kumar P. 42 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to enable the BI label drop down on a descriptive flexfieldContent Trying to figure out how I can use the BI label field drop down box on the description flexfield segment area when creating a new attribute. Reading the configur…Chris C 641 views 2 comments 1 point Most recent by Sailaja Chillara Reporting & Analytics for Sales -
How can we migrate BIP scheduled jobs (Definitions) from one env to another env?Hi, We are refreshing multiple lower instances for go-live, and during this process, the BIP schedule jobs are not being migrated from the source to the target instance.…Praveen_Paul_raj 75 views 4 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
Is there a table where we could query/retrieve the match configuration rule attributes for CDM?Summary: We've a requirement to create a report showing the match rule and the rule attributes. We can use ZCH_MERGE_DETAILS_B to get the match rule name for merged reco…
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 1.2K views 2 comments 4 points Most recent by Shishir Dhone Reporting and Analytics for SCM -
Digital Signature in RTF templatesSummary: Hi Team, Could you please advise on how to enable digital signatures in RTF templates that span multiple pages? According to the documentation, it seems we need… -
How can I add the current date to the file name on a scheduled reportSummary: I have a user who has a scheduled report which he receives as an excel file that gets forwarded to a Sharepoint directory automatically every day. The issue he …VivTed 196 views 3 comments 0 points Most recent by Shashidhar AM Reporting & Analytics for B2C Service
-
Most searched article OTBI ReportSummary: Hello , I am trying to create a OTBI report that lists Most searched KM articles. Tried using KM - Article search questions historical subject area , but doesn'…Lakshmi_Sasidharan 62 views 5 comments 0 points Most recent by Lakshmi_Sasidharan Reporting & Analytics for Fusion Service
-
Addins and WorkspacesI need to run a report which shows what all workspaces are having a particular addin.How to find out what all addins are used in a workspace? Regards, MeeraMeera Saseendran T 71 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C Service
-
I need to write a custom script in a reportI have a column which will shows some numbers. For example column A 45643746 464734329 Column will be like this. I need to show another column which will be result of co…Meera Saseendran T 31 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
Log for user's navigation in Oracle FusionSummary: Hi all, please, I would thank any help with the following: Is there any log/table/trace, anything, that is able to reflect when user presses any of this buttons…
-
Creating a Business Unit-Specific Lead and Opportunity Dashboard in Oracle FusionHi Community, I'm working on creating a dashboard in Oracle Fusion CX Sales to provide insights into lead and opportunity performance for specific business units. My goa…Fareeha Altaf 101 views 5 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales
-
Need Table name where approver comments are stored.Summary: Im working on Employee Request Type Report where i need Comments column. Here comments column need to be the comment left by the approver while approving the re…Supraja Sunnapu 33 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
How to get the SQL of a report made through Subject AreasSummary: We need to extract the source SQL code of a report made through subject areas Content (required): How can we get the source SQL code of a report made by subject…SERGIO BARRETO 693 views 9 comments 0 points Most recent by MFlannery Reporting & Analytics for Sales -
Is it possible to create a security context in oracle cloud?I want to create that combo in oracle cloud: define a role with a security context that I create and security context valueACNROMA2023 42 views 4 comments 0 points Most recent by HimanshuSetia123 Reporting & Analytics for Fusion Service
-
How to enable audit log in report and analytics.Summary: Is there any possibility to add audit log in report and analytics? For example: In objects(like Lead ,Opportunity ) there is a field which shows the value of la…ArjunReddy88 111 views 4 comments 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to define a custom field which its LOV is dependent on another field in the formSummary: Custom field added to form should hold LOV based on a query dependent on another field in the form Content (please ensure you mask any confidential information)…Michal Shaked 143 views 3 comments 0 points Most recent by Amr Hassan Reporting & Analytics for Fusion Service -
Archive/Unarchive permission to My folders onlySummary: BI Administrator role generally gives archive/Unarchive access to entire catalog. Here the requirement is for few users, we would need archive/Unarchive permiss…Karthik Soundarapandian1 71 views 3 comments 0 points Most recent by Karthik Soundarapandian1 Reporting & Analytics for Fusion Service -
Knowledge Base Report - answers.updated field no longer workingVersion 23D I have an issue with a KB report where the answers.updated field is not being updated on some KB's and won't show up on the report. Here's the audit log of o…Joe P. 41 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C Service -
Define Custom Summary BoxesSummary: Create custom Summary Boxes to be displayed on the Overview page of Accounts and Contacts Content (required): I see a list of OOTB summary boxes we can add but … -
i need to show only the incident' which having incidents.closed==transactions.createdSummary: What is the condition for show only the incident' which having incidents.closed==transactions.created. Content (please ensure you mask any confidential informat…Meera Saseendran T 31 views 3 comments 0 points Most recent by Meera Saseendran T Reporting & Analytics for B2C Service
-
how to capture case closure done through multi editI need to create a report to capture the details of incidents which are closed via multi edit. How to track this transaction?Meera Saseendran T 31 views 2 comments 0 points Most recent by Meera Saseendran T Reporting & Analytics for B2C Service
-
We could not find the table for Log a Call functionalitySummary: We could not find the table for Log a Call on Activity and Notes Table where the details are available on NGS Smart Action. Can you please help us to identify t…
-
Table Industries CRM SALESCordial greetings Please help me to identify the table that brings the Industries field data from the account in oracle cloud sales. Thank youJhonattan Diaz 11 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales