Category 129
Discussion List
-
BI Excel Template missing formula when data generatedSummary: I've created a BI Excel template based on a DM and the requirement is to have certain columns color coded in the end of the report and also have a formula field…KrishnakumarPathipati 32 views 5 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Invoices Paid on timeSummary: Hi Business is trying to generate the invoices paid on time report in Fusion Cloud Not able to trace the seeded / standard report for the same. Can you please g…SaurabhSinghal26 62 views 6 comments 0 points Most recent by Prateek Bajpai Reporting and Analytics for ERP
-
retrieve latest entry from table OKC_K_HEADERS_TLSummary: I am trying to get only the entry that has the most recent creation date from this table. Content (please ensure you mask any confidential information): Creatio… -
Identifying Underlying Queries for SmartLOV/ VOs In BI PublisherSummary: Content (please ensure you mask any confidential information): Hi experts, Would any of you know how to identify the underlying query for a view object in BI Pu…
-
Adding a custom report to DOR screenSummary: Adding a custom report to DOR screen and need the report to fetch data related to current employee but the report fetches null. Content (please ensure you mask …Salma Mohamed Salem 11 views 0 comments 0 points Started by Salma Mohamed Salem Reporting and Analytics for ERP
-
Etext template output file(.txt) is unable to print Arabic language in sequenceSummary: We have custom Etext template under disbursement payment file formats. In that Supplier name is required to show in Arabic language in output file. for testing …SireeshaJaladi 41 views 2 comments 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Oracle EBS - invalid SessionSummary: Oracle EBS - invalid Session Content (please ensure you mask any confidential information): How can this be resolved fndgfm.jsp error : The current session is i…
-
Is it possible to generate barcode for space in BIP fusion?Summary: Is it possible to generate barcode for space in BIP fusion? Content (please ensure you mask any confidential information): We've already setup BIP barcode font …Lucy.liu 43 views 3 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
How to filter and sum positive or negative value only in FRS reportSummary: To see if FRS report could filter value of positive or negative and do summation against it. Content (required): We would like to know is there a way to filter …Chow Ka Ming Jason-Oracle 82 views 1 comment 0 points Most recent by Janitha Perera Reporting and Analytics for ERP
-
BIP report historySummary: I have a requirement to pull the BI reports from Report history for failed runs. Do we have any table to pull the BIP report data based on date range. Content (…
-
OTBI Analysis - General Ledger - Journal Real Time : No output after MigrationHi, I have migrated OTBI report to one of the demo environment but I am not getting any data in the output. There are no filters in the report and I have validated that …Karun_Jain-Oracle 2 views 1 comment 0 points Most recent by Karun_Jain-Oracle Reporting and Analytics for ERP
-
RTF template to xls report with blank rows due to conditional regionHi All I created a rtf template which need to output as a xls file. After it generated, it shows some blank rows due to the conditional region in ref template. xls outpu…
-
DTD and Index file for Germany tax reportingWe have a Legal Entities registered in Germany and we have to submit data to German tax authority. For this, I have followed the note id Oracle Fusion Cloud ERP: Germany…
-
SQL-How I get all the children/parent of account in GL ?Summary: SQL-How I get all the children/parent of account in GL ? Content (please ensure you mask any confidential information): Hello I am looking for a custom report t…Cesar Saveedra 25 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
How to identify changes done in Project Task? Is there any Audit history mantained?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Akshit Chawla 12 views 1 comment 0 points Most recent by Akshit Chawla Reporting and Analytics for ERP
-
Schedule in Analytics is Greyed-OutSummary: The Schedule button is Greyed-out Content (please ensure you mask any confidential information): Please help! Version (include the version you are using, if app…Dorren Veil Laniog 138 views 2 comments 0 points Most recent by Dorren Veil Laniog Reporting and Analytics for ERP -
Replacing Project attribute with Organization name causes severe performance issueSummary: We enabled Project DFF and included the attribute as a filter as organization name in OTBI. The report runs normal if we filter for specific orgs but when submi…
-
How to bursting a report with multiple data sets ?Hi all, I have a BIP report with multiple data sets to query different data to different excel sheets. I'd like to use bursting function on this report, but I found that…Weitao 636 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
How to create an OTBI Report to display GL Parent/Child values ?Summary: How to create an OTBI Report to display GL Parent/Child values ? Content (please ensure you mask any confidential information): Hello I would like to have a Cha…Cesar Saveedra 212 views 2 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
FRS Workspace Server Settings - Impact to changing timeout valuesSummary: On Oracle Fusion, Finacial reporting studio, workspace server settings, want to understand the impact of changing the timeout values for session timeout and Kee…
-
GL Segment Level security and OTBI Subject areasSummary: We have a requirement to secure data down to a legal entity/cost center level for dashboard built in OTBI with the GL Transactions real time subject area. How b…amy hardtke 31 views 2 comments 0 points Most recent by Madhavi Godbole Reporting and Analytics for ERP -
Can anyone help in sharing an idea for developing contra account report.Summary: For example, if in parameter, an account is selected, all relevant Debit and Credit which were generated against that account gets reported. Content (required):…Usman Ul Haq 23 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Table/Query to find the BPM work flow notification pending with particular personSummary: We are looking for Workflow notifications (Especially Expense report) pending with one particular person for approval. Do we have any table which stores this de…Thanigainathan R 453 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
can we pull historical details of CANCELLED ESS jobs from back-end?Problem Description --------------------------------------------------- AUDIT CONCERN: can we pull historical details of CANCELLED ESS jobs from back-end? During an audi…Janardhan ACS-Oracle 31 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How to link between General Ledger, Subledger and Receivables tables in BI PublisherSummary: I'm trying to add information from the Receivables tables to a General Ledger query on income when a transaction has come from the receivables ledger. But I am …
-
Payables Posted Invoice Register to show final approver doubles invoice line amountsSummary: I'm trying to modify the Payables Posted Invoice Register to show the final approver, but the output shows the invoice line multiple times. Content (required): …Niall McColl 32 views 3 comments 0 points Most recent by Niall McColl Reporting and Analytics for ERP -
query for rejected invoices and rejector commentSummary: We're looking for a query that will show rejected invoices and the reason they were rejected as well as the cost center and creator. Content (please ensure you …
-
Oracle roles required for developing BI reportSummary: Need to know what Oracle roles are required for an user to develop BI report Content (please ensure you mask any confidential information): Version (include the…
-
Ago Function not working in OTBISummary: We trying to use AGO function for Previous Year Actuals Column in OTBI General Ledger - Balances Real Time. But report is showing null values in Previous Year A…FirozahamedSK 42 views 2 comments 0 points Most recent by FirozahamedSK Reporting and Analytics for ERP
-
Can we call OTBI/Analytics dashboard using SOAP/REST webservices in oracle fusion?Hi , We have a requirement to run/submit the analytics/OTBI dashboard using rest/soap webservices. Please share your inputs. Appreciate your help. Thanks in advance.Bhavani Rikkula 272 views 2 comments 0 points Most recent by Bhavani Rikkula Reporting and Analytics for ERP