SQL
Discussion List
-
Is it possible for Oracle Tables for all HCM transactions including archived transactionsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Get firstname lastname of user without person recordSummary: Requirement to get firstname, lastname of a user record which doesnt have a person record. since its ERP project, HCM part would not have been configured. PER_L…Jaeyshree K K 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Identifying the Main Legal Reporting Unit via BISummary: Identifying the Main Legal Reporting Unit via a SQL query. Content (required): Hello experts, We have multiple LRUs, and TRUs, setup for our implementation, and…
-
Need SQL query to fetch answers submitted by employee for questions configured using flex fieldSummary: Need SQL query to fetch answers submitted by employee for questions configured using configurable forms as follows. Hence i need SQL query to fetch Country of B…Kundan Kumar17 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
SQL query that returned the Leave approverSummary: Does anyone have a SQL query that return the leave approver? Content (please ensure you mask any confidential information): Version (include the version you are…Consultant Ian 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Extracting the absence durationSummary: Hi, I need to extract the absence duration of employees for a report need. I thought I could use the GET_PAY_AVAILABILITY function for this, but it didn't work.…Barış Ergün 41 views 2 comments 0 points Most recent by Omnia-Oracle Reporting and Analytics for HCM -
Date parameter is defined as date but I still get errorSummary: I have created p_date as a date parameter in my data model. p_date is defined as date data type and parameter type date. I am looking to get the days between p_…Consultant Ian 21 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to get Consolidated output using Bursting data modelSummary: Hi Team, I'm creating a custom email notification for overdue learning in the learning module. For that, I have built a SQL query with bursting. When I schedule…
-
Sample SQL Query for IBANHi, we have to develop a report with the Employee's Personal Payment method Details like IBAN and bank account info etc. Please share if any sample SQL query to capture … -
How to get ESS job schedule end date for all scheduled ESS JobsSummary: How to get ESS job schedule end date for all scheduled ESS Jobs Content (please ensure you mask any confidential information): Hi Team, Greetings! We have multi…Parag Hiremath 441 views 5 comments 0 points Most recent by Madhavi Achyuta-Oracle Reporting and Analytics for HCM -
How to increase the specific BIP report's runtime or timeout limit?The Query Time Out that has been configured within the Data Model>Properties was set to 36000. However, during running the report, I'm still getting this kind of error: … -
SQL query or Table for Manage Knowledge User Groups in HelpdeskSummary: Hi we need a table where the Manage Knowledge User Groups information stored Need a columns "user group name, reference key, department under the setup Manage K…
-
Getting "Check Reason" from person managementGood day, Is anyone familiar with the "Check Reason" field in person management? Please refer to the screenshot image below… I'm trying to fetch the values via SQL, I'm …notautomni9 11 views 1 comment 0 points Most recent by TudorV-Oracle Payroll and Global Payroll Interface (GPI) -
Manage Legal Entity HCM Information ReportSummary: Manage Legal Entity HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I seem to …Parag Hiremath 1 view 4 comments 0 points Most recent by PrashanthGanji Reporting and Analytics for HCM
-
An OTBI report that provides a historical record of all changes made to the employee's assignment.Hi, I need the details of the employee's assignment from hire to termination and I want to create a history report. For example like this, hire on '01.01.9999', promotio…Cansel Karasoy 940 views 6 comments 0 points Most recent by Karen Wilson Reporting and Analytics for HCM -
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… -
Able to view logos/images from Documents of Records in HTML output in BIPSummary: Able to view logos/images from Documents of Records in HTML output in BIP Content (please ensure you mask any confidential information): We uploaded few logos/i…
-
Time and Labor Value Set Issue after 23C on Web Clock_TCF Initialization FailedSummary: Hello, A few weeks ago, we transitioned to version 23C. After 23C I have created new layout set for new HCM group like before. The layout set is working but lin… -
History Limit in ESS_REQUEST_HISTORY Table?Is there a limit to the history stored in the ESS_REQUEST_HISTORY table? I can see transactions in the report history in the front en, but I'm unable to find related rec…
-
Need a sample query of Team Time Card page, to fetch Reported hours of Calculation Time.Summary: Query to fetch Reported Hours in Calculated time section of Approved Time cards for an individual. Content (please ensure you mask any confidential information)…Sujeeth Chinta 447 views 2 comments 0 points Most recent by Sujeeth Chinta Reporting and Analytics for HCM -
How to maintain the number format when a BIP report is exported to ExcelSummary: Maintain the number format when a BIP report is exported to Excel Content (please ensure you mask any confidential information): Hi When a BIP report is extract…
-
Changing Date format to 'DD/MON/YYYY' in SQL for BIP reportHi, Can you please suggest how to change the Date format to 'DD/MON/YYYY' in the SQL for BIP Reports. Thanks in advance.
-
Query to get Payroll costing details to match with EFT paymentsSummary: Need query to fetch the Costing of payments - Accounts, Account Type, Cost amount (Debit & Credit), Accounting date and prepayment details. It needs to be match…Priyabrata Prusty 623 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Dashboard Prompt Not Working on Logical SQL AnalysisSummary Dashboard Prompt Not Working on Logical SQL AnalysisContent Hi experts, - I have created a report using Logical SQL. Please see attached. - I created a dashboard…Raymund Jerome 201 views 18 comments 0 points Most recent by Kaustubh Deshmukh Reporting and Analytics for HCM
-
I need sql query to get employee timezone like employee working timezoneI need sql query to get employee timezone like employee working timezoneLakshmiVanarasi 11 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Is there a table which holds the certificate information within the security consoleSummary: Is there a table which holds the certificate information within the security console for users. I need to see what certificates employees have associated with t…
-
Need to pull in Seniority Date using SQL and add to an analysisSummary Adding Seniority Date to my Logical SQLContent Hi All, I hope someone is able to help me out. We currently have an Analysis that we were using to produce a repor…User_2025-02-04-08-51-08-912 798 views 3 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for HCM -
Invalid parameters requested.Summary Invalid parameters requested.Content Hi, Im getting an error "Invalid parameters requested." for one of the values in the LOV which is based on SQL query. Can yo…Damodar Peddakotla 789 views 3 comments 0 points Most recent by User_J7ULB Reporting and Analytics for HCM
-
BI table to retrieve Approval Status field in Workforce Compensation moduleSummary: Content (please ensure you mask any confidential information): Hello expert, do you know in which Compensation BI table is stored the highlighted value? Thanks …Valerio Curzi 11 views 2 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
PER_POSITION_BUDGETS is showing no data. Need Position Budget FTE for custom report.Summary: We need to add Position Budget FTE in a custom report but PER_POSITION_BUDGETS has no data. Do I need to add any role for this table to do we get this informati…Punnya Vijayan 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM