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
-
Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_TXN_TYPESSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_TXN_TYPES? Content (required): Version (include the versio… -
Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_INSTALLED_BASE_VSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_INSTALLED_BASE_V? Content (required): Version (include the…
-
How to enable selecting multiple values (not range) for Custom ESS Job parameters in Oracle FusionSummary: We have requirement where user need to select multiple values (not from - to range but random values) for different COA parameters in a custom ESS Job parameter…
-
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…
-
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… -
Can we enable or disable report one parameter field based on other parameter field input?Summary: We received requirement like, 1) Choose field say start date or end date from drop down 2) Choose Operator Prior/After/Between from drop down 3) Enter Date : Da…
-
User is not able to run Customer report in OTBI report,Summary: Users is not able to run Customer report in OTBI report, could anyone please let me know which Duty Role or Privilege required to run this report, we have assig…
-
Oracle Fusion: Is there any relationship/link between Security Job Roles and FND ApplicationsSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Fetch all the reports detailsWe are aware that to fetch reports details, "GL_FRC_REPORTS_B" table can be used. But it is giving only the Financial Report, do we have any other table which will give … -
Is it possible to add a Payment Date Parameter for Payables Withholding Tax Report.Summary: Adding Payment Date Parameter for Payables Withholding Tax Report. Can you please advise and provide the steps. Content (required): We are trying to add Payment…
-
How to create reports related to tables that are only in PaaSSummary: Hi, We want to know if there is a way to create reports in SaaS that retrieve information related to tables that are only in PaaS. I have created a custom table…
-
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… -
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…
-
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… -
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. -
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…
-
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…
-
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 151 views 4 comments 0 points Most recent by Lakshmana Rao Bandaru-Oracle
-
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… -
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)…
-
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…
-
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 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…
-
How do I display the lookup code in a OTBI analysis?Summary How to display a custom fiel lookup code in a OTBI analysis?Content Hi, A client wants a OTBI report with columns that contain the lookup code of some account's … -
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.… -
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 …