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. (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
-
Common Question: I didn't get any rows in the named subject area, what could be wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row…
-
OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date columnSummary: This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards. Content (required): 1- Response time of reports …
-
Common Question: In what particular subject area can I find these named columns?Typical Symptoms: you see columns on an application page and you want to know where they are in OTBI. Content: navigate to and download the latest database lineage mappi…
-
HCM OTBI Workshop Session 1Summary: This following link allows you to download the recording of session 1 of HCM OTBI Workshop for beginners organized by JAPAC CS Org along with DEV and COE. Conte…
-
Generate an OTBI or BI report that notes mileage or kilometer distance from home zip to work locatioSummary OTBI or BI Publisher SQLContent Does any one know of a way to get, for each Employee, the distance in miles or kilometers from the worker's home zip to work loca…
-
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…
-
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…
-
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…
-
table record to use for non benefits employees to new benefitsSummary: Hi, Writing a report to check the list of employees who are newly enrolled in the benefits. please share the table name which give the field name to separate th…
-
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…
-
"Report of the day" - Report about all data added/changed todayHello, I am looking for a report, which shows ALL data that have been added/changed by any user in the system per day. We have some troubles with one of our interfaces b…
-
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,…
-
Overall Summary and Rating in Document of RecordsSummary: Does anybody tried to bring the Overall Summary and Rating details from Performance to a Document of Record? Is it feasible to add those in a DFF? Content (plea…
-
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…
-
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…
-
HIDE THE FACTORY CATALOG FOLDERSContent Hi We are in 19D and we have removed one of the role which is(Extension Folder Reporting Duty) from Custom BI Webcat Reporting Duty to hide the Extension folder …
-
Where can I find tax registration Number for Reporting UnitSummary: Please can anyone tell me where the tax registration number is in OTBI, I am wanting to add it to a report but cannot find it. Content (required): I am looking …
-
How to Access Oracle HCM Cloud User Activity Audit data via API or any method ?Summary: Customer has a requirement to track the activities logs data performed by HCM Cloud User via API or any other method. They are interested to fetch the user even…
-
Can we download the attachments from BPM tables wfattachment?Summary Create hyperlink to download the attachments from BPM table wfattachmentContent Hello Experts, I am trying to generate a report with the approval transactions an…
-
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…
-
BIP Query to list 'Data Security Policies' tied to a job roleSummary: Client has a requirement to list ALL the Inherited Roles, Privileges and 'Data Security Policies' tied to a job role. We are able to list the Inherited Roles, P…
-
What is Grade and Performance Log Tables in HCM ModuleSummary: Is it possible to get Grade and Performance from Audit table. I need the who accessed the Grade and Performance data. Content (please ensure you mask any confid…
-
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…
-
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…
-
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…
-
Query to get Goal Approval StatusHello, For our report, we already have performance goals being listed in each row for every person. For each goals, we would require their approval status. However, when…
-
asdasdSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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…
-
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…
-
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…
-
How to fetch Cost Center Details which are mapped at Department LevelContent Hi Team, In our organisation we mapped Cost Center at Department level. How to fetch those cost center details. If anyone have SQL query please help me. I tried …
-
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 …