Category 81
Discussion List
-
Goal Task detailsHi, Which Table or subject area contains goal task details? Regards, NivyaNivya Mathire 34 views 5 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Facing the issue in below BI report query error is single row subquery returns more than one rowSummary: HI Team, We have report I'm facing the issue when i run the report or scheduled the report i'm getting below error but I'm unable to find the issue ? ERROR : OR…AjayKumar Maddipati 42 views 7 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Data issue- OTBI AnalysisSummary: We have an OTBI analysis to capture benefit details and I noticed that it's providing information for one legal entity although are three legal entities added i…Ayesha Iroshani 43 views 13 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM -
Creating a Report in OTBI for New Hires, Name changes, LOAs, and TerminationsSummary: Hello, I need to create a report in OTBI for New Hires, Name changes, LOAs, and Terminations but I am unsure if this can all be on one report or if I would need…Latia 62 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Oracle BI analysis - Relative deep links in interaction actionsSummary: Relative deep links in interaction actions Content (required): We are trying to add relative deep links to a big number of performance counter tiles. How can we…
-
BI Publisher RTF template with Excel output merging rowsSummary: I have a HCM Extract which outputs as Excel via an RTF template. However on the output it is merging 3 rows for each row of data (see below screenshot). Does an…
-
Custom SQL reports don't return data in another language anymoreSummary: Four users with the same security roles and Area of responsibility ran a report. 2 English-speaking users saw data, while the 2 French-speaking users no longer …
-
SQL Query to display OTL Calculated Hours/Reported HoursPlease I want a query or tables to search in to get the reported hours and calculated hours, except for those tables (HWM_TM_REC , HWM_TM_REP_ATRB_USAGES ,HWM_TM_REP_ATR…Muhamad 713 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Ethnicity causing Workforce Trend SA to produce inaccurate headcountWhen adding ethnicity to the Workforce Trend SA it causes the Period Start and End headcount to double/triple for those that have selected two or more races. I have atta…Andrew Mc 23 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to identify a merged person record in the Oracle Fusion HCM Cloud databaseSummary: When querying the database for person records, I want to exclude merged records from the output. How do I identify merged records in the table? Content (require…
-
How to show Other compensation in the Job offer through OTBISummary: Unable to show Other compensation (Individual Compensation) present in the Job offer in OTBI. Content (required): We are unable to show Other compensation (Indi…Sujay Bhowmick 31 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
People review meeting How to identify the Metting submitted by HR or manager, Whic table we can see?Summary: i have created one people review meeting. i have added 2 employees' population and 2 reviewers' manager. i have logged in as 1 manager and submitted the meeting…challa praveen 21 views 0 comments 0 points Started by challa praveen Reporting and Analytics for HCM
-
Capture the Course and Offering StatusSummary: I need to capture course status and offering status. I have a requirement where I need to capture course status and offering status of the relevant course. Cont…Sanduni Pathirathne 11 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
We need department and cost center details with effective state date in BI or OTBISummary: Hi Team, we need department and cost center details with effective state date. i tried in worker assignemnet real time but no effective start date. only two clo…AjayKumar Maddipati 33 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
"Number of Job Application changed to..." Code NeededDoes anyone know the code behind the following columns? For example, when viewing the numbers, the highlighted "Number of Job Application changed to Job Offer Phase" fie…
-
Why does the audit table PER_PEOPLE_EXTRA_INFO_F_ return no value?Hi all, I need to audit the PEI_INFORMATION1 field of the PER_PEOPLE_EXTRA_INFO_F_ table. I configured everything as stated in this document (https://support.oracle.com/…VincenzoCoppola 103 views 6 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Need a query which show all pending transactionSummary: Hi Everyone, I need a query in which we can show all pending, stuck transactions along with the person's name and approvers' information. Like, the document pro…
-
OTBI Report for Department ChangeSummary: Hi Team I want to create the department report ,where employee's department changed from any department to a specific set of department. Report to pull both the…R Hemavathy 94 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI - Pull up Job before Effective DateSummary: Making an OTBI report where I need to pull up historical data Content (required): I'm working on a retirement report using OTBI, (which I am completely new to).…SeanWesche 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Still we implemented Query level RTF templates, how can we implement in RTF level changesSummary: HI Team, Still we implemented Query level RTF templates, how can we implement in RTF level changes as per requirements . Any on help me on to learn RTF level . …AjayKumar Maddipati 31 views 3 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Join subject areas Human Capital Management and RecruitingSummary: How can I join the two subject areas below? Human Capital Management - Transaction Administration Real Time AND Recruiting - Recruiting Real-time Content (requi…
-
OTBI: Hidden Scheduling AgentSummary: I can't seem to find some currently running scheduling agents Content (required): Hello, In OTBI, I get 2 running agents I don't see. Others I see, but not thes…User_2025-07-18-02-04-51-132 22 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
How to get values entered in termination transaction details?Summary: How to get values entered in termination transaction details? Content (required): Hi Team, Greetings! Termination transaction initiated by the manager or HR Sup…Parag Hiremath 257 views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
What filtering should be used to show Active for a specified assignment category AND show terms...Summary: Using Subject Area WFM - Worker Assignment Real Time, I have a report that is required to show details of Active Limbo employees AND show terminations within th…
-
How to identify when a Job Code was last assignedSummary: We are working on cleaning up job codes. There are many active job codes and we don't want to inactivate them until we know when the last time the job was assig…
-
RTF Template with Excel Template AlignmentWhat would be the best way to get the good alignment when using RTF and output is Excel. We have more number of columns ...Example see the date of birth. The same way it…
-
How to add AVG formula to PivotSummary: Using Subject Area Payroll - Payroll Balances Real Time to pull worked hours by date paid. The requirement is to display both Total YTD Hours and Average Hours …JHaden3 23 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Correct sorting of report in sql queryHi, I want to sort the numbered numbers in the sql query I wrote. but when I want it to be sorted as 1,2,3.., it is sorted like 1,10,11. I'm having trouble with two-digi…Cansel Karasoy 24 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Query to fetch count of colleagues for whom balances have got loaded into systemSummary: After execution of "Load initial balances" job in system as part of HDL upload of balances. Now I need to know for how many colleagues balance information is lo…
-
Master data historySummary: Looking for an Audit query, which shows old and new values of master data. Content Hi I am looking for a query to track changes in Master data (Position, Locati…