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
-
xdofx:ifSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
SQL for Environmental health and safetySummary: Team, Does anyone have the sample environmental health and safety BI report (SQL). Please share Content (required): SQL for Environmental health and safety SQL … -
The user request exceeded the maximum query governing execution timeSummary: The user request exceeded the maximum query governing execution time Content (required): Hi Team, Greetings! We get error on OTBI report as 'The user request ex… -
Can we create analysis to fetch terminated workers who HAVE NOT been rehired since their terminationSummary: Can we create analysis to fetch terminated workers who HAVE NOT been rehired since their termination Content (required): Using worker assignment real time busin… -
Table name to get Element CategorySummary Table name to get Element CategoryContent Hi Team, Can someone help me with the table name to get the "Element Category", i was able to get this information inOT… -
Missing TimeCards ReportSummary Missing TimeCards ReportContent Hi Experts, Anybody developed Missing Timecards BI/OTBI Report. Could you please share the report. Thanks Thiru -
Absence category and absence types under this category query.I need a SQL query that returns information about the absence category and the absence types connected to this category. I would be grateful for the query you can share … -
Sending Bursting pdf as an e-mail body instead of outputI have a notification work that I have prepared, the report returns table type employee data and absence detail.I can send this tabular report as a pdf output, but I wan…
-
person security profileSummary: We need a person security profile that uses Job Type as a criteria. We only want our Sales Comp team to see the people who are in a job type of "producer". Any …
-
Expand Issuing comments in Document Record Notification email templateWe are currently working on expanding the comment box for document record email notifications and BPM work lists, as the current character limit does not align with the …
-
AS-OF-DATE on Prompt - CURRENT_DATE_REP_OTBI-Session DateSummary: I am using CURRENT_DATE_REP_OTBI in the calendar prompt # As of date . The date is is not defaulting correctly. The session date defaults to 01-Nov-2021. While …
-
Is there any table/way to find the tables used (data set details) in BIP reportSummary: Is there any table/way to find the tables used (data set details) in BIP report Content (required): Hi Team, Greetings! Is there any table/way to find the table…
-
COUNT EMPLOYEE GROUP BY POSITION NAME USING OTBISummary: Good evening, The client asked us to create an OTBI that counts all the employees who are in a location. However, there are many positions that have the same na…
-
Looking for a Workflow transactional Report where Self Approval is enabled.Hi Team, I'm Looking for a Workflow transactional Report where Self Approval is enabled. Either the report should let me know about on which workflow rule self approval …
-
We need to capture the Employee Acknowledgement Flag / Checkbox ResultsSummary: We need to capture the Employee Acknowledgement flag at the completion of a Performance Document, so it can be included in OTBI reports, and captured by Azure S…
-
BI Publisher reports now timing out (previously working)Summary: I have two BIP reports that were created several years ago that are now timing out. They began failing around the beginning of September 2023. Content (required…
-
Extract description of lookup in OTBISummary: Content (required): Hi everyone, we are having problems extracting the value of a dff configured for the JOB. Is it possible to extract the description of the r…
-
How to capture an end date on Individual Compensation element?Summary: How to capture an end date on Individual Compensation element? Content (required): I am trying to award compensation to an employee in the form of a sign on bon… -
Can anyone help adding position No and Name to my SQL Query?Summary: I need to add the Position number and position name to the SQL Query Content (required): Hi everyone, Could anyone help me to add the position number and positi… -
OTBI Report is not giving results.Summary: Hi Everyone! Workforce management - Worker Assignment Event Real time I am using above subject area to create a report but when i click results, i am getting " …
-
Can we schedule a OTBI report by password protecting the output?Summary Can we schedule a OTBI report by password protecting the output?Content Hi, We have a question: Can we schedule a OTBI report by password protecting the output? … -
Learning Report to Track Course CompletionSummary: We have been using Managing Learning Real Time subject area to build our report to track completion status for each course and offerings. However, that subject …
-
How to use Use the BulkDataExportService web service introduced in 22ASummary: Documentation missing for OTBI Webserivce BulkDataExportService Content (required): Release 22A has a note: Use the BulkDataExportService web service from the a…
-
Split rows in Succession Plan reportSummary: Hi Experts, I've created 7 DFFs on the Succession Plan candidate page. To report these I'm building an OTBI report using the "Workforce Succession Management - …
-
Is there a way to combine this so that the team shows on one row?Summary: Is there a way to pull the team on one row instead of duplicating per territory role? Content (required): I am trying to create an analysis for sales. The terri…
-
query to get current logged in user_id in BI publisher reportSummary query to get current logged in user_id in BI publisher reportContent Hi Experts, how to get current logged in user_id in BI publisher report. Thanks, Pradvin
-
How to change middle name field to just one character?Summary: When the middle name field is more than one character, is there a formula that can be used to only show the first character? For example middle name contains "W…
-
How do I sun total absence duration by employee?Summary: I want to get the total days lost for each employee. Content (required): Does anyone know how to sum in a table report that looks at the rows of data for each e…
-
How to fetch learning community access group details?Hi everyone, I have a requirement to fetch the learning community access group details like, Community Access Group Name, Community Access Group Learner Count and Commun…
-
What HCM table can I use to get the future Line Manager?Summary: I'm checking if I can use the BIP Bursting feature to send details which includes tasks to the worker's future LM once the transfer is approved. The client want…