SQL
Discussion List
-
Department to User Login report helpSummary Adding department to data modelContent Can anyone help add department to this user last login report please? It was built with a data model and I don't know sql.…User_2025-02-05-07-51-01-504 20 views 8 comments 0 points Most recent by User_2025-02-05-07-51-01-504 Reporting and Analytics for HCM -
Oracle Fusion Cloud Audit Reports - Changes in Static Data (Before and After Values)Summary Audit Reports - Additional Functionality (Before and After Values)Content Hi, My client wishes to have a more detailed Audit Report functionality Currently the A…Stuart Hackney 55 views 2 comments 0 points Most recent by Stuart Hackney Reporting and Analytics for SCM -
How to get a list of all languages from HRT_CONTENT_ITEMS_TLContent Hi, Under talent profile and language skills - how do I just get a list of all available languages? See they are hiding in HRT_CONTENT_ITEMS_TL but not sure how …King Jack 40 views 1 comment 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Performance issue while fetching details from data_cache columnSummary I am facing performance issue while fetching details from data_cache column.Content Hi Team, I am using below query for fetching all kind of approval transaction… -
Remove merged cells from report in reports & analyticsSummary Remove merged cells from report in reports & analyticsContent Hello, Please note that we have a report : Scott Marketing report which has merged columns B & C AN…User_2025-02-05-12-20-44-163 274 views 7 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Manager_type = Timecard_Approver in OTBISummary Manager_type = Timecard_Approver in OTBIContent Hi ALL, In OTBI when I see "Manager Type" ( "Workforce Management - Worker Assignment Real Time"."Worker"."Manage…User_2025-02-07-19-03-14-525 36 views 7 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable To Export To CSVSummary Enable CSV is enabled in the data model, but am not able to export to CSV.Content We have an existing report that the business would like to be able to export to…Matt Isaacs 57 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Shared mailing addressesSummary Require a report to show employees that have the same mailing addressContent Is it possible to generate a report that shows 2 employees residing at the same addr…User_2025-02-04-08-51-08-912 16 views 8 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Report for All Products in Staging with Order NumbersSummary Report for All Products in Staging with Order NumbersContent Hello, Can you please advise from which subject area we can download a report with all products in s…User_2025-02-05-12-20-44-163 29 views 2 comments 2 points Most recent by User_2025-02-05-12-20-44-163 Reporting and Analytics for SCM
-
Instance name - TableSummary Instance name - TableContent Hi Team, I want to know the Instance details available table or DBI or UE. We are using email options in the extract to send the out…User_4VVG2 41 views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Deriving column value based in ROLE.Summary Deriving column value based in ROLE.Content Hi All, Need HELP I'm creating report in OTBI and in report there is field call"Is Manager" and logic for this field …User_2025-02-07-19-03-14-525 16 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI Table Name to fetch Data Type under Column Assignment of Global SegmentContent Hi Team, I am trying to fetch Data Type under Column Assignment of the Global Segment Details. Please let me know the backend table name which stores that. Thank…Sandip Karmakar 34 views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Need tables in fusion that store the Salary Details and Salary Component Breakup detailsSummary Need tables in fusion that store the Salary Details and Salary Component Breakup detailsContent Hi, Can anyone please provide me the table names that store the s…User_MC37Q 171 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
HCM BI Report - table to extract value set data (table type)Summary HCM BI Report - table to extract value set definition (table type)Content Hi, I'm creating a BI report to show Value Set Definition (Table Type) and wonder which…
-
Deriving IS Manager column in OTBISummary Deriving IS Manager column in OTBIContent Hi ALL, I'm building OTBI Report. And I want to derive column "IS MANAGER" ( Note we are not maintaining in WorkerAssig…User_2025-02-07-19-03-14-525 53 views 4 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
How to get SalaryId information from ReportingContent Hello experts, I have noticed that in Compensation subject areas I cannot retrieve the SalaryId information. I need this information to massively correct Salary …Valerio Curzi 37 views 1 comment 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Reporting on Active User Role EmailSummary Email address for non-employee active user.Content Hi, I am developing a BIP report for Non-Employee Active User. But cannot find the table email address that wa…User_2025-02-04-07-19-57-588 51 views 4 comments 1 point Most recent by User_2025-02-04-07-19-57-588 Reporting and Analytics for HCM
-
Pay Period Start & End Date IN BI ReportSummary Pay Period Start & End Date IN BI ReportContent Hi ALL, Can someone help me, I'm looking for Pay Period Start and END Date. Which table do i need to refer to get…User_2025-02-07-19-03-14-525 38 views 4 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Employee, Manager, Department Head ( Director & up ) and Division Head ( VP & up) in a report.Summary Employee, Manager, Department Head ( Director & up ) and Division Head ( VP & up) in a report.Content HI, I'm planning to build a BI Report having Employee, Mana…User_2025-02-07-19-03-14-525 51 views 9 comments 0 points Most recent by Mishra Ankit Reporting and Analytics for HCM
-
Employees Hired in the Last 7 DaysContent Hi Guys, I'm trying to generate a report to show employees who were hired in the last 7 days. I've created a Data model and basically inserted this statement int…Ivy__Valverde 155 views 12 comments 2 points Most recent by Christian_Kaladjian-Oracle Reporting and Analytics for HCM -
Defaulting LOV parameter value from sysdateSummary Defaulting LOV parameter value from sysdateContent Hi All, How to default Menu Parameter, from sysdate. Say, we need to get Month and year in the format of 'Mon-…User_2025-02-05-08-33-37-492 32 views 4 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for SCM
-
Need Sample Query on Head Count BIP ReportSummary Need Sample Query on Head Count BIP ReportContent Hi All, I am trying to build a Headcount Summary Report in BIP to achieve the below results, Head Count Summary…
-
Row limits in OTBI ReportSummary Row limits in OTBI ReportContent Hi ALL, I have created OTBI Report based on Logical SQL. When I run it for one of the employee I see his data being populated wh…User_2025-02-07-19-03-14-525 113 views 9 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Fetching resignation reason and separation/resignation type in sqlSummary Fetching resignation reason and separation/resignation type in sqlContent Hi all, How to fetch resignation reason and separation/resignation type(ie.resignation …User_2025-01-29-01-27-20-754 674 views 12 comments 0 points Most recent by User_OWH0W Reporting and Analytics for HCM
-
SCM Report queriesSummary I would like to know where i can find a repository of report queries for this subject area.Content I would like to know where i can find this information for Pro…User_2025-01-25-06-03-46-894 97 views 4 comments 3 points Most recent by User_2025-01-25-06-03-46-894 Reporting and Analytics for SCM
-
Connecting Worker Assignment and Comp Salary work areasSummary Connecting Worker Assignment and Comp Salary work areasContent Hi ALL, I'm need fields from "Workforce Management - Worker Assignment Event Real Time" ."Assignme…User_2025-02-07-19-03-14-525 23 views 7 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM