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 - Filter Learning records per year and not between two datesSummary: Content (please ensure you mask any confidential information): Hi there, we have a simple learning dashboard with learning completions of employees. My colleagu… -
Columns Missing from the Subject Areas in OTBIwe have 3 OTBI reports showing error in the output, when i checked, some of the column headings are in the report like 1.Deduction Developer DF_QUALIFYING_PEN_SCHEME 2.D… -
Notes Attribute in Assignment Action Occurrence Subject AreaHello , We are interested in leveraging Notes attribute in Assignment Action Occurrence Subject Area from 25A , however I am having trouble locating where this attribute…
-
LOOKING FOR OTBI REPORT FOR EMPLOYEE AND CONTACT DETAILSI am looking for a report that shows the details of Employee and the Contact details. Columns such as Employee Number, Employee name, Contact Name, Contact Phone number,…
-
PER_ROLES_DN_VL table showing Duty Roles N or Null valuesHi Team, Greetings! We have encountered an issue while querying the PER_ROLES_DN_VL table for values in the DUTY_ROLE field. The table is only showing 'N' or NULL values…Bhuvaneswari Konduri-Oracle 132 views 0 comments 0 points Most recent by Bhuvaneswari Konduri-Oracle
-
Getting Style Error when exporting OTBI reportSummary: Content (please ensure you mask any confidential information): Hi there, I get this error when exporting a learning report from the Learning Records Real time s…
-
Plan period start date in absenceSummary: Hi Team, I am trying to get absence accrual detail in OTBI report. Please let me know how to get these details with plan period start date. Thanks Content (plea…
-
I want more than 2 prompt input lines in OTBI.Summary: I want more than 2 prompt input lines in OTBI. Content (please ensure you mask any confidential information): When a graph is created in OTBI, the value list is…
-
Is there a way to find all data-models that use Bursting?Summary: We are planning a change in Sender Address in our ERP Instance and one of the requirements is to also amend it for all the Bursting reports configured in the sy… -
Female turnover rates of DashboardI'd like to ask that if I select the Female as the Gender, how is the female turnover rates calculated? Is the denominator of the ratio in relation to all employees or o… -
How to link absence details and payroll detailsSummary: Hi all We need a report that provides absence details along with the payroll elements processed based on those absences. Specifically, for the OFFICIAL TRIP abs…
-
I need to update position of employees using HDL w.e.f 1st Feb 2025Summary: Hi There, Can someone help me with the HDL template to update the employees' position with effect from 1st Feb 2025. Appreciate your help! Thanks, Lakshmi. Cont…
-
Job Requisition Audit report neededHi Team, We have a requirement to create a report to bring Requisition Audit report, The client is trying to fetch each transaction that occurs with a requisition , any …
-
Reporting Agent failed with error message SQLSetStmtAttrWSummary: We have reporting agents set up which all ran into error, when normally no issues. Content (please ensure you mask any confidential information): We have report…
-
Convert Fact columns into Measure type in OTBI to get subtotalSummary: Hello, We are building a basic report and we try to view total for Total, Taxable Monthly, Non Tax Monthly etc based on Accounting Date. The issue is that all t…
-
OTBI - add a graph to show the number of candidates by locationSummary: I've created an analysis using Recruiting - Recruiting Real Time Subject area and have been trying to add a graph to show the number of candidates by location, … -
Unable to send bcc in bursting.In the bursting query i have added parameter 8 for BCC mails. However, 'to' mails are going and the employees are receiving the mails. BCC is not being received. Can any…
-
Current approval status table name for development goalsUnable to get approval status for development goal: Need a table name and SQL query for development goa approval status to check whether the goal is approved? rejected o… -
Career Site Metrics ReportSummary: Does anyone have Career Site metrics report based on Candidate Tracking subject area in OTBI? Content (please ensure you mask any confidential information): Doe…
-
How to add values from column to Dynamic column in OTBIHi All, We have a requirement, to add one column values (Answer) to Dynamic columns (Question). Please see the below screenshot to clearly understand the requirement. We…
-
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…
-
LACLS Navigation Page EntryHi, How to configure a Page Entry using a static URL, but this url is conditioned by environment?, I mean when the ERP is on production thay entry go to production Visua…
-
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…
-
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…
-
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…
-
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… -
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… -
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…
-
Document of Record Drill to Document DetailsSummary: This report uses Deep Links for Document Records to navigate directly to the worker's DOR from the report results without additional clicks or navigation. Conte… -
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…