SQL
Discussion List
-
Where to find Risk Code Description in DBSummary: Need to find the Risk Code (or Workers Compensation Code) description in the database. Content (required): I am creating a report pulling data out of hcm cloud … -
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 102 views 2 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Scheduling the report(Email Notification) if the data is present in itSummary Scheduling the report(Email Notification) if the data is present in itContent Hi All, Greetings !! Our customer's requirement is to receive the report/Email noti…User_2025-01-29-01-27-20-754 214 views 17 comments 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM -
How to read primary national identifier?Summary: How to read primary national identifier? Content (required): How to read primary national identifier? I use per_national_identifiers table but no reference to t…Nicola Petri 53 views 2 comments 1 point Most recent by Seema Kalantri Reporting and Analytics for HCM
-
Time and Labor Entries by BatchSummary Looking for a query of Time and Labor Entries by Payroll Transfer BatchContent We’d like to be able to report on the entries that were loaded from Oracle Time an…User_2025-02-04-10-25-07-624 75 views 5 comments 1 point Most recent by Santhosh T Murthy Reporting and Analytics for HCM
-
SQL Query for Supervisor/Employee Hierarchy with Both Direct and Indirect ReportsContent I have a task to create a BI Publisher report and attach additional data from different tables based on the bottom level employees. I am wondering if anyone has …Brian Todd-Oracle 952 views 2 comments 0 points Most recent by Suhitha K-Oracle Reporting and Analytics for HCM
-
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 41 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 523 views 1 comment 0 points Most recent by Raluca.S - Fusion GL Oracle-Oracle Reporting and Analytics for ERP
-
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 83 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-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…Gerardo Peluso 26 views 0 comments 0 points Started by Gerardo Peluso 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…User_2025-03-07-06-11-23-192 21 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 330 views 1 comment 0 points Most recent by MandeepGupta 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 21 views 0 comments 0 points Started by Aloka Bhattacharya 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 590 views 4 comments 0 points Most recent by MandeepGupta 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 …Parag Hiremath 11 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
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…Thulasi Ram 104 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
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 702 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.…
-
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 …Alice Gouzy 132 views 3 comments 2 points Most recent by Alice Gouzy Reporting and Analytics for HCM
-
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 11 views 0 comments 0 points Started by Jesper Majgaard Jakobsen Reporting and Analytics for HCM
-
OTBI filter to compare two attributesHello, We're building an OTBI Analysis that compares, for each employee, the competency’s rating given by his/her line manager in a Performance Document and the minimum …gguittini 62 views 4 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
Cannot test custom notificationSummary: Content (required): Hello experts, I'm trying to test custom notification by going to Schedule. However when I go to History task, teh system return an error me…Valerio Curzi 11 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
BI Report on Notification Approvals StatusSummary Trying to create a BI Report on the status of Notification ApprovalsContent I've tried looking at a number of tables, firstly in OTBI, but the subject area "Huma…User_2025-02-06-00-01-08-606 98 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Need to report on how long is it taking for managers to approve their tasks in a particular workflowSummary: We need a report from the workflow side of things to give us insight into how much is each manager taking to approve their tasks. Content (required): This is a …
-
cmp_transactions doesn't track Override when Worksheet Overridden by Another Manager is disabledSummary: Content (required): Hello, we are configuring a custom Worksheet Overridden by Another Manager notification. When we extract user transactions on compensation p…
-
XLA_TRANSACTION_ENTITIESSummary: Team, How to join XLA_TRANSACTION_ENTITIES with Payroll / Assignment Tables and Get Person Related Transactions. Any idea would be highly appreciated. Thanks in…
-
How to link Allocated tasks with questionnairesSummary: hello everyone, In order to create a report on the offboarding /exit interviews i need to link the allocated tasks with the questionnaires to get the allocated …Ayoub AFRASS 64 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Reporting and Analytics for HCM