SQL
Discussion List
-
Is there usage and adoption reports for HCM?Summary: Is there usage and adoption reports for HCM? I see the adoption reports for CRM, but none for HCM. We need some info for a business case we are presenting to pu…TerryM01 96 views 7 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get shift name start time, end time for certain date, from the work schedule caledarSummary: In oracle Fusion, We need a query to identify the shift name , shift start time and shift end time as the following parameters shall be passed Emp number Date C…MHanif 21 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
How to get shift name start time, end time for certain date after manually change the workSummary: I need to retrieve the shift name, start time, and end time for a specific date after manually updating the work schedule calendar. How can I get these updated …Sanduni Pathirathne 9 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Query to fetch data entered by employee in an ICP requestI am looking to build a query on the ICP request raised by an employee. This should include submitted and approved transactions. However, there are certain fields for wh…SHRUTI PRIYA 7 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to Query Reported Time for Specific Payroll Time Types Based on Time CategorySummary: I'm trying to query reported time entries for specific Payroll Time Types that belong to a particular Time Category — in my case, the category is called "**** T…Raghavendra M 13 views 1 comment 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Query to get the scheduled work hours of employee from shifts the employee has assignedContent I have a requirement to report the weekly work hours the employee is scheduled for. Employee will be assigned work schedule and work schedule will be liked with …Raghavendra M 4.8K views 8 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM
-
Need Help Identifying Tables for Custom Oracle Audit Report with Product, Business Object TypeSummary: Hello Oracle Community, I'm trying to build a custom audit report similar to Oracle's standard audit output with the following columns: User Product Event Type …Vishal Purohit 18 views 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
SQL Query - Pending Benefit Transactions that would prevent Employee TerminationHello, Hope you are well. Does anyone have a SQL query available, that displays any Active/In-Flight/Pending Benefit Transactions which would cause the Termination of an…David Oldfield 10 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Report Date Parameters needed START: (First_Day of Last month) END: (Last_Day of Last_month)Summary: Hi Forum: I'm looking to use below to accomplish General tab for Scheduling a report START: Last_Day(ADD_MONTHS(SYSDATE,-2))+1 First_day END: Last_Day(ADD_MONTH… -
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…Rajdeep Chavda 73 views 6 comments 0 points Most recent by Om Shukla-Oracle Reporting and Analytics for HCM
-
Comment Column is splitting into multiple rows in Excel outputComment Column is splitting into multiple rows in Excel output for online BI template.
-
APISummary: Hi Expert, How to get the ( additionalInformationDetailsUniqID)? I have only URL and Offer ID how shall i get the additionalInformationDetailsUniqID? /hcmRestAp…
-
From which table can I check the scheduled report job?Hi, Which hcm table can I query to view the history of my scheduled report? I want to get the last run date of the report job from this table. I will be grateful if you …Cansel Karasoy 866 views 16 comments 0 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
Dynamic Date Prompts and SQL Setup for OTBI Workforce ReportSummary: Assistance needed with creating a dynamic OTBI report that allows users to enter date ranges for Assignment Details Effective Start Date and Assignment Details …ReiV 23 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Report for compensation budgetSummary: I need to develop a report with compensation budget aggregated by country. Content: In a BI report (I can't use OTBI) I need to show the following data: Country…Gian Luca Triglia 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL Query for Calculation Cards > Benefits and Pensions for Employees with Multiple AssignmentsHi Navigation: Calculation Cards > Benefits and Pensions I need help to find out how to join the Pension scheme back to the Assignment number/id for a BIP report. If not…Nilesh D Patel 19 views 0 comments 0 points Started by Nilesh D Patel Reporting and Analytics for HCM
-
Information on scheduled processesSummary: How to get information what schedule process are scheduled through BI Report. With specific fields Content (please ensure you mask any confidential information)…
-
HCM Table for Transaction Audit Trail DataHello, how are you? I would like to know in which HCM table the audit trail from Diagnostic Log data of a transaction can be found. I tried the HRC_TXN_HEADER table, but…LeonardoNogueira 17 views 2 comments 0 points Most recent by LeonardoNogueira Reporting and Analytics for HCM
-
HCM iby_ext_bank_accounts_SELECT * FROM fusion.iby_ext_bank_accounts_ WHERE audit_action_type_ = 'DELETE' this is not giving me deleted records in the report. audit is enabled. insert is showing …
-
Is it possible for rich text format stored in a Data Field to display as Plain text in a report?Summary: Hello team, Is it possible for rich text format stored in a Data Field to display as Plain text in a report? This is the application data rich text format. My Q…challa praveen 34 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
SUM in Table ValuesetTeam, We need to use SUM in table valuset. If you have any idea then, please share. It would be helpful. SELECT SUM(peevf.screen_entry_value) FROM pay_element_entries_f …
-
Excel output from RTF template is having one blank line in the topContent Hi All, I am using the RTF template to get the output in Excel format. I have used the page break to get the output in different sheets in excel. When the output… -
Oracle HCM Inquiry Personal Payment Method and Bank AccountHi Oracle SME's, Here is our inquiry, since moving to redwood we noticed that the bank account and personal payment method has been separated. We just need a query to he…
-
Fusion table for Employee Vacation and Delegation rulesWe want to develop a custom BI Report for Employee Vacation and Delegation rules. However, we are currently facing some challenges in identifying the correct tables that…Srikanth Nakka 26 views 1 comment 0 points Most recent by Srikanth Nakka Reporting and Analytics for HCM
-
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
Looking for Questionnaire Question / Check-In Questionnaire manager and worker response textI’m currently working on building an OTBI report to extract “Questionnaire Question” responses from the Workforce Performance – Performance Rating Real Time subject area…
-
Is it possible for BI Publisher to read from external Excel file?Summary: Content (please ensure you mask any confidential information): We'd like to integrate Oracle data with an external Excel file stored in a shared location. Such …Stefano_Mazzocca 29 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
To optimize Run Deduction Report, converted to BIP report.Facing issue displaying Ded and Arrear colSummary: Payroll Run Deduction Report which Prior to 24A run times averaged about 30-minutes. Following 24A, run times increased to approximately 90-minutes. Proposed a …Bindu Janoti-Oracle 60 views 4 comments 0 points Most recent by MJ Surel Reporting and Analytics for HCM -
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…Manoharan 8.7K views 10 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Is there a table that store calculated time in time cardHello, I would like to ask whether this information is stored directly in a specific table or if it is derived through a calculation. Kindly advise. I've seen this view …