Category 81
Discussion List
-
Max Effective Date for Each ElementSummary: How to retrieve the max effective date for each Element. Content (required): I am trying to find the max effective date for each of the three Elements (differen…JA1 32 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Trying to create a calculated item using fields from two subject areasI have created a report using balances and calculation cards. The report will run and return data from both areas but when i try to create a new field using a formula th…Sharon Harper 32 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Resource Alert: Waitlist Exit AlertSummary: Hi All, I am working on a resource alert(alert composer) to achieve those learner details whose offering status change from waitlist status to some other learn …
-
Subject Areas not fetching data properlySummary: "Workforce Management - Worker Assignment Real Time" subject area not fetching the data properly. Content (required): I am working in internal test instance, it…Raghavendra M 145 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Is it possible to download the BIP output files to the particular folder in Machine?Summary: Is it possible to download the BIP output files to the particular folder in Machine? Suppose when we run any report, is there a way to download the output files…Kovi Harish Kumar 22 views 4 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Catalog for Payroll Balances Real timeSummary: Trying to create a report from Payroll Balances Real time SA to match the Balance Results values from SOE with the amount included in the report for the respect…Hem 82 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Can deduction arrears be one an OTBI report.Summary: Deduction arrears on an OTBI report. Content (required): I need to write an OTBI report for deduction arrears. Is that possible? What subject area do I need to …Donna Valentine 21 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
How can we fetch "Non-Union Benefit Eligibility Dates" in OTBI ?Summary: From the attached screenshot we can fetch all the fields under Extra Information in Workforce Management - Person Real Time subject area except Non-Union Benefi…AaronJai 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Capturing the time of activitySummary: Content (required): hi there I am running a report for a classroom course with several offerings. A few of the offerings happen in the same room on the same dat…Bobby Jourdan 13 views 2 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM
-
Need a report that shows everyone is a Closed Life Event StatusSummary: Could someone provide me with the correct criteria that shows everyone who is in a closed Life Event Status. I am using the subject area "Benefits Enrollments R…User_2025-02-11-00-58-38-371 21 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Is it possible to download the BIP output files to the particular folder in Machine?Summary: Is it possible to download the BIP output files to the particular folder in Machine? Suppose when we run any report, is there a way to download the output files…
-
Workforce Learning - Learning Management Real TimeSummary: Can anyone please help me with the table names/SQL that is being used in the Workforce Learning - Learning Management Real Time subject are .we have requirement…minati_behera-Oracle 92 views 2 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM
-
Error uninstall Oracle BI Publisher Desktop 1670:Unable to Load module with error code:1114Summary: We are trying to uninstall Oracle BI publisher Desktop , but we are getting below error 1670: Unable to load module c:\Users\Admin... Error Code: 1114 Could you…
-
How do I schedule a Job, So that a Job starts when earlier scheduled Job is completed.Summary: Schedule a Job for 10 sets of Employees so that each job set starts before earlier Job completes Content (required): I need to schedule a Job for 10 sets of emp…Anjan Polimera 13 views 1 comment 0 points Most recent by Anjan Polimera Reporting and Analytics for HCM
-
How to create date range parameter i.e. Date from and Date to in OTBI report?Summary: How to create date range parameter i.e. Date from and Date to in OTBI report? Content (required): We want to fetch payment details from specific date range in O…Priyanka More-Oracle 1.4K views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
OTBI Analysis takes about 20 minutes to return results, how to improve performance?Summary: OTBI Analysis for Master Headcount Report takes 20 minutes to display results. Content (required): Our client is migrating from EBS to HCM Cloud. Currently they…Vinay Hardas 44 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
User folder not visible in right pane due to system limitation of 300 folders at a timeSummary: Per Doc ID 2443757.1 users folder permission can be set by navigating to folder. However though I can see the user folder in left pane can't navigate to the sam…
-
How to Calculate Payroll ReversalsSummary: How to include payroll reversal values in calculation Content (required): We have BI publisher report that calculates Payroll distribution for all of our employ…GauravGupta39 52 views 5 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Create LOV for countries defined in the system and few more custom valuesSummary: Can we create an LOV that will include all countries already defined in the system plus few more custom values. Content (required): Version (include the version…
-
Value of a LOV is restricted depending on logged in userSummary: How can we restrict the values included in an LOV depending upon the logged in User Content (required): Version (include the version you are using, if applicabl…
-
Email Notification when Employee Changes Their NameSummary: I would like to setup an email notification to go out to a particular address each time an employee changes their name. Or optionally one email per day with a l…User_2025-02-12-02-38-00-520 22 views 4 comments 0 points Most recent by Vinayak | Camptra Tech Reporting and Analytics for HCM
-
How to get a PTO Accruals report with ONE line of data for balance per EE?Summary: We are using a 3rd Party for our PTO Accruals (UKG). Primary issue: Some EE's are in 2 plans, so they have 2 lines of data. The issue is that UKG will only pick…
-
How to get a details of Clock Entries missing for 3 days or more (OTL Module)Hello all (Report Description: The list of employees who have missing clock entries for 3 days or more should appear in the custom report) can anyone please tell me wher…
-
How to burst different notifications to different mail IDs based on exit interview responsesSummary: How to burst different notifications to different mail IDs based on exit interview responses Content (required): We have implemented the Offboarding Process in …
-
OTBI Filter CriteriaSummary: Need help to add a filter criteria in OTBI analysis. I am using the below filter criteria which is working in payroll subject area: "Balance Types"."Balance Nam…Mohan Murali 23 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM - Administrator Role for Report Scheduling in HCMSummary: Create an Admin record in HCM for Report Scheduling Content (required): Is there a way to create a user account in HCM that can be used as a central scheduler f…
-
Segregate visibility on OTBI to allow users to report only on Recruiting Subject AreasSummary: Content (required): Hello, The customer is requesting us the possibility to let Recruiters to access the OTBI and create some custom reports only related to Rec…gguittini 43 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL to return all job roles where a particular duty role is usedSummary: SQL to return all job roles where a particular duty role is used Content (required): Hi Team, Please share SQL to return all job roles where a particular duty r…
-
Pass an employee ID parameter from an analysis to a Skills pageSummary: We want to have an OTBI analysis table of employee information with a link per person that takes the viewer to the Skills and Qualifications page with the emplo…User_2025-02-05-22-55-58-511 43 views 2 comments 0 points Most recent by User_2025-02-05-22-55-58-511 Reporting and Analytics for HCM
-
DFF value is not coming in the OTBI reportSummary: Content (required): Hi Expert, We have created a DFF in the document of record and when we are using the OTBI report to fetch the data for this specific dff the…Faizan Rashid 426 views 2 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM