Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
How do I report on only the most recent assignment (active or terminated)?Summary I need to build a report of all employees and only want the most recent assignment to appear on my report.Content Hi all, Does anyone know how to report on all t… -
Managers on a Leave of AbsenceSummary Managers on a Leave of Absence reportContent Hello, I am trying to create a report that will show managers, the managers Assignment Status (to be used to determi… -
Element result report - explanationSummary How the Element result report is designedContent Hi All, Can anyone elaborate me how the Element result report is designed. I am able to understand the Extract's…
-
Which Subject Area holds the EmailAddressIdContent Could anyone tell me which subject area I can find the EmailAddressId? I need this to update email addresses through Data Exchange for the full version of HCM Da…
-
Convert numbers to Arabic in wordsContent Hi, We have a requirement to convert salary numbers to Arabic. How can we achieve this? Is there any possible way in BIP or rtf template? Regards, Nivya Version … -
Need a report to get all the fast formulas in the system along with formulaSummary Need a report to get all the fast formulas in the system along with formulaContent Need a report to get all the fast formulas in the system along with formulaVer… -
Headcount vs. Head Count DefintionsSummary There are at least 14 different headcount presentation columns in OTBI - when do you use whichContent I am new to OTBI and trying to understand when one would us… -
Change Details: Assignment view - location of data behind this viewSummary Looking to create a report or analytic showing Old Value and New ValueContent Hi. We are new to Oracle and to Oracle reporting. When we go into Person Management…
-
Educational Major meaning in OTBISummary Only code is available in Person ProfileContent Hello Everyone!I need your help again. We are building and Educational report and the Major information a code ("… -
Row numberContent Hi How to display row number in BI Answers , I am using Rank function but if any duplicate values comes then it does not gives me correct values. Thanks Rajesh
-
Oracle Fusion Application - Usage StatisticsSummary Oracle Fusion Application - Usage StatisticsContent Hello, Can anyone please help me to capture usage statistics on Oracle Fusion Applications? I was using one o… -
SQL to get Level 1,2,3,4... for an employee?Content What is the SQL (Not analysis) to get the different department levels for an employee? -
Absence taken between two datesContent Afternoon all, I've trawled these forums and have scoured the report Sharing Centre and cannot find something which i thought was an easy ask: I have an absence …User_2025-01-28-05-39-23-766 131 views 2 comments 1 point Most recent by User_2025-01-28-05-39-23-766
-
Bargaining Unit (Name) - Table and Column ?Content Hello Everyone, I'm trying to build a BI Publisher Report (complex requirement therefore cannot utilize OTBI) and I am requiring Bargaining Unit field, or to be … -
Error when Filtering Logical SQL Report off OTBI ReportSummary Obdc Driver Error when filtering based off OTBI ReportContent Hello, I'm currently trying to filter a logical SQL changes report based off an OTBI Analysis that …User_2025-01-31-00-25-12-234 48 views 3 comments 1 point Most recent by User_2025-01-31-00-25-12-234
-
Limiting Results of Reports Based upon Data Security Level DefnintionSummary Limiting Results of Reports Based upon Data Security LevelContent We have custom HR roles which limit some users from functions and AORs used for approvals. Is i…
-
probation confirmation Letter automation in oracle fusion HCMSummary Probation Confirmation letter Automation in Oracle fusion HCMContent Hi Team, I have to create the bursting report, in which whenever probation status for an emp…
-
Probation Confirmation letter Automation in Oracle fusion HCMSummary Probation Confirmation letter Automation in Oracle fusion HCMContent Hi Team, I have to create the bursting report, in which whenever probation status for an emp…
-
How we can export data from Infolets ?Summary If a table is displayed at expand view and we need to export it. Is there any way ?Content Hi All, We are displaying the data of manager reportees on the expand …
-
Significance of default Data Source 'AuditDB' in BI PublisherContent Hello What is the Significance of default Data Source 'AuditDB' in BI Publisher while creating the new data set. My Oracle Cloud Application is: 19A (11.13.19.01… -
REPORT EMAIL DID NOT RECEIVEDSummary REPORT OUTPUT DID NOT RECEIVED VIA EMAILContent Hello, We have existing BIP report job which runs and deliver report output via email. And today few customers re…
-
Row disappearing in the output of RTF when the XML group tag is not thereContent Hi All, I have built one RTF template and have 5 fixed absence plans. If any of the plans is not there then the row is not appearing in the output file. My requi… -
Need OTBI RpdSummary Need OTBI RpdContent Hi , I believe if we install BI Apps (OBIA) we can get RPD which has OTBI subject areas. Can some share OBIA/OTBI Rpd. I am mainly looking f…User_2025-01-29-21-55-25-526 38 views 5 comments 1 point Most recent by User_2025-01-29-21-55-25-526
-
Dashboard prompt returned error (Failed to load (Odbc driver returned an error SQLExecDirectW).)Content Currently I am using SQL Results option to populate value of a dashboard prompt called "Global Job Band".I am using below SQL code for this : Select SUBSTR ("Gra…User_2025-02-04-22-00-05-391 46 views 2 comments 1 point Most recent by User_2025-02-04-22-00-05-391
-
Employee Self Service: how do you show employees their salary history?Summary Employee Self Service: how do you show employees their salary history?Content Hi, Our team would like to display an employee's own salary history on the Personal…
-
Minimum Wage and Salary AuditSummary Is there a report or a way to mark employees as non-compliant with minimum wage and minimum salary.Content Hi, Has any one ever created a minimum wage/salary rep…
-
Need Table name to pull the Order Entry in Time and LaborSummary Need Table name to pull the Order Entry in Time and LaborContent Hi Team, Need Table name to pull the Order Entry in Time and Labor. highlighted the required fie…User_2025-02-04-07-00-18-658 26 views 2 comments 1 point Most recent by User_2025-02-04-07-00-18-658
-
HDL Loader issueSummary HDL Loader sample for balance group migrationContent I am looking for a sample for performing the balance group migration using HDL, we have a balance group with…
-
Report LogContent Anyone have an xml they would be willing to share or recommendations for creating a 'master' report that returns a list of all the BI reports in order to audit a…
-
OTBI Need subject areas with Representative Name to be pulled into reportContent Hi Team, We have captured HRBP in the representative section of Manage Employment. Now I want to capture that information in my OTBI report. But I am not able to…