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 get row count from PVOs in BICC?Summary: We have been asked to verify that the # of rows we have pulled out of Oracle via BICC is correct. When we attempt to do a COUNT(*) against some PVOs, we are get… -
Moved: Report to show PO with its contract and RFQ detailsThis discussion has been moved. -
Moved: How to prevent report output going to outside organization via email outputThis discussion has been moved. -
How to get data for Audit Reasons column in OTBI like the Expense Auditor Dashboard ?Summary: We are working on a custom dashboard for Expense auditors and one of the fields requested in 'Audit Reasons'. The subject area 'Expense- Expense Transactions Re… -
Moved: Custom BIP Report Dynamic Column IssuesThis discussion has been moved.
-
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… -
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…
-
Moved: oracle fusion ESS job request limits per hour.This discussion has been moved.
-
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 …
-
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 …
-
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…
-
How we can create custom popup notifications from Oracle Paas to Oracle FusionSummary: Hi Team , we have a requirement to create custom pop up notifications from Oracle Paas to Oracle fusion with action buttons. We are able to follow the recipe sh…
-
Descriptive Flexfields capabilities in FusionSummary Need to understand Descriptive Field Flexfields capabilitiesContent Wants to understand a point of view on the following points: 1. How security can be enabled a…
-
HOW TO SETUP TWO SEPARATE ENTERPRISE STRUCTURE FOR SEPARATE LEGAL ENTITIES IN ONE FUSION INSTANCEIs it possible in the latest release of Oracle Fusion Cloud Financials to establish two distinct enterprise structures for separate legal entities or legal groups within…
-
List of Incompatible ESS Jobs in Oracle Cloud FinancialsSummary: How do we find which ESS Jobs are incompatible to each other. Content (please ensure you mask any confidential information): Recently we had Posting Program run…
-
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 … -
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 …
-
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 …
-
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…
-
Moved: Customizing Accrual Reconciliation report and status is Retrying when running ess jobThis discussion has been moved.
-
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…
-
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…
-
Fixed Asset ReportingSummary Reporting from Fixed Asset Sub-LedgerContent Hello - I'm looking for the following information in a report from the Fixed Asset sub-ledger. I am looking for a re… -
Moved: How to query the latest pdf contract from purchase agreements after a change orderThis discussion has been moved.
-
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…
-
FRS - Member Descriptions and AliasSummary Alias concatenating Name and Description, and Description is blankContent Can anyone help explain why the Member Alias (Default) in FRS merges the Value and the …
-
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…