Category 81
Discussion List
-
Rating Subject Area showing future cost center instead current cost center informationSummary: Workforce Performance - Performance Rating Real Time Subject Area showing future cost center instead current cost center information Content (please ensure you …VarunG 13 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Data is not fetching When I add Column: PER_ASG_DF_DESC_UNIT - Worker Assignment DetailsSummary: No records are fetching when I add Column: PER_ASG_DF_DESC_UNIT - Worker Assignment Details from Workforce Management - Worker Assignment Real Time with another…sayeed_ahmed 26 views 9 comments 0 points Most recent by sayeed_ahmed Reporting and Analytics for HCM -
Does BI Publisher allows dates in dd/mm/yyyy format?Summary: Does BI Publisher allows dates in dd/mm/yyyy format? Content (please ensure you mask any confidential information): I see only these formats: I need dd/mm/yyyy …Stefano_Mazzocca 48 views 5 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
ORC - Answers to open questions not visible in analysis with Subject Area 'Recruiting Real Time'Hi, We can't seem to pull the answers from open text questions (prescreening) into a report using an analysis based on the Subject Area 'Recruiting Real Time'. We use th…Natalia_Leemans 11 views 2 comments 0 points Most recent by Natalia_Leemans Reporting and Analytics for HCM
-
Unable to list just one manager for each Matrix Manager TypeSummary: We have a report that provides employee details AND includes each manager type i.e. Line Manager, Comp Planning Manager, and Timeclock Supervisor. When we run t…Darrin N 15 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a way to include historical source information?Summary: Candidate Pool Reporting - historical 'Source' data Content (please ensure you mask any confidential information): We are building a report on candidate pools a… -
How to get "Person Type" and Assignment Details from Fusion TablesSummary: Hi All, We are seeing a difference between the "Users license Usage" numbers in the Usage reports for HCM Base cloud Licenses and number of "actual user report …
-
Alert based on Assignment StatusSummary: is there any way we can add this field assignment status in filter criteria under alert composer. Content (please ensure you mask any confidential information):…
-
how to send a custom email when employee submits resignationwe have a requirement to send an email to employee when he submits resignation and also we need to send another email as resigantion approved to employee with the custom…Dara Nagasai 16 views 2 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM -
job history reporthi Experts, From the below table I am able to get only the history of past one month. Does anyone now the table names to get the report for more than month ? fusion_ora_…Nivya Mathire 37 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Export audit logs through OTBI\BI publisherHi, need assistance on how to pull mass audit logs from the OTB?I\Bi publisher. thank you in advance.Gal Shani 43 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Course CategorySummary: Hi, Do you know where can I find the course category either in BI Publisher or in OTBI? Content (please ensure you mask any confidential information): Hi, Do yo…
-
Query for Person Security Profile ReportHi team, we need a person security profile report. can someone help me to provide the query of this if anyone has already gone through this type of requirenment. Thanks!Pushpendra Patle 16 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
OTBI: Prompt Link not workingHello All, When prompt link is generated either from edge or chrome browser it error out as Bad Gateway. Any help would be appreciated! Thank you.Gail Wilmoth 24 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Managing Bounce Back EmailsHi everyone, We are looking for ways to manage email bounce backs when assigning Surveys to a large group of employees. The purpose of this requirement will support the …
-
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou…Rich R 1.4K views 28 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Migrating OTBI reports from test to production environmentsHello, We are in the process of implementing Oracle HCM system and have created OTBI reports in test environment that we need to move to production. Our implementation p… -
Extract Development Goal Learning and join with employee goal report (SQL Query)Summary: 21D new learning section - Extract Development Goal Learning and join with employee dev goal report Content (required): Dear All, Would like to know, how to ext…Saadh Abi Vakas 202 views 4 comments 0 points Most recent by User_2025-11-28-00-58-48-932 Reporting and Analytics for HCM
-
Query for getting learning details of Development Plan GoalSummary: Please help with getting the query of learning details in the Development Plan Goal under Career Development Area.User_2025-11-28-00-58-48-932 7 views 1 comment 0 points Most recent by User_2025-11-28-00-58-48-932 Reporting and Analytics for HCM
-
Talent Profile report not printing few valuesHi, I am looking to extract license and certifications, career preferences values in print profile Navigation: My career->My profile->skills and qualifications -> action…
-
OTBI Report to get Activity Status value "Required"Summary: can anyone have OTBI Report to status of Activity in course - Learning Module Navigation for Requirement My Team>Learning>>Worker name>Course title>>Enrolment T…Rajdeep Chavda 14 views 2 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
How to get distinct record for Dimension field in OTBI just like SQL?Summary: Any DISTINCT function that can be used in OTBI to get distinct Dimension record just like SQL ? Content (please ensure you mask any confidential information): A…Pradnya_Pampatwar 463 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to get Salary Transaction entered by Name from Salary Transaction entered by for a Person NumberHello Everyone, I am using "Compensation - Salary Details Real Time" subject are to build a report. This subject area already holding a field "Salary Transaction entered…Ranjubala Pradhan 26 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
previos salary after correctionSummary: Content (please ensure you mask any confidential information): Hi all, I need to fetch current salary and the previous one, when i do it on the regular way - it…Hadassah Friedman 5 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Query to extract ElementEntry SourceSystemID and ElementEntryValue SourceSystemIDSummary: Content (required): Hello experts, do you have a query to extract ElementEntry SourceSystemID and ElementEntryValue SourceSystemID? We need to recover both keys…Valerio Curzi 49 views 4 comments 0 points Most recent by Raju Sandepogu-Oracle Reporting and Analytics for HCM -
Direct join between Benefit and Element tables issueSummary: Hi, I am building a report where I need to show the CONTRIBUTION_PERCENTAGE (BEN_PRTT_RT_VAL.ANN_RT_VAL) from Benefit and CONTRIBUTION_AMOUNT (pay_element_entry…Ranjubala Pradhan 92 views 3 comments 0 points Most recent by Ranjubala Pradhan Reporting and Analytics for HCM
-
When adding field to my report, the Matrix Manager values are being eliminatedSummary: I have a report that includes both Worker Assignment Real time and Compensation Salary Detail subject areas. I have been able to add all desired fields successf…Darrin N 39 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Not getting the proper charts on the user defined logical sqlSummary: I have written a sql statement by performing a left join between two subject areas. Have got the desired output. However am note getting the expected outcome wi… -
Absence Date End problem with clock change in OTBISummary: During British Summer Time (BST) (GMT+1) the Date End of an absence has a time stamp of 1am the next day. So 01/05/2021 00:59 not 30/04/2021 23:59. Content (req…Robert Craske 47 views 4 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
Is there a table or view that contains goal names before approval?Summary: Is there a table or view that contains goal names before approval? It seems that HRG_GOALS contains the information such as GOAL_NAME, SUCCESS_CRITERIA_TEXT, LO…S.Watanabe0110-Oracle 62 views 5 comments 0 points Most recent by S.Watanabe0110-Oracle Reporting and Analytics for HCM