Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
OTBI formula needed for multiple IF THENSummary: I have a simple report that uses the subject area Workforce Management - Worker Assignment Real Time. The report contains Person Name, Job Code, Job Name, Depar… -
How to map multiple columns from 2 different subject areas to one dashboard promptSummary: Hello everyone, I have 2 different OTBI analyses - 1 that refers to the Workforce Management - Worker Assignment Event real time and the other one refers to Wor…
-
OTBI Dashboard Embedded into HCM Not ResponsiveSummary: Issue with dashboard running/completing that are embedded in HCM. The dashboards were working until a recent patch after 22A. Content (required): Hi there, We h…
-
Matrix ReportSummary: We have a created a matrix report using BI Publisher report.The requirement is to have the drill down also to view the deatils. Can someone please suggest how c…
-
I am trying to learn how to determine what SQL is being issued in a Subject AreaSummary: I am trying to learn how to determine what SQL is being issued in a Subject Area. Any guidance is much appreciated. Thank you! Content (required): Specific anal…
-
Resume/CV extract from work history fields Using BI PublisherSummary: Has any one created a formatted resume report using BI publisher? I have a request to extracted work history entered by our employees who do not have resumes in… -
Split OTBI analysis to multiple worksheet depending on certain columnSummary: Is there a way we can split an existing OTBI Analysis into multiple worksheet for each location Content (required): Version (include the version you are using, …
-
Please help on Oracle Learning activity report not pulling activity completion date.Summary: Trying to create a OTBI report for Oracle Learning activity report using Workforce Learning - Learning Management Real Time subject area . But I am not able to …
-
Parameter based on list of values is not working in BIP reportSummary: Hi All, I have total 10 parameters based on list of values in the BIP report on which 5 are working perfectly fine but 5 are not giving any data in the drop dow… -
Organization Hierarchy fields causing missing employeesSummary: We have a report that keeps dropping employees whenever we add the Organization Hierarchy fields level 2 and level 3. We have made sure the values are populated… -
Using CASE to return formula-calculated valueSummary: Requirement is to build an analysis to convert hours leave balance to days equivalent, using employee assignment working hours value. As employee working hours …
-
How select only th last event in Recruiting - Recruiting Event Real Time Subject AreaSummary: Content (required): Hello Guys, We would create a report that extract the number of job application for each reason, but we only want take in consideration the … -
Issue when creating a BI report on Investigation QuestionnairesSummary: When creating an BI report on investigation questionnaires we are running into an issue where it is not possible to limit the investigation questionnaire to the…
-
Turnover report with custom column filterSummary: Hi Experts, our requirement is to create a turnover report with Active employees on the 1st of every month and the last date of every month, no of hires and Ter…
-
How can I add a column for % Holiday Balance remainingSummary: Hello, I'm looking to see if anyone has the correct formula for me to use, or has already added in the column for '% Balance Remaining' for the annual holiday a…
-
Does anyone have a report for Checklist Real Time and Transaction Administration Real Time?Summary: I am looking for a report/trying to build one for Checklist Real Time and Transaction Administration Real Time to try to report on when a Checklist has been rea…
-
Report for all the users along with all the rolesSummary: I am wondering if we have any report available that shows all active users with the roles assigned to them ? I am able to build OTBI report that shows Employees… -
URL inserted into browser window allows access to report without securitySummary: Users able to run reports using direct URL access Content (required): We have identified an issue where our users can enter a report specific URL into a browser…
-
Succession Plan Candidate Readiness Timeframe not showing in ReportSummary When reporting on our current succession plans, the Readiness Timeframe field is not showing any data.Content Is anyone experience issues when reporting on succe…
-
Issue in weekly schedule Bi report with effective date parameterSummary: Issue in weekly schedule Bi report with effective date parameter Content (required): Hi Team, Recently I was schedule a report which is weakly basis and it cont…
-
How to fetch the translated value from an Independent Value set in Oracle Fast FormulaSummary: How to fetch the translated value from an Independent Value set in Oracle Fast Formula Content (required): How to fetch the translated value from an Independent…
-
Running OTBI based upon the Results of another OTBI getting Error getting Drill InformationSummary: We are trying to base the results of one OTBI analysis off the results of a second OTBI analysis. Both analysis run successfully on their own. However, once con… -
How does your organization use Oracle to comply with the MN Wage Theft law?Summary: My organization is in the process of implementing Oracle and we’d like to understand if other MN-based organizations have a process in place related to MN Wage …
-
Fusion OTBI Workforce Succession Management - Talent Pools RealTime Subject Area Returning No ValuesHi, We are trying to create Talent Pools Analysis using Workforce Succession Management - Talent Pools Real Time subject area but nit doesn't yield any results. No matte…
-
Candidate Pool Ownership TypeSummary: Content (required): Hello Guys, We would extract the Candidate Pool Ownership Type information from BI, but we don't find the correct table and field, someone c…
-
Succession Plan BIP Report based on Job RoleSummary: Hello Experts, I have to create a Succession Plan BIP Report based on Job Role. Please help with a sample SQL/Report if you have worked on a similar requirement…
-
How to use Hyperlink in RTF templates?Summary: Hello Experts, Is it possible to use Hyperlink in RTF templates? Like, in the report output, the Person Number attribute will have a hyperlink, once the user cl…
-
How to split by page break with the date rangeSummary: Can we apply split by page break with in the date range? For example if we pass date parameters with in the 3 weeks date range, then report should pull 1st week…
-
Session/repository variables available in OTBISummary: Hi there, Is it possible to find out what session/repository variables are available in OTBI? Thanks for your help in advance. Vijay
-
HCM > Others tab > My Dashboard > End User Dashboard Does Not OpenSummary: HCM > Others tab > My Dashboard > End User Dashboard Does Not Open Content (required): Hello All, I will appreciate your support on the issue below: When the HR…