Reporting and Analytics for ERP
Discussion List
-
OTBI Analysis Subject Area: General Ledger - Balance Real Time "Period Name" range criteria issueContent Hello There, I am using a range critera BETWEEN for a OTBI analysis Subject Area: General Ledger - Balance Real Time column name 'Accounting Period Name' and thi…
-
How to convert English language to Arabic in rtf templateSummary: how to convert below English text into Arabic language and split it into two lines in rtf template. Example input text: "EIGHT HUNDRED FIFTY-SIX BAHRAINI DINARS…
-
Information regarding UCM storageHi Team, I have below given doubts regarding UCM as we are using UCM as storage while extracting file from BICC. 1) Is there any storage limitation with UCM ? Does it ev…
-
what role is required for data model in oracle biSummary: what role is required for data model in oracle bi Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code sni…
-
Schedule running of 'Workflow Transactions Listing'Summary: Can we schedule the running of the report 'Workflow Transactions Listing' and send an email to all the approvers included on the result of the run? Content (req…
-
Fusion SaaS BIP to OIC SFTP serverWe have a requirement to transfer a Fusion SaaS BIP report to OIC SFTP server within the same region. Is it the correct understanding that this traffic won't go over int…
-
In OTBI GL- Balances Real Time subject area 1 segment is missing from the Subject AreaSummary: Since second balancing segment label doesn't have the BI Object Name, we have created the custom label and given BI Object Name to add the Fund segment along wi…
-
Moved: Member Selection is not showing correct value in Smart View ReportThis discussion has been moved.
-
Scheduled Jobs ErrorSummary: Hi Team, We have few scheduled jobs which will run on daily basis. Recently few system automated jobs and manual scheduled jobs ended in error without any log f…
-
Need Information on Parameters for AP_TRIAL_BAL_REPORT_PKG.BEFORE_REPORTWe are using a customized version of the Payables Trial Balance Report to pull one specific account via custom parameter on the data model. We would like to add another …
-
SQL Query for bypass Approval transactions of the BPM workflowSummary: The Client is asking to build a report based on the bypass Approval transactions of the BPM workflow. (without Approval). Content (required): we need to build t…
-
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …
-
Limitations on number of Invoice lines that can be printed / generatedSummary: Business has a requirement to print Aggregated Invoice via ESS Scheduled Process/ Reports Business wanted to know if there would be a technical limitation on th…
-
eText Templates seeded sample templatesHi , From where can we download some of the seeded eText Templates used in Oracle for payment formats. Can anyone please share the exact path in the BI catalog. Thanks V…
-
Attaching BI Report to OTBI DashboardSummary: Hello, I want to attach a BI report to OTBI Dashboard and connect it with dashboard's prompt. Question 1: Can I attach and view a report made from FSCM Tables (…
-
FRC Report - issue in save and insert row and column template functionality in FRCWe are facing issue in using insert row and column template functionality in FRC , we are not able to transfer values from 1 report to another or 1 grid to another using…
-
Budgetary Control Analysis ReportSummary: Control Budget parameter search does not return all project numbers in the Oracle seeded BI Publisher report Content (required): We have a user that runs the se…
-
BI Publisher Data Field formulasSummary: Hello Oracle folks, Maybe someone knows the solution to below: can someone help how to achieve adding two summarized data field in BIP Layout? I have 2 fields t…
-
Edit template and add new column in the existing templateHi We have an existing date model with 20 columns and all are selected in the report template. I have added one more column in the DM as per requirement but am not able …
-
How tables are joined for a View ObjectSummary: Is there any document or Oracle Cloud Application embedded method to figure out how the Database Tables are joined for a View Object? Content (required): Versio…
-
SaaS Service Usage Metrics Report, Is it possible the overusage generates additional billing?Summary: The SaaS Service Usage Metrics Report / Hosted Named User Unexpected Usage, shows an overuse in B91079 SKU, is it possible that this overusage generates additio…
-
Employee Audit ReportSummary: Are there any delivered reports or custom BIP reports someone could share to help with an Employee Audit Report? I have already included the required Employee i…
-
Template for large BIP reportHi Which template is it recommended to use if we need to generate reports which require layouts with many columns. Using the wizard for creating .xpt reports, it is diff…
-
BICC offering on specific EntitySummary: I have configured the BICC on UAT and created the offering for AP Invoice and Line. I need to know how to extract the data only for specific legal entity (we ha…
-
How to create Dependent List of Values parameter in ESS Job with User-defined (SQL) LOV as SourceSummary: I would like to know if it is possible to create a parameter in an ESS Job that is dependent on another LOV parameter that has a User-defined (SQL) LOV Source. …
-
Procurement OTBI DashboardsSummary ERP Procurement OTBI Reports and Dashboards uploaded for the CommunityContent Sharing a procurement to pay dashboard with multiple tabs containing example report…
-
Query to get hash codes in case of Fusion APISummary: In max of the REST API for Fusion, we need to pass hash keys like for example in case of Invoice attachment (https://docs.oracle.com/en/cloud/saas/financials/23…
-
Need to know how much longer the ESS/Scheduled jobs logs can keep in the system.Summary: Need to know how much longer the ESS/Scheduled jobs logs keep in the system. Content (required): How much longer we can pertain the logs of the ESS/Scheduled jo…
-
Archive/Unarchive buttons missing in Catalog ReportsSummary Archive/Unarchive buttons missing in Catalog ReportsContent Hi All, Archive/Unarchive buttons missing in Catalog Reports Thanks, Dev Thota. Version 21B
-
How to Fix Height of table In An RTF TemplateSummary: Hi Team ,Can anyone tell me how to Fix Height of table In An RTF Template. Example: If table has 1 or 10 invoice the height of table should be same. I have chec…