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
-
BLOB in sql query datamodel, how to display readable values?Summary: In BI in a datamodel, how to display in readable format a BLOB value? select adhocschedule from fusion.request_history This value only displays: ��¿¿ ¿ -
Sql query to get PO Change Order line Details.Summary: Required sql query to get following PO Change Order line Details. Columns: Attribute Change From and Change To Content (please ensure you mask any confidential …
-
Unresolved Account Permission getting added to BI catalogue in oracle ERP after deployment.Summary: we are migrating the BI Data model and Report along with folder structure to higher environment in ERP cloud, we are facing issue where an "unresolved account" …
-
Query to fetch project and Time card entries(OTL)Summary: Hi Team, We need a table where the project number and time card entires details or SQL query Content (please ensure you mask any confidential information): We n…
-
performance issue in transaction listing reportSummary: I am trying to optimize the performance of GL transaction listing report. It is taking longer time to load the report & after 30 mins it is getting failed while… -
Emailing an OTBI Analyses does not send data for prompt selectedSummary: OTBI Prompt data selected does not match data when emailed. Detailed overview: I have a prompt built into an Analyses report, that enables a manager to select t… -
can we do the page personalization on the invoice type lov in the create payment pageSummary: can we do the page personalization on the invoice type lov in the create payment page, in fact we want to remove two option from the default LOV that is Manual …
-
How to get green check mark and Time along with Digital Signature in Oracle BIPI have a requirement to print the Digital Signature with Green Check mark and Time using RTF Template in BI Publisher(Sample Attached). Let me know how can we achieve th…
-
Need PVO details for PER_USER and PER_USER_HISTORY?Summary: I am looking BICC Tag for PER_USER, PER_USER_HISTORY I've found "HcmTopModelAnalyticsGlobalAM.UserAM.UserPVO" this PVO has history id so I assume this is for PE…
-
BI Publisher Report Linking Account with NodeContent I'm trying to create a report in BI Publisher that displays account (Segment2 in the GL_CODE_COMBINATIONS table) with the account tree node. I can't find a table… -
ExternalReportWSSService in SOAP UI does not give correct BIP Report responseHello All, I am facing issue in OIC New Hire Integration between Oracle HCM Cloud and Ceridian Dayforce. In OIC Service, SOAP API call(ExternalReportWSSService) to BIP R…
-
How to Schedule a BI Publisher Report with Dynamic time range in parameter ValuesIssue Description: We need to view the BIP Reports -'Execution History by User' and 'BIP Reports Execution Summary'. To accommodate this, we are utilizing one of Oracle'…
-
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…
-
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?
-
Prevention of Custom Extension Field mismatch in regard to different Instances for BICCSummary: Since Custom extension fields may differ from Instance to Instance is there a way to prevent this on BICC Content (please ensure you mask any confidential infor…
-
OTBI Bad Performance- After Adding Accounting Class Code - Subledger Accounting - Journals Real TimeSummary: Using subject area Subledger Accounting - Journals Real Time, for example looking at source: Projects with a filter on natural account/concatenated segment and …
-
Is it possible to use multiple letters in the 'begins with' filterSummary: We have some OTBI reports that we use an agent to schedule and they have gone over 25k rows so now they are not including the full data set (currently 44k rows)…
-
OTBI with Deep Link Sample Report for Purchase OrdersSummary: Hi, we have a requirement to enable drill feature on Purchase order number in the OTBI report. Clicking on PO number should enable to navigate to the Applicatio…
-
Page is not available after Click Launch Financial Reporting Web StudioSummary: Page is not available after clicking Launch Financial Reporting Web Studio Content (required): I Went through the following path to do and adjustment in Grids a… -
ESS job and job sets migration from one instance to anotherSummary: We have around 200+ ESS jobs and each time after refresh, it is a tedious and time consuming task to migrate each of them individually. We have to document each… -
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 it possible to audit invoice notes entered by accounts payable users?Summary: I am going through the Payables audit policies to determine if I can enable tracking of any invoice note edits or deletions. I'm not sure if the best approach i…
-
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten… -
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 …
-
Is there a way to limit what tables a user can query in OTBI?We have a support team that's requesting access to write Data Model queries in OTBI. Our concern is restricting them to only the financial tables. Does anyone know if th… -
Oracle Fusion BI Publisher - Pivot table - Dynamically derive headerSummary: Hi All, We have a requirement where we have to calculate opening balance of a fund(GL_CODE_COMBINATIONS.SEGMENT6) from GL balances and pivot it to the fund name…
-
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…
-
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 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… -
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 …