SQL
Discussion List
-
Seeking Performance Management tables for specific data fieldsSummary Seeking Performance Management tables for specific data fieldsContent Hi. My team is building a Performance Management BIP report and is seeking to include the f… -
Query taking more time to split,compare using regexp_substr() functionSummary Query taking more time to split,compare using regexp_substr() functionContent Hi , i have a report to get goal approvers names w.r.t. goal if pending with approv… -
Can you add a prompt to an analysis that uses a left outer join (or any join)?Content I have created an analysis that pulls in data from the "Workforce Succession Management - Talent Pools Real Time" subject area and the "Workforce Profiles - Pers…Duane Gay-Oracle 81 views 5 comments 1 point Most recent by Sandra Barr Reporting and Analytics for HCM -
"Approval Delegate to others" table nameSummary "Approval Delegate to others" table nameContent Hi All, i have an requirement to get report of all the "Approval delegate to others" in oracle fusion .i am unabl…nitin Sharma 69 views 2 comments 0 points Most recent by nitin Sharma Reporting and Analytics for HCM -
Report for fields using in systemSummary Report for fields using in systemContent Hi Everyone , Do we have any standard report or SQL query ,which will identify all the fields in table which is linked w…nitin Sharma 41 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
URL to LSQL Analysis with ParameterSummary How to prompt on LSQL column so that assignment_id can be passed in URL?Content Hi guys, We have a Logical SQL analysis which we'd like to embed on the app scree…Pavel Kartuz 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need to display current year as default value of a date parameter in BI publisher data modelSummary Need to display current year as default value of a date parameter in BI publisher data modelContent Hi, We need to display current year as default value of a dat…User_MC37Q 924 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Count the number of employees per FTESummary Report which present the number of the employees per FTEContent Hi, We tried to create an analysis that count the number of the employees per FTE (Full-Time Equi…Yaniv 123 views 6 comments 2 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
BIP report generating JAVA exception "java.lang.NullPointerException"Summary BIP report running into errorContent I am trying to run a BIP report but its generating an error.On running the data model for over 200 rows it generates the fol…User_2025-01-31-02-27-22-166 99 views 1 comment 0 points Most recent by Thiru Ch Reporting and Analytics for HCM -
14Have Impala configured by defaultDescription When creating a cluster on BDCS, BDCC or BDA also enable a solid Impala configurationUse Case and Business Need Today, Impala is not configured out of the bo…Jean-Pierre Dijcks 11 views 1 comment 14 points Most recent by Alexey Filanovskiy-Oracle Idea Lab – Big Data -
Absences ReportSummary get the working dates between start_date and end_dateContent we have requiremnet to generate absences report, need help on sql query, If any empployee having abs… -
Link BIP Report to InfoletSummary Can we Link BIP Report to InfoletContent Hi All, Can we Create BIpublisher Report and link to Infolet, and how we can give access to particular user these infole…
-
Table to get employee title informationContent Hi For the purpose of developing a SQL report required to know the correct table. I have referred tables and views document but could not able to find it. Can so…User_2025-01-28-21-18-43-496 35 views 3 comments 0 points Most recent by User_2025-02-01-08-03-07-149 Reporting and Analytics for HCM
-
Sql query is not workinkgContent Hi, trying to excute the following sql via BI publisher per support document: Doc ID 2187087.1 Select * from per_assignment_supervisors_f sup, per_all_people_f p…Gal Shani 69 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to create a report to pick address fields which have invalid charactersSummary How to create a report to pick address fields which have invalid charactersContent Hi I am working on a requirement to create a report which would pick invalid c…User_2025-01-30-21-52-52-008 41 views 9 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Max Coverage Date for Enrollment Results in OTBISummary Looking for the max coverage date by employee and benefit plan/optionContent Hello, I want to report the details of an employee's current enrollment (as of today…Susan Anderson 51 views 2 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsSummary Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsContent Hi, We need information about how to capture the evalua…User_MC37Q 355 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
how to get seniority date of a person from Oracle Fusion HCM tablesSummary how to get seniority date of a person from Oracle Fusion HCM tablesContent Hi, We are creating a BIP report to fetch seniority date of a person onto a Terminatio…User_MC37Q 1.1K views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Turnover ReportSummary Looking for help creating a turnover reportContent Hi, We have set-up turnover reports but when I checked the data the report is not pulling the correct informat…User_2025-01-30-01-37-19-048 114 views 8 comments 0 points Most recent by User_2025-02-03-23-33-26-899 Reporting and Analytics for HCM
-
Need inputs to fetch PBL batch start time and End timeContent Hi All, Please suggest in which table holds the when the PBL process started and end dated (i.e. completion time). Ex: If we submit PBL batch, we need to know co…
-
Big Data SQL 3.2 - Cloudera CertifiedSummary Big Data SQL 3.2.1 is now officially certified with Cloudera 5.14.1Content Big Data SQL 3.2.1 is now officially Cloudera Certified (see Oracle certified products… -
Need database table name that stores the Performance Goals that are present in subject area ""WorkfoSummary Need database table name that stores the Performance Goals that are present in subject area ""Workforce Goals - Goal Status Overview Real Time" "Content Hi. Need…
-
ORA-01427; single-row subquery returns more than one row error on data modelSummary Receiving oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row.Content…User_2025-01-31-02-45-52-854 218 views 3 comments 0 points Most recent by User_2025-01-31-02-45-52-854 Reporting and Analytics for HCM
-
Personal Payment Methods Processing OrderContent HI All, In the Manage person payment method UI is having processing order as 1,2,3 and corresponding column in DB as “pay_person_pay_methods_f” and “priority”. T…Visu 332 views 11 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Active\Inactive Employees with assigned Line ManagersSummary A requirement for a BIP report to show all employees and their Line ManagersContent Hi All, I have a requirement to create a BIP report to display all Active and…User_2025-01-30-03-54-32-528 494 views 12 comments 0 points Most recent by User_2025-01-30-03-54-32-528 Reporting and Analytics for HCM
-
Identifying if an assignment change was done with a future, retro or current dateSummary Having trouble finding a way to identify if an assignment change was done with a future date or retro date after the fact.Content Hello, My team is in the proces…Mak-Moose 199 views 4 comments 0 points Most recent by User_2025-01-29-21-12-23-173 Reporting and Analytics for HCM
-
Which table stores value set details used in fast formulaContent Hello everyone, Which table stores the information about the value set which is used in fast formula. if anyone knows which tabe defines the relationship between…