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 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 … -
Need help with querySummary: May I know what is wrong in this query Content (required): SELECT order_key, dfla.source_order_number, dfla.source_line_number, DFLA.ordered_qty using_requireme…
-
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… -
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…
-
SFTP bursting to home directoryHi All We have an issue delivering files to "\" directory for a vendor.. There are no sub directories and oracle documentation mentioned \ should not be used. and when n… -
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…
-
Unable to Import Lookup TableSummary: Getting error while trying to import lookup type code when having context segment and associated DFF. We have context attribute named as context segment which a…
-
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… -
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…
-
Looking for SQL query for Duty Role to Job Role mappingSummary: We have a couple of job roles and child duty roles and privileges assigned to the same job role. Can someone help me with SQL to fetch the same as we need to co… -
Importing Budget in Oracle Cloud for only reporting purpose.Summary: Our requirement is to import budget from external source (EPM). Either through integration or manual upload. We don't want to apply any Budgetary Control for th…
-
Ability to audit the native login enablement.Summary: We would like to understand if there is an option to Audit the native login being enabled/disabled in Cloud ERP. Content (required): Navigation: Tools > Securit… -
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 (…
-
How to download SOC(System Organisation Control) Reports for Oracle Fusion Cloud finance ERPSummary: Hi Team, Could you please suggest on how to download the SOC(System Organisation Control) Reports for finance ERP. Earlier, users having access to my service on…
-
Moved: FRC Report - issue in save and insert row and column template functionality in FRCThis discussion has been moved. -
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…
-
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…
-
Prompts are not currently supported for analysis that combine criteriaSummary: Combined two SA i.e "Projects Billing - Revenue Real Time" + "Project Performance Reporting Real time" and want to have 'Project name' as Prompt Value and it is… -
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…
-
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…
-
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…
-
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…
-
What will be the expression to calculate duration between two timestamps ?Summary: While Creating the Downtime Custom Page using Application Composer, a field named "Calculated Duration" is defined with data type as "Formula". So, an EL Expres…
-
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…
-
Not able to execute report from "Financial Reporting Center"Hi, I have developed a custom report and able to generate the data without any issue if i run from "Report And Analytics" but report execution is failed from "Financial …
-
Query to fetch the Requisition job pending approval details in oracle fusionSummary: In purchase requisitions we have to prepare a bi report for the pending approval status and their job name Content (required): Version (include the version you …
-
Report for Users Activity in Oracle Fusion - Audit ReportSummary: I would like to know if there is any report to see user's login date and time for audit purposes. Content (required): We would like to know when the users login…
-
how can we schedule the archive processhow can we schedule the archive process Content (required): how can we schedule the archive process for custom reports Version (include the version you are using, if app…
-
Moved: Need document on Localization for Israel, Switzerland and Portugal in Oracle Fusion ERPThis discussion has been moved.