Reports
Discussion List
-
can we use fetch multiple columns using single case statementHi Team, i am using the case statements as below to retrive the data for a single person but it is giving me the 4 rows for same person is there any way to group them al…Chetana Pawar 21 views 1 comment 0 points Most recent by Swathi Shetty Reporting and Analytics for HCM -
Costing of PositionContent Hi All, I am trying to get the Costing of position in SQL query. Does any have the SQL which can give the costing details of position. Thanks,Misbahul Khair-266763 429 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Journey report - display 'Saved as Draft' status in the reportHello, Related to Journey, I want to create a report that shows the task's progress status for each performer. In case of the performer saves the task as "Saved as Draft…Liran 23 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
Certain Term'd EEs not displaying in Transaction Accuracy Audit ReportSummary: Using the Transaction Accuracy Audit Report from the Powered Reports and Analytics/Human Capital Management/Workforce Administration folder in the Reporting Cat…CGardner01 1 view 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
Days of service calculationHi Team, I am using "Workforce Managemnet - Work Relationship Real Time" subject area and I want to calculate "Days Of Service" only for Terminated employees. I want to …Raghu_Nandan 21 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
How to get Collective Agreement detail from Workforce Management - Worker Assignment Event Real TimeSummary: Before 24A we were able to get the Union member and bargaining unit on our analysis from collective agreements folder of Workforce Management - Worker Assignmen…
-
OTBI Report: Worker Number nullSummary: In a custom OTBI report, starting from this month, suddenly the Worker Number, from "Workforce Management - Work Relationship Real Time"."Work Relationship Deta…Gian Luca Triglia 15 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get the Name equivalents of RECRUITING_LOC_HIERARCHY_ID and RECRUITING_ORG_HIERARCHY_ID?I'm trying to get the Recruiting Type, Recruiting Location Hierarchy and Recruiting Organization Hierarchy from the Areas of Responsibility - Scope section, but I only h… -
In person HCM Cloud OTBI Workshop at Oracle Reading UKContent In the last few years we have been running a popular HCM Cloud OTBI Workshop in EMEA to help customers get the most from their investment in HCM Cloud. We plan t…Julian Challenger-Oracle 54 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report to get cost center and account from time management (OTL)Hi Experts, I have an requirement to fetch Cost center and account from time management page. Please check below navigation and Image to identify requirement. My Client …Rajdeep Chavda 11 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Query or table to get the employee work schedule as of the leave start dateSummary: Hi Every one, Do any one have any query to get the employee work schedule as of the Leave Start date . The requirement is when employee applied the leave, I nee…Charan Kollipara 704 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Is it possible to present the data from first table as shown in second table using BI Report?Summary: This is the sample data we have and need to present as shown n Table 2 ****_ID ACTION_CODE REASON_CODE PERSON_ID EMP_TYPE ****_SEQ EFF_DATE PRIMARY_FLAG STATUS …Amit Mundlye-27103 21 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
HardCode a Value in OTBISummary HardCode a Value in OTBIContent Hi Team, How can we hardcode an LOV value of a field in OTBI analysis? Any samples or query with case? Thanks much. Regards, Kaly…Kalyani Koylada 96 views 2 comments 0 points Most recent by Raquel Herrera Reporting and Analytics for HCM
-
Get current and future termination EE records in OTBIHi, We are trying to build a demographic file that should pull the data of EEs as of system date and also future terminations in next 7 days. I have tried using the pref…
-
Observation Checklist Link not found in Oracle TablesHow is the observation checklist link/URL being created or generated to use for notification? Can it be found in Oracle tables? Where could the link be stored? Is there …
-
Analysis on section comments and development goalsHi, I'm trying to build a report that displays for each performance document, the manager section rating for a specific section and the development goal name and success…Catherine Abi Samra 11 views 0 comments 0 points Started by Catherine Abi Samra Reporting and Analytics for HCM -
Need a sample SQL for HDL Summary ReportSummary: I'm trying to create a HDL summary report, where I wanted to fetch the Submission Time, Finish Time and Elapsed Time which I'm unable to find the exact table. P…Sujeeth Chinta 23 views 4 comments 0 points Most recent by Sujeeth Chinta Reporting and Analytics for HCM -
OTBI parameter issueSummary: Hi Experts, I need some assistance. I'm working on the Talent Profile Report and wanted to capture all the details in one report. I picked up multiple values by…
-
Retrieve Person addressesSummary: Do we have any package function to retrieve the person addresses? Please share. Content (please ensure you mask any confidential information): Version (include …MilanMohanty 21 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
OTBI: How can we run a report with the previous month start and end dateSummary: How can we programmatically run an OTBI analysis report with the previous month start and end date? Content (please ensure you mask any confidential information…SUSAN SANDIFER 151 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Filter query using NVL not workingSummary Unable to save query when trying to use the NVL command with a logical sqlContent Hi All, I hope someone is able to help me with an issue that I am having. I hav…User_2025-02-04-08-51-08-912 86 views 10 comments 0 points Most recent by Tharuka Reporting and Analytics for HCM -
Recruiting OTBI Performance issueSummary: Hi Expert, I need your assistance. I'm trying to combine two subject areas 'Recruiting - Recruiting Real Time' and 'Recruiting - Recruiting Event Real Time' and…
-
Most recent date paidSummary: I have an OTBI report that runs every other Thursday pulling earnings. The Effective Date field uses the below advanced SQL filter to pull only the current date…
-
Filter command field greyed outSummary: Need inputs to enter value in the Filter Command in the FTP delivery option Content (please ensure you mask any confidential information): In the FTP delivery o…Visu 11 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
How to report on workers with termination date in last two monthsSummary: Content (required): I'd be grateful for some help with a filter on an OTBI report. The report is quite basic, showing employee name, person number, position, lo…Leanne W 814 views 7 comments 0 points Most recent by anusha chunduru Reporting and Analytics for HCM
-
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…
-
I need a query to get the attached images from HR document record and print it in RTF templateSummary: I need a query to get the attached images from HR document record and print it in RTF template Content (please ensure you mask any confidential information): Ve…Farah Alajou 31 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
In OTBI, how to set the filters to fetch data between the last 5 years to the current year?I'd like to create an analysis to fetch employees hired from the last 5 years up to this year based on "Worker"."Enterprise Hire Date". How to set the filters within the…Welsey 109 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Do we have usage reports for Document of Records categoriesSummary: Are there any reports that summarises number of documents loaded against document categories. Content (please ensure you mask any confidential information): Ver…Chandan Patel 31 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
IBAN with BIPSummary: Hi experts, we need to create a report with the Employee's Personal Payment method Details like IBAN and bank account info. Does anyone know how can I create si…Oriana L. 51 views 3 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM