Category 81
Discussion List
-
Results to be displayed horizontally instead of vertically in reportsSummary: We have a requirement where the results displayed in reports are vertical but we need to display that column horizontally. Suppose say for example this the resu…Prajwal kumar 83 views 5 comments 0 points Most recent by Prajwal kumar Reporting and Analytics for HCM -
Job Profile AuditsHi , I have a requirement to pull the changes made to Job profiles/Job details. Is there any way if it can be retrieved from Audit report, If yes, how can i achieve it. …Praveen_Chouhan 6 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How can I make sure that when the Dashboard is first opened, no data comes in without selecting a paHi, I designed a dashboard for users. It has a detailed dashboard with assignment information of individuals and multiple parameters. What I want is for the parameter sc…Sinem Kara 60 views 9 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL?Summary: Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL? Content (required): Looking for a query that can be used to check…
-
Unable to add Salary Basis Column in my existing Compensation detail ReportSummary: I need to add Salary Basis Column which I am unable to do so in the exisiting report. Subject area I have use is Payroll - Element Entries Real Time Content (re…Jasmine 37 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Calculated item for Actual Time spent in LearningSummary: Content (required): Hi there, the actual time spent for a learning item is measured in 0.5, 0.75, etc. We want to prepare a calculated item column in OTBI repor… -
Where to find Risk Code Description in DBSummary: Need to find the Risk Code (or Workers Compensation Code) description in the database. Content (required): I am creating a report pulling data out of hcm cloud …
-
Percentage of documents in various tasks.Summary: Hi Experts, The performance process flow we are using is 1) Set Goals 2) Self evaluation (employee) 3) Manager evaluation 4) Employee final comments 5) Manager …
-
How can I edit the pie report I added to the Dashboard screen?The pie report I prepared shows the gender information of the people working in the departments. For example, when I click on the number of women, the page in the screen…Cansel Karasoy 47 views 5 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
How can I show the number of rows returned from the report?I created a dashboard from the analysis report and there are parameters for this report. How can I show how many data is returned in the report depending on the paramete…Barış Ergün 85 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Utilizing Assignment Event Details with Workforce Trending SASummary: Would like some advice on how fields from the Workforce Events.Event Details folder can be repeated for each month it is active (during assignment Start/End Dat…MGF 87 views 16 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How can I make the report not open without selecting Parameters on the Dashboard screen?I have a few reports that I have prepared from analysis and I have created a dashboard from them. And reports work with parameters. When I click Open to Dashboard, repor…Cansel Karasoy 55 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Display Assignment Data as of hire effective dateI have created an analysis that gives me all hires between two dates. However, I noticed the assignment data that is displayed shows current information. How can it be m…
-
Delivered Report for State TaxSummary: Checking for delivered Report which provides State Tax Withholding details for all states. Content (required): We have built a custom report for State Tax Withh…Seema Kalantri 44 views 2 comments 0 points Most recent by Seema Kalantri Reporting and Analytics for HCM
-
BIP - Non-catalog item reportSummary: Hello, Have anyone tried creating a Non-catalog item report in Learning? Do you know where I can get these details below? (Column name, tables in BIP) Your help…Hazel De Castro 105 views 6 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Is it possible to open a detailed report for a tile or graph besides it?Summary: Is it possible to open a detailed report for a tile or graph besides it? When I am using action links in Interaction tab detailed report is getting opened in th…Parul Sah 23 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to display to a report chart in the Approval notification pageSummary: Hi There is a requirement to show the bell curve to the managers ( Approvers) of their subordinates in the performance document approval notification. Content (…
-
Create a Report for Candidate Job Application with the Prompts as Prescreening QuestionsSummary: Hello Experts, We have a requirement where we need to build a report with the Filters as the Prescreening Questions. There are 15 Prescreenshing questions but w…HarishVummidi 108 views 2 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Report in OTBI to show data as of end of previous monthSummary: Need to show number of openings (from recruiting requisitions) from a specific date (6/1/22) through the last day of the previous month. I created a filter to s…
-
What if i cannot find the Subject Area in the dashboard prompt. Does that mean i cannot create?Summary: Trying to create LSQL coming from Workforce Profile - Person Profile Real Time and Workforce Profile - Model Profile Real Time and will add it to a Dashboard wi…
-
Email Body not bursting correctly (22C)Summary: Content (required): Hi Since we went live with the 22C patch, notifications burst from OTBI are not including anything in the body of the email sent to recipien… -
How to embed Analytics, as an icon, in My Team page in UISummary: Our client wants to embed Analytics, as an icon, in My Team page in UI, which will redirect to a custom Analysis, as similar to the attached screenshot. The ico…Dona Das-Oracle 9 views 0 comments 1 point Started by Dona Das-Oracle Reporting and Analytics for HCM
-
OTBI Analysis report for auditing changesSummary: Hello - we are looking for a report/audit tool that will help us monitor when changes have been made to OTBI analysis based reports. We are utilizing the functi…Shanna Oppenheim 1K views 16 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How to read primary national identifier?Summary: How to read primary national identifier? Content (required): How to read primary national identifier? I use per_national_identifiers table but no reference to t…Nicola Petri 76 views 2 comments 1 point Most recent by Seema Kalantri Reporting and Analytics for HCM
-
Do Business Unit names in BI report criteria gets changed to BU ID value during archive/ unarchive?Summary: Hi All BI/ reporting experts - The question is regarding migrating BI reports from one pod to the other. Oracle recommends using archive/ unarchive feature. We … -
Terms (Leavers) with Most Recent Performance Score and Box AssignmentSummary: We need a report and bar chart that shows terms (resignation and term-invol), NO legal employer changes, with their most recent performance score- the Calculate…Rebekah Gilday 38 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Errors found FBDI - Import Project Resource AssignmentsSummary: I am receiving these errors while performing the imports by project. Some of these I believe are caused by bad configuration data but not all. I am new to HCM a…Jon Calhoun 29 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle HCM Spreadsheet Data Loader (HSDL)
-
Conditional display of dashboard analysisHi All We have a requirement to hide some area's (protected characteristics in particular, Age, Gender, Ethnicity) of the line manager dashboard based on the team size, …Murthy Kodavati 64 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for HCM -
HCM OTBI Workshop Session 2Summary: This following link allows you to download the recording of session 2 of HCM OTBI Workshop for beginners organized by JAPAC CS Org along with DEV and COE. Conte…Raghavendra Raghunath-Oracle 966 views 6 comments 14 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How can I get double quotes around fields in the output generated by an etext template?Summary: After adding a new field to a current etext RFT template and uploading it, the output no longer contains double quotes around the fields that contain spaces or …BeachDreamer 1.2K views 3 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM