Reports
Discussion List
-
Planning - The report generation has failed. Error executing query. The number of cells exceeds theSummary: .we have an issue with a report bursting export that we have configured and been sending since last year. since April and May this year . the export of data has… -
Formula Error with Exponential CalculationSummary: Content (please ensure you mask any confidential information): Hi Experts, I'm encountering an error when implementing this exponential formula in my report: Fo…
-
Oracle BI report for account hierarchyI am trying to create a oracle BI report for account hierarchy, but I'm a bit stuck. I used the code below but get a message of missing right parentheses. SELECT LEVEL A…
-
Management Report Page # vs Book Page #Summary Conflicting functions for displaying page numbers in reports and booksContent I am converting FR reports into Narrative Reporting Management Reports. Books do no… -
How to remove processed PO change orders from monthly subledger exception reportSummary: We have a few PO's that are showing up on the subledger exception report monthly but the change orders against them have been processed. How do you get them rem…
-
We are getting an error on migrating Financial reports to Reports.Summary: We are getting an error below on migrating Financial reports to Reports. Grid "Grid1" data row 01 references the property name "Intercompany Account" in express…User_LY017 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
where to find the database connection manager in FRS workspaceHi, I am trying to get the database connection definition and details for FRS report, however i can't find the database connection manager in 23D. I do see the Essbase a…nehayadav86 11 views 2 comments 0 points Most recent by Prasanna Villari BI Publisher Learning Center
-
Formula Returning -1 Instead of Error for Empty Data CalculationSummary: Content (please ensure you mask any confidential information): Hi Experts, I need help troubleshooting a formula issue in my report. Issue: Formula: Column B / …
-
I have to create a actual vs budget amount report for revenue and expense accounts in OTBI.Summary: I have to create a actual vs budget amount report for revenue and expense accounts in OTBI. I have used GL balances real time subject area. The columns selected…
-
How can we bring Approval status into FR reportsSummary: How can we bring Approval status into FR reports Content (please ensure you mask any confidential information): How can we bring Approval status into FR reports…SubramaniKalimuthu 11 views 1 comment 0 points Most recent by ApOK Financial Consolidation and Close
-
Standard VS Custom ReportsSummary: Hi Everyone, Content (please ensure you mask any confidential information): How to check if reports are standard reports vs custom report? I need a table that s…Srushti Dhote 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Validation Status from AP InvoiceSummary: I am creating the Data Model of our BIP Report and I need to find out which field from what table should I use as Validation Status. Content (please ensure you …
-
Existing Active Enrollments measure in BI Publisher using a particular time periodSummary: I need to build Existing Active Enrollments measure in BI Publisher for Learning Module using p_start_date and p_end_date Content (please ensure you mask any co…
-
How to get all attribute in one nodeSummary: Hi Experts, I need your assistance. I'm currently working on XSL files to get values in the XML files. I want to show all the attributes separately in one node.…
-
To connect Oracle Fusion database table with Oracle APEX to create oracle APEX ReportSummary: How to connect Oracle Fusion database table with Oracle APEX to create oracle APEX Report
-
OTBI reportOTBI reportVineet Srivastava Graviton 21 views 1 comment 0 points Most recent by Erick.B Reporting and Analytics for ERP
-
Image reflecting differently in RTF Template and BI Report OutputIn RTF Template I have made the background transparent But in the BI Report Output it is coming as
-
ReportService API appears to be deprecated or marked as obsolete in the April 25B update.Summary: As part of the April 25B Patch activity, we noticed that the ReportService API (/xmlpserver/services/v2/ReportService?wsdl) deprecated or obsolete?. Could you p…Chaitanya2324 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to Generate a Dynamic template based on the assigned Business UnitSummary: Hi Experts, I am seeking assistance regarding a specific requirement from our client. The client has expressed a need to create a document that is customized ac…
-
PRJ: Print Option is not working in Project Overview Page in Project Financial ManagementDear Team, Print option is not working in Project Financial Management, does any specific setup is required for the same? Regards Prashant
-
Task Manager - Adding task to view reports from Narrative Reporting?Summary: What is the best method to give a user direct access to a specific report from the Narrative Reporting library? Is using a Basic Task and then providing the URL…some_oracle_epm_guy 62 views 2 comments 0 points Most recent by GS Financial Consolidation and Close
-
PBCS - Migrated Financial Reports to Reports, but no artifacts are displayed in the target folderTested the migration of an existing Financial Report to Reports by using the Migrate Report icon (for a single report). I selected a target folder that was created in th…
-
Hi Experts, having a requirement to send debrief estimates to Service request contacts.Summary: I am unable to get joins between debriefs(depot repair ) , Service request and RMA orders .I tried joining RCL_DEBRIEF_HEADERS. parent_entity_id with RCL_PARTS_…
-
BIP SFTP Bursting vs BIP SOAP API calloutSummary: Advantages of BIP API download option (for data reports) Vs BIP report sent to SFTP channel Content (please ensure you mask any confidential information): We us…Abdullah Munaz 55 views 2 comments 0 points Most recent by Akash Katiyar-Oracle Reporting and Analytics for ERP
-
Request for Guidance on Managing DEI Attributes in OTBI Analysis Following Executive Order 14151In response to the Executive Order 14151, "Ending Radical and Wasteful Government DEI Programs and Preferencing," signed on January 20, 2025, our Compliance team is work…SwatiSharma 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
was trying to fetch the date format as 01-Jan-2025 in bip getting an errorHey i have a requirement in the bip where the date format is 01-Jan-2025 and in the SQL of bip i have used the format like TO_CHAR(ele.EFFECTIVE_END_DATE,'DD-Mon-YYYY') …Kande Likhitha 41 views 4 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie… -
Changes only HCM Extract for Payroll payments extract always extracts full fileSummary: We currently have a full file extract which sends the Check payment details to bank and now the requirement is to change it as changes only file . I have taken …
-
Showing BLANK pages in EPBCS Reports (Management Reports) even with SuppressionSummary: In the main report of my Budget Letter Book, it is showing or printing (PDF) BLANK pages because of No Data or suppression on the Grid. It is displaying the Hea…