SQL
Discussion List
-
SQL query to find the Users that has role provisioned by an role mappingI'm trying to create a query that return the MAPPING_NAME from the PER_ROLE_MAPPINGS table and the USER_ID from the PER_USER_ROLES table to know which USER_ID is associa…Letícia Costa-Oracle 464 views 0 comments 0 points Started by Letícia Costa-Oracle Reporting and Analytics for HCM -
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 10 views 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 27 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 20 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 77 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 36 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 530 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 15 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 8 views 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 1K views 6 comments 0 points Most recent by Karen Wilson Reporting and Analytics for HCM -
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 582 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…
-
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 698 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 215 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 18 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 840 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 956 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 15 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 16 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to extarct DDL of table in oracle fusion HCM/FSCMHi, We need to extarct DDL for few tables like column name, data type, size, primary key , foreign key constraints . We tried sql query approach but due to data type siz…hiteshsaroha 50 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM