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
-
In search of a basic termination reoprtSummary I am looking to create a standard termination report for the HR teamContent Our company is new to Oracle and we were not provided what I'd consider a basic termi… -
Report automatically sorting Month column in ABC orderSummary I want the 'Month' column to reflect appropriate order (Jan-Dec)Content I have a report created that pulls # of monthly transactions. I pulled in the "Month" fie… -
Tip:Blank Infolet but Underlying Catalog is returning output - What to do ?Summary Tip:Blank Infolet but Underlying Catalog is returning output - What to do ?Content For Viewing data in the infolets , its same as permissions on the subject area… -
How to avoid line managers modify their own job related detailsSummary How to avoid line managers modify their own job related detailsContent 1) We designed OTBI reports for line managers in Workforce Compensation. when the launch r…
-
Promotion Headcount Measure: Worker Assignment Event Real TimeSummary How is the promotion headcount calculated?Content Hello - I am reporting on the Worker Assignment Event Real Time Subject Area, Promotion Headcount and some rows…
-
Tip: SQL Query to check existence of HCM EnterpriseSummary Tip: SQL Query to check existence of HCM EnterpriseContent Tip: SQL Query to check existence of HCM Enterprise ,which can be used in data model. select name,orga…
-
Absence Data Parameter ReportSummary How to create an absence report only capturing absences between a certain periodContent I would like to add some date parameter fields onto my Sickness Absence R… -
Security and OTBISummary Provide access to run specific data reports without provisioning access in FusionContent I need to provide access to an employee group to access an emergency con… -
Number of current contracts in the actual month and in the previous MonthSummary Number of current contracts in the actual month and in the previous MonthContent Hello, I want to create report displaying number of employees by the contract ty… -
Resource for HCM field definitionsSummary Online resource for looking up definitions at the field levelContent Good afternoon. I am able to find online resources on HCM Subject areas, Folders and Tables.… -
OTBI vs BIP SecuritySummary How does security work for each of these report types?Content Hi all - does report security for these report types work the same? For example, I have an employee… -
How To Pull Effective Date of Change Of Assignment Category in HCM ExtractSummary How To Pull Effective Date of Change Of Assignment Category in HCM ExtractContent I have a requirement to pull Effective Date of Change Of Assignment Category in…
-
All - Data Visualization for Oracle SaaS Customers: September 13, 2017, 9 a.m. PT - Submit QuestionsContent Submit your questions for the All - Data Visualization for Oracle SaaS Customers session to have them answered during the live event. Post your questions by post… -
BI publisher - How to use conditional statement in SQL queryContent We have a payroll report, which accepts startdate and enddate from users. So there are 3 scenarios this report is generated: 1. Startdate is first of the month a…
-
Blank Infolet : Otherwise Full Data in analysis/CatalogSummary blank Infolet : Otherwise Full Data in analysis/CatalogContent Hi, Please advise on below - I have created a simple Analysis\catalog of person count and country.…
-
How to Include Ampersand in StringSummary How do I use an ampersand in a stringContent Hi all - we are reviewing a report today and ran across an error that we are not familiar with. When we create a new…
-
Need table details for "Associations"Content Hi All, Please suggest in which tables holds the "Associations" details and find the attached screen shot for your reference. Navigation: Person Management-->Man…
-
Managers unable to access reportsSummary Reports reflect 'No Results' when a manager attempts to open a reportContent I have created several reports and assigned permissions to the manager role. They ar…
-
BI - using CASE statement in WHERE clauseContent We are creating a report in BI and it takes parameter from a dropdown list that populates based on SQL. And we need to use that parameter in the WHERE clause. Ex…
-
Error running OTBI reportContent I have created an OTBI report using custom query (by clicking the "New Analysis" from the Advanced tab) And I am able to run the report fine ( I have the admin r…
-
In which Subject AreaContent We need to create a report to bring Vacation accruals and balances. I am looking for the Subject Area in which the Current Vacation Dollars Accrued is stored. An…
-
Vacation Hours Accrued (May to date)Content I am creating a payroll vacation report (in OTBI) and one of the columns is the Payroll vacation hours accrued from May to date. I am not able to map the balance…
-
Adding an "as at" date prompt into a salary analysisSummary Adding an "as at" date prompt into a salary analysisContent Evening all I need to create an OTBI report that returns the salaries of employees at an entered date… -
Dashboard Prompt: Not show Inactive values in Search selectionSummary Control dashboard prompt to not show the Inactive values for users in search selectionContent Hi All, We have built a dashboard with dashboard prompt for 'Goal P…
-
Issue with Infolets when underlying Analysis use session variablesSummary Infolets that rely on analysis that have session variables (such as NQ_SESSION.USER) do not display consistent outputContent Hi All, When we build an analysis us…
-
Need to Retrieve certain information from W2'sSummary Need to retrieve W2 Box information for reporting purposesContent We are in the process of moving from Payroll EBS to Fusion Payroll which as a result I have a B…
-
Filters on a Pivot TableContent Hi there, we have a pivot table report for employees phone numbers (XML attached). The report has filters to only report on UK employees where the termination da… -
Taleo vs Fusion Reporting FieldsSummary Can we report on same fields in Taleo and in Fusion?Content Hi all - I have fields in Taleo that I know I can report on (Employee Number, Ethnicity, Gender, Reli…
-
Goal Report not showing any data for ManagersSummary Goal Report not showing any data for ManagersContent Hi, we created a goal report based on the subject area "Workforce Goals - Goal Status Overview". The report …
-
Where can I find custom fields in Manage Employment in OTBI?Summary Custom fields in Manage Employment in OTBI?Content Hi all Our implementation partner created some custom data fields in the Manage Employment screen but I can't …