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
-
Job Qualification and Description for a profile from OTBISummary: How to get Job Qualification and Description for a profile from OTBI? I tried to find on Workforce Profiles - Model Profile Real Time but could not get it. Job … -
Links with BI Publisher when using With ClauseSummary: Data sets using the With Clause lose the ability to create links between datasets Content (required): I'm trying to leverage the powerful WITH clause in a bi pu… -
HCM Field VS Subject AreaSummary Trying to find a document that tells me which field on the front end maps to which subject area and fieldContent Hi, I am trying to figure out the best way to fi… -
Added a report into OTBI Dashboard - Download is happening as two different PDFSummary: We have added a report as a section into Job Profile OTBI Dashboard, when i try to download the result into PDF, the report we have added is downloading as diff… -
How to get data in 2 fields for Payroll Relationship -> 'Time Card Required' ?Summary: There are two fields for 'Time Card Required' on the Payroll Relationship responsive page. One is at the Payroll Association level and other at Payroll Assignme…
-
Need help to build the sql logicSummary: Hi Team, I am working on a requirement for position incumbent. Here my code will get each positon with vacant positon details. And for each position one record …
-
Using Variables in Etext templateSummary: Hi Team, I was reviewing a oracle guide for etext template. For one of my requirement I am trying to use Variables in etext template. GetVar(var-name) ResetVar(…
-
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 …