SQL
Discussion List
-
How can some Audit details be reported in Oracle Cloud HCM?Hi, I need some application security details that the client requires. For Example; User Login and logout Roles assigned to the user and their changes Password change in…Cansel Karasoy 4 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM -
Need Table name to pull Time Entry Layout Component in Time and LaborSummary: Need Table name to pull Time Entry Layout Component in Time and Labor Content (please ensure you mask any confidential information): Hi, Need Table name to pull…Sujeeth Chinta 18 views 4 comments 1 point Most recent by Prasenjit-Oracle Reporting and Analytics for HCM -
Is it possible to access the audit logs of selects placed on certain tables via Oracle cloud?Hi, I need the logs of some tables that are important for confidentiality. Is there a table on BI Publisher that contains the details of who ran it and when it was run i…Cansel Karasoy 17 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Manager information regarding the last active assignment of inactive employeesHello, In Oracle HCM system, the manager information of the employees who left the job is emptied, therefore the managers of the inactive employees are empty in my repor…Cansel Karasoy 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Tables for Archive Transaction detailsSummary Need tables for extracting details from transaction consoleContent Hi Team, There's a report requirement to extract previous years transaction details from trans…User_2025-02-04-13-27-19-123 535 views 3 comments 0 points Most recent by Ankit 10 Reporting and Analytics for HCM -
Employee Length of service (LOS) sql query based on Hire Date/Rehire Date in fusion hcmHello Team, I need a sample Employee Length of Service (LOS) SQL query based on hire date/rehire date in Fusion HCM to use outbound integration for one of my customers. …Janardhana K 27 views 1 comment 0 points Most recent by Janardhana K Reporting and Analytics for HCM -
Absence Balance MismatchHi All, Several employees have a balance discrepancy between the plan level and the accrual level. Is there a query available to retrieve this information and identify t…Saurav R-Oracle 1 view 0 comments 0 points Started by Saurav R-Oracle Reporting and Analytics for HCM
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 HCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Devel…Rashmi M-Oracle 15.3K views 19 comments 12 points Most recent by Tobias I. Reporting and Analytics for HCM
-
Rolling Average Wage ReportHi Does anyone have a sql query or a report that provides the average weekly wage over a 52-week period based on a specific date? We are trying to provide our Workers Co… -
What table stores the extended lookup code name for Visas and Permits?Summary: I am trying to build a DM for Visa and Permit notifications. What table stores the extended lookup code name for visas and permits? I would assume there is a ta…Luke.Findex 16 views 5 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
How to get the Job offer Approval history in a BIP report?Summary: Hello, We have a requirement to fetch the approvers, their approval comments and the date of approval in a report. How do we get this via BIP report? Version (i…Shreya Datir 32 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Is there a way to find all data-models that use Bursting?Summary: We are planning a change in Sender Address in our ERP Instance and one of the requirements is to also amend it for all the Bursting reports configured in the sy…Prateek Mohan 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Transaction Console Job Requisition approval chain reportSummary: The user can't access the transaction console and through administrative tasks in BPM, they can see only their job requisition. We need a report to see the appr…
-
How to fetch email ID of an user in oracle fusionSummary: How to fetch email ID of an user in oracle fusion Content (required): How to fetch email ID of an user in oracle fusion. I have the value of username and need t…Neelesh Varma 4.4K views 14 comments 0 points Most recent by Koda V V Satya Sai Surya Ramakrishna Reporting and Analytics for HCM
-
Standard PL/SQL API Caching ErrorWe use SOA to expose a PL/SQL procedure as a REST API and post requests to it. This procedure utilizes standard PL/SQL APIs to create and update Person and Assignment re…Salma Mohamed Salem 1 view 0 comments 0 points Started by Salma Mohamed Salem Reporting and Analytics for HCM
-
Query to get Vacation Rules informationSummary: Query to get Vacation Rules information Hi, We need to create a report for vacation rules for all employees in the system and I know that there is a seeded repo…Kiran345 344 views 14 comments 0 points Most recent by Deepak Kumar Dev-Oracle Fusion Applications Administration
-
Send automatic birthday wishes to employees via mail from organization.Summary: Send automatic birthday wishes to employees via mail from organization. Content (required): Hello All, I have a requirement, need to send automatic birthday wis…
-
How to fetch Cost Center Details which are mapped at Department LevelContent Hi Team, In our organisation we mapped Cost Center at Department level. How to fetch those cost center details. If anyone have SQL query please help me. I tried …User_2025-02-05-04-17-04-394 6.2K views 13 comments 0 points Most recent by Boying Reporting and Analytics for HCM
-
Alert Composer: Message text stored in which tableSummary: I want to get the message text of an alert composer. where it will be stored, Only message body was able to found-. which is in HTML format. most of the alerts …Merwin 2 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
OTBI Logical SQL complex query assembler - NOW 10 subject AreasSummary Now updated - Combine analyses from up to 10 different subject areas (V4) Content It was already posted on OBIEE forum, but I figured HCM would be a demanding th…Maxime Pignot-Oracle 1.3K views 9 comments 12 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM -
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 2.3K views 16 comments 1 point Most recent by Martin Smid-Oracle Reporting and Analytics for HCM
-
Date parameter is throwing an errorSummary: A date value is stored in the screen_entry_value field. I created two date parameters (p_week_start, p_week_end). I am trying to use the screen_entry_value in m…Consultant Ian 21 views 7 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
How to get the the latest balance from HCM ExtractHi, I have created a balance group HCM extract to retrieve the custom balance value. I have selected the UE - PAY_INTERFACE_PAYROLL_REL_UE and selected the process type …
-
Current approval status table name for development goalsUnable to get approval status for development goal: Need a table name and SQL query for development goa approval status to check whether the goal is approved? rejected o…
-
SQL to get number of Grades in a Grade laddersSummary: I need SQL to get number of grades contains in all the grade ladders that organization is having. If anyone having it please share Content (please ensure you ma…Smitashree Pradhan 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Enterable Calculation Values on Calculation Cards - Query/ReportSummary: Enterable Calculation Values on Calculation Cards - Query/Report Content (required): Hi Team, Greetings! Does anyone have the report or query to extract the dat…Parag Hiremath 91 views 5 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Need help SQL to pull Previous work schedules and present Work schedules of employeesSummary: I am currently working on a project that requires retrieving both the previous and current work schedules for employees from our database. I would appreciate yo…
-
Need Sample SQL Data Model for EFF for defaulting data using Sales order Header IDSummary: Business requirement to default the Demand Class value in EFF. need to know how to default that value which is applied on Line level and will be defaulted in EF… -
make etext template Tab delimitedSummary I need to make a report tab delimited, however I cannot seem to accomplish with etext template.Content I found this, but can't seem to apply it. I guess I am not…
-
Email Address FormulaHi Everyone, I am building a report for one of our HR partners. She is using the report as a file loader to put employee data in an external employee recognition platfor…