Category 81
Discussion List
-
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 452 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 426 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 42 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
-
Query to extract Mail address Effective start dateSummary: Content (required): Hello experts, please, could you share the SQL query to extract employees effective start date? Thanks in advance for your time! Kind Regard…Valerio Curzi 61 views 9 comments 0 points Most recent by DavidBlake Reporting and Analytics for HCM -
Unable to find the Subject area/SQL query to get the Final close date value in the PayrollRelationUISummary: In the Payroll Relationship UI we have final close date value at the Element duration dates as well as Assignment level. I am unable to find any subject area/SQ…
-
Table and field references for compensation manager hierarchySummary: Content (required): Hello experts, for this compensation campaign we should change the manager hierarchy workflow and we set the primary hierarchy as in the att…Valerio Curzi 62 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Understanding Actual Termination Date and Per_Periods_Of_ServiceSummary: Looking for SQL to pull in an accurate termination date given a point in time. And if that point in time is BEFORE the termination, then the business is wanting…SeanWesche 1.2K views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to generate EEO-4 report in HCM?Summary: Generate EEO-4 report as per federal requirements Content (required): What are the set steps required to generate EEO-4 report from HCM? Version (include the ve…Akhil Pillai 276 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Tile visual errors when The Table Visual is not added to ViewSummary: Hi, can anyone please help with the error message that appears when Table visual is removed from the view leaving the Tile visual in view. Content (required): T…
-
Job Incumbents 10th 25th 50th 75th 90th incumbent baseSummary: We are building an otbi dashboard that can be leveraged to report on incumbents jobcodes and paygrade ranges. We have the base report with jobcodes and number o…Akshay.Agarwal 42 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is it Possible to remove Dashboard creation option from the RoleSummary: Is it Possible to remove Dashboard creation option from the Role Version (include the version you are using, if applicable): 22DHarish Vummidi 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM