Category 81
Discussion List
-
Payroll query that fetches results only if for the Employee Generate Payslip flow is not run.Summary: I need to create a BI report which retrieves Employee Information of the users along with other Common columns also needed to see if whether is employee get pai…Ketan-Oracle 5 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,… -
HCM OTBI subject areas to database lineage mapping spreadsheetSummary This spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Dev…Raghavendra Raghunath-Oracle 36.9K views 177 comments 124 points Most recent by User_GDABQ Reporting and Analytics for HCM -
Remove Manager role from Worker self-evaluation Performance TaskSummary: Hello, I need help to check if my case statement below is correct. I encountered errors several times so I'm not sure what is the problem with this. I want to i…Marilyn O 8 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
What is the role of the Manager in Self-Evaluation?Summary: Hello, I'm currently working on Performance Task Status Report for my organization. I've changed the Role to Task Assignee. In the Worker Self-Evaluation, there…Marilyn O 13 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Unable to pull salary amount into OTBISummary: Hi, I am currently building an OTBI report and I am unable to pull the Salary Amount into the report. The report is crossing multiple subject areas and I have i…
-
hide an RTF hyperlink field on notification report conditionallySummary: Hi forum and BI Publisher Experts: i wish to hide a URL hyperlink only when ( 2 ) previous data model person number values (will not be shown on report) are equ…
-
Workforce Goals - Goal Tasks Real Time 'Development Goal.description same as 'Task Name.description'Creating a simple analysis to report each development goal along with it's associated task(s) by using the Workforce Goals - Goal Tasks Real Time subject area. The 'Deve…Melody Herbert 8 views 2 comments 0 points Most recent by Melody Herbert Reporting and Analytics for HCM
-
REST API for Salary, Payroll elements and StocksSummary: Content (please ensure you mask any confidential information): Hello experts, do you know where retrieving REST API for Salary, Payroll Elements and Stocks? Kin… -
Talent Review Meeting Report-Security BIPSummary: How can we limit the visibility of the Talent Review Meeting Report so that facilitators can only view the meetings where they are assigned as a facilitator, wi…
-
Need to report the number of Goal plan assignees who have Goals Created/Not createdSummary: Hi peers, My client wants a report that gives a count of the number of employees that have created goals as well as those who haven't yet created (even a single…
-
How can I export list of delivered reports for fusion HCM?Summary: Where can I find list of core delivered reports for fusion HCM modules. Content (please ensure you mask any confidential information): Version (include the vers…
-
HCM report for monitoring access visibilityHi All, As a part of Executive and above (10,000+ employees) salary migration to the Fusion system, we are planning to introduce controls on salary visibility and access…Sachini 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What Oracle IP address(es) should be provided to recipients of reports via SFTP delivery option?Summary: We need to provide IP addresses to an external third party so that they can whitelist them in order to successfully receive BI Publisher reports directly from O…BeachDreamer 249 views 5 comments 0 points Most recent by Christopher Haupt Reporting and Analytics for HCM -
Name of the table that stores the 'Location Based Access' infoSummary: Hi, I'm trying to figure out the table name that stores the 'Location Based Access' info. Navigation: FA → Tools → Security Console → Administration → Location …ganapathysundaramd-Oracle 6 views 0 comments 0 points Started by ganapathysundaramd-Oracle Reporting and Analytics for HCM -
Report to trace the elements costed from Journal entries along with transaction numberSummary: Report to trace the elements costed from Journal entries along with transaction number Content (required): Hi Team, Greetings! Once the entire payroll cycle is …Parag Hiremath 19 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for ERP -
Employee time card punch in, punch out details SQL query in OTL fusion HCMSummary: Hi Team, We have a requirement to send notification to employees who has missed their time card punch in, punch out. Can anyone please help me with the sql quer…Prasad Singamaneni-Oracle 3 views 0 comments 0 points Started by Prasad Singamaneni-Oracle Reporting and Analytics for HCM
-
Fast Formula doesn't return expected valueSummary: Content (please ensure you mask any confidential information): Hello, we built the following FF where we should retrieve value from two different value sets. If…Valerio Curzi 21 views 3 comments 0 points Most recent by A_R-Oracle Reporting and Analytics for HCM
-
Newly created prompt by one user not seen for other userWe wanted all BUs to be by default selected when LM Dashboard is opened up. So we modified the existing prompt by removing the filter of selecting the topmost BU. When c…
-
To remove NULL row occurring due to CASE statementThrough OTBI report, trying to pull element entries having input value as STI Target %, Percentage only. So, put the following formula in the case statement: CASE WHEN "…
-
I'm unable to upload rtf template in report or it is showing uploading since long timeSummary: I'm unable to upload rtf template in report or it is showing uploading since long time. Content (please ensure you mask any confidential information): Version (…Anup Karmankar 6 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Overall Summary and Rating in Document of RecordsSummary: Does anybody tried to bring the Overall Summary and Rating details from Performance to a Document of Record? Is it feasible to add those in a DFF? Content (plea…GeorgianaB. 6 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle 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 19 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Can I report on whether learners have uploaded a file into their learning assignment?Summary: I'm trying to create a report that shows me which learners have uploaded a file into their learning assignment for a particular course. In their enrolment the l…
-
How to get the USER_NAME or USERID into default value of a data model parameterSummary: How to get the USER_NAME or USERID (or exquivalent) into default value of a data model free form string parameter Content (required): In a data model I would li…
-
HCM Transformation Fast Formula : Getting all Metadata for AssignmentWe are trying to develop Worker.dat which will include Workterm and Assignment Metadata why We are able to get all the required fields metadata for worker but somehow as…Ajitabh Kumar-Oracle 29 views 2 comments 0 points Most recent by User_VB3A0 Reporting and Analytics for HCM
-
SYSTEM_PERSON_TYPE not updated to CANCELED_HIRE after Cancellation of work relationshipSummary: We used to get the employees whose work relationship is cancelled after Hire (from Pending Worker to Employee conversion) by querying the 'per_person_type_usage…Sujay Bhowmick 49 views 6 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
What particular role or privilege needed to gain access to Manage Report Jobs page?Summary: What particular role or privilege needed to gain access to Manage Report Jobs page as well as the list of scheduled report jobs? Here's the example: -
Multi Language update to existing OTBI reportsSummary: Multi-Language: How would you create or update existing reports to pull in any language? Is there a way to update all reports simultaneously with the option to …