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
-
In case of termination, there is a requirement to show last payment date.Summary: In case of termination, there is a requirement to show last payment date. Can anyone please guide on which oracle delivered field its captured? Content (please … -
Payroll Transfer statusContent Hi All, We are trying to display "Payroll Transfer Status" in OTBI and we are referring "Workforce Management - processed Time Cards Real Time" "Processed Time E…
-
How to add multiple IF function in the Field Browser using Microsoft Word - BI Publisher?In my RTF template, I'd like to put a message for employees who are not belong to a specific department: However, in our case, some employees under 'ABC Expert' departme… -
Calendar Quarter column formatSummary: Hello, Could you please let me know how to change the format of column "Time"."Calendar Quarter" in OTBI subject area "Workforce Management - Workforce Trend Re… -
Column Formula to get bi-weekly salarySummary: I need to get the bi-weekly salary of the employees, dividing the annual salary by 26 ( pay periods). Content (please ensure you mask any confidential informati…
-
Table that stores BIP error detailsSummary: Which table stores BIP error details text? Content (required): We are trying to build a custom BIP report to summarize all BIP job errors into a notification em…
-
Unable to fetch Resignation Transaction approval rules data in the reportWe have a requirement to fetch the approval rules data in the BI report. But we are not able to get the full approval flow from the tables.
-
Unable to Upload PGP key Post 24A UpgradeI'm Unable to Upload PGP key Post 24A Upgrade in BI Publisher using Administrator. It is giving 'Generating BI Publisher kaypair failed: reason = gpg --gen-key command f…
-
report to show timecards that aren't approved (when the last editor was not the worker him/herself)Summary: Just sharing BI SQL. We have a need to output instances onto a report to show which worker did not re-approve a timecard that was edited by a member of our time… -
Using the Termination Date value for counts between Calendar Month Start Date & Calendar Month EndSummary: I have read a lot of posts where individuals have been looking to get counts of employees who have a termination date between X & Y. However, if an employee has…
-
How do you compare columns in a formula when the columns are in two different subject areas?Summary: Specifically, we are trying to compare the resident state (from Person Real Time) to the Worked State (from Calculation Cards Real Time - Location). I'm able to…
-
SQL Report Filter for Previous_MonthSummary: I am trying to create a filter in my OTBI report that will return Pay Date results from the Previous month. Any suggestions? Content (please ensure you mask any…
-
Privileges/Roles to access the Reports and Analytics Work areaSummary: Content (please ensure you mask any confidential information): Hi experts, I'm working with a custom job role that should be able to access the Reports and Anal…
-
Candidate Risk of Loss and Candidate Impact of Loss field table namesContent HI All, We have a requirement to fetch the succession plan, Candidate Impact Loss and Candidate Risk of Loss details through BIP . I find the "HRM_PLANS " and "H…
-
BI Publisher Bursting with Multiple Templates , Multiple Data setsSummary BI Publisher Bursting with Multiple Templates , Multiple Data setsContent Hi Friends We have a requirement where we need to burst BIP reports. Now i have 2 diffe… -
ORC:Date of Probity, Date of Interview, Date of review fields in Subject AreaSummary: Currently there is no any subject area available in ORC to get details directly against Date of Probity, Date of Review, Date of Interview and other phases. can… -
User-Defined tables name in Oracle HCM BISummary: Content (please ensure you mask any confidential information): Hello experts, do you know the BI table to extract user-defined tables? Thanks in advance for you… -
Unable to see output on scheduled report jobSummary We have users, not all, that are unable to see the output file from a scheduled report job.Content Does anyone know what may be causing some users to be able to … -
Custom Token in the alert composerSummary: I have created a custom alert composer in the name of Anniversary. Here I have pulled in the filter for the adjusted service date and have given the below param… -
How to know input values supported by any fast formulaContent Hi All, Like we have query to get context supported by fast formula, do we have any similar query or table that can help to fetch input values supported by any f… -
OTBI Dashboard Prompt showing Error Code:ACIOA5LNSummary: OTBI Dashboard prompt showing Error Code:ACIOA5LN for one of the user account ? What could be the reason? Content (please ensure you mask any confidential infor…
-
User not able to run a dashboard in OTBISummary: Content (please ensure you mask any confidential information): Hi, I am testing a user where he is able to view the Dashboard and when I click on it, the prompt…
-
Manager not appearing in Termination reportContent Hi, We just recently implemented Oracle Fusion HCM and still trying to work some issues out. One of the issues when I try to pull a termination report that I cre…
-
How to link transaction adminstration Real time with worker assigenment Subject area ?Summary: HI Team, We have need to track the all transactions in hcm of : Change Location, Change Manager, DeleteAssignment Promotions ResignationTransfers. with worker d… -
OTBI snapshotsWe want to create monthly snapshots of static data within OTBI for our analytics team to reference as part of the month-end processing? Is there a preferred out of the b… -
How to: Translate BI Publisher Report Parameters at 24ASummary: How to: Translate BI Publisher Report Parameters at 24A Content (please ensure you mask any confidential information): Version (include the version you are usin…
-
Signature in the reportSummary We need to store Digital signatures in the Fusion cloud and need to display same signatures in the reports.Content Hi All, Can we store Signatures in the Fusion …
-
OTBI/BIPublisher report for searching employees based on Talent ProfilesSummary: I am looking for a seeded or custom OTBI/BIPublisher report where there will be parameters like Language, Qualifications, Skills ,Work Preferences etc. (Talent …
-
How to create a historical report with actions reasons in OTBI?Summary: How to create a historical report listing all actions/reasons since the hire date including future dated action reasons/ Content (required): I'm using Worker As…
-
How to find Notifications setup on a Scheduled Process scheduleSummary: In Scheduled Processes, how you do view/edit Notifications setup on a scheduled report? Content (please ensure you mask any confidential information): Version (…