Get Started with Redwood for Oracle Cloud HCM Begin Now
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
-
Add custom font to OTBI reportsSummary Can we add custom fonts to OTBI reports?Content I did upload a ttf file and created font mapping in Administration page but the font is not reflected in the OTBI… -
Journey report - display 'Saved as Draft' status in the reportHello, Related to Journey, I want to create a report that shows the task's progress status for each performer. In case of the performer saves the task as "Saved as Draft… -
Promotion and Demotions Report not pulling the intended dataSummary: Promotion filter pulls in Job change code change data as well which creates duplicates when actually there was only one promotion. Content (please ensure you ma… -
How to create AOR based transaction console BI report in oracle fusion hcmHow we can create AOR based transaction console BI report in oracle fusion hcm
-
Certain Term'd EEs not displaying in Transaction Accuracy Audit ReportSummary: Using the Transaction Accuracy Audit Report from the Powered Reports and Analytics/Human Capital Management/Workforce Administration folder in the Reporting Cat…
-
Days of service calculationHi Team, I am using "Workforce Managemnet - Work Relationship Real Time" subject area and I want to calculate "Days Of Service" only for Terminated employees. I want to …
-
How to use an SQL query to select records of elements whose value was changed by CORRECT?Hello everyone, How to retrieve with an SQL query records of elements whose value was changed not by UPDATE but by CORRECT, is it in the HRC_EVT_OBJ_CHANGE_COMPONENTS ta…
-
How to get Collective Agreement detail from Workforce Management - Worker Assignment Event Real TimeSummary: Before 24A we were able to get the Union member and bargaining unit on our analysis from collective agreements folder of Workforce Management - Worker Assignmen…
-
debugging an errorSummary: debugging an error Content (please ensure you mask any confidential information): Hello everyone, I am getting this error when running a report in PROD but not …
-
Absence Calendar page to add Absence BalancesSummary: Hello, Please assist on the following… I am using the Line Manager dashboard → Absence Calendar page → Workforce Management - Absence Calendar Details Real Time…
-
Seniority date blank on front end but populated in PER_SENIORITY_DATES_F TableSummary: For many employees Seniority date is blank on front end but populated in PER_SENIORITY_DATES_F Table. I noticed TOTAL_ADJUSTMENT_DAYS is Negative and if I add i…
-
OTBI Report: Worker Number nullSummary: In a custom OTBI report, starting from this month, suddenly the Worker Number, from "Workforce Management - Work Relationship Real Time"."Work Relationship Deta…
-
Update Affiliation or Professional BodySummary Trying to update the field in Talent Profile/MembershipsContent Hello, We are attempting to bulk update to the field labelled Affiliation or Professional Body ho… -
How to get the Name equivalents of RECRUITING_LOC_HIERARCHY_ID and RECRUITING_ORG_HIERARCHY_ID?I'm trying to get the Recruiting Type, Recruiting Location Hierarchy and Recruiting Organization Hierarchy from the Areas of Responsibility - Scope section, but I only h… -
Worker Termination Alert fetching all termination dates (Older ones also)Summary: Hello Everyone, We have developed an alert using alert composer for triggering notifications when termination transaction occurs. But the issue is, we are getti…
-
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha… -
Person Identifiers for External ApplicationsSummary: For some employees we have updated payroll id under Person Identifiers for External Applications in person management. Content (required): If I need to take tha…
-
How to distinguish the output file basing on the scheduling dateSummary: How to distinguish the output file basing on the scheduling date Content (please ensure you mask any confidential information): Hi, we created a BI report; the …
-
In person HCM Cloud OTBI Workshop at Oracle Reading UKContent In the last few years we have been running a popular HCM Cloud OTBI Workshop in EMEA to help customers get the most from their investment in HCM Cloud. We plan t… -
Report to get cost center and account from time management (OTL)Hi Experts, I have an requirement to fetch Cost center and account from time management page. Please check below navigation and Image to identify requirement. My Client …
-
Table for Payroll Transfer Status and Payroll Processing StatusWe need to get Payroll Transfer Status and Payroll Processing Status. Where are these information gets stored? Please share if you have any inputs. We have tried using p…
-
Query or table to get the employee work schedule as of the leave start dateSummary: Hi Every one, Do any one have any query to get the employee work schedule as of the Leave Start date . The requirement is when employee applied the leave, I nee…
-
Is it possible to present the data from first table as shown in second table using BI Report?Summary: This is the sample data we have and need to present as shown n Table 2 ****_ID ACTION_CODE REASON_CODE PERSON_ID EMP_TYPE ****_SEQ EFF_DATE PRIMARY_FLAG STATUS …
-
HELP - Hierarchical Columns - Query not returning dataSummary: When I query multiple folders within the Recruiting - Sourcing Real Time subject area no results are returned. Security is working correctly. Content (please en… -
Is there a way to get new and old value for an object in OTBI without logical SQL?is there a subject area that inherently stores old and new values of objects like department l -
HardCode a Value in OTBISummary HardCode a Value in OTBIContent Hi Team, How can we hardcode an LOV value of a field in OTBI analysis? Any samples or query with case? Thanks much. Regards, Kaly…
-
Manage Document Security ProfileSummary: We can View the Document Type Security Profiles however we would like to have a report or query to know which document type is associated to which profile. Or j… -
Get current and future termination EE records in OTBIHi, We are trying to build a demographic file that should pull the data of EEs as of system date and also future terminations in next 7 days. I have tried using the pref…
-
Observation Checklist Link not found in Oracle TablesHow is the observation checklist link/URL being created or generated to use for notification? Can it be found in Oracle tables? Where could the link be stored? Is there …
-
Report of everyone who reported to a terminated managerUsing OTBI, how can I pull a historical listing of all employees who had a specific manager in their management matrix over a specified date range?