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
-
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 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…
-
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…
-
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 …
-
ODI Marketplace integration with SharepointSummary: Team, do we have any possibility of connecting ODI with SharePoint for data exchange. Has anyone on the team encountered this need before? can you please share …
-
Is there a Oracle DB package / function to retrieve a country code from a given location_id?Summary: Hello, I'm looking for a Package / function which I can use in a BIP datamodel to retrieve a country code for a given location id. Some of the seeded datamodel …
-
How to embed logo or image in email body using email bursting querySummary: Need info on Parameter5 of email bursting query can be included with image file or Logo in it. We want company logo to be added along with email body .Please gu…
-
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 …
-
Need the table name that stores job history of BIP reports submitted through BI publisher dashboardSummary: Need the table name that stores job history of BIP reports submitted through BI publisher dashboard but not the Scheduled processes page. (I know the ESS_REQUES…
-
Data Extraction Approach for Oracle tables that doesn't have PVO'sProblem We need to understand what is the best Data Extraction Approach for Oracle tables that doesn't have PVO's Came across below approaches: Approach 1: Steps: 1. Cre…
-
using trigger for BIP reportSummary: I am trying to use a trigger for a BIP report and schedule. Content (please ensure you mask any confidential information): I only want to deliver the report whe…
-
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…
-
Oracle BICC Frequency options checkSummary: Hi , Oracle BICC has feature to schedule the data extract job with recurrence frequency of Hourly, Immediate, Daily, Weekly and Montly. However our client needs…
-
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…
-
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…
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo…
-
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 …
-
Validate OTBI Table Access for User based on Item Class RulesSummary: We have assigned the group “HPSA_CHANGE_REQUESTER” to Item Class “IC_HPSA”. And then assigned the role “HPSA_CHANGE_REQUESTER” to some users in order to assure …
-
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…
-
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…
-
OTBI BIP - Secured List Views for ERP and SCMSummary: With reference to the Fusion BI Publisher - Fusion Security in BI Publisher Data Models - Secured List Views SLV (Doc ID 2708546.1) - (Refer the document sectio…
-
My approved invoices OTBI reportHow do I default in an OTBI report invoice approver to be the User running the report? Or at least have in the drop down list only value available my name (the name of t…
-
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…
-
report for tax rates by jurisdictionWe are looking for a report for tax rates by jurisdiction
-
What are the Oracle plans on releasing the Redwood functionality for Financial modules and any ETA?What are the Oracle plans on releasing the Redwood UI for Oracle Cloud Fusion ERP - Financial modules and any ETA?
-
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 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…
-
FR studio dividing by 0 causing issues.Summary FR studio dividing by 0 causing issues.Content Column a= 634.74 Columnb= 0.00 Columnc= -([a]-[b]) = (634.74) columnd= [c]/[b]*100 = (should be 0 but getting weir…
-
Merge Two OTBI Subject AreaSummary Develop a OTBI report by Merging two OTBI Subject AreaContent I have a requirement to develop OTBI report using two OTBI subject areas. Following OTBI subject ar…
-
Group Project Tasks by Task NameSummary Group Project Tasks by Task NameContent We have a standardized work breakdown structure and would like to compare costs for the same task across projects, right …