Reports
Discussion List
-
HCM Extract: ORA-06502: PL/SQL: numeric or value error: character string buffer too smallSummary: The extract is running into error, logging also set to "no logging". But still the extract running into error, below shows log. There was a ORA-06502: PL/SQL: n… -
Configure unit inventory including property, building, floor, and unit details.Summary: Property hierarchy in Fusion Lease Accounting Cloud for Revenue Leases. Content (please ensure you mask any confidential information): Is it possible to create … -
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 3.8K views 22 comments 1 point Most recent by Mitali Meshram Reporting and Analytics for HCM -
Is there a way to correlate the Personal Payment Method ID and Bank Account ID to actual banksSummary: We can pull audit reports on personal payment methods which include a bank account ID. We would like to correlate that Bank Account ID to an actual bank account… -
Creating a quick analysis for employee terminate information with legal employerI am creating a quick analysis for a bulk worker termination but when adding the legal employer name column that is needed in the criteria, it breaks the results. When I…Damien Curtis 32 views 7 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Note number on Financial statements to be linked with Notes gridSummary: On face of Financial statements like Statement of Financial Position or Statement of Profit and Loss there is Note no which is linked to Notes report grids embe…Amara Sai Sandeep 31 views 7 comments 0 points Most recent by Tom LeFebvre-Oracle Narrative Reporting -
Larger Reports Generating Significantly Slower After 26.07 UpdateSummary: Has anyone else had larger reports processing time take a lot longer after 26.07 update? We are seeing our larger reports generate a lot slower than in the past… -
FR report with 2 gridsSummary Need to create a FR Report with 2 grids from 2 databaseContent Hi everyone,I'm in a move to cloud and I have some reports from financial reporting that have one …Mayela de la Vega Duque-143698 67 views 5 comments 0 points Most recent by Dave Roberts_-Oracle Planning -
Set different alias tables for different columns/rows.Suppose in my report i have selected alias table A, which is what I want for my Accounts which are present in rows. Now for the Entities present in columns, i want to us… -
Table to get user password expiration dateSummary: Table to get user password expiration date Content (required): Hi All, Which table stores the user password expiration date? The user wants to create a report. … -
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…Md Jamil 24 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Does Report package refresh have available rest API/features in OIC to get triggered?We are creating a report package. We want to know if there is an automated way to refresh all the reports content in the report package using REST API/features in OIC. o… -
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 63 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Performance Document Period Questionnaire Responses ReportSummary: Using Workforce Performance - Performance Rating Real Time to build a detailed report based on the Questionnaire Responses. Content (please ensure you mask any … -
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 … -
HRC_TXN_CONSOLE_ENTRY table is not returning any values for the TASK_APPROVER fieldSummary: HRC_TXN_CONSOLE_ENTRY table is not returning any values for the TASK_APPROVER field. When I export the transactions from the transaction console, it exports the…DariaTekoutieva1 16 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
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 3 views 2 comments 0 points Most recent by Abhishek Premchandra BI Publisher Learning Center -
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 … -
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 54 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… -
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 5 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 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP