Category 81
Discussion List
-
OTBI report does not display data for a day because TC timezoneSummary: As per the Oracle white paper on Transaction Console, you can get up to 500 transactions in the downloaded csv file. It is a technical limitation that download …AmitSM 6 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Pending Action Items ReportSummary: I am attempting to create a report of all current pending action items in our system in OTBI. However, I seem to only be receiving completed action items and no…User_2025-02-11-20-55-10-551 22 views 8 comments 0 points Most recent by Sanskriti Gupta Reporting and Analytics for HCM -
Query to retrieve Union fieldSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve the employee Union name as in the attached …Valerio Curzi 14 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Table to get Absence plan details in Payroll element taskSummary: Hi Team, Could you please provide us the Table or SQL query for the input values of Absence plan details, Absence Payments, Accruel Liability and Balance Paymen…Opkey PA 16 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Oracle Fusion BI Publisher - RTF - Generate Multisheet Report Excel OutputSummary: Hi Team, We have a requirement where we need to generate an excel output with 3 tabs in the output file. Sheet1 name: Static value as "Parameter" and it has to …
-
Query required to fetch the fields - Resident PSD Code, Resident School District, Work PSD Code.Hi, Does anybody have a query that will fetch the fields - Resident PSD Code, Resident School District, Work PSD Code, Work School District. These fields are present in …SowmyaSk 442 views 9 comments 0 points Most recent by Rini_Varghese-Oracle Reporting and Analytics for HCM
-
query to get variable rate program for all employeesSummary: Content (please ensure you mask any confidential information): Hi all, I currently have a query where I am trying to get the variable profile name (under manage… -
I need help on my SQL for With and Without Goals ReportSummary: Hi, I hope someone can help me with my query. Only the employees "With Goals" are showing up. The employees "Without Goals" is not showing up in the report. I n…
-
How to Filter a Date Column by Another Date ColumnSummary: I have an OTBI analysis that is 3 subject areas. The goal is to show specific actions in Workforce Management - Worker Assignment Event Real Time, and then show…
-
Error Codes: OAMP2OPY:U9KP7Q94 - OTBI AnalysisSummary: We have a weekly Analysis that runs via Agent. After running many times without issue each week, we are getting these errors: OAMP2OPY:U9KP7Q94 - "An Unexpected…User_2025-03-07-06-07-08-189 1.2K views 8 comments 0 points Most recent by User_U5PJ2 Reporting and Analytics for HCM
-
While running the talent report the technical competencies are not fetching for one employee.Hi Team, Need assistance on talent report, the report not fetching the technical competencies for one employee. But when we run the data model the data is coming. Thank …xbyz-Oracle 3 views 1 comment 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
Recruit to Hire - Top 10 Openings per Job FamiliesSummary: Top 10 Openings displaying info, and not info active Content (please ensure you mask any confidential information): We are in the process of going live with Rec…
-
Oracle HCM Fusion Table to find Business capability in Oracle content ItemsDear Team, We are trying to fetch the business capability field from below navigation: Navigator > My Client Group > Profile > Item Catalog > Search for Skills Library >…
-
Report on Benefits Self-Service Enrollment actionsSummary: Looking for a way to report whether employees went through the Benefits Self-Service enrollment process thoroughly. For example, did an employee click on Enroll…
-
Benefits OTBI Subject Area for Plan ID, Coverage Amount and Age Grade Rate.Summary: Hi Team, I am working on the OTBI reports for benefits module. Kindly suggest me the subject area for below mentioned columns. Benefits Plan ID Coverage Amount …
-
Competency proficiency reporting - employee and manager ratingSummary: Hi there, I need help where to find the Employee rating for Competencies. The Manager rating is located in this folder "Workforce Performance - Performance Rati…
-
Query to fetch candidate personal email address and personal phone numberHello Team, Please provide SQL query to fetch candidate's personal email address and personal phone number. These details should be taken from candidate info/candidate t…Ooha Pranathi Akkala 67 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
BICC | Delta data records are not displayed correctlyHi, The BICC is to be used for the extraction of data. When testing the delta method, there are discrepancies between the status in the PER_ALL_ASSGINMENT_M table and th…Tobias I. 6 views 1 comment 0 points Most recent by Bala Mahalingam-Oracle Reporting and Analytics for HCM
-
Need to fetch the Content ID of HCM ExtractSummary: We have requirement to fetch the Content ID of HCM Extract through BI report. Any one have idea how we can fetch Content Id. Content (please ensure you mask any…Alpesh Sanghvi 3 views 0 comments 0 points Started by Alpesh Sanghvi Reporting and Analytics for HCM
-
In Oracle Fusion TEST, Profile Codes shown in front end but not in HRT_PROFILES_B table.Summary: In oracle fusion TEST instance, am able to see the Profile Codes for Talent Profiles in front end, but am not able to see it in HRT_PROFILES_B Table. Whereas I …Gopika Prem Kumar 13 views 0 comments 0 points Started by Gopika Prem Kumar Reporting and Analytics for HCM
-
Table for Time Type in TimecardWe have a requirement to fetch the time type from timecard. pay_payroll_time_type from hwm_tm_rep_m_ptt_atrbs_v is not returning any value. Could someone guide me on thi…
-
Looking for Table for Issue Description & Resolution in Transaction ConsoleSummary: Hi Team, I am looking for the table which store the 'Issue Description' & 'Resolution' details captures. I have tried in this table "HRC_CONSOLE_FAULT_DETAILS_V…Mohan Murali P-Oracle 266 views 13 comments 0 points Most recent by Venkat5678 Reporting and Analytics for HCM
-
BIP Output file is not moving to FTP ServerSummary: BIP Output file is not moving to FTP Server Content (please ensure you mask any confidential information): Hi Team, Greetings! We have observed that the file SF…Parag Hiremath 85 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
PVO that has attribute columns in per_location_details_fSummary: We are on FDI 25.2—looking for a PVO which has the attribute columns in the per_location_details_f table in Fusion. Content (please ensure you mask any confiden…
-
How do I convert the field Time.Month from CCYY / MM to just show the month?Summary: The Time.Year fields just displays the year The Time.DayofMonth fields just displays the day The Time.Month field displays the year and month. I need the Time.M…Mark Stoker 61 views 11 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM -
OTBI - Job Application direct URL in OTBIHi Team How to get the candidate's job application URL in OTBI?
-
Service Account not able to report on FeedbackSummary: We have a service account that we use for reporting purposes in OTBI. Typically, this account is able to pull accurate data across all Business Units. We discov…Megan Obiedzinski 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Where can we get the History of the Position for a report.Summary: I am trying to do a report for Position Details and trying to find the 'History' changes which can be found in the Position "Details" page just below the "Grade…
-
'Time type' field column mapping from which table to fetch itSummary: Hi All, We are creating one report to get the employee overtime unpaid overtime details. we are looking for 'Time type' field column mapping from which table to…
-
Time card details query in Fusion OTLSummary: Hi All, We are creating one report to get the Time card details. we are looking for 'Time type' and 'Override dept costing' fields. We couldn't able to find the…Sai Krishna Chelikani 4K views 7 comments 0 points Most recent by Sri N Reporting and Analytics for HCM