SQL
Discussion List
-
Which table stores value set details used in fast formulaContent Hello everyone, Which table stores the information about the value set which is used in fast formula. if anyone knows which tabe defines the relationship between… -
BI Report: Need help with Dependent parameter LOVSummary BI Report: Need help with Dependent parameter LOVContent Hi, I have a BI Report where there are 2 parameters: 1) Review Period: 2) Period_Month_Or_Week 1) Review…User_MC37Q 60 views 15 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Issue in "Workforce Performance - Performance Rating Real Time" Post Rel 13Summary Post Release 13 IssueContent Hi All, Attaching a report for performance tracking created on the "Workforce Performance - Performance Rating Real Time"(subject ar…User_2025-01-30-00-14-06-021 81 views 6 comments 0 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM -
Can I use one dashboard prompt parameter value as input in the SQL results query(choice list) of anoSummary OTBI : Can I use one dashboard prompt parameter value as input in the SQL results query(choice list) of another dashboard prompt parameterContent Hi, Please find…User_MC37Q 83 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Reports: Condition Region around tables are not working in RTFSummary BI Reports: Condition Region around tables are not working in RTFContent Hi, To explain in detail: We have a data model which has a parent and a child group. G_G…User_MC37Q 33 views 2 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Dependent Parameter in BI Data Model does not work as expected.Summary Dependent Parameter in BI Data Model does not work as expected.Content Hi, Dependent Parameter in BI Data Model does not work as expected. The 2nd parameter's va…
-
Report on Anytime FeedbackContent Hi All, Is there a delivered report for anytime feedback that we can leverage? If not, has anyone built one and how? Please share any information you might have.…PriyaPenugonda-SC 92 views 1 comment 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM -
Compare 2 columns in OTBI report & apply conditional formatting ( (Colors) on one of themSummary Compare 2 columns in OTBI report & apply conditional formatting ( (Colors) on one of themContent Hi, I'm new to OTBI. I have a requirement to display the Column …Aloka Bhattacharya 420 views 13 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Schedule Report JobSummary Adding Output destination typeContent I need to add a destination type like FTP and Web folder. Can someone let me know how to add values for it ? Also I need kn…User_2025-01-28-21-18-43-496 76 views 2 comments 0 points Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for HCM
-
Returning the most recent dateSummary Want to return only the most recent dateContent I have an analysis that I am doing in BI and trying to return just one record per person, with the date as the fi…Deb Luisi 93 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need help in excel templateSummary Need help in excel templateContent Hi All, I'm facing issue when I try to paste the xsl code into a cell in the excel template. Let me brief about my requirement…User_DZMJW 51 views 2 comments 0 points Most recent by User_2025-01-28-07-12-45-467 Reporting and Analytics for HCM
-
how to fetch previous and current value for global transfer action?Content Hi, we are not able to find solution to action 'global transfer' (when changing Legal entity) to see in one report the old and new value- related to the fact new…Gal Shani 113 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need to find out the Payroll Batch Loader Element Entry input value tablesSummary Need to find out the Payroll Batch Loader Element Entry input value tablesContent Hi All, I have a requirement to generate an error report for payroll batch load…Sricharan Monigari 117 views 6 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
OTBI Security Risk - Seeded Reports Without User Security & OTBI Access for EmployeesSummary OTBI Security Risk - Seeded Reports Without User Security & OTBI Access for EmployeesContent Hi All, We have recently discovered that seeded Oracle reports do no…User_2025-01-29-23-59-58-976 140 views 12 comments 1 point Most recent by User_2025-01-29-23-59-58-976 Reporting and Analytics for HCM
-
Displaying images in BI Publisher RTF TemplatesSummary Displaying images in BI Publisher RTF TemplatesContent Hi, I'm fetching employee images from PER_IMAGES to display in the report. I have provided size restrictio…Aloka Bhattacharya 62 views 4 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM
-
SUBSTRING function to separate multiple Valid GradesSummary We are trying to separate each valid grade into a separate columnContent When pulling job codes and valid grades, all valid grades are in one cell. We would like… -
Reports not running since R13 18A appliedContent We upgraded to R13 and all Reports were running as expected, with no problems. Maintenance Pack 18A was then applied, and some reports are now experiencing issue…Rebecca Smith-27468 35 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Push Weekly Email Notifications to a particular group of Line Managers and EmployeesSummary Push Weekly Email Notifications to a particular group of Line Managers and EmployeesContent Hi Friends I need to send couple of weekly notifications to a group o…Mansur Khalil 53 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
EText Template: Count of rows not resetting at each LevelSummary Count the number of rows generated for each EmployeeContent Hi, We are trying to get a count of the rows generated for each Employee, but the count keeps increas…Brendon Charles-24581 221 views 3 comments 1 point Most recent by Brendon Charles-24581 Reporting and Analytics for HCM -
Reporting on KPI's of HR teams including metadataContent Hi Guys, I'm sourcing ideas on how tor report on KPI's that we need to report on around our HR team. Does anyone have any templates or ideas on how to create the…Ivy__Valverde 80 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report on Active Employee count as of dateSummary I need a report that provides me an active employee (Active & LOA) as of start of each monthContent Hi, This is Shailesh. When I look at the counts from 'Workfor…User_2025-01-29-01-34-30-592 183 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
End of Year Active AssociatesSummary List of employees that were active the last day of last yearContent I have tried this every which way to Sunday and I can not get the right amount of employees. …
-
New Hire and Termination ReportSummary Combining Active and Inactive Information in one ReportContent Hi, We currently have a BI Publisher report that were pulling all the New Starter base on the date…User_2025-01-29-01-38-21-058 201 views 2 comments 0 points Most recent by User_2025-01-29-01-38-21-058 Reporting and Analytics for HCM
-
Last calendar day of the previous month as default promptContent Hi Oracle Community, We are trying to have a prompt with the date automatically set on the last calendar day of the previous month (which is our closing day), bu…[Deleted User] 46 views 3 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM
-
Fields for day start week and end weekSummary Create 2 fields in OTBI report for start date of the week and end dato of the weekContent Hi, Sorry for the dummy question but I couldn't figure out how to do it…
-
Has anyone built a report that lists all possible drop down menu option for HCM fields?Content Afternoon all, I was wondering if anyone has built a report that shows all configured data items for OOTB fields and DFF. We want to do an audit of all configure…User_2025-01-28-05-39-23-766 68 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Count of Workers With No Performance GoalsSummary Need for building a report with workers without any performance goalContent Hi community, We currently have the report attached in BI to count workers per # of g…[Deleted User] 67 views 2 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM
-
Future Dated RecordsSummary Future dated records/Inserted rowsContent I need to build a daily report for when managers/HR has entered a change when there are future dated records that need …User_2025-01-28-04-58-46-119 97 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Fast formula - Assignment History detailsContent Hi all, I need to export into a compensation worksheet the Last Updated Date from assignment history (please, see attachment) when it's been changed the custom f…User_2025-01-28-21-18-09-074 169 views 2 comments 1 point Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM
-
Fast formulas - standard fields & content typeContent Hi all, In order to build fast formulas, I'm lookig for the dbi for that standard fields: * PER_PERIODS_OF_SERVICE.ORIGINAL_DATE_OF_HIRE * PER_ALL_ASSIGNMENTS_M.…User_2025-01-28-21-18-09-074 48 views 5 comments 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM