Category 81
Discussion List
-
How to report on proxies setupSummary: We have a requirement to report on the proxies information setup (Set Preferences > Proxies). Is there any seeded report or information on building custom repor… -
How do you display the run date, time (AM/PM), and timezone. Example 11/28/23 11:57 AM ESTSummary: When running a BIP report I am trying to show the timezone of the run date and time being displayed. I am using an RFT template. Content (please ensure you mask…
-
How to use an OTBI analysis to create a data model with a parameter (prompted?)Summary: I am trying to use an OTBI analysis to create a data model. My data model will be refrenced by Oracle Journeys so there is a requirement that I attach a specifi…Amy Wilson 764 views 7 comments 0 points Most recent by Stefan v. Glabbeek Reporting and Analytics for HCM -
Reporting Prior Month Data SQLSummary: Can we add SQL to the formula to look at the Prior Month data? So tell it to look at the System date - 1(for prior month) and pull 1st to last date of that prio…THawkins_LGI 42 views 12 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Using Workforce Management - Worker Assignment Real Time Can't view own record in OTBISummary: we have one OTBI report with SA "Workforce Management - Worker Assignment Real Time". When admin user(non employee) runs this report it pulls all the records. w…User_7A1QO 56 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Business Unit Hierarchy looking for Parent Business Unit NameSummary: I would like to know what table Parent Business Unit Name is in for a BI publisher SQL Content (please ensure you mask any confidential information): Version (i…
-
Need to create a BI report to See What Jobs Are Scheduled Along With Frequency, Start and End dateSummary: Hi All, We've a requirement from the customer where they need to create a report to See What Jobs Are Scheduled Along With Frequency, Start and End date. Can so…Sandeepan Rana-Oracle 22 views 3 comments 0 points Most recent by Sandeepan Rana-Oracle Reporting and Analytics for HCM
-
Seeded reports not returning any dataSummary: I am trying to run the seeded reports in the below location but none of them are returning any data. I am running this report with the seeded Employee and Line …Consultant Ian 23 views 8 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
OTBI Report Issue with Candidate Inclusion and ExclusionI'm facing a challenge with the OTBI report. I'm trying to incorporate two sets of logic: Requisitions with candidates. Requisitions without candidates. However, when I …Ranjith Antony MPC 11 views 0 comments 0 points Started by Ranjith Antony MPC Reporting and Analytics for HCM
-
What table is storing Change working hoursHi Team, Which table is storing change working hours information? Any sample will be helpful.
-
how to bulk download the attachments in report job historyHi Team, I have a requirement to download the output name (attachments) in the Job History. But when I download the files it's coming in the XML Format. can anyone tell …Haritha 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Unable to get the proper count for Assignment Count when I am using two subject AreasSummary: Hi Team, we have requirement to get the count for Nationality to get this column we are using 'Person Real time' Subject Area. and we also have to filter this c…Ashok Dhara 14 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Privileges/Duty roles required to extract Absence data via OTBI AnalysisSummary: Hi Team, Could some one kindly help us on the below requested issue. We are unbale to extract Absence related data from the Subject Area: Workforce Management -…User_2025-02-07-03-03-32-616 193 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Termination category field causes blank rows for OTBISummary: Termination category field causes blank rows for OTBI Content (please ensure you mask any confidential information): Hello experts, we are building a custom OTB…Oriana L. 14 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
Restrict parameter value in seeded line manager dashboardSummary: We are using Line Manager Dashboard in Fusion hcm, we have different BUs and we have requirement to restrict business unit & legal employer parameters (LOV) in …
-
Has anyone ever see this error- Exception in expression "RequisitionBOVO" object function Convert_tSummary: When creating a requisiton we get this error Exception in expression "RequisitionBOVO" object function Convert_to_Decimal(java.lang.String) : java.lang.NullPoin…Hi.itsa.me 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Recruiting, Opportunity Marketplace -
How to report Open Requisitions with AS OF DATE parameterSummary: Need OTBI report that shows all open requisitions with an AS OF date parameter. For example, all open requisitions as of 1-1-2022. Content (required): I have an…
-
Cannot see Schedule name in OTBISummary: We have an OTBI report that shows the work schedule assignment using Person Real Time"."Person Schedule Assignment"."Schedule Name". Users with HR admin roles c…Crystal Pace 44 views 4 comments 0 points Most recent by Crystal Pace Reporting and Analytics for HCM
-
OTBI Subject Area permissionsSummary: I have an issue attempting to edit reports in Oracle Transactional Business Intelligence (OTBI). Specifically, when trying to edit reports related to different …XUM TECHNOLOGIES 23 views 3 comments 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for Sales -
How to edit contents within a Data Model Report?Summary: Need to update our disclosure form that is a data model thru OTBI connected to Our New Hire Journeys. Is it possible to upload the new data model or edit the co…
-
Is there a way to pull a report that shows if an assignment is missing a payroll relationship?Summary: Is there a way to pull a report that shows if an assignment is missing a payroll relationship? We are new to adding assignments for employees, and didn't realiz…Jenna Savage 46 views 5 comments 0 points Most recent by BrentBlackwell Reporting and Analytics for HCM -
I need query to get expense approver nameDoes any one have query to get expense approver nameSwati U 200 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for HCM
-
Subject area/database table for historical manager hierarchySubject area/database table for historical manager hierarchy Client is interested in building dashboards to show different HR metrics for which historical manager hierar…
-
how I can measure application usage in HCMSummary: Now a days i need to verify if my users are using the app, for example if they are creating new depts, they hire new persons or they are be in some feature in s…User_1VTMP 28 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Data Model throws a nullpointer exception while trying to retrieve dataSummary: I have created a data model with 2 data sets (one for employees and one for Contingent workers) - I have created an Excel Template that has 2 tabs for the data …User_2025-02-04-08-51-08-912 264 views 3 comments 0 points Most recent by John Peter Noble-Oracle Reporting and Analytics for HCM
-
Report showing enrollments As Of Prompted DateSummary: Requirement is for an OTBI report showing enrollment detail as of a prompted date and plan(s). For example, what employees were enrolled in Voluntary Life as of…
-
Beneficiary missing some dataSummary: Hello! I am using subject area Benefits - Enrollment Real Time to pull out primary beneficiaries. I have a record in file that is missing some data. EMP Person …Sarah D 44 views 5 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
How to setup dynamic filters in BIP report?The dynamic filter should adhere to the following logic: Year: If today falls between February and December, use the current year. If today is in January, use the previo…Janardhan ACS-Oracle 28 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
Calling an external image in bursting using tokensHi We need to call an external image in the bursting query. by passing token. Please help in achieving this. Regards, ShanmukhiShanmukhi 12 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
Profile id not available for some employeesSummary: Profile id not available for some employees Content (please ensure you mask any confidential information): Hi experts, we want to create a report that retrieve …