Reporting and Analytics for ERP
Discussion List
-
Create List of Values for Dependent Segments in GL Custom BI Publisher Reports White PaperSummary: Your finance staff may modify standard GL BI Publisher (BIP) reports to address specific business requirements. They may need to run a GL BIP report by various … -
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter … -
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…
-
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… -
BICC - ability to product a single CSV output merging data from many data stores/VO'sSummary: Does BICC support selecting columns from different data stores/PVO's and apply query filter? Content (required): We have a business requirement to extract large…
-
Customize Receivables aging seeded ReportSummary Customize Receivables aging seeded Report - to include Project information and grouping totalsContent Hi, We want to customize Receivables aging by General Ledge… -
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…
-
Fixed Assets- Asset Balance Real Time and GL SegmentsSummary In OTBI Fixed Asset subject don't have the GL Segments - just concatenatedContent I need to build reporting on fixed assets around the different segments in the … -
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…
-
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…
-
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… -
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…
-
Financial Reporting Webstudio Performance IssuesSummary: Oracle closed out the old discussions on this topic. We are still facing (on 22B) performance issues with Financial Reporting Webstudio. We are interested to he…
-
Where can I find the Payment Number for Payables on OTBISummary: I'm trying to pull together a report listing payments made to suppliers and need to include the the Payment Reference Number (i.e. the cheque, payable order (PO…
-
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 …
-
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… -
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…
-
Unable to locate Direct SQL option after upgrade 19ASummary Unable to locate Direct SQL option after upgrade 19AContent HI, I'm not able to location the Direct SQL option after upgrade the 19A. Can anybody suggest where w… -
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…
-
Is there a mapping document from eBS to Fusion CloudSummary: We are moving one of existing eBS customer to Cloud and while moving existing reports for customer, we are facing many challenges to map eBS fields to Fusion Cl… -
Supplier Audit ReportSummary Supplier Audit ReportContent Good People, Anyone create supplier Audit Report as a custom one apart from the one available ? Thanks, Soumya -
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…
-
Adding Distribution Information to Payables Invoice InquiryYou can extend pages with custom OTBI reports, for example with budgetary control charge account and projects information is useful when viewing invoices. The Embedded I… -
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…
-
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…
-
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… -
Where to find the Building Society Roll number for a supplier on OTBISummary: I'm based in the UK and need to pull together a report (preferably using OTBI) listing suppliers' bank details that includes the Building Society Roll number or…
-
Fixed column for year and other columns are promptedSummary: Content (required): Hi all I would like to know if it is possible to have one fixed column which always shows the forecast for e.g. 2022 while other columns are…
-
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…