Get Started with Redwood: Oracle Cloud SCM and Purchasing
SQL
Discussion List
-
Need to identify the tables that hold sensitive information using Oracle Cloud RecruitingSummary: I need to identify the any tables that hold sensitive information (PII). We have started using Oracle Cloud Recruiting and want to identify tables that have thi… -
IN BI report how to restrict the usersSummary: Hi Team, how to restrict the user in BIP query. suppose i want to restict one person in query how can i restrict. Thanks, Ajay Content (please ensure you mask a…AjayKumar Maddipati 21 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Can you please provide us the details of the report which provides information about all the reportsSummary: Can you please provide us the details of the report which provides information about all the reports along with permission set to that particular report Can you…Shubham Bindal 12 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BI Reporting on BPM SetupSummary BI Reporting on BPM SetupContent Hi Team, Hope everyone is doing great ! We have a requirement to create a report on BPM Approval setup . Is there a table that s…
-
Query to pull the failed transactions from transaction consoleSummary Query to pull the failed transactions from Transaction ConsoleContent Hi Experts, Good Day!! We have the requirement to pull the failed transactions from transac…Charan Kollipara 931 views 13 comments 0 points Most recent by Trupthi Reporting and Analytics for HCM
-
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …
-
Does anyone know which tables I need to use to retrieve the Bonus Amount from the Compensation ModueSummary: I have a requirement to show last years performance bonus amount in a report and I have built most of the information using SQL but I am unsure what tables I ne…User_2025-02-04-08-51-08-912 528 views 6 comments 0 points Most recent by Phils Reporting and Analytics for HCM -
HTML Markup values are not working after 23B updateSummary: Good afternoon, I am having issues while trying to save an edit of code within the sandbox > HTML Markup. When making the replacement, the system only saves par…Jorge_Trindade 62 views 8 comments 0 points Most recent by User_3MBEU Reporting and Analytics for HCM
-
Need table name to pull "payroll processing status" field from time and laborSummary Need table name to pull "payroll processing status" field from time and laborContent Hi Team, Need table name to pull "payroll processing status"(Like Processed …User_2025-02-04-07-00-18-658 81 views 3 comments 0 points Most recent by Abhishek Bhaskar Reporting and Analytics for HCM
-
Which table stores bip reports scheduled history data.Summary: Which table stores bip reports scheduled history data. Content (please ensure you mask any confidential information): Hi Team, Can some one will help me to find…
-
Standard report for Oracle journeysSummary: Standard report for journeys Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard reports delive…Oriana L. 201 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report for ESS and MSS TrasactionSummary: Need Report for ESS and MSS Trasaction Content (please ensure you mask any confidential information): Hi All We need to fetch all ESS and MSS transactions Versi…
-
Workforce Management. Changes to view without informing customers: HWM_TM_RPT_ENTRY_VSummary: Workforce Management. Changes to view without informing customers: HWM_TM_RPT_ENTRY_V Content (please ensure you mask any confidential information): Hi Oracle C…
-
Home or Work email address depending on termination statusSummary: Hi I'm building an analysis which contains both current employees and employees who have left within the last 60 days (established using a filter on termination… -
Report for onboarding buddySummary: In which table can I find the oboarding buddy? I need a query to extract it in a report BI. Version (include the version you are using, if applicable): 24AGian Luca Triglia 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Is there any table that stores the transaction of the Transfer Direct Reports transaction?Summary: Which table stores the transaction or transaction history of the Transfer Direct Reports transaction in Fusion? Need to pull the one who initiated or do the Tra…James Leborn 1 view 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
Oracle BI tables to retrieve individual compensation plan nameSummary: Content (please ensure you mask any confidential information): Hello experts, we are building custom report. Do you know the BI table to retrieve Individual Com…Valerio Curzi 4 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Is it possible to track who changed user roles and when it happened in Security Console?Summary: Content (required): Hello experts, is there a way by OTBI or SQL to retrieve who changed user roles in security console and when it occured? Thanks in advance f…Valerio Curzi 690 views 6 comments 0 points Most recent by Pavan Kumar Thummalapalli Reporting and Analytics for HCM
-
Table for Additional Statuses (Timecard)We have a requirement to get Earned Date, Value, Unit of Measure, Payroll Time Type , Absence Type , Payroll Transfer Status & Payroll Processing Status. We are trying t…Manoharan 48 views 2 comments 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM
-
Transpose rows to columns in OTBISummary I need to build a report that shows every employee as a column. Convert all rows to Columns in OTBIContent Hi I hope you can help me. I need to build a report th…
-
How to remove Blank Rows in a report?Summary: Once we export the report there are a few Blank rows at the bottom, is there a way to remove them? Content (please ensure you mask any confidential information)…THawkins_LGI 74 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Elements - balance feed "as of" date promptSummary: We are using SQL data model to report on various balance feed items for elements. We have hundreds of elements and need to be able to compare configuration as o…Michelle Hughes 11 views 3 comments 0 points Most recent by Michelle Hughes Reporting and Analytics for HCM
-
Reporting Prior Month Data SQLSummary: Can we add SQL to the formula to look at the Prior Month data? So tell it to look at the System date - 1(for prior month) and pull 1st to last date of that prio…THawkins_LGI 42 views 12 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Business Unit Hierarchy looking for Parent Business Unit NameSummary: I would like to know what table Parent Business Unit Name is in for a BI publisher SQL Content (please ensure you mask any confidential information): Version (i…
-
What table is storing Change working hoursHi Team, Which table is storing change working hours information? Any sample will be helpful.
-
Termination category field causes blank rows for OTBISummary: Termination category field causes blank rows for OTBI Content (please ensure you mask any confidential information): Hello experts, we are building a custom OTB…Oriana L. 12 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM
-
Report to show when a spouse works for the same companySummary Benefits for spouses that work for the same companyContent Hi All, I am hoping someone can help me out. We have a request to generate a report that shows when th…User_2025-02-04-08-51-08-912 59 views 10 comments 0 points Most recent by MarleneRay Reporting and Analytics for HCM
-
I need query to get expense approver nameDoes any one have query to get expense approver nameSwati U 195 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for HCM
-
Subject area/database table for historical manager hierarchySubject area/database table for historical manager hierarchy Client is interested in building dashboards to show different HR metrics for which historical manager hierar…
-
Data Model throws a nullpointer exception while trying to retrieve dataSummary: I have created a data model with 2 data sets (one for employees and one for Contingent workers) - I have created an Excel Template that has 2 tabs for the data …User_2025-02-04-08-51-08-912 253 views 3 comments 0 points Most recent by John Peter Noble-Oracle Reporting and Analytics for HCM