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
-
Performance Rating History OTBISummary Looking for an OTBI report with Annual Performance Ratings for the last 3 yearsContent Hello I am looking for an OTBI report with Annual Performance Ratings for … -
Find column in OTBI reportSummary: Hi all, I have added these subject areas in my report:- Workforce Goals - Goal Plan Assignments Real-Time Workforce Goals - Goal Status Overview Real-Time Workf… -
OTBI export to excel and lost data.Summary: Content (required): Hello everyone, I wanted to ask you if you could provide us with more information or if it has also happened to you regarding the loss of da… -
Logical SQL Dashboard Not Working After 22BSummary: Hi - we have a report that pulls payroll information and salary information. It is run weekly by our compensation team. It was working fine through last week an…
-
Line Manager can't see Time cards in OTBISummary: Content (required): Hi The Line Manager role can't access time card reports (standard Oracle Time Cards). The reports are standard and delivered by Oracle. The …
-
Learning Initiative associated with a courseHello everyone, we would need to know if a course has an initiative attached to it and possibly the number of that initiative. However, among the documentation we could …
-
Difference between data table join.Summary: Difference between data table join. Content (required): Hello All, I have some confusion on table joins. Please refer below example. I have two data tables. PER…
-
Folder Level Security (Idea/Feasibility)At our organization, the staff is used to our discoverer reports where one report will pull from multiple tables/views, after asking around and looking at OTBI security …
-
OTBI Report ColumnsSummary: I am using three Subject Areas: Workforce Performance - Performance Document Status Real Time Workforce Performance - Performance Rating Real Time Workforce man…
-
Turnover Analysis - Line Manager DashboardsSummary Count fields - Termination Headcount, Voluntary Termination Headcount under Subject Area "Workforce Trends" are not reflecting correctContent Hello, We are looki…
-
Error in OTBI reportSummary: Content (required): Workforce Management- Worker Assignment Real Time Workforce Goals - Goal Plan Assignments Real Time Workforce Goals - Goal Status Overview R…
-
Fiscal Year HR ReportingSummary Needing to have reports such as a Turnover Report that is based on Fiscal Year vs Calendar YearContent Does anyone have any experience or examples on how i could…
-
Rehire Recommendation Details Isn't Coming in ReportSummary Rehire Recommendation Details BlankContent Hello All, This is Harmender, hope everything is fine at your side. I have created one subject area report for rehire …
-
How to schedule OTBI reports via SFTP ?Summary: Hi Team, we have three OTBI reports to scheduled Via SFTP but I new to this area Can anyone help on this? Content (required): Version (include the version you a… -
FTE and Salary - Compensation Salary Details Real Time Subject areaSummary: The FTE and Annualized Full Time Salary appear to be sourcing the FTE from the Assignment instead of the Salary row Content (required): I'm digging into an erro… -
BI Publisher Style Templates vs Online Layout BuilderSummary: How to deliver a consistent look and feel in BI Publisher reports Content: I'm trying to improve my skills with writing BI Publisher reports and learn about Sty…
-
No Data in OTBI when Department Name is addedSummary: Content (required): We are using Subject Area "Workforce Goals - Goal Plan Assignments Real Time". When we add Worker.PersonNumber then we are getting all the 1…
-
Cost Center ReportingSummary How to report on Cost Centre in Cost Accounts section of Manage Costing of DepartmentContent All, I am new to Fusion OBTI reporting and am hoping you can help me… -
Logical SQL is not recommended?Summary If Logical SQL isn't the answer what is the recommended approach?Content Hello Everyone, I've been told through a recent Technical SR that Logical SQL is not a r…
-
BIP Email Bursting - Best PracticesSummary: Content (required): Hello, We've received a requirement from customer to implement automatic custom notifications to employees. More in depth: HRs post job requ… -
Is there any way to identify which roles have security profiles?Summary: Is there any way to identify which roles have a View All Document Types and View All People person security profile, and who these are assigned to? Content (req…
-
Where can I find tax registration Number for Reporting UnitSummary: Please can anyone tell me where the tax registration number is in OTBI, I am wanting to add it to a report but cannot find it. Content (required): I am looking …
-
Unable to pull specific employees for a performance reportSummary: Team - My counts vary as I try to pull additional fields from a specific report that pulls from the following areas: Compensation - Workforce Compensation Real …
-
How to get FULL_NAME from PER_PERSON_NAMES_F_V if user row is not on PER_USERS?Summary: We have a very simple section of report code that uses the LAST_UPDATED_BY field on FA_TRANSACTION_HEADERS table ("FTH" in the code below) to get a user's full …
-
HCM Report Sharing CenterHello - does anyone know if there's still a place where all shared reports appear together in a table such as in the screen shot below? We have recently implemented cert…
-
How create a Recruiting Report with ReasonSummary: Content (required): Hello Guys, We would create a Report that extract the reason linked to the last event for each worker, how we can create it, in our database… -
How to find requisitions pending approvalSummary: We are trying to find/create a report that can show the requisitions currently pending approval. I found the column that stores the status in Job Requisitions -…
-
HCM &Power BISummary Possible that Oracle HCM cant feed automatically to a Dashboard using PowerBIContent Hello, I am just wondering is there any posibility that Power BI can be refr…
-
"Close Date" in Payroll RelationshipsSummary: Morning, We are trying to report on the "Close Date" in Payroll Relationships but I am struggling to find it in OTBI. Would it be possible to have it in the OTB…
-
Gender Pay Gap ReportSummary Has a Gender Pay Gap report been release for HCMContent I am trying to find the equivalent Gender Pay gap report that existing in EBS. Is there one? If not what …