Category 81
Discussion List
-
Retrieving learner-submitted attachments through the BI reportSummary: I need to fetch learner-uploaded attachment details via the BI report from the specified path below. UI Path - Edit Assignment > Related Materials > Learning As…Sanduni Pathirathne 21 views 3 comments 6 points Most recent by Harikaran Ravikumar Reporting and Analytics for HCM -
Tables Containing Approval History with Approver Names and Statuses in Oracle HCMHi! Which tables contain the information from the Approval History section, including the names of the approvers and their statuses? Do you have an example query?LeonardoNogueira 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Headcount is different across Line Manager Dashboard and reportingSummary: Hi, I am having an issue at the moment where the Line Manager Dashboard is showing me 5.8k Headcount and 5.1k FTE, but my OTBI report is picking up 6159 active …GregoryKew 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absences created in Advanced modeSummary: It appears that the OTBI report splits out absences created in Advanced Mode onto separate lines by work week but gives the total absence duration for the leave…Stephen Jones 81 views 3 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM
-
Absence Detail AnalysisSummary: I'm looking to create an analysis which will show a detailed list of all absence entries in our system. I've created the following using Workforce Management - … -
Road map to upgrade BIP Excel 97 version to excel 2010HI Team, I am for road map plan to upgrade BIP Excel 97 version to excel 2010. Currently BIP excel supports 97-2003 version only. Most of the advance excel function like…shiva G1 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get list of tables that stored a data in oracle fusion hcmSummary: I am looking for list of table name that stored a data in oracle fusion hcm. Content (please ensure you mask any confidential information): Version (include the…Anup Karmankar 41 views 4 comments 0 points Most recent by MandeepGupta 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 461 views 8 comments 1 point Most recent by Sanskriti Gupta Reporting and Analytics for HCM -
Journey report saved to Document of Record through a Journey task is not showing any data in it.Summary: Journey report saved to Document Record through a Journey task is not showing any data in it. Why is the report that is being generated in Journey task not save…
-
Redwood Workflow NotificationsWe have custom workflow notifications currently still in the Classic UI. We are in the process of migrating all modules to Redwood. Please help us transfer the custom wo…
-
Workforce Management - Person Real Time.Person Legislative Information Education Level doesn't showHi We have OTBI report which doesn't show Education data. We use Person Real Time.Person Legislative Information subject area. In application user can see the data. What…
-
Group similar columns together in bip report either through report editor or rtf templateSummary: We have a requirement to build a performance report in BIP to bring all the similar worker and manager comments in single row instead of the rows being repeated…
-
when I scheduled OTBI report through agent it's failingSummary: Hi Team, when I scheduled OTBI report through agent it's failing. Thanks, Ajay Content (required): Version (include the version you are using, if applicable): C…AjayKumar Maddipati 101 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Need SQL to extract Individual Compensation entries prior to approvalSummary: Need SQL to extract Individual Compensation entry values prior to Approval Content (please ensure you mask any confidential information): We need to report on I…SRIROU 231 views 5 comments 0 points Most recent by Prasad Singamaneni-Oracle Reporting and Analytics for HCM
-
Table names/SQL query for Individual Compensation details in HCMSummary: Hi All, Can you please share me the Table names/SQL query for Individual Compensation details in HCM. Thanks, Janardhana Content (required): Version (include th…Janardhana Kondaveeti 6.1K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Rate in OTBI Report displays as double the amountSummary: Rate in OTBI Report displays as double the amount Content (required): I created an OTBI analysis report to display information related to the salary history qui…Nick Henderson 144 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Getting insufficent privledges error when executing SQL in Data ModelWe are trying to create a report that shows bursting queries scheduled in our system. The code was found here: Document 2210437.1 The SQL code we are trying to execute i…Christopher Hitchcock 31 views 4 comments 0 points Most recent by Christopher Hitchcock Reporting and Analytics for HCM
-
Query to retrieve employees with Termination Date nullSummary: Content (please ensure you mask any confidential information): Hello experts, please, could you share a query to retrieve employees without past and future actu…Valerio Curzi 91 views 6 comments 0 points Most recent by Ashraya S.N Reporting and Analytics for HCM -
OTBI Report: Accrual Balance Based on Effective DateHello Experts, We have a requirement to extract accrual balance details using an OTBI report based on an effective date parameter. This effective date should be compared…Vasanthakumar Ravi 91 views 4 comments 1 point Most recent by Swapna Govind Reporting and Analytics for HCM -
In RTF Tag is not getting into BoldSummary: We are printing CTC - Salary amount in Offer letter all the amounts (Please refer to the table image from attachment) we need to make the Total Cost to company … -
Learn Module SQL Query to get assessment QuestionnaireCreated the attached SQL to fetch the Learn Module SQL Query to get assessment Questionnaire. But Questions Text and Answers are blank. What am i missing? https://us.v-c…Harish B Choctaw 41 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to Default Assigned Project to Web Clock and Time Card Based on Project Execution AssignmentSummary: Hello, In Oracle Time and Labor, we want the Project field in both Web Clock and Time Entry Layout (Time Card) to be automatically defaulted with the project th… -
SQL query or Table for Double Opt In Management in Fusion ORCSummary: Hi, Which table is having the information of the task "Double Opt In Management" or please provide query Content (please ensure you mask any confidential inform…
-
Can we have BI/OTBI Report to extract details to get data about privileges of the RolesCan we have BI/OTBI Report to extract details from security console to get data about privileges of the Roles as below: It should include Role, Privilege details and Inh…
-
Creating a report to show those exempt from Federal Income TaxI have a requirement to build a report that shows those who are exempt from federal income tax. I have searched through subject areas and data lineage and I can't find a…Sean-B-01 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How can we identify the columns for Employee comments and manager comments in the OTBI Report?The issue we're facing is that we are unable to locate the columns for employee comments and manager comments in the OTBI subject areas in order to retrieve the accurate…Vikas V. Kamat 101 views 3 comments 0 points Most recent by Thulasi Ram Reporting and Analytics for HCM
-
Interview Percepts feedbackDear team Hope you are doing well Could you please provide a query to retrieve the Interview Percepts feedbackManal Almutairi 1 view 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace
-
Is there a report available for all transaction across all module for leadership prospective ?Summary: We are looking at all transactional report, like which and how many employees click on view paycheck link from self service, who's clicking on other features av…
-
Transaction Console Job Requisition approval chain reportSummary: The user can't access the transaction console and through administrative tasks in BPM, they can see only their job requisition. We need a report to see the appr…