SQL
Discussion List
-
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 214 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 493 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…
-
BI Report: Need help with Dependent parameter LOVSummary BI Report: Need help with Dependent parameter LOVContent Hi, I have a BI Report where there are 2 parameters: 1) Review Period: 2) Period_Month_Or_Week 1) Review…User_MC37Q 58 views 15 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Issue in "Workforce Performance - Performance Rating Real Time" Post Rel 13Summary Post Release 13 IssueContent Hi All, Attaching a report for performance tracking created on the "Workforce Performance - Performance Rating Real Time"(subject ar…User_2025-01-30-00-14-06-021 79 views 6 comments 0 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM
-
Can I use one dashboard prompt parameter value as input in the SQL results query(choice list) of anoSummary OTBI : Can I use one dashboard prompt parameter value as input in the SQL results query(choice list) of another dashboard prompt parameterContent Hi, Please find…User_MC37Q 82 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Reports: Condition Region around tables are not working in RTFSummary BI Reports: Condition Region around tables are not working in RTFContent Hi, To explain in detail: We have a data model which has a parent and a child group. G_G…User_MC37Q 32 views 2 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Dependent Parameter in BI Data Model does not work as expected.Summary Dependent Parameter in BI Data Model does not work as expected.Content Hi, Dependent Parameter in BI Data Model does not work as expected. The 2nd parameter's va…
-
Compare 2 columns in OTBI report & apply conditional formatting ( (Colors) on one of themSummary Compare 2 columns in OTBI report & apply conditional formatting ( (Colors) on one of themContent Hi, I'm new to OTBI. I have a requirement to display the Column …Aloka Bhattacharya 426 views 13 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Need info on inventory adjustment for all material transactionsSummary Need info on inventory adjustment for all material transactionsContent Hi Experts, I am looking for any BI or OTBI reports to get inventory adjustment for all ma…
-
Schedule Report JobSummary Adding Output destination typeContent I need to add a destination type like FTP and Web folder. Can someone let me know how to add values for it ? Also I need kn…User_2025-01-28-21-18-43-496 75 views 2 comments 0 points Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for HCM
-
Returning the most recent dateSummary Want to return only the most recent dateContent I have an analysis that I am doing in BI and trying to return just one record per person, with the date as the fi…Deb Luisi 92 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need help in excel templateSummary Need help in excel templateContent Hi All, I'm facing issue when I try to paste the xsl code into a cell in the excel template. Let me brief about my requirement…User_DZMJW 50 views 2 comments 0 points Most recent by User_2025-01-28-07-12-45-467 Reporting and Analytics for HCM
-
how to fetch previous and current value for global transfer action?Content Hi, we are not able to find solution to action 'global transfer' (when changing Legal entity) to see in one report the old and new value- related to the fact new…Gal Shani 121 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need to find out the Payroll Batch Loader Element Entry input value tablesSummary Need to find out the Payroll Batch Loader Element Entry input value tablesContent Hi All, I have a requirement to generate an error report for payroll batch load…Sricharan Monigari 126 views 6 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Cloudera 6 released - when will we have it on BDCS/BDCC & BDASummary Quick update on Cloudera 6 on BDCS and BDA as well as BDCCContent With the release of C6 on August 30th, we are now working towards releasing this on the Oracle … -
OTBI Security Risk - Seeded Reports Without User Security & OTBI Access for EmployeesSummary OTBI Security Risk - Seeded Reports Without User Security & OTBI Access for EmployeesContent Hi All, We have recently discovered that seeded Oracle reports do no…User_2025-01-29-23-59-58-976 158 views 12 comments 1 point Most recent by User_2025-01-29-23-59-58-976 Reporting and Analytics for HCM
-
Displaying images in BI Publisher RTF TemplatesSummary Displaying images in BI Publisher RTF TemplatesContent Hi, I'm fetching employee images from PER_IMAGES to display in the report. I have provided size restrictio…Aloka Bhattacharya 64 views 4 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM
-
How to: Automating Data Ingest to Zeppeling NotebooksSummary Leverage data pipelines and big data manager to automate ingest to analyticsContent In this 20-minute tutorial, you learn how to create and run a new Oracle Big …
-
Reports not running since R13 18A appliedContent We upgraded to R13 and all Reports were running as expected, with no problems. Maintenance Pack 18A was then applied, and some reports are now experiencing issue…Rebecca Smith-27468 34 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Push Weekly Email Notifications to a particular group of Line Managers and EmployeesSummary Push Weekly Email Notifications to a particular group of Line Managers and EmployeesContent Hi Friends I need to send couple of weekly notifications to a group o…Mansur Khalil 51 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
EText Template: Count of rows not resetting at each LevelSummary Count the number of rows generated for each EmployeeContent Hi, We are trying to get a count of the rows generated for each Employee, but the count keeps increas…Brendon Charles-24581 227 views 3 comments 1 point Most recent by Brendon Charles-24581 Reporting and Analytics for HCM