Category 81
Discussion List
-
BIP Query Job Roles and the roles assigned to themSummary: I'm trying to create a BIP query that shows me Job Roles and the roles assigned to them. I tried to create the report, but I can only get it to this point: sele…JaimeOrtega 122 views 4 comments 0 points Most recent by JaimeOrtega Reporting and Analytics for HCM -
Log details about user account lockSummary: Log details about user account lock Content (please ensure you mask any confidential information): Hello, is there any way to check why the account gets locked?…Bartek Barylka 21 views 2 comments 0 points Most recent by Bartek Barylka Reporting and Analytics for HCM
-
OTBI analysis for consolidated manager viewSummary: I am creating a manager dashboard comprises of performance, goals, feedback, check-ins and performance booster report. We need to apply a filter for manager whi…Techie 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
I want to add custom text in workflow notification which should be sent to initiator aloneSummary: I want to add custom text in workflow notification which should be sent to initiator alone.Is that possible? Content (please ensure you mask any confidential in…
-
How to convert RTF template file from LF to CRLFSummary: Convert file from LF to CRLF Content (please ensure you mask any confidential information): I would like to ask on how to use the CRLF in RTF Template. Is it li…MayCab 16 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Values being truncated at 240 characters in the non-Excel output formatsHow to address those values being truncated at 240 characters in the non-Excel output formats.Ronel M 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Balance trending reportWe have developed a Balance trending report for current & previous check dates. When we are running for a particular employee we are able to see data within 2 seconds, W…JanardhanP 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Building a BIP Report for User Access TrackingSummary: Dear Customer Connect Community, I hope this message finds you well. I am looking to create a BIP Report using standard SQL to track user access within specific…Matheus Roberto 32 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
User All Login Details within a specific periodHello Experts, Below query provides information on Last Login Date. For example, a user last logged in 1st Nov, this query will provide Last Login Details. However, is i…ImSt2509 102 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Payroll - Element Entries Real Time SA not returning car allowance Elements in the reportSummary: I have created an OTBI report with car allowance element entries for two Business units by using "Payroll - Element Entries Real time" subject area, each BU hav…Hitachi ServiceDesk 11 views 0 comments 0 points Started by Hitachi ServiceDesk Reporting and Analytics for HCM
-
Knowledge Search Efficacy DashboardKnowledge Search Efficacy Dashboard; I would like to know exact information since the details are not present in oracle docs. a. # of Clicks b.# of Searches with Clicks …
-
Employee displays in analysis for indirect leader they no longer report up toSummary: We've kicked off our workforce compensation cycle. I have an employee who changed managers earlier this year. The indirect manager they previously reported to i…Susan Anderson 21 views 2 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Excel Output Formats is not generating any data and file size is showing only 7 KBSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…sayeed_ahmed 11 views 1 comment 0 points Most recent by sayeed_ahmed Reporting and Analytics for HCM -
OTBI-How to combine Requisition other locations into one fieldSummary: I have created an OTBI report ( Subject Area :Recruiting -Recruiting Real Time) , and the Requisition Other Locations are displayed in multiple lines in output …
-
Encryption format supported by OracleSummary: The public key algorithm for this private key is not supported error while connecting to a FTP server Content (please ensure you mask any confidential informati…
-
SQL Query to fetch value set details with respect to modulSummary: Hi All, I want to fetch the value set details with respect to module, can anyone help me with table name or query? Version (include the version you are using, i…ShawShankk 343 views 1 comment 0 points Most recent by Deepak Deenadayalan Reporting and Analytics for HCM
-
Active Candidate Pools OTBISummary: Dear Community, We would like to create an indicator that counts all active candidate pools within our system. However, while exploring the Recruiting - Recruit…Giuseppe Iacono 2 21 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
OTBI report for finding position wise incumbants including candidates with Job offersSummary: We are looking for an OTBI report to fetch all incumbents of a given position along with candidates with active Job offers already given. This report will help …Pavan Kumar Thummalapalli 163 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
if we can run an OTBI report that shows when a password has been reset as well as an email updated?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Chandra Rao.D 21 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Write-back errorSummary: Write-back error - An error occurred while writing to the server. Please check to make sure you have entered appropriate values. Content (please ensure you mask…AM HRE 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Timing issue for an SQL querySummary: Content (please ensure you mask any confidential information): Hello experts, we built a query to retrieve the organization manager assignment id for a specific… -
Query to fetch the individual Manager Rating and Employee rating corresponding to each Goal.Summary: I am creating a custom report to get the employee and manager ratings for each performance goal. I got the summary ratings from table 'HRA_EVAL_RATINGS'. But fo…Rahul K-Oracle 921 views 2 comments 0 points Most recent by Jean Vishal Reporting and Analytics for HCM
-
Can someone please help, on where to find this value in oracle Tables?Hello can someone please help on where to find this field on HCM Table and Views? UI Navigation is Benefit Administration> Plan Configuration> Rates and Coverages> Varia…Joliver Caangay 11 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Report to get Original Date Earned of element entrySummary: Report to get Original Date Earned of element entry Content (please ensure you mask any confidential information): Hi Team, Greetings! Does anyone have the repo…Parag Hiremath 325 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Need sample query to fetch list of document records for dependentsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Mallikarjuna Reddy 1 view 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to get manager comments from absence approval notification in BI reportsHi Team, How to get manager comments from absence approval notification in BI reports We are searching for table name and field name that stores manager's approval comme…Anup Karmankar 31 views 1 comment 0 points Most recent by Florin Dumitru-Oracle Workforce Management
-
How to change 'TO' email address in workflow approval email notifications BIP TemplatesSummary: We have a requirement to change the "TO" email address when approving /rejecting workflow emails. We need to replace it with organization email address. Then it…Aditya Jena 31 views 2 comments 0 points Most recent by Venk Kudire- Support-Oracle Fusion Applications Administration -
OTBI filter show no dataSummary: Hello experts, we have a report for recruiting requisitions, but when trying to search in the values we get no data.. the list of values: SELECT DISTINCT IRB.RE…Lucas B Maciel 21 views 3 comments 1 point Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Need Join Condition column for tablesSummary: Hi team, I have two tables to join hrc_dl_message_lines hdml and HR_ALL_POSITIONS, where i need position code from HR_ALL_POSITIONS table by joining with below …