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
-
OTBI - Need filter on from date to To date as sysdateSummary: Hi Team, we have requiremnt in OTBI to apply the filter(Completion Date) as From date is 1-04-2023 to TO Date is sysdate. thi is the the is colums of fomula : "… -
HSDL for Work Schedule AssignmentSummary: Does anyone have an HSDL template to assign Work Schedules? Content (please ensure you mask any confidential information): Version (include the version you are … -
Creating BI Publisher Audit Reports Equivalent to Native Oracle Fusion Audit ReportsSummary: Hi everyone, We're running into the row limit in the native Oracle Fusion HCM Audit Reports UI and are exploring the possibility of building custom BI Publisher…
-
How do I calculate the number of days a position has been vacant?I am trying to write a report in OTBI to calculate how many days a position has been vacant for to enable management of aging positions. My initial analysis was in Worke… -
BIP query to get OTL project and task detailsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BIP query for LCP tracker informationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Comparison between two fields in rtf templateSummary: Comparison between two fields in rtf template Content (please ensure you mask any confidential information): In the RTF template, we need to conditionally displ…
-
Unable to get the Calculation card Federal Start Date valueSummary: Unable to get the Calculation card Federal Start Date value in OTBI/BIP query Content (required): I am unable to get the Federal Start Date value in OTBI/BIP qu…
-
Special Characters in BIP ReportSummary: have requirement of replacing special characters coming in the description column of the BIP report with following: Double quotes replace with '"' need to … -
How to report on worker Area of Responsibility records assigned?Currently created an analysis report in OTBI to pull Area of Responsibility records against current active employee records. Tried testing with a variety of ways with di…
-
Session Variables for Use in Activity Center VisualizationsHello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reportin… -
when we run the RTF template report we getting below errorSummary: HI Team, we have RTF developed template but now we have enchement on statement of text so we changed the matter but we getting below error. please assitance on …
-
Cannot Create Visualization in Redwood AnalyticsHello, In following this documentation, I attempted to create a new visualization for Redwood Analytics and mapping an OTBI report to it. My goal is to add this to the R…
-
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…
-
difference between legal employer hire date and enterprise hire dateSummary difference between legal employer hire date and enterprise hire dateContent Hi, Please find attached screenshot of Manage Work Relationships for a person: 63060.… -
How can we print different Logo based on LE name in EXCEL BIP TemplateSummary: For the Excel template, we have a requirement to print the logo based on the Legal Employer selected in the parameter while running the report. This requirement… -
How to report on job subfamily?Hi, Is there a way to run a report with the job code, job name, associated job family and associated job subfamily in BI publisher?
-
Headcount value 0 for some employeesSummary: I was comparing the headcount (the built-in fact) against the employee detail row wise data and the counts did not match. I noticed that some employees had the …
-
Reliable way to identify negative gross / net pay employees without error message text?Hi all, We maintain a custom BI Publisher report that flags employees with negative gross or negative net payments during payroll processing. The report is provided to o…
-
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b… -
Payroll : Fiscal year to date balance showing results for the Calendar year and not Fiscal yearSummary: Payroll : Fiscal year to date balance showing results for the Calendar year and not Fiscal year Content (required): Hi, We have enabled "Relationship NoCB Fisca…
-
Is Marketing Communications Opt In available in Recruiting OTBI?Summary: We need to report the Redwood Recruiting candidate-profile value “Marketing Communications Opt In”. The value is stored in IRC_CANDIDATES.OPT_IN_MKT_EMAILS_FLAG…
-
Need a query that identifies run results or balances where taxes are not being withheldNeed a query that identifies run results or balances where taxes are not being withheld, even though tax withholding is configured on the Calculation Card. There are sev…
-
Matrix Manager HDL Load shows new manager in UI but not in OTBISummary: We completed an HDSL load of new Matrix Manager assignments for employees. The UI shows the new manager but the OTBI report does not. Reflect the update. Is the…
-
Query to display the Phases and States of the CSP in OBIContent Hi Experts, I am looking for a OBI query to display the Phases and States which are associated to the CSP. Regards, Harish Version 20D -
Exception: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violationSummary: Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation Content (please ensure yo… -
on Redwood page using Guided Journey- BI report bind parametersSummary: To show/embed BI report link on the redwood page and pass the assignment id of the logged in employee as a bind parameter to the path , tried using below &_xmod…
-
Sql Table to get the details of BIP Data model QueryContent Hi, Is there any database tables available to fetch the details(Query) used in a BIP Report. We would like to see the list of reports using a particular field sa… -
Time Card Approver DetailsSummary Time Card Approver DetailsContent Hi Experts, Which table holds the information of who approved the time card. #1.HWM_TM_REC is having time card details. Whether… -
Which table stores the geography data on the recruiting side in Geography Hierarchies Task?Summary: I need to identify which table stores the geography data used specifically on the recruiting side within the Geography Hierarchies Task. The existing tables I h…