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
-
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 … -
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…
-
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 …
-
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… -
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 …
-
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):…
-
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…
-
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…
-
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…
-
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…
-
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 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…
-
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… -
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…
-
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… -
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… -
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 21 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle
-
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…
-
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…
-
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…
-
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…
-
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…
-
Can we control Embedded report display properties?Summary: We have embedded a report to Account object. But it is not displaying in full screen, can we control such properties for BIP report to display it as user wants.… -
How to insert logo dynamically in RTF template headerSummary: We have a RTF template in that we are showing logos in header and same will be different for different Business units. now we have a base 64 encoded format of i…
-
How can I create a custom job Role in BI Publisher?Summary: I can view the Roles and Permission under the Security Center using the /xmlpserver/. However, I cannot create a custom Role as there is no way for me to see th…
-
How to add dynamic parameter to embedded BIP report in Sales Account objectSummary: Hi All, We have a requirement to embedded a report in Sales Account object. I have created a BIP report and via mashup content I added this to a new custom subt…
-
Is there a way to automatically trigger a scheduled job if it encounters failure on scheduled run?Summary: We have one file that was not sent to SFTP location as there is a connection issue in the SFTP as there is an emergency change in SFTP. In Oracle BI Publisher, …
-
ORACLE FUSION SAAS CLOUD BI REPORT TIME OUT ISSUESummary: ORACLE FUSION SAAS CLOUD BI REPORT TIME OUT ISSUE Content (required): ORACLE FUSION SAAS CLOUD BI REPORT TIME OUT ISSUE IN DATA MODEL PROPERTY I HAVE INCREASED … -
Backend table name for Role Code field for View ObjectSummary: We are going to create a Report for Monitoring and I would like to know the backend table name for Role Code field for View Object CrmAnalyticsAM.ResourcesAnaly…