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
-
BI Bursting - ZIP text files during deliveryHi All Is it possible to zip the text files from BI FTP bursting ? Thanks -
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (GL) For An Employee Columns are: Accounting Date Transaction Number Payr… -
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…
-
Tools > Audit Reports - What table can I look at to see this data?Summary: Tools >Audit Reports > run the report to view changes to supplier banks. There is a field Description. Need the table where this data is populated Content (requ…
-
How to add Award project burden schedule and burden rate available in OTBI ?Summary: Our business needs ward project burden schedule and burden rate available on OTBI side. Has anyone configured them via flexfields? Content (required): Version (… -
What data store contains DFF fields for Enterprise Contracts header record?Summary: Content (required): We are trying to extract Enterprise Contract Header DFFs but cannot find a data store that contains these. Version (include the version you …
-
performance between xmlpserver/services/ExternalReportWSSService versus more api rest in integrationSummary: performance between xmlpserver/services/ExternalReportWSSService versus more api rest in integration on oic Content (required): hello I could to know that diffe… -
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… -
BI Publisher Excel TemplateSummary: How to display a column conditionally in BI Publisher Excel Template? Also I want to display a hard image in excel based on condition of data source in excel te…
-
How do we set the default value to "On" for the prompts auto-complete field?Summary:In recent upgrade documentation https://docs.oracle.com/en/cloud/saas/otbi/otbi-notable/index.html#TBIWD-GUID-26F03E96-6982-42BC-A9CA-8BFEDBA1FFFC It mentions “S…
-
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 51 views 2 comments 0 points Most recent by User_2025-02-11-10-53-01-866 -
Can Oracle ERP Cloud BIP pulling data from external database to build report?Summary: Can Oracle ERP Cloud BIP pulling data from external database to build report? Content (required): Version (include the version you are using, if applicable): Co…
-
Outbound Integration - Every one hourSummary: Outbound Integration - Every one hour Content (required): Hi All, We got the requirement for GL Journal outbound integration through BI report. The job should r…
-
Oracle Fusion BI Catalog Folder ControlSummary: Oracle Fusion BI Catalog Folder Control Content (required): We have encountered multiple times where users have accidently moved or made changes to BI Catalog F… -
Report that shows project codes and cash receipts associated with that projectSummary: I am working on generating a report that shows both the project codes and the associated cash receipts/revenue detail with regard to that project - grant revenu…
-
No data in subject area Project Management - Task Management Real TimeSummary: Content (required): I cant see data in the OTBI subject area Project Management - Task Management Real time. Despite I can see the milestones the application. I…
-
How to send BI Publisher reports to FTP folder from ESS jobSummary: How to send BI Publisher reports to FTP folder from ESS job Content (required): Hello All, I will appreciate your support in the following: When I schedule the …
-
Approval Groups Report - ESS JobSummary: Hi, which privilege grant access to this report? We know role Financial Application Administrator grant access but we need which specific privilege as we need t…
-
Working on PO detail report that includes change ordersSummary: I need to create a detailed report that shows all PO detail including all change order activities - this could also be a requisition report if that is the prope…
-
FRS - Selecting multiple values for Point of ViewSummary: Selecting multiple values for Point of View Content (required): Hi All, We have a requirement to selct multiple values for the POV when selecting the initial re…
-
Receivables: Status Tracker in OTBI/BIPSummary: Content (required): Is it possible to report on this Status Tracker in OTBI? Or BIP? And if so which which subject area or which tables are these to find in? St…
-
Conversion Strategy for reimplementation of Oracle ERPSummary: Content (required): We have already implemented Oracle Cloud, but we’ve since been acquired by another organization. This new parent org is on a different calen… -
How to lock down HSGETVALUESummary: Would like to lock down (hard-code / copy-paste) all "HSGETVALUE" formulas, without locking down all the other formulas in the spreadsheet Content (required): I…
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe… -
How to convert hexadecimal to Base64 in BI ReportSummary: How to convert hexadecimal to Base64 in BI Report Content (required): Hi All, How to convert hexadecimal to Base64 format in (SQL) BI report. Need to generate Q…
-
Roadmap Features ListSummary: Roadmap Features List Content (required): Hi , Is there any page where we can see roadmap of upcoming features till next 2 or 3 releases. One of my customer is … -
Oracle Fusion the seeded report "Receivables Aging by General Ledger Account Report" custom steps ?Summary: Seeded Report name - "Receivables Aging by General Ledger Account Report" custom steps ? How to use the Report parameters used in this scheduled report in some …
-
Legitimacy of SQL Writing Softwares like Cloud MinerSummary: Content (required): Hi Gurus, Recently, we heard that softwares like Cloud Miner is helpful in writing SQL query in Fusion BI without the need to create a repor…
-
Is it possible to set up triggers for BICC extractsSummary: Is it possible to trigger a BICC extract to occur only when data has changed? Content (required): We would like to extract data stores that don't support increm…
-
How to modify Asset Cost Summary ReportSummary: I'm trying to modify the Asset Cost Summary Report. I created a copy of the DM (path = /shared/Custom/Financials/Fixed Assets/Asset Balances/Data Model/Cost Sum…