Category 81
Discussion List
-
Query for extract Hierarchy ManagerHi there , we need to reconstruct the hierarchy of a user's managers via a query in BI. The real problem we encounter when a manager then has several active assignments …User_2025-02-07-06-30-13-200 2.1K views 6 comments 0 points Most recent by User_2025-02-07-06-30-13-200 Reporting and Analytics for HCM -
All assets that have been created in projects but have not been capitalized yetSummary All assets that have been created in projects but have not been capitalized yetContent I need to create a report in Project Costing - Assets Real Time subject ar…Andrew_Schmitz 24 views 3 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
Payroll Costing and BalancesSummary: Has anyone ever used these two subject areas in an OTBI analysis correctly? : Payroll - Payroll Costing Setup Details Real Time & Payroll - Payroll Balances Rea…Andrew_Schmitz 41 views 7 comments 2 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
how to sum two condition in e-text template on oracle fusion hcmSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
Reporting on Supporting Reference Balances for a secondary ledgerSummary: When reporting on Supporting References in OTBI the values associated with secondary ledgers exist in the "Subledger Journals Real Time" subject area but not th…Daniel Martin 41 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub -
how to sum two condition in e-text template on oracle fusion hcmSummary: When we add all 4 fields the output of the report comes blank. I am able to add Shift Pay+Incentive+Current Salary the output appears but when i add Lead Pay (w… -
Display Extended Absences by day from Absence ModuleSummary: We have a requirement to show absences by day if they are booked over a period of time. Content (required): The example we have is if someone books a week long …User_2025-01-31-00-25-12-234 21 views 2 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Error Receive when View ReportSummary: Error Receive when View Report Content (required): User receive the error message below when generating dashboard Version (include the version you are using, if…CraigX 11 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
Not able to add dashboards objects and OTBI contents on Dashboard pagesSummary: I am trying to create one dashboards using analysis but when I created one dashboard and trying to add column sections and other dashboards options on dashboard…Kamini Kaushik-Oracle 21 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Output from BI Report is not fully getting passed to HCM Extract in the flowSummary: We are working on the process with the flow including the first step of HCM extract execution which calls BI Report to generate the data in HDL format and then … -
Dashboard- Headcount to be represented as a % - By Length of Service per GradeSummary: I am looking to represent length of service per grade as a bar graph showing % of headcount . I am able to achieve this when using stacked 100% or presenting th…Anita 41 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Identifying managers in OTBISummary How to identify a list of workers who are managers in OTBI for us in an analysis destinationContent Hi everyone, I've posted this topic in the Core HR forum, but… -
Employee Phone Numbers Comparision ReportHi Experts We have client requirement for design a report which pulls up Employee details along with their work and home phone numbers. The inputs are Start Date and End… -
How can we print an encrypted alphanumeric code on the face of each cheque?Summary: The banking sector has made changes in respect to cheque production, this change requires a UCN (Unique Cheque Number) to be applied to each cheque produced. Ma…Sohesh Patel-Oracle 71 views 1 comment 0 points Most recent by Andy Hayes Payables, Payments & Cash Management -
Getting dupplicates records if we are using Historical Assignment UE and Performance issue.Summary: Getting dupplicates records if we are using Historical Assignment UE and it is taking too much time to complete Extract. Content (required): We are using PER_EX… -
ORA-06553: PLS-306: wrong number or types of arguments in call to 'XMLTYPE'Summary: When trying to replace HRC_TXN_DATA.DATA_CACHE with HRC_TXN_HEADER.XML_DATA_CACHE; facing error - ORA-06553: PLS-306: wrong number or types of arguments in call…Priyanka More-Oracle 355 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Custom Subject Area not availble to useSummary Custom Subject Area not availble to useContent Hi There, We created a custom Subject area from one of the implementor user who is able to access and produce resu…Sahil_Makhiza 33 views 5 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
Show OTBI Graph with no values rather than No Results messageSummary: There are instances when the OTBI bar graphs result in no data results. Instead of showing a "No Results" message, is it possible to show the graph instead? We …User0901 41 views 1 comment 1 point Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
PO Quantity field is editable when it is converted from a PRContent Hi Team, When we process the requisition and convert the PR into PO, a buyer can go and change the quantity field when the PO is in incomplete status. This is a … -
How is the security defined for the analytics "Recruiting Real Time"Summary: I am trying to create a analysis using the subject are - "Recruiting - Recruiting Real Time". The user has administrator access and role to view all job requisi…Shikha Agarwal 31 views 5 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM