Category 81
Discussion List
-
How to display the recruiting candidate's department name in OTBISummary: Content (required): I have a candidate who's department in the job offer is different from the one in the requisition. Using OTBI, is it possible to display the…User_2025-02-12-02-38-00-520 58 views 8 comments 1 point Most recent by Mansur Khalil Reporting and Analytics for HCM -
Offers Report not pulling dataSummary: Content (required): Anyone experiencing data not pulling through on OTBI analysis reports created using subject area: Recruiting - Recruiting Real Time? Anyone … -
How do I remove unwanted commas in OTBI report outputSummary: Custom address field column contains extra columns when source column is null Content (please ensure you mask any confidential information): I have created an O…DennisOliver 27 views 5 comments 0 points Most recent by DennisOliver Reporting and Analytics for HCM -
HCM native datamodels/bipSummary: are there another schema.table wich sample reports delivered in HCM Cloud are stored to extract a list of them ?? Content (please ensure you mask any confidenti…
-
csv output giving multiple date format while using etext templateSummary: I have built a report to display a date column in dd-mm-yyyy format using etext template. the report output is displayed in text or csv. In both the cases when …Nisha_Hegde 75 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
SQL instruction to join data from 2 or more BI tablesSummary: Content (please ensure you mask any confidential information): Hello experts, which instruction when building queries in data models allows me to join two or mo…Valerio Curzi 15 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Connections BIP report - how to remove HTML tags?Summary: Hello, I've created a BIP report for Connections. Could you please advise how to remove HTML tags? Please find SQL query attached. Kind regards, Marta Content (… -
How to remove the duplicates in rtf templateSummary: Currently using the three Data sets in the report First DS will contain the employee details,legal employer name ,Dept id and element amount Second DS contains …
-
How to filter the column values by another column?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to filter employees which have these Response A…
-
Facing issue with top manager type in OTBIWe have created otbi report using top manager type. Multiple managers are visible in OTBI, but in system only 1 manager is tagged. Is there any way we can pick the activ…Pranay_Soma 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Coding Conditional Formatting into LSQL?Summary: Logical SQL Conditional Formatting OTBI Content (please ensure you mask any confidential information): Hi All, When building a report in LSQL - I apply the SQL …William_Johnson 22 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Why there is no error message if same allowance is added with overlapping dates for pending workerSummary: Why there is no error message if same allowance is added with overlapping dates for pending worker but only for Employee using ICP.User is expecting such error …Pavani Kondisetty 12 views 2 comments 0 points Most recent by Pavani Kondisetty Reporting and Analytics for HCM
-
How to create a record in the position flexible field from postman with Oracle Rest API?Hi, I want to send a record to the flexible field opened on the position with the help of Oracle standard rest APIs. But when I examine the oracle document, I cannot see…Cansel Karasoy 31 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Setup table to pull Approval rulesSummary: Setup table to pull Approval rules Content (please ensure you mask any confidential information): Hi, Could you please advise setup table to pull out Approval r…Bhavna-Civeo 53 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Add parameters to BIP report URLHello, Is it possible to add parameters to a BIP report URL? My report BIP URL: https://***/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=****%2FF…
-
How to capture employee working as a manager in Employee details oracle BIP reportSummary: What is the table and column to capture working as a manager column, to write a employee details BIP report. Content (please ensure you mask any confidential in…
-
To pull Open Enrollment Benefit data if life event closed and Employee Enrollment not yet submittedSummary: To pull Open Enrollment Benefit data if life event closed and Employee enrollment not yet submitted Content (required): We are looking SQL query/OTBI report to …
-
Workforce Management - Worker Assignment Event Real Time - Assignment FTESummary: We want to achieve below requirement using OTBI. Can we get FTE and leaving reason from the same SA or need to join other SA to get the data ? Can we get Assign…Jatin_Maru_1 21 views 2 comments 0 points Most recent by Jatin_Maru_1 Reporting and Analytics for HCM -
Issue while configuring BI Publisher ReportSummary: Hi, I've configured the BI Publisher files custom folder but not able to see the folder after Upload successfully done. Do you have any suggestions? Need your h… -
Can we report on users with no work schedule using OTBI analysis?Summary: Users with no work schedule not showing on OTBI analysis of work schedules by user. Content (please ensure you mask any confidential information): I have an OTB…
-
Date Calculation formulaHi, I've a requirement where I have to show some data based on future dates and also print dates like First Calendar Date of Next Month, Last Calendar Date of Next to Ne…Ninja 11 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible for rich text format stored in a Data Field to display as Rich text in a report?Summary: We are using Rich text format in Questioners in Carrer conversation. Content (please ensure you mask any confidential information): 1.Thinking big, what do you …challa praveen 22 views 2 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
Track changes to Primary National Identifier (social)Summary: Track changes to social (Primary National Identifier) Content (required): Have a requirement to identify changes (within the last 30 days) to a person's Primary…
-
Learning BIP Report Table LogicSummary: Hello, The current BIP Report we have in our org is based on the Learning Assignments Table (WLF_ALL_ASSIGNMENTS_V). However, we had an issue that a person was …
-
xmlpserver: RTF Template for quick action Change AssignmentWe were able to locate RTF templates for Person Management changes on the xmlpserver, but we were unable to locate quick actions like Change Assignment RTF templates. Th…Ashok Kumar Sharma 13 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
Workflow Notification TranslationsSummary: Workflow Notification Translations Content (please ensure you mask any confidential information): Hi , When we customize seeded notification and make copy of it…
-
Quick Action Employment Start DatesSummary: Report to identify details when Quick Action Employment Start Dates is used Content (required): Need a report that shows when a Hire Date is changed when using …JHaden3 42 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get previous experience of employee plus current company experience in OTBI or BISummary: Hi Team, we have requirement to get the previous experience of employee in OTBI is possible. In BI , we used (ff_user_column_instances_f fucif.value as experien…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Enabling BPFM Notification and Template customisation for Goal ManagementHi Team, 1)Can we include BPFM in Goal FYI notifications? 2) How to bring supervisory in Goal FYI notifications rules in "THEN" Condition and which rule is triggering no…
-
Payroll : Fiscal year to date balance showing results for the Calendar year and not Fiscal yearSummary: Payroll : Fiscal year to date balance showing results for the Calendar year and not Fiscal year Content (required): Hi, We have enabled "Relationship NoCB Fisca…SakthiPradeepa_NK 127 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM