SQL
Discussion List
-
Looking for a Workflow transactional Report where Self Approval is enabled.Hi Team, I'm Looking for a Workflow transactional Report where Self Approval is enabled. Either the report should let me know about on which workflow rule self approval … -
BI Publisher reports now timing out (previously working)Summary: I have two BIP reports that were created several years ago that are now timing out. They began failing around the beginning of September 2023. Content (required…
-
Extract description of lookup in OTBISummary: Content (required): Hi everyone, we are having problems extracting the value of a dff configured for the JOB. Is it possible to extract the description of the r…Gerardo Peluso 1 view 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Can anyone help adding position No and Name to my SQL Query?Summary: I need to add the Position number and position name to the SQL Query Content (required): Hi everyone, Could anyone help me to add the position number and positi…Isabela Radivoi 122 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
What HCM table can I use to get the future Line Manager?Summary: I'm checking if I can use the BIP Bursting feature to send details which includes tasks to the worker's future LM once the transfer is approved. The client want…
-
Oracle BI Tables for compensation plan columnsSummary: Content (required): Hello experts, do you know which Oracle HCM BI Tables store compensation plan user-defined columns (custom numeric and text column); Compone…Valerio Curzi 33 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to pull correct Learning Assignment Status valuesSummary: Cannot determine the logic to pull the correct Status value that is displayed in Status column of Learning Assignment Page. The Table has two Status fields and …Vanessa Gepitulan 316 views 6 comments 0 points Most recent by Vanessa Gepitulan Reporting and Analytics for HCM
-
Extract the ID of a department (going active on 01 october) from FusionHello, In Fusion we have created a department that will become active on the 1st of October. For our integration with Taleo I need the Department ID of this department a…
-
Query Slower after patch Favoring Full Table Scan (FTS) instead of Index ScanSummary: A report built to get the timecard details (OTL query) is suddenly running for a very long time after the recent patch was applied. It does full table scan rath…Nisha_Hegde 24 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Table name where department set is storedSummary: Table name where department set is stored Content (required): Was looking to build a query based on Department set, which table department set is stored. Versio…Bhavna-Civeo 1.6K views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Is changing PER_ABS_PLAN_ENTRY_ID normal behaviour?Summary: We have absences that are submitted for a person, and when one of the absences is withdrawn, the PER_ABS_PLAN_ENTRY_ID field for the other absences that the per… -
How to query email of a user account which is not linked to any person record?How to query email of a user account which is not linked to any person record? In this case person id can be null in per_users table and we can't join it with per_email_…Ankit_Bhadja 1K views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Oracle functions to calculate third quartileSummary: Content (required): Hello experts, we need to calculate THIRD QUARTILE for a set of employee salary amounts. The calculation should work in this way: For employ…Valerio Curzi 155 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to get Projected End Date?Summary: How to get Projected End Date? Content (required): Hello, we wrote the follow piece of SQL select pc.* --to_char(PC.CONTRACT_END_DATE,'MM-DD-YYYY') from PER_ALL…Nicola Petri 381 views 10 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Assignment Changes including Effective SequenceSummary: Hi - I have a logical SQL built that is looking for changes in a DFF field that do not take place on a Sunday. It is supposed to capture the changes between row…
-
Is it possible to build custom reports retrieving data in more active workforce plans?Summary: Content (required): Hello experts, we need to build custom reports retrieving compensation components values and making analysis based on data loaded in several…Valerio Curzi 11 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
HCM Extract completing with Alerts with no output generated when using aggregate conditionSummary: Hi Team, We have a requirement to get the sum of the attribute conditionally in HCM extract by using it as a summary element. When I am trying to make use of th… -
Mid Year Check In ReportSummary: Hi All, We have a requirement to fetch both the employee's & manager's responses to the questions for the 2022 Mid-Year Check In. Looking for a report which cov…Peeyush Chandel 41 views 4 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
Assignment EFF Rest APII am trying to query from postman with the relevant platform_id information using Assignment eff rest api,(/hcmRestApi/resources/11.13.18.05/emps/{empsUniqID}/child/assi…Cansel Karasoy 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
calculate the past experience in HCM BI ReportSummary: calculate the past experience in HCM BI Report Content (required): My client requirement is to calculate the past experience and current organization experience…
-
"Selected Performance Goals Report" does not display the correct goal plan end dateSummary: I believe there may be a bug with this report, where the SQL is selecting the wrong Goal Plan End Date. While the OTBI subject areas (i.e. Workforce Goals - Goa… -
ORA-01830: date format picture ends before converting entire input stringSummary: Getting above error while running query with date parameter instead of parameter if i give sysdate it is working fine Content (required): Version (include the v…Narendar Rao Naineni 589 views 2 comments 0 points Most recent by Narendar Rao Naineni Reporting and Analytics for HCM
-
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…Rohan Fernandes 21 views 8 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM
-
Poor performance with CASE statement and sub-querySummary: Custom analysis with CASE statement extremely slow Content (required): Good afternoon, I have created an OTBI analysis that yields the names of line managers wh…ammiano 52 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI tables to extract Contract attributesSummary: Content (required): Hello experts, which table allows me to extract PER_CONTRACT_LEG_DDF attributes; Italy Context? We need to retrieve the highlighted fields f…Valerio Curzi 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Report to show all items in the report and analytics catalogSummary: Is there a way to pull a report to show all items in the catalog (Shared Folders & Dashboards)? Content (required): Hi, This might be a long shot but does anyon…Amar Bilkhu 891 views 11 comments 2 points Most recent by ahmed alsharief Reporting and Analytics for HCM
-
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu… -
23c has destroyed my ability to research UE and DBISummary: Content (required): Does anyone have backend SQL to research the UE and which DBI are attached to each? Version (include the version you are using, if applicabl…
-
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (Payroll-> Review Journal Entries) For An Employee Columns are: Accountin…Manoharan 51 views 1 comment 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM
-
Long Running Custom BI Report OptimizationSummary: We have created custom BI Report which is running for long almost 4.5 hours and wanted to improve the performance of the report. we have used sub query in the s…