Category 81
Discussion List
-
TERMINATION EMPLOYEES DATA NOT FETCHING POST 2018 IN OTBI REPORTSummary: With the help of OTBI tried to create report containing Person number, Name, Job code, Job Name, Grade Code, Grade Name, Termination data and Salary Basis, wher…Kavya Veluri-Oracle 31 views 2 comments 0 points Most recent by Kavya Veluri-Oracle Reporting and Analytics for HCM -
Prompt does not work in dashboard for different analysis using different subject areasSummary: Content (required): I have a Dashboard with the following analysis (tabs) called: 1. Requisitions (SA:Recruiting Real Time) 2. Applications (SA:Recruiting Real …Maria Xydopoulou 41 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Changing Fetch First 250001 Rows Only to another valueSummary: How do you change the Fetch First 250001 Rows Only to another value or remove it entirely. Content (required): I need to remove the Fetch First 250001 Rows Only…
-
Reporting Sales within HCM OTBISummary: Content (required): I have a requirement that is asking to report Sales by Organization, but also housing infomation that you would find In workforce management…Yamalia Roberts 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to get the OldValue and NewValue by using per_bipntf_utilitySummary: Unable to get the OldValue and NewValue if any change on the Employeement level by using per_bipntf_utility Content (required): We did few changes on the Emplom…
-
Layer filters?Summary: Looking to be able to layer filters. An example would be that I want to only pull department names that start with a specific sequence of numbers AND have/don't…Jessica D 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Ethnicity values question in Recruiting Subject AreaSummary: Asking for assistance in understanding the difference between 2 Ethnicity fields Content (required): Hello. Can anyone advise on the difference between the 2 fi… -
OTBI - Calculate Tenure using Presentation VariableSummary: I need show Tenure calculation by subtracting the Work Relation Start Date of a person from the Date passed by the user against the presentation variable (Promp…Harpreet Shergill Oracle 94 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Publisher AverageHI, I need support to calc an average in this table rtf. I need to see in the red circle the average of 3 and 2 (the blue box). How do it? In zip I've attached rtf and x…gdegenna 12 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
OTBI analysis column content does not wrap when added to dashboardSummary: OTBI analysis column content does not wrap when added to dashboard. Content (required): Standalone OTBI wraps text but when added on dashboard text is not wrapp…Adil Muhammad 22 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Unable to scroll Subject Areas with UnionSummary: When trying to use the "Combine results based on union intersection and difference operations" I'm unable to scroll past the initial list of Subject Areas to th… -
Handling Invalid Dates in a CASE statement in OTBISummary: How do you replace 00--0 with an actual date in OTBI? Getting error with CASE statement below Content (required): My CASE statement is coming back with an error…
-
How to get Active Bank Account DetailsHi Experts I am trying to write a query to get Active Bank Account Details for a given employee. I am not sure in which table and column this flag is stored. I checked "…Dharmendra Shukla 453 views 4 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
To avoid Oracle Repository external accessHi team, I need your precious support! Cause of notifying the candidate, we created a BI report adding a "link" to make the recipient able to download a .zip file. We us…tommasodicesare 33 views 0 comments 0 points Started by tommasodicesare Reporting and Analytics for HCM -
Need the field from the table to use the alternate email for internal cand to build the customBI repSummary: Need the field from the table to use the alternate email for internal candidate to build the custom BI report and i am not able to find this field in IRC_CANDID…
-
Need inputs for 401k Contribution ReportSummary: Need inputs for 401k Contribution Report Content (required): Hi Team Greetings! This is about getting the details for 401k contributions report including deferr…Parag Hiremath 75 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
How do you include inactive requisitions in an analysis?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Ed Sevilleja 51 views 4 comments 0 points Most recent by Ed Sevilleja Reporting and Analytics for HCM
-
How to report on Date Paid in last 12 monthsSummary: I have a report using the Payroll Balances Real Time subject area. The requirement is that when the report runs on the first day of every month, the output is f…
-
Reporting on ICD/Manage Personal Contribution Requests that have been SavedSummary: Content (required): We use Individual Compensation Distributions for our employees to claim for irregular payments (overtime worked etc.) as we are not yet usin…Leanne W 41 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
report of all list of ESS jobs which are Running more than 24 hrsSummary: report of all list of ESS jobs which are Running more than 24 hrs Content (required): report of all list of ESS jobs which are Running more than 24 hrs Version …Swati U 33 views 2 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…Swati U 427 views 10 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM
-
How to apply a 'Custom Theme' to OTBI reports/dashboards.Summary: How to apply a Custom Style Theme to dashboard and reports to align to Company standard. Content (required): is it possible within OTBI to generate and apply a … -
How are users interacting with systemSummary: Content (required): Hello We would like to know how our users are interacting with our system. The ASE_USER_LOGIN_INFO table shows the date of the last login, b…Helen Thomas 43 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Oracle Fusion HCM Extract getting fails when we select Delivery Type as FTPSummary: Hi, Delivery option getting failed when we select delivery type as "FTP" along with bursting in BI data model. if I select Delivery type as "None" extract getti…
-
The promt does not affect the analysis report on the Dashboard screen.I have an analysis report that I use on the dashboard screen and parameters that I expect to affect this report, and one of these parameters does not affect the report, …Cansel Karasoy 61 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Which table stores the "Assign as" information for initiativeSummary: Hello All, I am trying to build a report to fetch learning initiative details but i am not finding any information regarding the assign as column in the UI.Plea…minati_behera-Oracle 51 views 3 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM
-
How can i query the "Active" Organization Tree version description?Summary: How can i query the "Active" Organization Tree version description? Content (required): I'd like to be able to return the value / name of the Version ID tied to…Shant Karakashian 2.5K views 3 comments 0 points Most recent by Shant Karakashian Reporting and Analytics for HCM
-
Need function condition to exclude any character other than numbers and alphabets for address in BISummary: Need function condition to exclude any character other than numbers and alphabets for address in BI Content (required): Address should not have any characters o…
-
Syntax for comparing numeric plain text value with number valueSummary: Requirement is to build analysis to identify employees whose payroll run result of a particular element does not match a corresponding value held in assignment …Alastair Wood 34 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM