SQL
Discussion List
-
Approver Name of a transaction with OTBISummary: Create an OTBI report with Transaction details, the initiator and approver Content (please ensure you mask any confidential information): Hello experts, is it p… -
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…usr_a.nv 62 views 20 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
I want SQL query to fetch data from talent review meetings , employee view potential assessmentSummary: below question and answers i need to fetch against the employee. (navigation talent review meeting in progress → select any employee in meeting → Actions tab→ v…Amit Baghel 19 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Need Guidance/References: Reporting Post-Approval Timecard Edits in OTLSummary: Hello Everyone, We have a requirement to build an OTL BI report that captures post approval timecard edits. Specifically, when an employee updates a timecard af…tejaswi kilaru 3 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…Yaniv 765 views 12 comments 1 point Most recent by Naryman Ismail-Oracle Reporting and Analytics for HCM
-
How to export all HCM extracts in one goSummary: How to export all HCM extracts in one go Content (please ensure you mask any confidential information): Hi All, Greetings! We typically export the XML for a giv… -
Query to get Languages in ORCSummary: Based on the screenshot I provided, What table in HCM can I get the list of values for the Languages in ORC. Content (please ensure you mask any confidential in…
-
How to get shift name start time, end time for certain date, from the work schedule caledarSummary: In oracle Fusion, We need a query to identify the shift name , shift start time and shift end time as the following parameters shall be passed Emp number Date C…MHanif 74 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 374 views 6 comments 0 points Most recent by Neha Thakre 2023 Reporting and Analytics for HCM
-
Query to get all the defined UOMSummary: Query to get the UOM that we've defined in our application. Content (please ensure you mask any confidential information): Hello, We need to have a query to get…Mamdouh Ahmed 12 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
Link learning evaluation questionnaire to learning assignment in Bi publisherHello, I have a requirement in BI Publisher in wich I need to extract the answer of a specific question from the offering evaluation (in learning) My base is that, howev…Sara Suleiman 11 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
We are not getting qstn_answer_id value in the HRQ_QSTN_RESPONSES tableSummary: We have some set of questions in the questionnaire for the performance document and when the user provides the response a row is getting generated in the HRQ_QS…
-
SQL query to retrieve earnings and deductionsSummary SQL query to retrieve earnings and deductionsContent Hi Experts, I'm designing a balance extract that needs to fetch pension deductions 403. To create the data g…Aloka Bhattacharya 2.8K views 7 comments 2 points Most recent by Shubham Kadam Reporting and Analytics for HCM -
Report SQL parameter filter in DataModel dont show in Dashboard PageReport SQL parameter filter in Data Model dont show in Dashboard Page Dont show in Dashboard Page In Report showFERNANDA SANTOS 11 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
Why would a report not reflect the updated data model?We had an issue wherein the report did not reflect the updated data model. The fix was then to duplicate the report itself without any changes. The duplicated report the…Hazelle 49 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Master tables and employees transactions tableSummary: Hi, We need to Archive all information of the system so want to know which all Master tables which stored configuration details and which all tables stores empl…Namrata_20 31 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Generating Record 0150 (Participants/Suppliers) in SPED Fiscal (Bloco K) via LACLS_SpedInvBlocoKHi everyone, I have a question regarding the Brazilian Localization for EFD ICMS/IPI, specifically concerning the generation of Bloco K (Inventory and Production Control… -
Effective end date in PER_MANAGER_HRCHY_DN not updatedSummary: When does effective_end_date in PER_MANAGER_HRCHY_DN gets populated? We are assuming that when an employee is no longer reporting to a manager then effective_en…
-
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …
-
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 3.5K views 21 comments 1 point Most recent by SangeethaSekar-Oracle Reporting and Analytics for HCM
-
BIP Report to Track “Synchronize from Position” UpdatesSummary: Hello, Is there a BI Publisher (BIP) query or report that captures all attributes updated by the “Synchronize from Position” action on a daily basis? Any pointe…Explorer 22 views 2 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
How do I define the dashboard prompt to include date range on the same columnSummary: Need help in defining the dashboard prompt to include date range on the same column, for example: date range on hire date and how to incorporate in BI Publisher…Surabhi Kumari 332 views 10 comments 0 points Most recent by SudiptaDey-Oracle Reporting and Analytics for HCM
-
SQL query for Fusion Subledger Accounting Hub with Channel Revenue ManagementHello, we need to create an SQL query where we have ChRM Program details, Accrual and Journal Batch Transaction Details: Debit/Credit from Accounting Hub. Can you please…Raluca Balan-Oracle 3 views 0 comments 0 points Started by Raluca Balan-Oracle Reporting and Analytics for SCM
-
Need a SQL query to get the Total Quantity of Pending Transactions of a item in oracle fusionHi Experts, I need a SQL query to get the Total Quantity of Pending Transactions for a item. My requirement is to get "Available to Transact" Quantity of a item. ( = 200…Krishan_Palihakkara 1.2K views 19 comments 0 points Most recent by Mahi_Ranjan Reporting and Analytics for SCM
-
Query to return employees related to a particular Representative type for a given AoR and scope of rSummary Query to return employees related to a particular Representative type for a given AoR and scope of responsibilityContent Hi All, Please share Query to return emp… -
Time Entry Audit Report for Reported timecards.Hi Team, I am trying to build a report, where we will show the Time audit details like Person Number, Time Type before change, Time Type after change , Timecard start ti…Khush Tiwari 553 views 11 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM
-
SQL query to get the result of Recalculate Payroll for Retroactive ChangesSummary: SQL query to get the result of Recalculate Payroll for Retroactive Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Ca…Parag Hiremath 13 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…Manoharan 9.6K views 12 comments 0 points Most recent by Anusha Bhat-Oracle 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 …Merwin 56 views 2 comments 0 points Most recent by Jason Lobo Deloitte Reporting and Analytics for HCM