Reports
Discussion List
-
EPm Cloud new Reports logo positioning is incorrect after migration from FRSummary: Content (please ensure you mask any confidential information): Hi all After the migration of FR reports to the new REPORTS, the logos do not remain in position.… -
Scalled reporting currencySummary: Hi All, Recently we migrated data from EPBCS to FCCS on EUR_Reporting currency. However, in it's reports and forms, the customer would like to have the possibil…DylanPauwels 51 views 3 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close -
Management Reports Fail to Load After Continuous use of ApplicationHas anyone else encountered an issue: after using the application for a while, I am unable to generate reports? The rest of the application works fine, but to get the re…B.Bhandari 51 views 11 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How to handle the data which has a new line in it in LOV/BI Reports.Summary:User has mistakenly entered new line in a column, where data type CLOB is text, for that the LOV value is populated in 2 line and the report parameter is not han…Sura Yashaswini 12 views 3 comments 0 points Most recent by Sura Yashaswini Reporting and Analytics for HCM -
User Entity and Data Base item for getting Period Name from person results page after a payroll runPlease help me with the User Entity name and Data Base item for getting 'Period name' from person results page after a payroll run in an extract. Please find the screen … -
Unable to convert date in specific formatSummary: We are fetching termination date from xml table which is fetched in string format. We need to convert date in format 'DD-MON-YYYY' which is not happening. Data …Arpit Dhalawat 13 views 2 comments 0 points Most recent by Arpit Dhalawat Reporting and Analytics for HCM -
Absence Accrual BalancesContent Hi - I have a report that shows the absence accruals for each of our plans and it works great for those that are calendar year Plan Period Type. It shows me the …Prudence K 354 views 27 comments 4 points Most recent by Shameer Shaik Reporting and Analytics for HCM -
Does the SOC report cover any risks and controls related to the mandatory audit trail requirement?Summary: Does the SOC report cover any risks and controls related to the mandatory audit trail requirement? please advise. Content (please ensure you mask any confidenti…KC-2109 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How can I access the candidate profile source via BI publisher?Summary: I need to access the source fields on the candidate profile. I have so far identified that I can access the application source via the IRC_SOURCE_TRACKING table… -
Compensation OTBI Best PracticesSummary Technical brief discussing compensation related OTBI best practices Content Document 2571003.1 - Compensation OTBI Best Practices (July 2019)Gail Langendorf-Oracle 151 views 2 comments 8 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need help on Long Running Custom BI Report - running more than 5 hours and failingSummary: The Custom bip report is running for long time(more than 5 hours) and erroring out saying that "Elapsed Time is exceeded" . Would you please help in tuning the …Rama123-Oracle 294 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
grid promptSummary: Content (please ensure you mask any confidential information): Hi I migrated FRS report to Reports folder. The report consits of multiple grids, with every grid… -
Report book synchronization issueSummary: Hello, It seems there is a synchronization issue with the report book. When we change the POV in the report included in the book, the report book stops function…Sashidhar Reddy K 21 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
We want to dynamically change the formula for a Total based on the Month of the Calendar Year(FRS)Summary: Hi Team, We have a formula Cell in FRS Report where the sum is multiplied by the Number of Months. Right now the formula is Static, but we need the formula to d… -
Suppress rows on the basis of notes in line grid entryI have created a grid in Narrative Reporting which has 3 note columns with account and data source members in rows. I want to suppress the rows which has no notes entere… -
Pivot balance rolling basis calculated using rtf template in BI reportHi, I hope this email finds you well. I facing some issue from balance logics in rtf layout, Also, balance is equal to (On-hand + current commit – demand qty) on a rolli… -
How to enable password for P60 Document with date of birthSummary: We are trying to password protect the Oracle P60 document with employee's Date of Birth. The XML doesn't have the Date of Birth tag. Can we modify the seeded Da…SAHAD 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM -
Filtering the top 20% and Bottom 10%Summary: I am working in a Dashboard Report Identify Top Talent (using Performance and Potential) Report. Is there a way to filter the top 20% and bottom 10% of employee… -
BI Report for otbi reports and the scheduled agentsWhich table stores the information of otbi reports and its scheduled agents.Aishwarya Somvanshi 81 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Get all EMP reporting to a manager in certain time periodI am looking to get all direct reports(all active and term) of a manager during the time period 10/31/22 to present day 05/20/24. If termed I need also need the term dat…Trupti Khodke 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Absence Daily BreakdownWe have a daily absence breakdown report built using the subject area Workforce Management - Absence Calendar Details Real Time. SQL code attached. https://us.v-cdn.net/… -
Oracle HCM Value Sets Rest APIHi, I want to create a record for value set using Oracle Rest Api information.I found this API for this How should I use the ValueSets_Id information, which is the param… -
Can we export the reports in Powerpoint directly using smartviewHi, We are trying to export the FCCS reports using SmartView directly in the Microsoft word and file. Is this functionality available in the MR reports? Regards Jyoti Sh…JyotiSharma 21 views 2 comments 0 points Most recent by JyotiSharma Financial Consolidation and Close -
Report off of Attachments Within Performance ModuleSummary Managers and employees can add attachements to their performance form. I need to know who has an attachment.Content Our managers can use the attachment field at …User_2025-01-25-00-37-41-739 63 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Resubmission Reason and Resubmission Status values in Manage Time cardsContent Hi All, In which column and table holds "Resubmission Reason" and "Resubmission Status" values. Navigation:Navigator--> My Client Groups-->Time Management--> Man… -
Manage Administrator Profile Values ReportSummary: We are trying to Fetch the Module Name (Meaning) Can anybody Please advise for fetching the Module Name of Manage Administrator Profile Values Content (please e…MilanMohanty 232 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
How can give condition Sysdate betwee effective start date and effective end date in OTBI analysisSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Anup Karmankar 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Is it possible to have dynamic columns in FCCS/Planning reportsHi Team, We are trying to built report in Planning with the dynamic columns but seems there are not much options. We wanted to populated completely different set of colu… -
link between FND_SESSIONS table to country and stateSummary: link between FND_SESSIONS table to country and state Content (please ensure you mask any confidential information): By using FND_SESSIONS table, we can get the …