SQL
Discussion List
-
does the system keep track of changes made by the manager on the employee's goal plan?Summary: Is there any way to track the historical data of an employee's goal plan? when the manager makes changes to the employee's goal plan (e.g., in the mid-year time…Alessandro Nesi 22 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM -
Is there a table or a view holding "Previous Comments" or "Approval History" related to unapprovedSummary: In order to check a detailed approval status of Goals before approval, I'd like to extract data such as "Previous Comments" or "Approval History" . I'd like to …S.Watanabe0110-Oracle 14 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
BIP Report Status DashboardSummary: BIP Report Status Dashboard Content (please ensure you mask any confidential information): Hi Team, Greetings! As you know -we submit/schedule multiple flows wh…Parag Hiremath 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM -
Bypass self-evaluation reporting in Performance ManagementSummary: Bypass self-evaluation reporting in Performance Management Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking for…Parag Hiremath 22 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
query to get deactivation date of userSummary: query to get deactivation date of user Content (required): May I know if any one know how to get deactivation date of user, I tried using end_date from per_user…Swati U 419 views 7 comments 0 points Most recent by Adrian Dogeanu-Support-Oracle Reporting and Analytics for HCM
-
I need a subquery that returns whether the manager filled out an assessment of the employees' goalsI need a subquery that returns whether the manager filled out an assessment of the employees' goals - from which tables can this be retrieved? In Oracle HCM Explanation …Alex_Balanovsky 12 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
How to fetch all sites linked to a particular customer using querySummary: How to fetch all sites linked to a particular customer using query Content (please ensure you mask any confidential information): Version (include the version y…Neelesh Varma 13 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
need query to get activities content type for all the courses along with offeringsHi we have requirement to get the Course names along with the offerings and their activites content type in the bi report. Can any one share me the sql for fetching all … -
Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM CloudSummary: Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM Cloud Content (required): Hi All, We got the requirement to extra…Venkatesan 2K views 3 comments 0 points Most recent by Navya Siddaling Reporting and Analytics for HCM
-
Standard Hours From per_availability_details.get_availability_detailsTeam, We have a requirement to get the standard hours for particular period. We have two parameters. Period Start Date and Period End Date. Ex. We are passing 03-Dec-202…
-
Adding approval history information to the reportHi, I designed a report that works the same as the standard notification with custom parameters. I would like to add the following field to the report, which comes in th… -
Get Scheduled Hours From Assignment Work SchedulesWe have a requirement to get the scheduled hours from Assignment Work Schedules. We are trying with the below code but its not giving hours. SELECT * FROM ( TABLE(PER_AV…
-
Query showing the values on the current Tax Calculation CardsSummary: I need BI publisher reports that show the values on the current Tax Calculation Cards for all active employees including their hire date. The values of greatest…
-
Due Date dashboard prompt in OTBI gives precision_scale errorSummary: OTBI Learning Dashboard prompt for Due Date set to between gives a precision_scale error across all analytics Content (please ensure you mask any confidential i…Kevin Robertson 14 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Sequence NumberSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Rick Jason 1 view 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
How many ways do I restrict the BIP reports and OTBI reports?Summary: How many ways do I restrict the BIP reports and OTBI reports? Content (please ensure you mask any confidential information): Hi Experts, Please tell me how many…Malak 5 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
No of days old in OTBISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Error on NLS_DATE_LANGUAGE code for Traditional and Simplified ChineseHello, We are editing a data model to update the date in a report for custom languages Traditional and Simplified Chinese and we are facing this error : "ORA-12702: inva…Lise_Rekik_Acc 27 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
query to get details of Potential assessment in talent review which is completed by the Managerneed to know the tables and links between the tables where to get the Manager Assessed Avg Performance, Manager Assessed Risk of Loss, Manager Assessed Potential, Manage…Sanduni Pathirathne 330 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting and Analytics for HCM
-
FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle CloudSummary: FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle Cloud Content (required): We got mail from Oracle Cloud Saying following : As par…Swati U 941 views 7 comments 0 points Most recent by Avinash Veeranna Reporting and Analytics for HCM
-
Assignment Manager Prompt - Direct and Indirect ManagersHi all, Does anyone know if its possible to use Assignment Manager as a prompt for a dashboard and also include the full direct and indirect managers for the user? At th…
-
ORA-20001:An internal assertion test couldnt be completed at location pay_balance_pkg.chk_rel_actionSummary: Custom BIP report is developed and It is not working from ESS job. Note: When it directly run from BI Publisher is working. Error: Waiting Time: 2 seconds Trigg…Bejoylin 292 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
address purpose Filed and table locationSummary: Looking to add the address purpose field into a previous BI report Content (required): I have a previous supply report i had built in BI publisher, a recent req…RJ Blankenship 116 views 6 comments 0 points Most recent by H.Chauhan Reporting and Analytics for HCM -
OTBI > Ability to AggregateSummary: OTBI > Ability to Aggregate Content (please ensure you mask any confidential information): Hello All, In order to prevent the repetition of the Time Card Commen…
-
Agents and RecipientsSummary: Does anyone know how I can get a list of Agents and recipients out into a report? Content (please ensure you mask any confidential information): I need to get a…GJ79 41 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Write a BIP report query in which termination records should be picked only once in output fileSummary: My requirement is: I have to write a query in BIP report to fetch the current and future hire employees, and termination records should be picked only once. The…Anuroopa Sahoo 95 views 1 comment 0 points Most recent by Serban Nicolae-Oracle Reporting and Analytics for HCM
-
how to show different content for in app and email workflow notificationswe have a requirement to show different content for in app and email notifications of RESIGNATION. So I used below condition in the RTF template using the oracle docs. …Dara Nagasai 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
I have made changes to emps to workers from our integration urls but unable to find AssignmentDffId"Summary: I have made changes to emps to workers from our integration urls for testing one url need this "AssignmentDffId" but i have checked frontend as well as backend …
-
IRC_REQUISITIONS_B AND PER_ALLOCATED_TASKS RELATION in oracle table and viewsSummary: Need to build Onboarding - Overdue Tasks Report Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Pradnya_Pampatwar 401 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Reporting and Analytics for HCM
-
Difference between creation_date and submission_date in IRC_SUBMISSIONS tableSummary: Difference between creation_date and submission_date in IRC_SUBMISSIONS table Content (please ensure you mask any confidential information): Hello experts, does…Oriana L. 2 views 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM