Category 81
Discussion List
-
IBAN with BIPSummary: Hi experts, we need to create a report with the Employee's Personal Payment method Details like IBAN and bank account info. Does anyone know how can I create si…Oriana L. 52 views 3 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Position Costing with Incumbent ReportSummary: Does anyone have a report that includes both Position costing, with position number, and the position incumbent. We don't have the skills on the team to build a…Jenna Savage 135 views 9 comments 0 points Most recent by Jenna Savage Reporting and Analytics for HCM -
Tables used in "User Password Changes Audit Report"Hi team, would like to know the tables used in the User Password Changes Audit Report program and do we have any standard report for user account name changes in oracle …chandrakanth makam-Oracle 18 views 2 comments 0 points Most recent by Thomas De Leeuw Reporting and Analytics for HCM -
Query to fetch high performers termination countSummary: Fetch the count of high performers termination Content (please ensure you mask any confidential information): We have a requirement to fetch high performers ter…Hitha Harikumar 21 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM
-
Is it possible to report on payroll costing data with the position that the cost relates to?Summary: We have a business need to be able to separate out costs for a position change and to be able to report on them separately, but the data table only holds the as…
-
SQL query to fetch all postal codes and their corresposding county, city and state in US legislationHi All, I need an sql query to fetch all the postal codes and their corresposding county, city and state in US legislation. Please help Thanks. SowmyaSowmyaSk18 125 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
when the employee has signed the contractSummary: Hi experts, we have the following requirements: for all the employees it is necessary to retrieve info such as their person number and when they've signed the e…Oriana L. 13 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Management Levels on OTBISummary: We have Management Levels defined on Job definitions. (Screen shot attached). For a person we would need to capture the management levels against the job on the…Vibha Pandey - Oracle 52 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to deliver xml within body of email via BI Publisher?Content (please ensure you mask any confidential information): I understand this is possible by setting the delivery method as HTML via bursting, however is there a way …Luke.Findex 12 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
UK Payslip: Is there any approach to trigger payslip only for employees who have work email.Summary Payslip Process Completed with Warning : Many employees do not have email id and we are trying to send payslip as email through bursting option, in such scenario…
-
Index Match formular for OTBIHi all, I am after some help on a formular that works similar to an index match formula in MS Excel I'm after the Legal Employer value of Managers using the manager pers…Tina T 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query that retrieve Eligibility Profile from Benefit ProgramSummary: Hello! I need some help to finish some query, and it envolve Eligibility Profiles in benefit Program. Is there a table that I can get the Eligibility Profile th…Matheus Roberto 98 views 1 comment 1 point Most recent by Monica Vijayashanker -Oracle Reporting and Analytics for HCM -
Usability report by user across modules or applicationsHello Please, Is there a Dashboard or Report that can be run/access that can show the Usage Statistics per User across modules or applications that they have worked on. …Wale Odusanya 11 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Payroll element BI table where retrieving employee Assignment IDSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve for an employee the assignment id where a payroll element is loa…Valerio Curzi 13 views 3 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
DOR Report: How would I create a report that allows me to see DOR data by employee?I am trying to build a report that shows the following information for Document of Records, but the fields I add show no data. Would it be possible to know which fields …Jay_Brannan 90 views 11 comments 0 points Most recent by Jay_Brannan Reporting and Analytics for HCM
-
Blank Specialization Sections and Activities from Workforce Learning - Learning Records Real Time.Summary: When using the Workforce Learning - Learning Records Real Time Subject Area we are getting Blank values for the Specialization Sections and Activities. We are u…David Bean - BW 91 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Is it possible to add candidate Hire date using OTBISummary: We have a requirement to include hire date in the report. The intention of the report is to capture all offers that are created, even if they don't end in hire.…Christina Roy 3 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
concatenate error in otbi reportSummary: CONCAT(NVL(TO_CHAR("Worker"."days"), '0'), ' Days, ', NVL(TO_CHAR("Worker"."months"), '0'), ' Months, ', NVL(TO_CHAR("Worker"."year"), '0'), ' Years') i tried t…
-
Excel Template error 'Maximum active cells allowed in a template is 100000'Summary: Hi Team, We are trying to create a report using the Excel template since there are a lot of tabs expected in the Excel output. We are getting the error 'oracle.…Tanu Shri Patel 220 views 6 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
Would it be possible to further understand the HR Dashboard - Birthday Reminders tab?Can we have support on the following for this Birthday Reminders tab in the HR Dashboard? https://fa-eups-saasfaprod1.fa.ocs.oraclecloud.com/analytics/saw.dll?Dashboard …
-
HR Dashboard - Compensation Tab - Where to find where data is coming from and how to hide data?On the out-of-the-box HR Dashboard (Reporting > HR Dashboard tile), is it possible to know where this data is being pulled and if there can be an extract of the data? Th…
-
Send DOR attachments to employees Personal emailSummary: Customer wants to send the documents upload under a specific DOR type, into employees Personal email. Is it possible to fetch the document, tag in the email as …Siva Sankari N 52 views 3 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management -
OTBI - recruiting - recruiting real time > Job Application issueSummary: Hi everyone, I'm customizing the 'Applications by Requisition' standard OTBI analysis. Trying to add the candidate Interview feedback field in the current analy…Saher 22 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI report only showing an individual's supervisor and managerSummary: I have a requirement to create a report showing each workers named supervisor and line manager (mostly these are the same person, but in some cases they're diff…Rich M 50 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query that link Legal Employer to Reporting EstablishmentSummary: Hello! Good morning/afternoon/evening Customer Connect! I am in a need of a query that can list all the Reporting Establishment for a Legal Employer. Does anyon…Matheus Roberto 25 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Dashbord prompt issueSummary: Hi, I need assistance concerning the OTBI Prompt. I created a recruiting OTBI dashboard by combining two subject area subject areas in my report, 'Recruiting - …
-
Assigned Performance Document Manager not showing Assigned Indirect DocumentsSummary: I have created a dashboard that includes an OTBI report showing Performance Documents by When I run the report I can see all the Performance Documents assigned …Aaron Reynolds 13 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Direct and indirect reports in dashboard promptHi There, We have designed a custom dashboard with is using the subject area Workforce Management - Checklist Real Time. We have a requirement to display direct and indi…MadanMohan 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Token for Rejection NotificationSummary: Does anyone know where/how to find out the definition of a token? For example, we are trying to figure out what “${CEConfigurationSiteName}” means. Also I see t…Antonio Washington 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to add SQL based Dashboard promptSummary: Hi All, I am trying to add an SQL based Dashboard Prompt and facing the Error: Failed to load(Error during query processing (SQLExecDirectW). The SQL I tried to…Abhishek Bhaskar 70 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM