Category 81
Discussion List
-
Element HDL Template Generator ReportSummary OTBI report to generate sample files to create Payroll Elements using HDL Content Introduction: This report provides sample files to create Payroll Elements usin…Kaushik R-Oracle 9.4K views 127 comments 35 points Most recent by Lava Somepalli-Oracle Reporting and Analytics for HCM -
Human Capital Management - Transaction Administration Real Time subject area not workingSummary: We have a report reuqirement to fetch all workflow transactions whether completed or failed, and for failed transactions we need to populate th eissue title, is…Velidi Supraja 3 views 0 comments 0 points Started by Velidi Supraja Reporting and Analytics for HCM -
Query/table information to obtain issue description from transactions that end in errorSummary: need a way to report on Issue description, Resolution and Number from transactions that end in error. Content (required): When a transaction ends in error there…PrashanthGanji 303 views 11 comments 1 point Most recent by Velidi Supraja Reporting and Analytics for HCM -
User Adoption ReportHi, Has anyone implemented "User Adoption Report" in Oracle Fusion using Doc ID "Security Reports in Fusion Application (Doc ID 2210883.1)". After enabling the profile, …pradeep chandrasekaran 2 views 0 comments 0 points Started by pradeep chandrasekaran Reporting and Analytics for HCM
-
Action link for learningSummary: Need guidance to create action link for course learning report. I have made a learning report where course related columns are present, e.g. learning item name,…
-
Performance Calibration Module data in OTBI?What Subject Area is this data stored in? I'm specifically trying to extract the Calibrated rating. I've found all other data in our module setup with the exception of t…tim.glasheen_1073872 22 views 4 comments 0 points Most recent by tim.glasheen_1073872 Reporting and Analytics for HCM
-
SUBJECT_ID context in HRQ_QSTNR_PARTICIPANTS in case of use for Feedback CenterSummary: Hello, I'm building BIP report which should show Feedbacks from Feedback center where customer uses the questionnaire. I have SQL which returns me all questions…Martin Smid-Oracle 10 views 1 comment 0 points Most recent by Martin Smid-Oracle Reporting and Analytics for HCM
-
From which table can I check the scheduled report job?Hi, Which hcm table can I query to view the history of my scheduled report? I want to get the last run date of the report job from this table. I will be grateful if you …Cansel Karasoy 850 views 16 comments 0 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
Work Email is visible but Personal Email is blank for specific usersHi, We are experiencing an issue in Oracle HCM where a report that includes both Work Email and Personal Email behaves differently depending on the user running it. When…
-
extract element type id from xml cacheSummary: How to extract element type id from xml cache: When I try to extract the value , it is always throwing error : extractValue(value(ElementEntry), '//ElementTypeI…
-
Dynamic Date Prompts and SQL Setup for OTBI Workforce ReportSummary: Assistance needed with creating a dynamic OTBI report that allows users to enter date ranges for Assignment Details Effective Start Date and Assignment Details …ReiV 19 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Which table contains 'Collaborator' for Oracle Recruiting CloudSummary: Which table contains 'Collaborator' for Oracle Recruiting Cloud Content (please ensure you mask any confidential information): Hi, we would like to have a BI Re…Barile Alberto 15 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How can I force FND_FLEX_VALUES_TL to update to the latest values for Description?After updating the Name of Department from '60508-East Operations-508' to '60508-Operations-508' via Setup & Maintenance > Manage Departments > Update > Submit The FND_F…Matt_C. 12 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
BI Report for compensation budgetSummary: I need to develop a report with compensation budget aggregated by country. Content: In a BI report (I can't use OTBI) I need to show the following data: Country…Gian Luca Triglia 7 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
received error messages when running Missing Time reportsHi Team, As we are trying to run below delivered Missing Time Reports OTBI then we are getting below error. Could you please help to resolve the issue. ERRORChanikya Neelam-Oracle 18 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
DFF UniqIDSummary: Hi Team, tESTInstance/hcmRestApi/resources/11.13.18.05/recruitingUICreateOrUpdateJobOffers/{OfferId}/child/additionalInformationDetails/{additionalInformationDe…
-
SQL Query for Calculation Cards > Benefits and Pensions for Employees with Multiple AssignmentsHi Navigation: Calculation Cards > Benefits and Pensions I need help to find out how to join the Pension scheme back to the Assignment number/id for a BIP report. If not…Nilesh D Patel 12 views 0 comments 0 points Started by Nilesh D Patel Reporting and Analytics for HCM
-
From which tables can I get the Workflow details of transactions archived in transaction console.Summary: Tables to get the Workflow task details of transactions archived in the transaction console. Content (please ensure you mask any confidential information): Vers…JSAHOO1988 8 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
List of all Oracle ERP ReportsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Venkatesh Chittajallu 9 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development…Raghavendra Raghunath-Oracle 42.4K views 185 comments 127 points Most recent by Pedro Teixeira Reporting and Analytics for HCM -
Adding Learning Comments to Criteria is causing my analysis to fail to process ResultsSummary: I have a report using Workforce Learning - Learning Records Real Time that works until I add "Evaluation Questionnaire"."Answer Comments" to the Criteria. Then …Sherie Ross 18 views 3 comments 0 points Most recent by Narula Shray Reporting and Analytics for HCM
-
HCM Extract Parameter LOV values are blank and the parameter is made out of Value setsSummary: I am working on HCM to WACS OOTB. HCM Extract Parameter LOV values are blank and the parameter is made out of Value sets . Value sets are configured properly. P…Rajajeyakumar 22 views 7 comments 0 points Most recent by Shubham Raj-Oracle Reporting and Analytics for HCM
-
Information on scheduled processesSummary: How to get information what schedule process are scheduled through BI Report. With specific fields Content (please ensure you mask any confidential information)…
-
Tables Name to Access to the employee's Compensation historySummary: Tables Name to Access to the employee's Compensation history Content (please ensure you mask any confidential information): Hi, we are looking for the tables wh…Barile Alberto 16 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Report: Missing Seniority, Entitlement, and Vacation BalanceI’m building the Employee Vacation and Sick Leave Balance Report in OTBI with the following filters: Assignment Status is in Active – No Payroll, Active – Payroll Eligib…
-
Employees With or Without Goals Report - Missing dataSummary: Hello again, I need some help on my report. I need a report of Employees With or Without Goals. I created case statements for Total Employees, Goal Status (With…Marilyn O 41 views 2 comments 0 points Most recent by SAI KOMATIREDDY Reporting and Analytics for HCM
-
I am looking for a report to validate or find missing goals in PerformanceSummary: I am looking for a report where it has Employee number, Name, Performance Document Name, Goal Period Name, manager, and Goals Status(Has goals or No goals ) Con…SAI KOMATIREDDY 11 views 0 comments 0 points Started by SAI KOMATIREDDY Reporting and Analytics for HCM -
HCM Table for Transaction Audit Trail DataHello, how are you? I would like to know in which HCM table the audit trail from Diagnostic Log data of a transaction can be found. I tried the HRC_TXN_HEADER table, but…LeonardoNogueira 13 views 2 comments 0 points Most recent by LeonardoNogueira Reporting and Analytics for HCM
-
Learning reports / dashboards - any good examples to share?Summary: Any learning reports or dashboards that people would like to share? Content (required): My company is moving from managing all training administration on spread…
-
how we can assign multiple shift work schedule to another employee in UISummary: We have created work schedule with different shifts as Morning night and afternoon for four hours likewise. If work schedule is assigned to one employee and if …Balaji Vijayakumaran 6 views 0 comments 0 points Started by Balaji Vijayakumaran Workforce Management