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 & Analytics for Sales
Discussion List
-
Generate CSV file output with column names from BI publisherSummary: Is there a way to exclude column names from printing on a csv file output using BI publisher? I created the DM and report and the csv output has the required da… -
SaaS UCM retention period and Storage LimitSummary: What is the Oracle SaaS (HCM, ERP, Cx) retention policy and storage What is the Retention policy of fusion UCM? What is the storage capacity in UCM? Can we have…
-
total column row should have only total amount valueSummary: In Report we are using Pivot table and there is amount column so doing total of the row , but the total row is giving again entire row values. Providing sample …
-
How to create a Last Completed Activity in OTBISummary: I have created a report in OTBI using a custom subject area based on primary object Opportunity however there is one more field i would like to add to this repo… -
Error in casting date in OTBI Reports ConditionSummary: I need to display a different formatting in date time. However, when I try to use the To_DateTime("Goals_c"."FacetoFaceMeeting1_c", 'YYYY-MM-DD') condition, it …
-
View analytical reports in SFA from other users as adminSummary: View analytical reports in SFA from other users as admin Content (please ensure you mask any confidential information): Dear All, There is a way to view the rep…
-
How to use custom field as parameter in Analytics Sub TabSummary: Hi, i referred below link. this is for Standard Id field But how to use custom field as parameter Content (please ensure you mask any confidential information):…
-
How we can get the Account Change History information in Analytics Report and BI FileSummary: We want to see all change History information in Oracle Sales Cloud Analytics Report and Cloud Console Export. Any specific Subject area we need to use. Please …
-
BI Report Migration Not Captured in Audit LogSummary: We have noticed that some of the custom BI report and data model migrations are not captured in the audit log. The same functionality is working for the same us…
-
Is there a way to get overlay credit details in opportunity OTBI report ?Summary: Is there a way to get overlay credit details in opportunity OTBI report ? Content (please ensure you mask any confidential information): Version (include the ve…
-
Not able to find CDM Subject AreaSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BI Report Not giving correct Result Based on Multi Choice list value Printable ViewSummary: I have create Subject area report & we are filter data based on Multiple choice list. But Its not returning result Using data from 2 custom objects (i)View Docu…
-
Where do Fusion BI Publisher report outputs get saved to by defaultSummary: Where do Fusion BI Publisher report outputs get saved to by default? We would like to save scheduled reports in our OCM Content (please ensure you mask any conf…
-
BIP SQL to Retrieve Meaning Instead of Lookup Codes for Multi-Select FCLsOur organization has a requirement to depict the meaning of a multi-select FCL in a BIP report. The attribute currently pulls the lookup codes properly, but when applyin… -
OTBI Partner Resource RoleSummary: Hi, I need to create a simple report showing Partners and all the Partner Resources (First Name, Last Name) with their Resource Role. Can someone point me to th…AparajitMalliJawaharBapu 21 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle
-
How to use images dynamically in BI Publisher RTF templateSummary: How to add conditions to the RTF template. checked on this Oracle Fusion BI Publisher: How to use images dynamically in BI Publisher RTF template (Doc ID 240985…
-
OOTB Subject Area Partner does not OOTB field Preferred Contact NameSummary: Hi Experts, I am trying to create a simple OTBI Analysis report within Oracle Sales Cloud (CX Sales) SaaS. The OTBI Analysis report should show all Partner Orga…
-
Filter to get the earliest date in the OTBI Analysis.Summary: Content (please ensure you mask any confidential information): Hi, kindly asking for your help. I am trying to get the earliest date per account/activity within…Ivony Ann Paula Salango 32 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle
-
Diagnose link purpose?Summary: What's the purpose of the Diagnose link in analytics dashboard? Content (please ensure you mask any confidential information): What's the purpose of the Diagnos…
-
custom subject area factSummary: My customer requested the creation of custom subject areas to put the information from these child custom objects in the reports. My team and I created the cust…
-
REST API to run BI reportSummary: Hi, I am trying to run existing BI report using REST API but getting error. Pls advise Thanks Content (please ensure you mask any confidential information): Ver…
-
OTBI does not display and filter standard Oracle Cx attributesSummary: Hello community, I hope you are well. To generate a Leads report, you need to filter the Leads by type of currency, the standard attribute of "Revenue". "Curren… -
Analysis required on Appointments amendmentSummary: User need to analyze the trend of amendments in appointments. From my understanding, this can only be achieved if the system creates different versions or a his…
-
OTBI does not show attributes standar that were created in Oracle CxSummary: Hello community! When creating an analyst in OTBI, and located in the object "Lead" missing the field "ExpirationDate", this field is standard, however, does no…
-
Can ORACLE Fusion (CX Sales) integrate an external system using protocol POP3 or IMAP or MAPI ?Summary: We are required to verify CX sales customer emails with an external email verification system using the POP3 or IMAP or MAPI protocols. Content (please ensure y… -
Is it possible to create a text to column like Excel column in OTBI based on a Listagg column?Summary: I need to see data on one row. I've managed to do this using Listagg. However, now they are asking if that it not be concatenated and still keep it all on one r…
-
how to add dynamic values inside message content in BIP report schedulingSummary: I would like to know whether we can add parameter values under "message" while scheduling the report . The screen shot is given below. Content (please ensure yo…
-
Which Table stores data for Source Systems for Trading Community MembersSummary: Which Table stores data for Source Systems for Trading Community Members. SOAP WSDL and Operation to retrieve the data is below https://servername/crmService/Fo…
-
I was creating multi partitioned external table received errorHello Tom i was creating multi partitioned external table from parquet file but end up having these error did so much research but not able find cause of this error plea…
-
OTBI Report to pull Opportunity details with team membersSummary: Need an OTBI report on Opportunity and associated team members Content (please ensure you mask any confidential information): How to expose Opty team members de…