Category 81
Discussion List
-
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 52 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 124 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Maintain Meta Model and IndexHi, We have a Maintain Meta Model and Index process in error in scheduled processes. This was scheduled by someone who is now a leaver, so may be the reason for the erro…Daniel.McDermott 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Mask Employees Payroll Run Results data after cloneSummary: We need to mask all Employees previous processed Payroll Run Result data on the cloned system Content (required): We are taking Clone from production to test fu…aabdelghany 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way to report on the 'Work Category' field on the Timecard?Summary: I am trying to report on the 'Work Category' field from the Timecard but I can't find it in any of the subject areas relating to Timecards Content (required): I…Debbie Kilgallon 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Error while using Evaluate functionSummary: Error while using Evaluate function in OTBI. Content (please ensure you mask any confidential information): Hi, I'm getting error if I use the Evaluate function…
-
Sample OTBI Report and Dashboard Workforce Compensation moduleSummary: Content (required): Hello experts, our customer want to see some delivered OTBI Analysis and Dashboards for workforce compensation module. I've tried to open th…Valerio Curzi 344 views 16 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Vacant Positions in SQLSummary: Hi I have had a request through to list vacancies per Position Code/per CC. But instead of having one row per vacant position, it needs to have as many rows as …
-
How to resize Rows and Columns in OTBI reports?How do I set column or cell dimensions to have a consistent format for my report?
-
Showing assignments without data entries?Summary: Using subject areas to create an analysis, we have issue showing assignments without data entries. Content (required): We are creating a number of analyses usin…Matti Bugge 51 views 22 comments 0 points Most recent by Matti Bugge Reporting and Analytics for HCM -
Seeded Roles allowing to open Workforce Compensation Budgets seeded reportSummary: Content (please ensure you mask any confidential information): Hello experts, I cannot successfully open the seeded dashboard in screen (screen 1). The user has…Valerio Curzi 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
can we generate a report with employee names and with file attached in Document Record.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…Mathieu Garneau 11 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM