Category 81
Discussion List
-
Move to HR blank in analysisSummary: Move to HR blank in analysis Content (please ensure you mask any confidential information): Hello experts, we are creating a custom OTBI analysis where we need … -
How to fetch latest record in OTBI ReportSummary: Hello All, I am developing an OTBI report to fetch Person's Skills and development data. For this, i have used 'Workforce Management - Person Profile Real Time'…Amarnath Podaralla 41 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
DFF in termination under PER_PPS_DF which subject area can we report from?Summary: We have added a DFF to termination under PER_PPS_DF and would now like to report on it in OTBI, which subject area can we do this from? Content (please ensure y…Sharon Ferguson 20 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM
-
When we try to fecth the inactive employees data using OTBI we facing below the issueSummary: Hi Team, when we try create the inactive employees data we facing the issue that is suppose some of employees have mutlipule terimation relationships like 'X' e…AjayKumar Maddipati 54 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Error Codes: EKMT3FK5 Limitation of Pivot table in OTBISummary: I pivot 'Balance Name' (around 70 columns) and get this error message if I output too many records, I'm wondering how can I increase this limitation number for …Yiming Xiong 22 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Payroll HCM - What tables would show historic scale points and hourly rates for that scale point.Hi , I'm currently looking into a request from one of my colleagues asking if it's possible to have our Holiday Accrual report have the Hourly rate reflect March 2024 pa…Josh Dewar 11 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a way to see the Oracle tables & selection criteria used to generate Payroll Activity Rpts?Summary: Several of our BI Publisher payroll reports, which have successfully reconciled to Oracle Payroll Activity Reports for the same timeframes for the past five yea…BeachDreamer 14 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
Benefit Participant Eligibility Employment Assignment Category TableHi, We are trying to create a report to fetch Participant Eligibility information. But not able to figure out the Employment Assignment Category information. Can anybody… -
BIP Report Assistance - Transaction Console with Approvers (Job Requisition)Summary: Looking for assistance with creating a BIP report to audit pending actions from the Transaction Console. I found most of the information needed in the following…
-
How to pass NULL and All column values prompt values in logical sqlSummary: Hi, I have created a dashboard prompt but when I am passing values as NULL and All Column values in prompt analysis is showing no result. I have created analysi…Shreya Datir 46 views 18 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
How to add two subject areas event real time and performance real timeSummary: Hi Team, Any one help me on it's urgent requiremnt . How to add two subject areas workforce management—worker assignment event real time and workfroce performan…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
How can i get the results of a fast formula directly from a querySummary I have a complex fast formula and need to read the result of it through a query. Content (please ensure you mask any confidential information): Version (include …Farah Alajou 57 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Chage Default Timezone for a Time columnSummary: There is a need to change the timezone of a time column in one of the OTBI analysis to reflect UK timezone. Currently it has default UTC timezone. Content (requ…User_2025-07-18-16-26-02-907 61 views 4 comments 0 points Most recent by SimonTomey Reporting and Analytics for HCM
-
REQUESTED_FOR_PERSON_ID Foreign key for BI ReportSummary: REQUESTED_FOR_PERSON_ID Foreign key for BI Report Content (please ensure you mask any confidential information): Hi, we would like to create a report which prov…Barile Alberto 12 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Restricting Data for Direct reports of a Line ManagerSummary: Hi All, How do we restrict Line manager access to only his/her direct reportees Learning Items in OTBI Report. Can you let me know the steps ? Content (required…Veena P 63 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
HR_GENERAL.DECODE_LOOKUP not returning valueSummary: HR_GENERAL.DECODE_LOOKUP function is used in the BIP report to fetch the meaning of the lookup code passed. Content (required): HR_GENERAL.DECODE_LOOKUP functio…Meenakshi K 1.1K views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Adding a number format for OTBI reportSummary: I have created an OTBI analysis to get the grade related min, max and average values. Content (please ensure you mask any confidential information): The OTBI an…Ayesha Iroshani 174 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
We have long service award OTBI Report but need to show in performance tile viewSummary: Hi team, we have long service award OTBI Report but need to show in performance tile view chart by if we click the 5 years then need to show 5 years completed c…AjayKumar Maddipati 83 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
how to update position, job and location using hdlSummary: want to change employment data using HDL Content (required): I'm new to OTBI and want to change employment data for columns like Position, Job, Location. From w…
-
Missing a voided check in reportSummary: Missing a void check in pay_ce_transations Content (please ensure you mask any confidential information): Hi, One of our report to fetch a list of voided checks…
-
impact of scheduled HCM Extract and Reports during the maintenance or upgrade timeSummary: Customer has concern with scheduled BI, OTBI Reports and HCM Extract during the Maintenance window. What will happened with them. CRitika.ray-Oracle 12 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Phone numbers repeating instead of suppressing duplicatesSummary: Mobile phone and home phone number columns are repeating even though they are duplicates and the columns are set to repress. Content (please ensure you mask any…
-
How to get the self service url from course numberSummary: I have requirement to fetch "Self Service URL" which pops when we click Course Number in the Course Page. Sample URL : "https://fa-xxxx-dev3-saasfaprod1.fa.ocs.…Amrita_Pritam_Nayak 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Where is the LONG URL stored for candidate source tracking?Summary: I am trying to locate the LONG URL that is captured as part of Source information mentioned in the second paragraph of this oracle help document. Does anyone kn…MarkHodges 3 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Need assistance to get YTD balance using pay_balance_view_pkg.get_balance_valuesSummary: We are trying to get YTD balance using pay_balance_view_pkg.get_balance_values. I am using the attached query, but it is not returning any result, though employ…
-
Response ScoreSummary: Hi, Does anyone know where can I find the Response Score (if it is the correct answer - 1 or the wrong answer - 0) in OTBI? I've tried under Questionnaire Respo…Vasco 12 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
Workforce Performance - Performance Task Status Real Time showing incorrect assignment informationSummary: The Workforce Performance - Performance Task Status Real Time subject area seems to be displaying incorrect assignment information for employees that have had t…CClark30 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Dashboard prompt is not workingSummary: Hi, I have created an analysis using logical sql and passed parameter i.e. presentation variable inside logical sql. But when I am using dashboard and dashboard…Shreya Datir 43 views 5 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
What is the OTBI Subject Area for State Wise Minimum Wage?Hi Team - Can anyone please let me know the OTBI subject area for State Wise Minimum Wage. The DB tables for the same are PAY_VALUE_DEFINITIONS_F and PAY_RANGE_ITEMS_F. …Ramya Rajendran 22 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to pull latest termination date AND/OR null term date based on Person Number & Latest AssignmentSummary: I'm using an OTBI report to pull a distinct count of # of employees at a specific location between two dates. This report includes fields like Job Name, Hire Da…CGardner01 207 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM