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
-
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries… -
Task Performer name in Workforce Management - Checklist Real Time is blank in OTBISummary: Task Performer name in Workforce Management - Checklist Real Time is blank in OTBI Content (please ensure you mask any confidential information): If the Task pe…
-
Is Oracle BI Publisher Desktop Plug-In freeSummary: The Oracle BI Publisher Desktop Add-In, which can be downloaded to work with MS Word and Excel, requires a separate license for installation on machines. We are…
-
Dies anyone know the table and field for "Enrollment Type Description" in OBTI Learning?Summary: Does anyone know is what the table and field that correspond to "Enrollment Type Description" and/or "Enrollment Type" in OBTI. Specifically under "Workforce Le…
-
Unable to see all privileges in Security - Roles and Privileges Real Time SAWhen I am trying to fetch roles & their respective privileges from subject area(Security - Roles and Privileges Real Time). It is not fetching all the privileges. Can so…
-
Succession Plan ReportHow to view All Private succession plan available in system in OTBI ?
-
Is it possible to report on Workforce Compensation Change Statement Volumes executed by managers?Summary: We have our Compensation Change statements configured to Printed and delivered by managers, we would like to monitor and report on how many managers are accessi…
-
Tip on how to remove the dashboard header when embedding in a screenSummary Tip on how to remove the dashboard header when embedding a dashboard into a custom pageContent I have been asked a few times recently if it is possible to embed … -
BIP Report schedule to send data only when it has dataSummary: I want to schedule a BIP Report daily but it only send the report if there is a data in the report. If the report does not have any data, it will skip. Content …
-
Sql query required to identify time card approver and assignee detailsSql query required to identify time card approver and assignee details. We tried to join hrc_txn_header, hrc_txn_data and fa_fusion_soainfra.wftask to get the details. B…
-
How can we call BIP Report from Offer Progress Redwood Page through parameterSummary: Navigation: MyClientGroup>Hiring>Job Offer>Progress Content (please ensure you mask any confidential information): Version (include the version you are using, i…
-
Converting to dateSummary: We have hire date and we are using this to create a two new columns called 'Current Year Anniversary Date' and 'Days to Anniversary Date'. It used to work earli…
-
Can we send alerts to AOR via alert composersSummary: Hi Team, I have a quick query can we share alerts to AOR / role via alert composers Content (required): Version (include the version you are using, if applicabl…
-
Position History ReportingSummary Is it possible to report on changes to positions themselves over a period of timeContent I have a requirement to report on historical changes to positions in OTB…
-
Assignment HistorySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Query to get Position History along with Changed Attributes.Summary : I have a requirement to find out Position History details along with the changed attributes as shown in screenshot below. If anyone have query for this kindly …
-
How to Join the AoR (Area of Responsibity) table columns in OTBI logical SQLContent Hello All, As per my knowledge and got the information from other resources, OTBI does not currently support Areas of Responsibility (AoR) and there is no any su… -
we looking lapsed(Forfeiture) data in all plan types as on dec 2024Summary: Hi Team, we looking lapsed(Forfeiture) data in all plan types as on dec 2024. please find xml of report. Thanks, Ajay Content (please ensure you mask any confid… -
How to use the BIP Report Data Set (Sql queries) into the OTBI Subject AreaSummary: We have created a custom HCM OTL Roster report on the monthly basis based on the scheduler profile. We have to use these Data Set (SQL Queries) directly into th…
-
Looking for Issue description and resolution querySummary: Content (please ensure you mask any confidential information): Dears , I am working on a query to get issue description and resolution , I found them but I coul…
-
How to create report for this absence plan pageSummary: Hi , I want to code this page , can anyone help me in this . And i want to get the it as of balance calculation date my report should work. Content (please ensu…
-
How to Get Response Text for Performance Document QuestionnaireSummary: Have a report I pulled from Shared Reports as it gets me closer to what I am trying to pull, but it still leaves a blank in the Response Text section. I am tryi… -
BI Publisher report errors while running from Scheduled ProcessesSummary: Hello Team, Our technical team has developed a BI publisher report under Reports and Analytics—>Custom—>HCM folder. But when a user tries to run the same from T…
-
Date a collaborator was added on req ORCSummary: Is there a way to report off when a collaborator was added to a requisition? Content (please ensure you mask any confidential information): Version (include the… -
effective date dashboard promptSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
extra "NULL" checkbox in the dashboard promptSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to make HCM Line Manager Dashboard available to HR Admin Roles ?Currently Line Manager Dashboard works only for its direct and indirect reports. We want it to execute under the Data Security of HR Admins, so that they can see data fo…
-
Period of service ID is Null - Cannot link contract to assignment in analysisHi all, I have an issue where contract values cannot be searched for many assignments. If I add a measure (Such as "Employment Contract"."# Of Current Contracts") or ass…
-
Need to get referrer Job Title and Referrer assignment status in OTBISummary: We are using "Recruiting - Recruiting Real Time" subject area to get Requistion number, requistion title, referrer person number, referrer person name, worker p…
-
How to display column label values dynamically in a Matrix report using BI PublisherHi, We have a Matrix report requirement using BI Publisher where we need to bring across the row and column label values dynamically (as values are not constant) as per …