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 and Analytics for ERP
Discussion List
-
BIP 12.2.1.4 desktop flagged with Malicious with high threat scoreSummary: Software packaging team has restricted BIP 12.2.1.4 desktop installation due to high threat score. Need a workaround so that we can continue to use BIP desktop … -
How to handle data access security in Custom BI ReportsSummary: We have the requirement to restrict data in custom BIP reports based on business unit access for the user in Fusion. For example, if report is built for 'XYZ' b…
-
after email updates(change) user not able to access Favorites & My folder..Hi Team, after email update(change) user not able to access Favorites & My folder..Is there anyway to restore that data ?? and what precaution we should take to retain t…
-
DFF in the BICC extract for PO_LINES_ALL. We have DFF in PO_LINES_ALL.DFF in the BICC extract for PO_LINES_ALL. We have DFF in PO_LINES_ALL. The DFF's are BI Enabled. But these DFFs do not appear in the BICC extract Data Store. Can you ple…
-
Is there a list of Essbase cubes and fields available for Cloud ERP?We are trying to find a list of all Essbase Cubes and the fields in those cubes so we can create reports more effectively in SmartView. Does anyone know where we can fin… -
How do I provide FAW accessHello, How does one add fusion analytics warehouse access in oracle.. Our access team stated there used to be an assign groups section listed under the OCI login. It app…
-
ORA-29400: data cartridge error ORA-10260: PGA limit (20000 MB) exceeded - process terminatedSummary: We are running a custom report that have recover more than 1.2 million of records and cheking the XML Data this have over the 1GB, when we executed this report … -
how to get production instance name in BIP reportSummary: How to check via SQL in BIP report whether the instance is Production vs non Production ? we have a requirement to put a check in the BIP report so that emails …
-
Installment payment dateSummary: We would like to have the installment payment date on a report. Content (please ensure you mask any confidential information): We have a report with using the P… -
How to change the output format of the JAVA type ESS Job from .csv to .xmlI have a ESS Job of JAVA Type in Oracle Fusion having output in .csv format, User want the .xml format anyone have any idea how could I change the format?
-
Need Latest Data Lineage Document for DFFs and their associated VOs for BICC cloud extractSummary: Need Latest Data Lineage Document for DFFs and their associated VOs for BICC cloud extract. Lot of BI enabled DFFs are not available in Doc ID 2463485.1. For ex…
-
BI publisher reports using Custom Subject Area objects show Slow PerfomanceSummary: Hi, we defined several custom objects in our sandbox and created Custom subject areas to develop reports by using fusion bi publisher In general, reports are wo…
-
Is it true that oracle is planning to deprecate webservice datasets from BI Data Model?Is it true that oracle is planning to deprecate webservice datasets from BI Data Model? and if its true, what are all the dataset types that will be retained in the futu… -
How to let trial balance report show both PTD and YTD informationSummary: Our user would like to have YTD and PTD shown in one report rather than export twice separately. Is there any standard function to satisfy this requirement? If …
-
I need to get OTBI Report Link with parameter like BIP ReportSummary: Hi Team I am looking for deep link or OTBI report link so that I can hit the URL directly by passing parameters. We have this feature in BIP to get the link , b… -
BI Reporting restricting by segment value depending on UserSummary: I am looking for a way of resticting a BI report by a segment value depending on the user accessing the reports. Ideally by assigning a segment to a user withn …
-
BI query as list of values for a dashboard promptHello, We have a request to create a prompt with the names of employees based on a given job title. To access the data in the subject area "Security - Roles and Privileg… -
permissions to access reports and analytics catalogSummary: Cloud ERP R13 Content (please ensure you mask any confidential information): I have a user with BI Administrator but when trying to access Tools > Reports and A…
-
What is the difference between Uploading a BIP report vs. Archiving a BIP ReportSummary: There are two options to take a copy or get a copy of Data Model and Reports. XMLPServer and click on Upload/Download Catalog folder and Archive/Unarchive Conte…
-
default oracle fusion bi publisher reports listSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Moved: Asset Transaction Real time is not showing dataThis discussion has been moved. -
report for tax rates by jurisdictionWe are looking for a report for tax rates by jurisdiction
-
Calling another template in RTF left-justifies the alignment instead of justifySummary: Content (please ensure you mask any confidential information): Hi all, I am calling another template within my rtf template and it's working great, but the issu… -
Need Setup/Configuration changes Report for Oracle Finance, Procurement, HCM setupsSummary: I Need Setup/Configuration changes Report for Oracle Finance, Procurement, HCM setups. The report should show about the changes made in setups. Content (please …
-
I am not able to access data model through report edit section, page showing as unresponsiveWhen I am trying to access a BI report to attach a data model through Edit section of the report, page is showing as Page Unresponsive in DEV instance, can i delete the …
-
Is that possible to find that does report has used bursting by sql querySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BurstingSummary: Hi team I have a requirement where I should extract list of the reports name in which we have used bursting? Content (please ensure you mask any confidential in…
-
Is there a way to delete data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tablesSummary: Hi Fellow Developers, The requirement is to delete all data from FND_SESSION_ATTRIBUTES, FND_SESSIONS tables for security reasons. Content (please ensure you ma…
-
general ledger journals via subledger to receivablesSummary: BI publisher → SQL → Journal General Ledger Journal Data joining to Receivables at distribution level of detail Content (please ensure you mask any confidential…
-
how to get json formatSummary: Hi, We've a requirement to format output into Json format. Is it possible to do OTBI / BIP Report in this format? Any help is highly appreciated. Thank you!