Category 81
Discussion List
-
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 704 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.… -
OTBI Agent - Italic in narrative textSummary: Content (required): Hi, I'm creating an agent to send automatic emails: is it possible to insert some italic text? In case, could you please tell me how? Thank …Alberto Americi 11 views 4 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM
-
Restricting report access to read only using Application RoleHi, In HCM (Reports and Analytics), We are trying to restrict reports access to read only for particular users using Application role. For that created a new role assign…
-
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
-
Benefits Enrollment Real Time Subject Area not pulling for future dated enrollmentsSummary: Hi All! We just completed Open Enrollment and tried running a report based on the above Subject area and we are only able to pull current year. Is this how the …Tristan Aquino 44 views 8 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Report to pull goals not createdSummary: Can any one please send me the query or analysis to pull the employees who not created goals. Content (required): Version (include the version you are using, if…Reddykrishna Chidella-Oracle 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Hourly Rate FormulaSummary: I have a report using the subject area Compensation – Salary Details Real Time and need to add a formula that calculates a base hourly rate. Here is what I'm lo…JHaden3 116 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to find and report on duplicate socialsSummary: I have a requirement for an analyses report that identifies duplicate social records. When duplicates are found, the report detail will include Person Number, P…
-
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
-
Date Match Formula ErrorSummary: Date match formula errors when I run the report. CASE WHEN "Work Relationship Details"."PER_PPS_LEG_DDF_ST_BS_SR_STRT_T_" = "Workforce Management - Worker Assig…
-
Benefits | Added or Removed Dependents ReportSummary: Hi All! Does anyone have an example report that shows added or removed dependents? Content (required): We would like to audit our benefits to see if employees h…Tristan Aquino 11 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Report to show Employees Not Paid in the Last 6 MonthsSummary: I am trying to work out Casual employees that have not been paid in the last 6 months. I can get employees that were paid over 6 months ago, but this also shows… -
OTBI Report Performance IssueSummary: OTBI Report Performance Issue Content (required): Hi Team, We have developed the turnover dashboard using "Workforce Management - Workforce Trend Real Time" sub…Vasanthakumar Ravi 74 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
BIP table for pending approval assignees?Summary: We want to be able to get the list of assignees from an approval process/transaction, before it is completed. Content (required): If an approval process is stil…User_2025-02-12-18-16-11-815 45 views 2 comments 0 points Most recent by User_2025-02-12-18-16-11-815 Reporting and Analytics for HCM -
Turnover -Month on MonthSummary: I am looking for calculating turnover 12 months from a certain date month by month. But I want the period start date to remain the same as the start month of th…
-
Learning Completion Summary Report Pivot TableSummary: Total shown in Learning Completion Summary Report Pivot Table Content (required): I have a requirement to do a learning completion summary report for people who…Ridma Karunanathan 54 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle 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 -
HCM Reporting Only Role - Both BI and OTBISummary: Hi Guys, Anyone has any idea how to go about creating a Reporting Role for Applications Internal Team for adhoc BI & OTBI reporting . Is there a delivered role …AshishERPCloud 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-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 -
OTBI report to sum element Medical ER rate for calendar year where payroll isn't processed in OracleSummary: Looking for OTBI report to sum element Medical ER rate for calendar year per employee where payroll isn't processed within Oracle for W2. Or if someone has a da…Becki Willard 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Most recent salary record (Active and Termed)Summary: I have a report using the subject area Compensation – Salary History Details Real Time. I need the report to display only the most recent salary record for both…
-
Need inputs to display Dependent and other information side by side in OTBISummary: Need inputs to display Dependent and other information side by side in OTBI Content (required): We developed Benefit OTBI report. Currently if an employee is ha…
-
Image stored on Web content Server not getting displayed in the Email Output after scheduling ReportSummary: Hi, We have created a check-in on content server to store an image and we are using that link in a report. The link is working fine when tested directly. We als…Abhishek Bhawalkar 137 views 5 comments 0 points Most recent by Abhishek Bhawalkar Reporting and Analytics for HCM
-
Voluntory Turnover ( Full Time Equivalent) - Workforce Management - Workforce Trend Real TimeSummary: I need to understund in the subject area the calculation rules applicated for the turnover Content (required): in order to create a monthly report on Voluntary …Ayoub AFRASS 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Adding People Group to Workforce Trends/Payroll Run Results Subject AreasSummary: Adding People Group to Workforce Trends/Payroll Run Results Subject Areas Content (required): Version (include the version you are using, if applicable): Code S…
-
WebDAV bursting option configuration to access share pointSummary: Hello Team, I am trying to leverage WebDAV bursting option to access share point and place the files in the system. However, it is throwing error. Please share …Shiva Prasad M 42 views 2 comments 0 points Most recent by Raghavan p-Oracle 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…