SQL
Discussion List
-
Tables to capture details about the Absence current and previous plan detailsHi All, I'm currently working on capturing details about an employee's current and previous absence plans. I'm seeking guidance on the specific tables that would contain…Sanduni Pathirathne 174 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Third party organization payment method reportSummary: Third party organization payment method report Content (please ensure you mask any confidential information): We have a requirement to run a report of the bank …Michelle Hughes 110 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
in OTBI Performance Report Completion Weight value not showing the total weight percentageSummary: OTBI Performance Report needs to show the Completion Weight percentage value display as the total. it is displaying as the separate Completion Weight percentage…Ritu Surve 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report to extract Assessment Questionnaire of Learning sectionSummary Need to extract assessment questionnaire of an offering linked to a learnerContent Hi All, I am trying to extract the assessment questionnaire with the answers i…teresa.marciano 669 views 3 comments 1 point Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM
-
Oracle BIP Report -> Timezone Issues (displays +5 hrs)Summary timezone offsetContent Hello, Can anyone please help me? I have a learning activity with a start time of 08:00 am and with timezone of EST. When it is included i…SantoshKumarBhairi 110 views 8 comments 1 point Most recent by Cristelle Dahak Reporting and Analytics for HCM -
case statement was producing only 3 records instead of 6 records in FINAL_PATH ColumnHi All, need help on below case. i am concatenating the different structure of Reports Url's (BIP,OTBI,DASHBOARD) with POD url along with report path. Here FLV.DESCRIPTI…Ravindr-Oracle 11 views 4 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
How to fetch Level 1 department for a person via SQL codeWhats the sql code behind level 1 department in Worker assignment real time subject area?
-
Time and Labor -- Calculated time card entries for a date range or pay periodSummary Calculated time card entries for a date range or pay periodContent Hi Friends I have been working on a report for Calculated Time Card Entries and so far i have … -
Measuring the Completeness of Onboarding Task by EmployeeSummary: Measuring the Completeness of Onboarding Task by Employee Content (please ensure you mask any confidential information): In the Onboarding report use the Checkl…Thulasi Ram 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Differance between data table ending with "_" and normal data table?Summary: Differance between same data tables but ending with "_" table? Content (please ensure you mask any confidential information): Hi Team, I have a query. what is t…
-
What payroll field and table track if a deduction (element) was actually deducted from gross?Summary: If an employee's gross pay is not large enough to accommodate all of his/her payroll deductions (i.e. taxes, benefit deductions, 401K), it looks like Oracle ded…BeachDreamer 107 views 1 comment 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
Report to get the list of employees with change in payroll groupSummary: Report to get the list of employees with change in payroll group Content (required): Hi Team, Greetings! The change in payroll group, especially from weekly to …Parag Hiremath 31 views 5 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Differance between table and view?Summary: What is the differance between table and view? Content (please ensure you mask any confidential information): Hi Team, Can some one will help me the below query…
-
Types of keys in data tables?Summary: How many types of keys are there in data tables? Content (please ensure you mask any confidential information): Hi Team, I have some queries. How many keys are …
-
Table to extract BPM Approval Groups InformationHi, I cannot see any data when querying the tables below. Could it be due to the role? What could be the reason? I think it should be recorded in these tables. fa_fusion…Cansel Karasoy 22 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
ESS Job Report with link between parent and child requestsSummary: ESS Job Report with link between parent and child requests Content (please ensure you mask any confidential information): Hi Team, We use the different reports …Parag Hiremath 548 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
OTBI - change field from text to numberSummary Changing text format fields, which include number values, to number formatContent Hi :) I have a report which shows information on Element Entries. The input val…
-
Table Name for Availability CalendarTeam, Need table name which holds the availability calendar details. Person Management -> Work Schedule Assignments-> View Calendar. Please Guide.
-
Age Formulas using SQLSummary Need age as of the current date and when someone will be a certain ageContent Hello, I am needing a formula to calculate age in Years that does NOT round. For ex…Rebekah Gilday 85 views 9 comments 0 points Most recent by Diane G123 Reporting and Analytics for HCM -
How to restrict based on previous Backout statusSummary: Hello All, I'm currently working on restricting the custom BIP notification based on below scenario. If an employee benefits is backed out and reprocessed again…
-
Pending Approver when a transaction is claimedSummary: The transaction detail analysis as well as the SQLs do not provide the information of the current approver when a transaction is claimed in case of parallel app…Sowdha Murugan 12 views 1 comment 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
Scheduling a BIP Report for Biweekly...Summary Bi-Weekly schedulingContent HI All, I was wondering if there was any way to easily schedule a report to be run bi-weekly. We have some reports that need to be ru…User_2025-02-04-08-51-08-912 170 views 4 comments 2 points Most recent by Sree Latha Reporting and Analytics for HCM -
Parameter definition in reportI will use the last_update_date parameter in the report I prepare. But I want to use the last_update_date column in more than one table in a single parameter. For Ex: pe…Cansel Karasoy 21 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
How to use Listagg functionality in OTBI AnalysisSummary Listagg in OTBI reportsContent Hi Team, Listagg function in OBIEE reports is used to display multiple lov's in a a single row with (,)separator. How can we achie…Kalyani Koylada 923 views 8 comments 0 points Most recent by Tonya H Reporting and Analytics for HCM
-
How to join cmp_stock_details & hrc_integration_key_mapSummary: We are trying to create a report for fetch source system ID used for loading stock but No joins are available to join cmp_stock_details & hrc_integration_key_ma…Niharika 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Payroll - Calculation Cards Real TimeContent Good Morning, We are trying to find granular details with regards to Pension details. On the front end we can see in a sub-folder called 'Calculation Component D…User_2025-01-28-07-12-45-467 185 views 7 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Value as columnTeam, The timecard layout has been configured and there is a custom attribute created like below. PROJ_FUNCTION - AttributeVarchar1 We have got the above details from on…
-
Oracle BI Tables to retrieve manager hierarchy level and Plan Access LevelSummary: Content (please ensure you mask any confidential information): Hello experts, which Oracle BI tables allow me to retrieve manager hierarchy level and plan acces…Valerio Curzi 32 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report to get list of users who are lockedSummary I need to get a list of locked user accountsContent I looked at the 'Reporting on Application Users and Roles' section the Oracle documentation, but none of thos…David Villegas 1.6K views 17 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Identifying global transfer records, hire/rehire records from per_periods_of_serviceSummary: Identifying global transfer records, hire/rehire records from per_periods_of_service Content (please ensure you mask any confidential information): Hi All, Empl…Gayathri K M-Oracle 708 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM