Reports
Discussion List
-
How to stop oracle smartview automatic refresh in a private connection fileWe have multiple reports created in oracle smartview using private connection. Everytime when we open the file it ask for refresh and don't show any data. Is there we ca…Himanshu Saxena 34 views 7 comments 0 points Most recent by SaifUrRehman Financial Consolidation and Close -
Customize Payroll Activity Report and/or Periodic Payroll Activity ReportQuestion: What are best practices for customizing the seeded, legacy Payroll Activity Report and/or newest Periodic Payroll Activity Report? How can we add in assignment… -
Query to fetch the report columns name in oracle fusion.Is there any query to find the Report columns Name , Report Path, Report Name Oracle fusion. There are various kinds of report present in the instance such as BI report …
-
Notify Project Admin when Project manager is terminatedSummary: Hi I have received a request from Project Administration if it is possible to create an alert to notify the registered Project Admin if the currently active Pro…
-
How to set static/Dynamic password generation for PO-PDF in Oracle FusionSummary: How to set static/Dynamic password generation for PO-PDF in Oracle Fusion A requester received a Purchase Order (PO) change notification, which included the PO …Shweta Prakash Veer 2 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Oracle Fusion Lease Accounting – Common Lease Interface Issues During StabilizationHi Community, We are currently in the stabilization phase of our Oracle Fusion Lease Accounting (FLA) implementation and would like to share some of the recurring interf…
-
Rest API or SOAP service to list down user folders under /users folders of fusion BIPSummary: We have a requirement to get all user folders and objects under /users (my folders). Is there any way to extract the user folder list. Content (please ensure yo…
-
Where can I get OTBI sample seeded financial reports?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Greg Hyndman 6 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
SummarizeGridNotes using members that are not in the ML FileSummarizeGridNotes with Use Context enabled ignores customized Notes Summarization ML examples that consistently omit technical POV members. Is there a way to make sure …
-
Do not promote feature in ReportsWe have an option called Do no promote in Forms Formatting / Validation rules , which allows user to restrict promoting an entity in Approval workflow. Do we have any su…Amara Sai Sandeep 33 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Virus Scanner Not Reachable - Unable to Archive Files in My Folders / Shared FoldersSummary: Content (please ensure you mask any confidential information): Hi, We are encountering an issue when trying to archive files in My Folders and Shared Folders. E…Sankalp Shukla 1.8K views 14 comments 1 point Most recent by yurtsevmihcioglu Reporting and Analytics for HCM -
How can I edit a data source in Planning?Summary: I have migrated reports from Narrative Reporting to Planning, in version 26.07, and the reports were pointing to a data source in Narrative Reporting that have … -
OTBI report - functional managersSummary: I would like to create a report that could give me a list of functional managers by employee - OTBI reports. Content (please ensure you mask any confidential in…Jacqueline GRANDIN 26 views 2 comments 0 points Most recent by User_MKTG2 Reporting and Analytics for HCM
-
Re-hire employee HDL templateSummary: Hi Expert, We are looking for an HDL template to rehire terminated employees. The requirement is to rehire employees with the same assignment information they h…
-
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 864 views 11 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM -
Is there a report or table which store history or audit on the data access sets granted and revokedSummary: Is there a report or table which store history or audit on the data access sets granted and revoked. We cannot see the any data access set once they are revoked…
-
Modify New Hire State Report Template for USSummary: We have a requirement to include few extra columns in the delivered New Hire State Report for US. I would like to understand if we are allowed to that? Previous…
-
Annual salaries for current and terminated employees in one reportIs it possible to create a report with just a list current and terminated employees and their annual salaries?Ulitka 101 views 15 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Generate .ZIP file from BI Publisher ReportSummary Need to create a BI publisher Report that can output .zip file to be run in HDLContent Hello, We want to create a BI publisher report that can provide us a .zip …
-
Financial Reporting Center - Define Tags (GL_FRC_USER_ACCESS_REPORT_TAGS)Summary: Is anyone using the GL_FRC_USER_ACCESS_REPORT_TAGS table in a BI Publisher report? How are tags defined? https://docs.oracle.com/en/cloud/saas/financials/26c/oc…Meredith Bickell 5 views 0 comments 0 points Started by Meredith Bickell Reporting and Analytics for ERP -
Need sql Query to fetch the Job Applicants in Draft StatusSummary: We have a Requirement to build a BIP Report for fetching the Job Applicants in Draft Status. Can anybody please share the sql query for this requirement. Conten…Milan_Mohanty 21 views 2 comments 0 points Most recent by Milan_Mohanty Reporting and Analytics for HCM -
Web Forms opened in SmartView IssueSummary: Web Forms opened in SmartView is showing Zero values in Blank Formula Rows and Columns. Anyone has experience the same? Content (please ensure you mask any conf…Kenneth John Asper-Oracle 146 views 7 comments 1 point Most recent by Niranjan Bodas Financial Consolidation and Close -
Intercompany Report displaying value in Partner Amount instead of Entity Amount columnSummary: I have a question regarding out of the box IC report: Lets say there is a transaction recorded by Entity 54001 with a trading partner has an amount of 2,167. Ho…Saraiya Daisy Dhanesh 31 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
enable gen AISummary: enable generate AI in narrative - any additional costs? Content (please ensure you mask any confidential information): Assuming the client has enterprise perfor… -
How to add dynamic logo to an OTBI analysis ?Summary OTBI Analysis & Dynamic LogoContent Good People, Is there anyway we can add dynamic logo to an OTBI Analysis ? Thanks, SoumyaSoumya Prakash Parhi 123 views 7 comments 1 point Most recent by Tiw.Jyotsna-Oracle Reporting and Analytics for ERP -
Setting the Audit Retention PeriodSummary: We regularly run the roleAssignmentAuditReport, which in the past contained 90 days of data. Recently we found it only contains 30 days of data. Per the documen…Jacalyn Munyon 13 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to get Barcode on PDF type BIP reportHi, I am facing an issue where the report generated from BI publisher is able to fetch the barcode in RTF and HTML format, but when i change it to PDF, it disappears and…Prashast Dabral 9 views 1 comment 0 points Most recent by Abhishek Premchandra BI Publisher Learning Center -
Facing performance issue with a query on gl_periods and per_calendar_events tables.On Fusion ERP I have a BIP report with complex query which involvers among others GL_PERIODS and PER_CALENDAR_EVENTS tables. Report parameters are GL Period From and GL …N.V. Mehta 11 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
AI Agent Audit ReportSummary: Two different BI Publisher reports to track AI Agent usage by end-users and administrators. Summary Audit Report that audits a completed conversation from a pub…Race Schreimann-Oracle 531 views 10 comments 3 points Most recent by Race Schreimann-Oracle AI for Fusion Applications