Reports
Discussion List
-
I Combined two subject areas but two records coming with active status but only one activeSummary: Hi Team, We have Combined two Subject Areas but assignemnt status showing as active with two records both are active but diffrence is one is with termination da…AjayKumar Maddipati 42 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
BI Output file name along with current dateContent Hi, Can someone help me how to add date in the output file name of BI report while downloading directly from BI catalog? ex: Employee Detailed Report_yyyymmdd.xl…Nivya Mathire 626 views 8 comments 2 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
which tables stores interview evaluation feedbackHi Team, May I know which tables stores interview evaluation feedback ? If possible can I get a snippet of SQL code ? Regards, Harish -
Report Refresh Option in Smartview from menu does not refresh dataSummary: Content (please ensure you mask any confidential information): Hi all We are seeing an issue where if we : Open a REPORT in Smartview and change data via an Add… -
DFF - Character limitContent We currently have a flex field with a character limit of 160, it is proposed that this is increased to 1500. Will it be possible to still report in an OTBI analy… -
Dashboard Prompt Not Working on Logical SQL AnalysisSummary Dashboard Prompt Not Working on Logical SQL AnalysisContent Hi experts, - I have created a report using Logical SQL. Please see attached. - I created a dashboard…Raymund Jerome 211 views 18 comments 0 points Most recent by Kaustubh Deshmukh Reporting and Analytics for HCM -
Exceeded Configured Maximum Number Of Allowed Output Prompts- error code WVIMVZWVSummary: Exceeded Configured Maximum Number Of Allowed Output Prompts- error code WVIMVZWV Content (required): Exceeded Configured Maximum Number Of Allowed Output Promp…Swati U 511 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
What parameters to pass when scheduling TimecardApprovalNotificationBulkReport to get XML fileSummary: Hi experts, We have a requirement to get the XML file from a seeded report - TimecardApprovalNotificationBulkReport. However, when scheduling the report, there'… -
How to schedule to run the report and send it via email?Hello everyone, I want to schedule to run a report in EPBCS and send it via email. Is there any function that can help with this requirement? I tried to find it in the J… -
Is there a table which holds the certificate information within the security consoleSummary: Is there a table which holds the certificate information within the security console for users. I need to see what certificates employees have associated with t… -
possibility to update POV layout orderSummary: Content (please ensure you mask any confidential information): Hi all We wanted to change the order of the POV items: Year and period and I was not able to do s… -
book table of content does not displaySummary: Content (please ensure you mask any confidential information): Hi all I am trying to create a BOOK with Reports with a table of contents and it is not displayin… -
Table or SQL queries for getting Project number along witht Expense report number ?Summary: Hi Team, Can anyone please let us know the table or SQL queries for getting Project number along witht Expense report number ?. Need to connect table PJF_PROJEC… -
Lease Details Report Layout ChangeSummary: Change in the Lease Details Report layout? Content (please ensure you mask any confidential information): We have noted a change in the Lease Details Report lay…Janelle Azimullah-Oracle 51 views 9 comments 1 point Most recent by Courtlyn Henderson Lease Accounting -
Invalid parameters requested.Summary Invalid parameters requested.Content Hi, Im getting an error "Invalid parameters requested." for one of the values in the LOV which is based on SQL query. Can yo…Damodar Peddakotla 1.1K views 3 comments 0 points Most recent by User_J7ULB Reporting and Analytics for HCM -
Headcount is not being populated in Work Measure tableSummary Some employees have rows for HEAD others don'tContent Hi There, Does anyone know why HEAD information is populating for some employees but it is not for others? … -
Report grid exportSummary: Content (please ensure you mask any confidential information): Hi In FRS we were able to export grids. Pls check the option highlighted in yellow. I need to fin… -
How do you suppress NRCS reports for bursting definition members with no data?Summary: We have all historical departments in our department hierarchies. Many of the departments are old and have no data. We then use the department hierarchies in ou… -
Connection time out while scheduling BIP reports post 24C upgradeHi All, We are getting Connection timeout issue while scheduling BIP reports. This is something we are experiencing post 24C upgrade. Does this has anything to do with N…Satyabrata Nanda 83 views 2 comments 3 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
PER_POSITION_BUDGETS is showing no data. Need Position Budget FTE for custom report.Summary: We need to add Position Budget FTE in a custom report but PER_POSITION_BUDGETS has no data. Do I need to add any role for this table to do we get this informati…Punnya Vijayan 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
we joined two subject areas but when we apply single country it is woking fine but multiple not workThere was an error rendering this rich post.AjayKumar Maddipati 21 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to extarct DDL of table in oracle fusion HCM/FSCMHi, We need to extarct DDL for few tables like column name, data type, size, primary key , foreign key constraints . We tried sql query approach but due to data type siz…hiteshsaroha 41 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to fetch attachments from OTBISummary: Hi Expert, Currently, I'm using "Recruiting - Recruiting Real Time" & "Recruiting - Recruiting Event Real Time" Analysis and want to see the attached file in my…Saher 166 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Report to use in journeys e-sign task to pull employee job's job descriptionSummary: Hi, We would like to trigger a journey to internal employees when there is a job change action performed on their employee assignment. I see action "job change"… -
Issue with extract for termination detailsSummary: We are using this extract from couple of months back . It is working for all other employees. Only 2 employees facing issue with termination details , we could …Vishnupriya 67 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Query to fetch 'Report Job Histories' data from 'Manage Job History'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…jahanavi metta 125 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Manage Enterprise HCM InformationSummary: Hello everyone, I have a report about Manage Enterprise HCM information. Can anyone advise on how to pull the corresponding columns? You can find them by naviga…Chris Carloff 41 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM