SQL
Discussion List
-
SQL query for Length of service in years and monthsSummary: Hi, I am trying to add formula in OTBI report on Service Date field to calculate duration in years and months. However, I don't know SQL, but was able to find b… -
Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances tableSummary: Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances table Content (required): In the Pay_run_balances table able to see "RUN" related bal… -
Need inputs to fetch balance "Reference" field value against balance dimensionSummary: Need inputs to fetch balance "Reference" field value against balance dimension Content (required): In the Employee Payroll balance results we are able to see Ba…
-
Logical SQL querySummary: Content (required): I am trying to join the candidate person number to their employee person number to get their days of service since I need this data by recru…Riti Malhotra 15 views 1 comment 0 points Most recent by Riti Malhotra Reporting and Analytics for HCM
-
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (GL) For An Employee Columns are: Accounting Date Transaction Number Payr…Manoharan 18 views 1 comment 0 points Most recent by Raluca.S - Fusion GL Oracle-Oracle Reporting and Analytics for ERP
-
Restrict employees to be eligible to more than one compensation planSummary: Content (required): Hello all, I would like to create a fast formula in order to exclude employees from other plans if they are eligible to a specific plan. Mor…Maria Xydopoulou 10 views 0 comments 0 points Started by Maria Xydopoulou 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 12 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM
-
need sample query with time card submission statusSummary: need sample query with time card submission status (Saved,Submitted, Approved etc) Content (required): need sample query with time card submission status (Saved…Ishtiaque AHmed 8 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Oracle Reporting and Analytics for HCM
-
Enter values for lexical referencesSummary: Content (required): Hello everybody, We are having issues using this query to extract information from the learning module. I suppose that the error is given by…
-
Create a Report for Candidate Job Application with the Prompts as Prescreening QuestionsSummary: Hello Experts, We have a requirement where we need to build a report with the Filters as the Prescreening Questions. There are 15 Prescreenshing questions but w…HarishVummidi 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Query to get Questionnaire answers given by user and right oneContent Hello experts. I need a report for learning assessments. This report is to get the learning item - task assesmment - questionnaire - answer - right answer (based…Pedro Teixeira 30 views 6 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
Oracle Fusion Payroll Balance QuerySummary:Performance Issue with my BI Publisher report Payroll Balance Query Content (required): My current payroll balance query is using pay_balance_view_pkg.get_balanc…
-
OTBI folder and column name Contract InfoSummary: Content (required): Hello, do you know in which folder or the column name in OTBI for the highlighted columns (Contract Info)? Kind Regards, Valerio Version (in…Valerio Curzi 19 views 3 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM -
Query to Retrieve All Privileges and Roles for All RolesSummary: We want to know the query/tables that will allow us to retrieve all Roles details including the assigned Functional and Aggregate Privileges Content (required):…
-
Prompt does not work in dashboard for different analysis using different subject areasSummary: Content (required): I have a Dashboard with the following analysis (tabs) called: 1. Requisitions (SA:Recruiting Real Time) 2. Applications (SA:Recruiting Real …Maria Xydopoulou 14 views 0 comments 0 points Started by Maria Xydopoulou Reporting and Analytics for HCM
-
OTBI Subject Area or Query to retrieve Job Profile informationSummary: Content (required): Hello experts, is there an OTBI subject area to retrieve Job Profile information such as: ProfileItemId, ProfileId, ProfileCode, ContentType…
-
Reporting issue - How to show sickness days vs actual worked daysSummary: Reporting issue - How to show sickness days vs actual worked days Content (required): I am trying to write a report to show the number of days a person is contr…Simone Williams 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Payroll Element QuestionnaireSummary: Looking for a query to Fetch the Payroll Element Questionnaire Details Can any body Please share a query to Fetch the Payroll Element Questionnaire details Cont…MilanMohanty 13 views 1 comment 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM -
Associate Roles with the FUNCTIONAL modules.Hi Experts, I have a question on the Roles defined in a Fusion Instance. Is there a way to associate a role with the module where it actually comes into play? I'm trying…Aloka Bhattacharya 1 view 0 comments 0 points Started by Aloka Bhattacharya Reporting and Analytics for HCM -
Query to get the list of roles in applicationSummary Query to get the list of roles in applicationContent Hi Experts, Is there any seeded query or custom query available to pull the list of all seeded and custom ro…Charan Kollipara 73 views 6 comments 0 points Most recent by Vibha Pandey Reporting and Analytics for HCM
-
How to add multiple filters in HCM Extract Filter CriteriaSummary: We want to add another filter under HCM Extract Data Group Filter Criteria to filter out terminated employees who has been rehired later from our result set. Co…GauravGupta39 31 views 4 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
how to add a manager email as cc in a bursting report sqlSummary: I have a report which i'm trying to schedule, but i'm stuck at the cc part. i need to add the manager in the cc field. below is my sql, how do get the manager v…
-
Payroll Run Error ReportsSummary: Payroll Run Error Reports Content (required): Hi All, Greetings! What is the best option available to get the payroll run error list - apart from the flow 'Run … -
Can anyone assist with joining two tables in Learning? WLF_EVENT_ASSIGNMENTS_F and WLF_LEARNING_ITEMSummary: I am trying to join the course and the associated initiative information from the two base tables in Learning. Content (required): Joining the learning_item_num… -
Oracle HCM Cloud: Where can I see the seeded Packages for BIP?Summary: Does Oracle have a list of DB packages that we can use for BIP? I saw this one "pay_balance_view_pkg" but I wanted to know if Oracle have a full list of package…
-
when i ran My Bi reports I'm getting error is ORA-01427: single-row subquery returns more than oneSummary: Hi Team, when i run my report some countries coming data and some of times als coming the data but some times I'm getting below errror: ORA-01427: single-row su…AjayKumar Maddipati 51 views 13 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
ODBC Error - ADFService11g on OTBI AnalysisSummary: After 22B went into our Test environment, a report built on a few subject areas no longer works. It is giving us the following error: State: HY000. Code: 77031.…HROps17 31 views 3 comments 1 point Most recent by MeganTerrellHowmet Reporting and Analytics for HCM
-
Custom Data Model - ProfileApprovalNotificationSummary: How to custom the seeded data model in order to add flexfields Content (required): Hi, I need to add flexfields from one Profiles section (Honor and Awards) in …
-
How to link Action and Action Reason to a BPM Worklist taskSummary: Hi. We can create a BIP where we have the BPM Worklist tasks but we would like to have Action and Action Reason included in that report so we can see what Actio…Jesper Majgaard Jakobsen 2 views 0 comments 0 points Started by Jesper Majgaard Jakobsen Reporting and Analytics for HCM
-
OTBI Hospital Custom TableSummary: Dear All, Where can i find this table is maintained in Oracle system? Thank you Izliana Content (required): Version (include the version you are using, if appli…