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
-
Upgraded from Version 1 to 3. PER_SENIORITY_DATES_F - How is it Populated?Summary: New table PER_SENIORITY_DATES_F created as part of upgrade to version 3. Can any one share the details of the data migration to this table? Content (required): … -
How to know BI reports andOTBI Reports of scheduled report jobs and Agents list through query or anySummary: Hi Team, we have sceduled reports and OTBI reports through Agents how to get the list of reports scheduled from system any query or OTBI for ? we have report jo… -
Payslip Reprinting Report flow does not Produce Output and cannot be opened because it has no pagesSummary: Payslip Reprinting Report flow is completed successfully and does not Produce Output and cannot be opened because it has no PDF (Blank) pages ####[2023-07-11T16… -
Timeout while using ESS to manage BI submissionSummary: Our ESS job keeps failing with an odd error but if we manually submit the BI it succeeds Content (required): We have a long-running BI query which has been gran… -
OTBI promptThe OTBI prompts to exclude the Legal Employer having "DO NOT USE" word. On OTBI reports, we have applied Legal Employer Prompts, it shows all legal employers in the pic… -
We have below EFF fields in per_person_eit_eff table but unable to find this table in Oracle DocsSummary: Hi Team, We have below EFF fields in per_person_eit_eff table but unable to find this table in Oracle Docs. Any one help me on ? Thanks, Ajay Content (required)… -
Issue in dashboard PromptSummary: Issue in dashboard Prompt Content (required): Hi All, We have created a dashboard prompt using the Workforce Management - Worker Assignment Real Time subject ar… -
Annualized Salary Doubling when adding in Level 1 Organization Name in OTBI ReportSummary: We have a report built which is combining Compensation - Salary Details Real time and Compensation Individual Compensation Real Time subject areas. We have sala… -
Mouseover on Performance TileDears, is it possible to change somehow the mouseover on performance title? I've been trying to add an html "title" within the cell header but that did not work. Thanks … -
Is it possible to include a link to a PDF file in an OTBI report?Summary: We are looking to have a report based on the Documents of Record subject area where the user can run the report and access the document reported as a PDF. Conte… -
How to convert multiple rows into columnsSummary: Need help converting rows into columns for the attached report OTBI report. I tried to use Pivot and Case statement but, was still stuck. Here is the sample OTB… -
Hierarchy not availble in BIWe have created an Organzaiotn Hierachy as per 1th of january 2023. The tree version is active, but noy (yet) avaliable in BI. Same for a Department Hierarchy. Is there … -
Custom Performance Management Audit BI ReportSummary: Build a custom BI report that contains audit for performance document Content (required): Would like to know if there's an oracle hcm table to capture the previ… -
Creating a My Reporting tab in HCMSummary: Anyone created a My Reporting tab in HCM with links to dashboards? Content (required): I was recently on a demo using the Vision environment and spotted that a … -
Standard OTBI report displaySummary: Content (required): Hello everyone, We are experiencing problems with the visualization of a standard OTBI made available by Oracle that allows the 'department … -
Oracle HCM: How to change existing Host Key Fingerprint in BI AdministrationHi Team, We have a requirement to change the Host Key Fingerprint because of change in SFTP hostkey due to recent changes within SFTP application. Are we able to change … -
Is there a seeded skills and qualifications report?Summary: Content (required): Is there a standard qualifications report? Version (include the version you are using, if applicable): 23A Code Snippet (add any code snippe… -
Form output created in BI PublisherI prepared a absence form using BI Publisher, when I add the relevant fields, it does not change according to the person, the only date is fixed. What could be the cause… -
BIP Report QuerySummary: Hi All, We created one BIP report where we can run by the Department name that shows all Position in the Department (both filled and vacant) and their Parent Po… -
California Meal Break ReportCalifornia Meal Break Report Could you please help us getting a meal break report for the California Employees? Thanks Mansur -
Executing seeded data model to display report - TalentProfileDMSummary: How can I run the seeded data model, TalentProfileDM, to review the data that I have input into the talent profile? Content (required): This is a massive data m… -
Table for security console audit?Summary: We have auditing enabled. Specifically, the "Oracle platform security services" option. We need the table names where audit tracking takes place with respect to… -
Replace special characters with standard onesSummary: Hello, we need to build an integration with a BI report where the recipient cannot accept special characters. In person names we have a lot of special character… -
I'm looking BI Report from skills and qualifcations page skills,cerifcations and languages cloumnsSummary: Hi Team, I have below code but unable to find the below cloumns in Bi report. Navigation of UI- ME>Performance>Skills and Qualifications In that we have section… -
In OTBI Report,we are used Worker assignement Event Real time but "State" column not available ?Summary: Hi Team, In OTBI Report, we are used most of the employee address columns from ( Worker assignement Event Real time) subject area but "State" column not availab… -
OTBI Union Query - R12 - Career StatementsSummary Report working in R11 but union no longer working in R12Content Hello I have an analysis in R11 that we use to identify the % of staff who have a career statemen… -
Is there query to get Audited performance management rows?Summary: Is there already a default query on the system that retrieves audit values for performance management? We have already turned the performance management object … -
Career Development ReportSummary: Trying to create an OTBI report using subject area "Workforce Career Development - Development Goal Overview Real Time". I have no issues adding fields from Dev… -
Issues with "Workforce Career Development - Development Goal Overview Real Time"Summary Unable to pull dataContent Dear All, I am planning to pull out a report on Development Goals from "Workforce Career Development - Development Goal Overview Real … -
Can the Performance Review, Comments section font be made uniform when using custom font?Summary: When creating a custom version of the employee and manager printed performance review document in BI, we are unable to force the font in an open text comment se…