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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
How to retrieve the OLD payroll frequency and NEW Payroll frequency in the BIPHi ALL, Kindly support me to resolve below issue: I have a requirement to retrieve the OLD payroll frequency and NEW payroll frequency in BI report. Following with other…
-
What is the Table name to fetch Comments & Attachment posted in Allocated TaskSummary I want to know the table name which stores the comments & attachments which are added by the Approver while marking a allocated task as completeContent I want to…
-
SQL to retrieve fields for BI ReportSummary: Hi All Please share SQL query to fetch below details for generate bursting report. Thankyou, Ram Content (required): SQL to retrieve Employee Number, Employee N…
-
How to make BI report output file (RTF template with Excel op) as non editable once it's downloadedSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
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…
-
Is there a SQL query that will show when last a BI Report has been run by a user?Summary Is there a SQL query that will show when last a BI Report has been run by a user?Content Hello Is there a SQL query that will show when last a BI Report has been…
-
Query to fetch all the workflow transaction in HCMSummary: Team, can someone please share me the query to fetch all the transactions recorded in HCM Cloud(Transaction Console), I tried to query from fa_fusion_soainfra.w…
-
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 - …