SQL
Discussion List
-
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 869 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 14 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 188 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 676 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Database items for Minimum and Maximum Input valuesSummary: Content (required): Hello experts, which database items allows me to extract the attached information (minimum and maximum input value). Thanks a lot in advance…Valerio Curzi 22 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Is there a way to get date tracked data for Per_periods_of_service tableI'm trying to figure out the date when the "Actual Termination Date" is changed, but Per_periods_of_service table has top of the stack record only. Is there a table that…
-
We can able to load the data in User-Defined Table Business objects but not able to see in frontSummary: We can able to load the HDL data but we can't able to see the data but in backend we can able to see the data. Note: If we entered manually in UDT then we can s…Ravindr-Oracle 70 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
To check if the requisition has Suspended state completion eventsHi, We had an issue in FAW, where for some requisition the suspended completion duration is missing. While debugging this issue, we are trying replicate the same in FA, …
-
How to make hyper link in one of the column values in BIP reportSummary: I have to establish link between MEANING Column values to the respective bip report . Thanks For Your Help!! RavindraRavindr-Oracle 41 views 3 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
BIP| How to link two data sets/source using outer join.Content Hi, I am working in a report where I have two different data sets A and B . There is a column which is common in both the data sets. I can link both sets using t… -
Retrieve payroll elements amount increasesSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to retrieve the payroll element amount increases? For salary basis,…Valerio Curzi 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
We have OnBoarding_15Days_Report but timeout error coming on below querySummary: Hi Team, we have OnBoarding_15Days_Report its runing ok but few days onwords we getting error is timed out error, we apply one year durationand even schedule al…AjayKumar Maddipati 42 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
MAX functions for payroll element effective start dateSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the most recent effective start date for a payroll element loade…Valerio Curzi 44 views 11 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
In Salary report one employee showing two records, difference is one is old salary second new salarySummary: HI Team, In Salary report one employee showing two records, only difference is one is old salary and second one new salary , how can we get latest record (New s…AjayKumar Maddipati 63 views 8 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM
-
Need a sql to get "extra info" on "position details" pageHi All, I'm trying to find SQL tables and joins behind getting "Regulatory Licence Information" under Extra Info Section of Position Details. Navigation : Set up and Mai…
-
Oracle BI Tables to retrieve last payroll element entries amount and last dateSummary: Content (please ensure you mask any confidential information): Hello experts, which BI tables collect data related to payroll element entry last amount and last…Valerio Curzi 31 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
SQL to retrieve employee name,person number,department name and department DFF detailsSummary: SQL to retrieve employee name,person number,department name and department DFF details Content (required): Hi All, Please share SQL to retrieve employee name,pe… -
Issue with Logical SQLSummary: Hi, I was working with a Report which will provide various employee emails like home email and business email addresses along with few other assignment details.… -
How to return Geographies using OTBISummary: We want to return Geographies (State, County and City) using OTBI. But the data should not return the geocodes but should return the actual name. Ex: State: LA …RenzelkeithCoquia 2 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
HCM native datamodels/bipSummary: are there another schema.table wich sample reports delivered in HCM Cloud are stored to extract a list of them ?? Content (please ensure you mask any confidenti…
-
csv output giving multiple date format while using etext templateSummary: I have built a report to display a date column in dd-mm-yyyy format using etext template. the report output is displayed in text or csv. In both the cases when …Nisha_Hegde 74 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
SQL instruction to join data from 2 or more BI tablesSummary: Content (please ensure you mask any confidential information): Hello experts, which instruction when building queries in data models allows me to join two or mo…Valerio Curzi 15 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to filter the column values by another column?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to filter employees which have these Response A…
-
Coding Conditional Formatting into LSQL?Summary: Logical SQL Conditional Formatting OTBI Content (please ensure you mask any confidential information): Hi All, When building a report in LSQL - I apply the SQL …William_Johnson 22 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
How to create a record in the position flexible field from postman with Oracle Rest API?Hi, I want to send a record to the flexible field opened on the position with the help of Oracle standard rest APIs. But when I examine the oracle document, I cannot see…Cansel Karasoy 31 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Setup table to pull Approval rulesSummary: Setup table to pull Approval rules Content (please ensure you mask any confidential information): Hi, Could you please advise setup table to pull out Approval r…Bhavna-Civeo 52 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM