SQL
Discussion List
-
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 27 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 17 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 97 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…
-
Way to hide hyperlink on Workflow Notification / BIP RTF template based on Security Role?Summary: My customer wants to have me hide a "View Attachments" hyperlink on a DoR notification (BI Pub - RTF template) based on specific AoR role. I don't see how to pi…
-
Need query to get the list of all privileges for a given roleSummary: Need query to get the list of all privileges for a given role Content (required): Navigation: Tools > SecurityConsole > Roles If I query a role name, I am getti…Jaeyshree Kumaran Kalpana 5.1K views 17 comments 2 points Most recent by Nathan CCC 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 …
-
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… -
unable to query the rejected transaction details from the approval related tablesContent Hi All, We have a requirement to report on the approval transactions (approved/rejected) and we have built the query based on hrc_txn_fnd_bpm_task_vl and hcm_fus…Sricharan Monigari 372 views 5 comments 2 points Most recent by User_DTPT3 Reporting and Analytics for HCM -
SQL query or Table for Actions under Transaction Design studio in oracle fusion HCM my client groupSummary: Hi @everyone We need your help to get below requirement: in case we do personalization through transaction design studio, we can unhide a section in the page wh…
-
WLF_ASSIGNMENT_TASKS_F does not have Latest InfoSummary: Content (please ensure you mask any confidential information): Hello experts, We are using WLF_ASSIGNMENT_TASKS_F to fetch the data from the learn tables. Unfor…
-
SQL query or Table for Actions under Transaction Design studio in oracle fusion HCM my client groupSummary: Hi Team, We need a table name or SQL query where the information of Actions under Transaction Design studio in oracle fusion HCM my client group. Content (pleas…
-
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.1K views 8 comments 0 points Most recent by mujahid Reporting and Analytics for HCM -
How to use Choose and when condition in fusion hcm bip rtf templateSummary How to use Choose and when condition in fusion hcm bip rtf templateContent Hi Team, We have created BIP Report to send notifications based on legal employer wise…User_2025-02-01-06-07-07-886 77 views 8 comments 0 points Most recent by Neha Aishwarya Reporting and Analytics for HCM
-
How to check the which stage of TLSS workflow transaction got flagged incomplete?Hi Team, Could you please confirm Is it feasible to add a column to identify in which stage of TLSS workflow transaction got flagged as incomplete, for example while doi…
-
BIP reportsSummary Apply data restrictions on BIP reportsContent Hi , Is it possible to place restrictions on a BIP report output based on Role ? eg: I have a BIP report to display…User_2025-01-30-00-14-06-021 97 views 12 comments 0 points Most recent by llnl_jtw Reporting and Analytics for HCM
-
List of Approvers in Workflow NotifcationSummary: List of Approvers in Workflow Notification Content (required): Hi , I need a list of Approvers who are going to approve the transaction in below format. I have …NitinSharma28 6 views 1 comment 1 point Most recent by Akshitha Vyas Reporting and Analytics for HCM
-
SQL/OTBI query to get the Organization Payment Method and Payment sourcesSummary: SQL/OTBI query to get the Organization Payment Method and Payment sources Content (please ensure you mask any confidential information): We are looking a report…
-
Payroll Report HelpI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…
-
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 325 views 13 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
SQL query that brings the fields to HDL for CostCenter?Summary: Content (please ensure you mask any confidential information): Does anyone have a SQL query that brings the fields to HDL for CostCenter ? Simple with the minim… -
SQL Query based on date input value errorSummary: SQL Query based on date input value error Content (please ensure you mask any confidential information): We are trying to run the below query to be used in a va…
-
Transaction console approvals reportThe user is asking for a BI report that shows all the approvals for a transaction in HCM, right now I'm able to find the current and historical approvals but I can't fin…RODOLFO GARCIA SOTELO 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-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 8 comments 12 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM -
Query to get Goal Approval StatusHello, For our report, we already have performance goals being listed in each row for every person. For each goals, we would require their approval status. However, when…