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
-
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
How to call a query or data of one particular data model to another data model.We have a requirement to get gross salary details in many BI Reports. We need to know that is there any feasibility to call one data model related data in another data m… -
Duplicate a page in Dashboard - OTBISummary: Content (required): Hi there How can I duplicate a page in an OTBI Dashboard? Thanks Bobby Version (include the version you are using, if applicable): 21C Code … -
What is the role of the Manager in Self-Evaluation?Summary: Hello, I'm currently working on Performance Task Status Report for my organization. I've changed the Role to Task Assignee. In the Worker Self-Evaluation, there…
-
WorkRelationshipPVO missing DFFsSummary: WorkRelationshipPVO is missing DFF's such as PDS_INFORMATION% and PDS_INFORMATION_DATE% columns from PER_PERIODS_OF_SERVICE. We are using DFF's to populate cust…
-
Missing HcmTopModelAnalyticsGlobalAM.OrgAttributesDFFBIAM.FLEX_BI_OrgAttributesDFF_VIWe don't see HcmTopModelAnalyticsGlobalAM.OrgAttributesDFFBIAM.FLEX_BI_OrgAttributesDFF_VI in BICC offering though it is available HCM PVO mapping document. How do we ge…
-
Benefit Enrollment Report which has all Life events and the Enrollments in an excel format?Summary: Content (please ensure you mask any confidential information): Can someone share the report format where we have the following format Effective date Life event …
-
Need Oracle SQL query to get the Office number for Location details from Assignment pageSummary: Need Oracle SQL query to get the Office number for Location details from Assignment page Content (required): Need SQL Version (include the version you are using… -
OTBI Agent Not Sending Files to Distribution List EmailGood Day Experts, We have an OTBI Agent that is not sending the file to a distribution list email. The OTBI Agent is sending our dashboard to an excel file. Sending to i…
-
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,…
-
-
Performance Managment Document ReportingSummary: I need to know how to pull Section Comments made on Performance Goals, in the Performance Document. These are the Goals that are pulled into the the Performance…
-
OTBI Report data issueSummary: OTBI Report data issue Content (please ensure you mask any confidential information): Hi All, We developed OTBI report with Workforce Management - Worker Assign…
-
Can I download bi publisher to mac?Summary: Hi team, I want to switch to mac , I saw that is problem to download BI publisher, someone tried? and there any other problem with mac?
-
Absence Balance Report Based on Balance Calculation DateSummary How to get the absence balance to include future dated absencesContent In the existing report, balances are reflected as of today; however, would like it to refl…
-
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…
-
Query to retrieve manager assignment numberSummary: Content (please ensure you mask any confidential information): Hello experts, we need for each employee to retrieve the line manager assignment number. Do you h… -
Can you use "prompted based on results of another analysis" when using presentation variables?Summary: Essentially we need to find the delta/ difference between two analyses that are date tracked to different points in time in the Prefix of the OTBI Analysis usin…
-
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, … -
When the employee open a report we need to send one email to same employeeSummary: When the employee open a report we need to send one email to same employee Content (please ensure you mask any confidential information): Hi Team, We have a req…
-
Query to find BIP report schedule detailsSummary: Query to find BIP report schedule details Content (required): Hi Team, We have requirement to fetch the schedule details of a BIP report like schedule start dat… -
How to get users last login dateContent Hi, We have requirement to fetch all users last login date and time. May i know which table can help to get the info. I tried FND_SESSIONS and ASE_USER_LOGIN_INF… -
User Last Login Date ReportSummary Need to report on User Last Login DateContent Hi All, I am looking for a way on how can I report for User Last Login Date using BI Publisher. I tried using the F…
-
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…