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
-
How to concatenate elements with same name in etext templateSummary: How to concatenate elements with same name in etext template Content (please ensure you mask any confidential information): We are working in etext template for… -
How to update the timezone in reports?Hi, I have my time zone set at the user preference level. However when I run the seeded Trial Balance Report, the time is wrong on the output (showing UTC): How to corre…
-
Payables Trial Balance ReportSummary: I've set up a role so GL Users can run this report but when they do it errors with a permissions issue. Is it right only Payables Managers can run this report, …
-
Created a BIP report from subject area Payables-Payments Disbursement Real to concatenate columnsSummary: Created a BI publisher report using Subject area from Payables. There is no option to concatenate two or more columns. I need to concatenate the payee address f…
-
How to reorder columns in xpt templateSummary: How to reorder columns in xpt template Content (please ensure you mask any confidential information): Hi Team, We have created xpt template and we need to re-or…
-
Employee Location not visible in custom report output for certain usersSummary: We have created a program that extracts all the posted journals for a set of accounts. In our implementation, Employees are stored as parties for making payment…
-
Auto Refresh a BIP ReportSummary: How to refresh a BIP report after a certain period of time? Content (please ensure you mask any confidential information): HI, We want to show a report on a Dis…
-
Can someone suggest me with respect to performance tuning of the query?Issue is with a BIP report for optimizing the report query FYI this is AR report for Aging bucket. please find my initial findings below, request you to please provide y…
-
Fusion to SFTP - File got corruptedSummary: By bursting query we are transferring a fusion report to SOA SFTP. But in SOA SFTP the files seems to have missing lines. i.ie., Fusion report has 18k lines in … -
Can't create dynamic hyper link in PO approval notification template.Summary: I am trying to create a hyper link that takes the po number () in the po approval template and pass it to a parameter in another custom report I created . That'…
-
Supplier data model missing a column in displaySummary: The tax ID column is missing in a custom data model for one user. Content (please ensure you mask any confidential information): I created a data model (SQL que… -
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…
-
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… -
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 …
-
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…
-
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 …
-
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" …
-
What is the Retention policy for BIP Jobs run in Fusion ERP Cloud?Summary: What is the Retention policy for BIP Jobs run in Fusion ERP Cloud? Do we have more information on maximum value/minimum value for retention? Also Is there a cos… -
SoX BI report for Role and ESS changesHi All, As part of SoX auditing, we are looking for lookback BI reports to identify Role and ESS changes as we find from our analysis that the Audit reports available ou…
-
Is it possible to pull the approvers for Job Requisition Approval?Summary: We are trying to create a BI report to know with whom the Job Requisition Approval is pending with. We have used the below query to pull the details but when th…
-
Need to modify Privileges to IT IT Auditor roleCan you help identify which Privileges have access to modify Profile Options and REST API. We want tocustomize this Role. IT Author Role Access This role gives access to…
-
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)…
-
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 …