Category 81
Discussion List
-
How can I get mass results for Responses in Assessment?Summary: We assigned our organization (~7,200) a video to watch and asked everyone to answer a feedback question. All that was fine except now I am trying to report on a…Aaron Reynolds 31 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
Is the External Application Merge feature of FAW GASummary: Currently working for a customer who has a lot of custom SA's which they would like to bring into FAW. Merging the SA's into the FAW RPD seems to be the easier …Amrita Gupta-Oracle 53 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
BI Publisher SQL helpHello Team, i have written below sql to fetch count of time entries. select REC.RESOURCE_ID, count(distinct(to_char(start_time ,'yyyy-MM-dd'))) as Counter from HWM_TM_RE…minati_behera-Oracle 32 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to Pull Future Dated InformationSummary: How to Pull Future Dated Information from HCM Content (required): I have created a report in OTBI using the Payroll - Calculation Cards Real Time Subject Area. …User_2025-03-07-06-11-23-192 32 views 4 comments 0 points Most recent by User_2025-03-07-06-11-23-192 Reporting and Analytics for HCM
-
Tables to get the talent ratingSummary: What are the tables to get the Talent ratings(Performance rating) Content (required):Navigation Me->Directory(search for employee). Go to show more and click on…Rahul Saini 101 views 13 comments 0 points Most recent by Rahul Saini Reporting and Analytics for HCM
-
Removal of first two rows in OTBI outputHi Team, When we schedule the OTBI report with excel output, Output contains first line with header and next line is blank. Our actual output starts from third line. How…
-
Add "Business Object Type" and "Attribute" columns to the Delete Audit ReportSummary: We had a custom report called 'Delete Audit Report' and the client wants to add columns on it for 'Business Object Type' and 'Attribute' same on what we see on …Maria Cristina L. San Jose 32 views 1 comment 0 points Most recent by Maria Cristina L. San Jose Reporting and Analytics for HCM
-
Termination Headcount MeasureSummary: Subject Area: Workforce Management - Work Assignment Event Real Time, Assignment Event, Termination Headcount calculating terms on the last day of the month in …Rebekah Gilday 93 views 5 comments 0 points Most recent by Yves Blanc Reporting and Analytics for HCM -
How to identify Specific Column used Reports in BIPSummary: Hello Everyone, Is there any query we to fetch all BIP reports which are using specific column? Eg: Person_Number (Per_all_people_f) Can we pull all BIP Reports… -
Are there any dashboard prompt experts or videos out there?Summary: Trying to create an EDI dashboard cross referencing with the new Learning Subject Area Content (required): I need to access data in three subject areas "Workfor… -
Can we access SOA MDS schema in fusion OBI reportsSummary: How to access SOA MDS schema in fusion OBI reports Content (required): We want to fetch business rules information in Cloud HCM through an OBI report. Is SOA MD…Hitachi ServiceDesk 21 views 0 comments 0 points Started by Hitachi ServiceDesk Reporting and Analytics for HCM
-
DATE_ADD function ErrorSummary: Hi Everyone! I am try to add specific year to the hire date using Date_add function, but it is throwing "Missing right parenthesis error". Could any one help me…
-
Procurement and Projects Folders are still available after doing Catalog Lockdown steps!Summary: Content (required): Procurement and Projects Folders are still available after doing Catalog Lockdown steps! Version (include the version you are using, if appl…Walid Hamdy 23 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Analysis with parameter not errors from Reports & Analytics but works from BI CatalogueSummary: We have a report which is available for managers but it errors from the Reports and Analytics page but works from the BI Catalogue. The report has a prompt (dat…Ruurd Reuver - Oracle 42 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Fusion BI Report Output file name along with current date and timeSummary: Fusion BI Report Output file name along with current date and time Content (required): Hi Team Can someone help me how to add date and time in the custom BI rep…[Deleted User] 2K views 4 comments 2 points Most recent by Kavitha Balaiah Reporting and Analytics for HCM
-
Oracle BIP Report Issue with RTF templateSummary: Seeking a solution to fix the corrupted RTP template. Content (required): Enhancing the existing rtf template to add a new field. However, the new field value d… -
Top Employee Missing from HierarchySummary: Our top employee is not appearing in reporting when the organisation hierarchy is included in a report. Content (required): The head of our organisation current…
-
Address change by DepartmentSummary: I need to be able to provide address changes only for certain departments. The Workforce Management - Person Real Time subject area does not appear to have the …
-
Costing table link with gl tables in hcm fusionSummary: I am looking for the below tables Whether its linked with gl tables pay_costs pay_cost_allocations_f pay_cost_allocations_keyflex GL_JE_BATCHES, GL_JE_HEADERS G…
-
Resignation/Termination Approval- Current/Pending Approver DetailsSummary: Resignation/Termination - Pending Approver Details Content (required): Hi All, There is a report requirement to show Resignation/ Termination approval -> curren…
-
View Display Error - Error Codes: EKMT3FKSummary: I am running a fairly simple OTBI analysis and the report won't return all the records. The below error is presented when exporting the report: View Display Err…
-
Report on Employee's Time in Current RoleSummary: Content (required): We're looking to build a report that show us how long an employee has been in their current. Do anyone have recommendations or samples? Vers…Ratha Sun 41 views 1 comment 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM
-
How to take Resignation Submission date?Summary: How to take Resignation Submission date? Content (required): Hi All, Report requirement to show employee's Resignation Submission Date. From which table we can …Venkatesan 31 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
SQL for PER_EMAIL_ADDRESSES to obtain Email Address IDSummary: Email Address ID required for HDL worker.dat file to mass upload email address changes. Content (required): We want to use HDL to mass upload email address chan…Michelle Hughes 3K views 6 comments 0 points Most recent by Michelle Hughes Reporting and Analytics for HCM
-
Restricting the values of a dashboard promtSummary: Hello, We have made a BIP report on an Assessment which will show the candidates who have reached the assessment state and their results/current status etc. The…Shreya Datir 42 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How can i get access to OTBI?Is there a specific role/privilegie that grants access only to the OTBI? Thanks Guys, Mayko MeloMayko.Melo 32 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
State tax details in hcm fusionSummary: I am looking for the below details in the state tax setup level state tax type state Minimimum wage state of the tax defined Please guide me to refer the table …
-
Rehires are showing twice when using Seniority Years in Wrkfrc Mgmt - Person Seniority Real TimeContent (required): When I add Seniority Years (or months/days) to a report in this subject area, rehires are duplicated with one row calculating based on their enterpri…Monique Dias 52 views 5 comments 0 points Most recent by Monique Dias Reporting and Analytics for HCM
-
Post P2T, how to switch from classic dashboard view to new dashboard view?Summary: We have dashboard in Prod which has a responsive UI as per below. However post P2T, In Test it is showing classic view for the dashboards. How to change this vi…Sathesh Ramaswamy 61 views 9 comments 1 point Most recent by PriyankaM Reporting and Analytics for HCM
-
Column order in BIP ReportSummary: Column order in BIP Report Content (required): Hi, We are trying to have specific order of columns in our BIP report (CSV output). Earlier it was word layout wh…