Category 81
Discussion List
-
Ability to Hide Future Hire Recored for Line Manager viewSummary: Future hire records who all are considered as sensitive hires are needs to be hidden fro Line Manager's view before theire DOJ Content (please ensure you mask a…Maran Aswin 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Person address data not displaying for user - BI reportSummary: I created one BI report and it has SSN and person details including address. When I ran the report, it shows all the details. When user ran it, the address fiel…Peoplesoft 31 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
List of standards reports and infolets in Oracle HCMHello, Is there a list of standard infolets and reports in Oracle HCM that companies can use please ? Thank youHiba Ghoualmia 313 views 4 comments 0 points Most recent by Hiba Ghoualmia Reporting and Analytics for HCM -
How to cancel double row in changes BIP report?I have a BI PUBLISHER report that shows changes in addresses and marital status of an employee. I use the table HRC_EVT_OBJ_CHANGE_COMPONENTS, The problem is that it sho…Alex_Balanovsky 13 views 1 comment 0 points Most recent by User_4XX09 Reporting and Analytics for HCM
-
OTBI Questionnaire text column how to set the questions inproper to order ?Summary: Hi Team, We were developed new report by using Check list real time subject area to get onbaording Questionnaire text of employees but issue questions are inpro…AjayKumar Maddipati 31 views 12 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Duplicate record in analysisSummary: Duplicate record appears when pulling data from Workforce Management - Document of Record Real Time Content (please ensure you mask any confidential information…Steph Yeung 55 views 8 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 371 views 5 comments 0 points Most recent by Narula Shray Reporting and Analytics for HCM
-
Need help in retrieving PLAN MANAGER in workforce compensation planSummary: Hi Experts, I was trying to retrieve workforce compensation plan manager. I could not find comp plan manager as filter when searched under Matric Manager in Wor…Ganesh Purnima 12 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
IN OTBI Absence Real time issue on accrual balanceSummary: we have requirement is to show the report as ui(Annual accrual balance of annual accural ) in below screen shot but shown as below wrong Could you please assist…AjayKumar Maddipati 51 views 6 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
accrual balanceSummary: I have a report on front-loaded plans to show Accraul, leave taken, Leave scheduled, Adjustments and Accrual Balance. Now we have made some adjustments for empl…Wouter.Schaap 31 views 1 comment 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
OTBI Report Not Returning employment contract detailsSummary: Created an OTBI report using subject area "Workforce Management - Employment Contract Real Time" to extract contract details. However, the fields when added fro…User_2025-02-11-02-55-52-410 38 views 16 comments 0 points Most recent by Samir Patro Reporting and Analytics for HCM -
How to sort the Questions in order using OTBI report?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to display the Questions under the Questionnair…Welsey 72 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Getting inconsistent data from event date fields. Can anyone help explain this or how to fix this?Summary: While creating an analytic for the state activation and completion, by job application, it created multiple lines. To solve this, we have in the past been able …Faraz123 42 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
BIP Schedule ReportSummary: BIP Schedule Report Content (please ensure you mask any confidential information): Hi Team, Greetings! There are multiple BIP Reports scheduled at the different…Parag Hiremath 52 views 5 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
what all types of the condition/logics can be used in e-text templateRequired Types of logics, condition and syntax for e-text templates in BI Publisher -
3rd Substring from a Field in OTBISummary: Need 3rd Substring from "Job"."Job Name" Content (please ensure you mask any confidential information): I have "Job"."Job Name" field and the data looks like "U…Pradnya_Pampatwar 4 views 2 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Prompt not working in a logical sql analysisSummary: I created a logical sql analysis (see image1). And I also created a dashboard prompt (see image2). I filtered the "Calendar_Year" as 'Is Prompted' but for some …
-
Tables to fetch queries used in DataModelsSummary: Hello Team, Is there any specific tables that are being used to fetch queries used in Data Models? Is there any way to achieve this? Thanks, Paramesh Content (p…Kurva Paramesh 21 views 3 comments 0 points Most recent by Kurva Paramesh Reporting and Analytics for HCM
-
Columns from Grade and Worker folders in Workforce Management - Eligible Jobs Realtime OTBI AnalysisSummary: Columns from Grade and Worker folders in Workforce Management - Eligible Jobs Realtime not showing results Content (please ensure you mask any confidential info…
-
OTBI prompt set default values for date between first and last day of current yearI know that I can set a default for a prompt as todays date using the SQL expression select current_date from "Workforce Management - Worker Assignment Real Time" I thin…
-
How to Disable OTBI agentWe have almost 160 agents in one of the folders and we need to disable all the OTBI agents. How to check whether the agents are actively running and how to disable them …Karthik Soundarapandian1 21 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Need 2 Date Fields having Case or Filter functionality in OTBI ReportSummary: Interim Review Date ("Performance Document"."Performance Document Period Name" like '%Interim%') and Final Review Date ("Performance Document"."Performance Docu…Pradnya_Pampatwar 42 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
ORC OTBI Report issue when we export from outputSummary: Hi Team, we getting below issue when we ty to export the data. Thanks, ajay Content (please ensure you mask any confidential information): Version (include the …AjayKumar Maddipati 23 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Latest Tax not Pulling through Subquery ResultsSummary: Latest Tax not Pulling through Subquery Results Content (required): The sub query set up correctly pulls back latest tax code effective start date in a calculat…
-
Learn Records show Duplicates within OTBI Report for all employees and coursesSummary: Content (please ensure you mask any confidential information): Hello, I have recently created a report where the OTBI report shows duplicate rows for most cours… -
Help with Query optimization - Sum of Payroll Balance DimensionSummary: Only months into our post-implementation and our pension report query is consistently timing out. I believe I have narrowed down the offending portion of the da… -
Secured List Views: For any information related to SLVs please raise a Service RequestSummary: I raised an SR some days ago asking for some additional information on Secured List Views (as instructed by Doc ID 2708546.1). I got this response: Your questio… -
Pull birthdays in the next 90 days in OTBI.Summary: Hello all, How to pull birthdays in the next 90 days in OTBI. The logic I currently use is to pull birthdays that fall between WEEK OF YEAR ( CURRENT_DATE) and …
-
List of Seeded Reports for Oracle HCM CloudSummary: Hello, Is there a place where Oracle list out all of the seeded reports they provide? Content (required): Version (include the version you are using, if applica…Emily Cox 4.5K views 5 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to calculate Age with Person Date of Birth and Effective Date variableSummary: Calculating Age using Person Date of Birth and the Effective Date variable based on a date entered in the prompt. Content (required): I need to calculate Age us…GJ79 603 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM