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 Fusion Service
Discussion List
-
Questions on BICCSummary: Questions on BICC Content (required): Hello Experts - We are planning to pull some of the entities from Oracle ERP Cloud to our external DW tables for reporting… -
ZX_REP_TRX_DETAIL_T not giving any dataSummary: I need accounting information for the transactions. zx_lines is not helping since it does not have history data. Tried using ZX_REP_TRX_DETAIL_T, but its not gi… -
BIP report output file encoding is changing in different ERPC environment, why this is happening?Summary: We developed a BIP report and for that BIP report client requirement is to send data in particular format and it should be in UTF-16LE encoding . file is in .tx…
-
What is the limitation for how large of an XML string Oracle/BIP can handle?Summary: **This post was created as part of a How to Service Request (SR) Release: 23A Content (required): Customer is getting data from external source using web servic…
-
Moved: 2023SOC Reports and Bridge LettersThis discussion has been moved. -
Adding static hyperlink to BIP RTF TemplateSummary: I need to add a basic static hyperlink to a BIP rtf template to open a OTBI analysis. I cannot get the hyperlink or even basic text to display once I upload the…
-
can we create an ESS job to get output files of any other ESS job and send that output to email?Summary: We were trying to get output of an ESS Job (Approval Group Report) over mail. But unfortunately there is no output option for that particular job in advance opt…
-
Is it possible to customize the downloaded report of Transaction console?Summary: After selecting the required process and from actions menu, there is an option to download the report of all the transactions. In the downloaded report is there…
-
2023SOC Reports and Bridge LettersSummary: Has Oracle changed the titles and/or naming conventions for SOC letter and Bridge Letters from 2022 to 2023 Content (required): Our External Auditors are questi…
-
Payload is required for the SOAP web service - BIP scheduled job historySummary: We require the payloads of BIP scheduled job history SOAP web service. Please find the following web service details and share the appropriate payloads to get t…Lakshmana Rao Bandaru-Oracle 225 views 4 comments 0 points Most recent by Lakshmana Rao Bandaru-Oracle
-
Multiple Values for BIP Report Parameter from LOVSummary: How to select multiple values from a LOV for a BIP report parameter Content (required): Version (include the version you are using, if applicable): Code Snippet…
-
Will a version of SQL Developer that can connect to a SaaS instance be released?Summary: We see other products that are being marketed to allow users to query the tables in the SaaS database. Just wondering if a version of SQL Developer might be dev… -
i have this two rows in the result column from union of two subject area i need to divide those rowsSummary: i need to divide the result from subject area 1 (defect as in the screenshot ) above the result of subject area two (total as in screenshot ) Content (required)…
-
what are the seeded Reports/Analytics and infolets in Oracle Help Desk?**This post was created as part of a How to Service Request (SR) Release: 11.13.22.07.0 Summary of the question: What are the seeded Reports/Analytics and infolets and d… -
How can we identify the reports that are using a Custom Subject Area?**This post was created as part of a How to Service Request (SR) Release: 22C Summary of the question: There is a way to find the reports that are using a Custom Subject…Ionel Spaloghe-Support-Oracle 21 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle -
Data Model of Contact and Account EntitiesHi, Please advise how to get the data model of Contact and Account Entities. We referred Doc ID 2154413.1 but it was of no use. if ER diagram cannot be accessed, then an… -
Markie Awards- We want to put YOU in the spotlight- Nominate now!This year marks the 16th year Oracle will celebrate customer experience (CX), innovation, and excellence in advertising, marketing, sales, service, and e-commerce.It’s a… -
Markie Awards- We want to put YOU in the spotlight- Nominate now!This year marks the 16th year Oracle will celebrate customer experience (CX), innovation, and excellence in advertising, marketing, sales, service, and e-commerce.It’s a…
-
BICC PVO is extracting same delta extract every time irrelevant to Last Extract DateSummary: BICC PVO is extracting the same delta extract every time irrelevant to the Last Extract Date. Below are the two PVO for which we are encountering this issue: 1.… -
View the Milestone Due Date's Time in OTBISummary: How do I get the time stamp of a milestone's due date? Content (required): I need to present in a report the difference between the current time and the milesto… -
Sales Analytics DashboardHi, Kindly help me out where does the configuration need to be done to setup the hierarchy to be displayed in Sales Analysis Dashboard report For eg I need John in Globa… -
Need all the columns with CLOB data type in the BICC Extract along with the PVO NameSummary: Hi All, We need all the columns with CLOB data type in the BICC Extract along with the PVO Name in Excel Format. Thanks in Advance :) Content (required): Ricoh …
-
Truncate the Data size to avoid "ORA-12899: value too large for column" in ODISummary: We have a source a file that has more than 4000 char in one column and we trying to load data in ADW but the maximum varchar2 character limit is 4000 char only …
-
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…
-
OTBI - How to get Person_Number for 'People Center Requests' -> 'Primary Point of Contact'?Summary: I am building an OTBI Analysis for Helpdesk Aged Tickets using Subject Area "Service - CRM Service Requests Real Time". How to get Person_Number for the Primary…
-
Chat report by Activity level by DaySummary: Is there a chat report that shows the most active time of day and can graph it for me? Content (required): Interval, month/.day/hour (not inclduing weekends) an… -
remove rows with 0 value from reportSummary: Remove rows with 0 value from report or remove weekend dates/Saturday and Sunday days only. Content (required): reports Version (include the version you are usi…
-
How to pass date to ESS Job for Oracle BI reportSummary: We have created a report that takes start and end date as mandatory parameters in the format (MM-dd-yyyy). When we run this report from Analytics Catalog page t… -
Actionable infoletSummary: Actionable infolet Content (required): Hi, Is it possible to build an actionable infolet for Service request? Version (include the version you are using, if app…
-
Omni Channel - Events ReportSummary: Omni Channel - Events Report Content (required): 1. Omni Service Request and Queue Assignment performance Tile This report would help SR admin to know what is t…Venkataraman Ramakrishnan-Oracle 32 views 0 comments 0 points Started by Venkataraman Ramakrishnan-Oracle