SQL
Discussion List
-
Fetch Request a Position Change Details - Table/XML/TableHi Would someone be able to point to me which table and fields circled in my attachment exist? I am looking to build a report that captures all the details submitted whe…Jose Guerra 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
We want to create a BIP report for the Approval Delegations.Oracle has a delivered report, Employee Vacation and Delegation Rules Report. We need to know the tables behind this report so we can add more fields to the report. Does… -
Using Dynamic Hyperlink in Layout Editor (.xpt template)Summary: I have a report using .xpt template / Web layout editor, there is a text Goal Center that I need to convert to a hyperlink so users can go directly to My Team >…Carlo Reyes-59977 81 views 0 comments 0 points Started by Carlo Reyes-59977 Reporting and Analytics for HCM -
Is there a way to know who changed Password and when?Summary: We would like to know if there are any tables that store information about users' passwords Content (please ensure you mask any confidential information): Hello…Giuseppe Casalino 112 views 7 comments 0 points Most recent by Giuseppe Casalino Reporting and Analytics for HCM -
How to fetch Audit reports under tools or how to schedule the audit report and get data on a dailySummary: Hi Team, I need to fetch audit data, I am able to export the data from the audit report under the tools, how to schedule this report on a daily basis or help me…nanda.patil 223 views 3 comments 1 point Most recent by Ashwin Sinha Reporting and Analytics for HCM
-
Is it possible to add a field to an OTBI analysis that uses sql to query the underlying oracle tableSummary: We have an existing OBTI Analysis that reports on candidate from ORC. We need to add that a field from the Extra Info section of the candidates profile, the Des… -
Could not find the lookup HRC_TRANSACTION_STATUSSummary Could not find the lookup HRC_TRANSACTION_STATUSContent Hi Experts, As a part of pulling the Approval Transaction Details, I have used the table HRC_TXN_DATA. Th…Charan Kollipara 118 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BIP HCM Payroll - Is there any alternative to pull the Payroll process statusBIP HCM Payroll - Is there any alternative to pull the Payroll process status apart from below Query /* ( SELECT meaning FROM hcm_lookups WHERE lookup_type = 'ORA_HWM_PA…BhaskarDondapati 331 views 10 comments 0 points Most recent by Sunil Makam Reporting and Analytics for HCM
-
BIP Parameters Not Working Correctly with SQL in Data Model and ReportHi all, I'm hoping someone can possibly take a look and help me out with an issue we're having with our BIP Data Model and SQL. We're needing to build an OTBI based repo…
-
OTBI Logical SQL complex query assembler - NOW 10 subject Areashttps://us.v-cdn.net/6034893/uploads/IRBUUHV044EZ/logical-sql-assembler-v5.xlsx Summary Now updated - Combine analyses from up to 10 different subject areas (V4) Content…Maxime Pignot-Oracle 1.6K views 14 comments 15 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM -
LOV Parameter Disabled When Using Full Item DescriptionSummary: I'm working on a BI Publisher report in Oracle Fusion where I want to use item description as a parameter. The parameter is based on a List of Values (LOV) from…
-
Table names/SQL query for Individual Compensation details in HCMSummary: Hi All, Can you please share me the Table names/SQL query for Individual Compensation details in HCM. Thanks, Janardhana Content (required): Version (include th…Janardhana Kondaveeti 6.1K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Query to retrieve employees with Termination Date nullSummary: Content (please ensure you mask any confidential information): Hello experts, please, could you share a query to retrieve employees without past and future actu…Valerio Curzi 94 views 6 comments 0 points Most recent by Ashraya S.N 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…
-
Query to find hr_assignment_id/assignment_id for which payroll has been RunSummary Find link between payroll run and assignmentContent Hello Team I need a query to find the assignment for which a payroll(quick pay/Regular payroll) has been run …AvishekNandi 1K views 13 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
Incremental file for Payroll PVO -HcmTopModelAnalyticsGlobalAM.HcmBalancesSetupAM.PayrollBalancesPVOWe are currently facing challenges with the use of this BICC Payroll PVO Offering: HcmTopModelAnalyticsGlobalAM.HcmBalancesSetupAM.PayrollBalancesPVO. It appears to gene…
-
Need to update the absence Entry before holiday and after holidaySummary: Hi Everyone , We have requirement where we have to update absence entry for employees who is in long term absence. Below is requirement:- First Step: Check for …Krishna Manmohan 11 views 1 comment 0 points Most recent by Tamilarasan Sekar Reporting and Analytics for HCM -
Query to retrieve Union fieldSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve the employee Union name as in the attached …Valerio Curzi 43 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Table to get Absence plan details in Payroll element taskSummary: Hi Team, Could you please provide us the Table or SQL query for the input values of Absence plan details, Absence Payments, Accruel Liability and Balance Paymen…Opkey PA 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
query to get variable rate program for all employeesSummary: Content (please ensure you mask any confidential information): Hi all, I currently have a query where I am trying to get the variable profile name (under manage…Steph96 161 views 3 comments 0 points Most recent by Matheus Roberto Reporting and Analytics for HCM -
How to Filter a Date Column by Another Date ColumnSummary: I have an OTBI analysis that is 3 subject areas. The goal is to show specific actions in Workforce Management - Worker Assignment Event Real Time, and then show…
-
HCM user entities to pull published schedule details for group of employeesWe are working on an integration where we need to extract published schedule details for a group of employees within a time period (past 3 months). We also need to track…
-
Need to fetch the Content ID of HCM ExtractSummary: We have requirement to fetch the Content ID of HCM Extract through BI report. Any one have idea how we can fetch Content Id. Content (please ensure you mask any…
-
Table for Time Type in TimecardWe have a requirement to fetch the time type from timecard. pay_payroll_time_type from hwm_tm_rep_m_ptt_atrbs_v is not returning any value. Could someone guide me on thi…
-
Identification of missing associations on Calculation CardsSummary: Identification of missing associations on Calculation Cards Content (required): Hello Experts, Can you please suggest if Identification of missing associations … -
Retrieve Department Hierarchy per User Assignment (with Effective Date)Summary: Hi everyone, I'm wondering if anyone has a query that returns the organizational department structure for users based on their assignment, while properly consid… -
Query to fetch overall rating from Performance documentSummary: Hi All, Can you help me in sql query to fetch overall rating from the performance document? TIA Version (include the version you are using, if applicable): Code…ShawShankk 2.7K views 5 comments 0 points Most recent by Vikas.puppala Reporting and Analytics for HCM
-
How to generate the BIP report with the user time zone rather than the server time zone?Summary: Our reports are generated in UTC time zone, especially when it comes to Exit reports the LWD & the submitted dates are not matching because of time zone differe…Elavarasan S 64 views 2 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
SQL query to retrieve the approval history dataSummary: I wanted to create an SQL query to retrieve the approval history data which is in Transaction Console for process name 'Journal Approval' Content (please ensure…Sonia V 95 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
please help me to fetch report for Specialization with individual activity status in Learn ModuleI want to pull the details of specialization, including status, along with individual activities and their status | SQL query to get specialization details , module name…Nagarani M 12 views 0 comments 0 points Started by Nagarani M Reporting and Analytics for Taleo Learn