Category 81
Discussion List
-
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 51 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 121 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 71 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 11 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 71 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.2K 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 221 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 viewThere was an error rendering this rich post.AjayKumar Maddipati 81 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 11 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 1 view 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 11 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 51 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 21 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 281 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Selection Process Internal vs External - OTBISummary: Hi Expert, I have a requirement to show no application to the respective phase name and with the filter criteria month, year, and candidate Selection process na…
-
Duplicate lines of data for employee in Worker Assignment Real TimeSummary: I have developed an analysis export which brings all current assignment data for an employee based on the Worker Assignment Real Time subject area. However, the…Dan_Hinsley 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
We are taken the backup of BI report before cloning but now unable to edit the reportSummary: Hi Team, We are taken the backup of BI report before cloning but now unable to edit the report and I'm able to get below error ? PFA. Thanks, Ajay Content (plea…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to use 1 common filter for graph and tableSummary: Hi Experts, I created an OTBI analysis and want to add one common filter for graphs and tables. Can someone assist me with how to use all filters for both? Than…
-
Reporting: Active on a requisition within candidate pool reportingSummary: We have a candidate pool report utilising 'Recruiting Events Real Time' Subject Areas which lists all candidates in our Pools, their current state/phase, prefer… -
Need to edit the NewHireReport data model to include the SecurityFinal tableSummary: In the AssignmentChangeReport datamodel (EmploymentUpdateProcess), there is a table called "SecruityFinal". This table provides the following data (see below) o…
-
Job Change ReportSummary: I have a Job Change report that I was sent and I need to add a few fields to it. It was built in Logical SQL and I'm having trouble adding a few fields. Any hel…