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
-
Need to move Profit and loss FRS report from one instance to anotherSummary: Content (required): I have created a FRS report of profit and loss statement and I need to move it to another instance. Any suggestions on how to do this Versio…
-
How to create an OTBI Report to display POs by running for GL Parent/Child Department valuesSummary: How to create an OTBI Report to display POs by running for GL Parent/Child Department values Content (required): How to create an OTBI Report to display POs by …
-
Export Current Page returns all rows i.e, entire dashboard data in OTBI.Summary: Export Entire Dashboard is exporting all rows but "Export Current Page" no longer exports only the rows on the current page. It is exporting all rows. Please ad…
-
-
Extract Fusion Spend Classification Data using BICCSummary: How to extract Spend Classification Data from Fusion? Content (required): As per Fusion 21C, Oracle has introduced Spend Classification Oracle Procurement Cloud…
-
What System Role gives access to PER_LDAP_ROLES?Summary: What System Role gives access to PER_LDAP_ROLES? Content (required): Hi All, I keep forgetting and cannot find a document outlining this but what role gives acc…
-
Which database is used by Oracle Analytics Cloud?Summary: I wanted to understand if Oracle Analytics Cloud sits on the same Cloud Fusion ERP database or it uses a different database. Content (required): To be clear - I…
-
COUNT Function to get specific valuesSummary: Hi Experts, I have created a report to get the sum of certain rows by specific values. For example, the column returns values as either "REC" or "UNR". So the r…
-
FscmTopModelAM.FinGlAccountsCodeComboAM.CodeCombinationPVO returns empty rowsSummary: FscmTopModelAM.FinGlAccountsCodeComboAM.CodeCombinationPVO is not returning any row while runni ng from BICC Content (required): Version (include the version yo…
-
OTBI - Count FunctionSummary: Content (required): I have the below requirement, A report to capture all transaction details and the entry users has already been created. (The format is attac…
-
A report for print options for AR customers - Missing FieldSummary: A report is required to detail the print options for AR customers The issue I am having is location the tables that hold Statement Preferred Delivery Methods fr…User_2025-02-11-10-53-01-866 41 views 2 comments 0 points Most recent by User_2025-02-11-10-53-01-866
-
AP Aging reportSummary AP Aging reportContent Is there a standard AP Aging report available online? We were advised that the AP Aging report in Oracle can only be run on the current da…
-
How to link the sla to an invoice lineSummary: Need to link invoice lines to the subledger xla and xle files Content (required): Version (include the version you are using, if applicable): Code Snippet (add …
-
How to send and unsend a report based on its content in oracle BISummary: How to send and unsend a report based on its content in oracle BI Content (required): Hi everyone, There's a requirement to have a certain report output mailed …
-
After a refresh from Prod to Test (P2T), is there a list of recommended processes to run?Summary: After a refresh from Prod to Test (P2T), no data is showing on neither the inquire on detail balances screen nor the budgetary control dashboard. Content (requi…
-
OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier?Summary I'm building an analysis in OTBI and wanted to know if it's possible to have a calculated column that summarizes one of the other columnsContent I'm building an …
-
How to change the logo dynamically in fusion home page?Summary: How to change the logo dynamically in fusion home page? Content (required): Hi All, Is it possible to change the logo based on the user login on the fusion home…
-
Current year + 2 as filter in columnSummary: Content (required): Hi I would like to show the forecast for 2 years from now for a specific column. For example in the code below I've used a repository variab…
-
Report on OTBI Agents Scheduled / StatusesSummary: Report on OTBI Agents Scheduled / Statuses Content (required): Is there any way to Report on OTBI Agents Scheduled / Statuses, either via SQL in BI Publisher or…
-
Combine BiP and OTBI audit data in custom reportSummary: Is it possible to combine BiP and OTBI audit data? Content (required): We have enabled the BiP audit feature and have compiled an OTBI audit report. Business is…
-
DFF not available in Subject area even after running the specified processSummary: We have created an OTBI report for Projects using Project Cost - Actual Real Time subject area and it includes a couple of DFFs. This report was migrated from o…
-
how to define a xml in rtf if there are multiple datasets with the same column nameSummary: Hi everyone, Recently I faced an issue with a seeded report that was customized. The report had two datasets with the same column on both, where when I try to l…
-
Error : Exceeded configured maximum number of allowed output sectionsSummary: Error : Exceeded configured maximum number of allowed output sections Content (required): Hi Experts, We are trying to run thr report " Payables Credit Memo Mat…
-
Prepayment invoice detailsSummary: Prepayment invoice details Content (required): Hi experts, I got new report requirement to display prepayment invoice details based on as on date. 1. prepayment…
-
ERP BI and OTBI Reporting - Creating Custom RoleSummary: Hi Guys, Anyone has any idea how to go about creating a Reporting Role for Applications Internal Team for adhoc BI & OTBI reporting . Is there a delivered role …
-
Error whilst joining Subledger and GLHi, I am trying to create a report that joins the subject areas Subledger Accounting: Journals Real and General Ledger: Journals Real Time. It works fine up to the point…
-
OTBI Dashboards for AP and AR AgingSummary Graphical dashboards with summary aging of AP and AR debt, with drill-down to invoice detailsContent These dashboards provide a graphical summary of AP/AR debt w…
-
BI Bursting - ZIP text files during deliveryHi All Is it possible to zip the text files from BI FTP bursting ? Thanks
-
Pick Slips Not printing to printerSummary: Pick Slips Not printing to printer Content (required): We have scheduled Pick waves. Document set attached to the rule. Pick slip is submitted but failed to pri…
-
customizing Receivables Aging by General Ledger Account ReportSummary: I'm trying to customize the Receivables Aging by General Ledger Account Report, but I'm not able to get any sample data. Content (required): I have created a co…