Category 81
Discussion List
-
SQL Query to retrieve User Status both Active and InactiveSummary: Query to retrieve User Status both Active and Inactive Content (required): Trying to put together a query that will tell which users and how many of those are e…Edwin Martinez 3K views 2 comments 0 points Most recent by Edwin Martinez Reporting and Analytics for HCM -
Any BIP reports to pull Tax withholding details. Federal, State, Local tax dataSummary: Any BIP reports to pull Tax withholding details. Federal, State, Local tax data Content (required): Version (include the version you are using, if applicable): …Prabhu Krishnamoorthy 68 views 6 comments 0 points Most recent by Chelsea Holden Reporting and Analytics for HCM -
Count of week days for absence reportSummary: We need to count the weekdays (Mon - Fri) in a selected period to calculate absence percentage. Anyone a suggestion or solution how to get this done? WouterWouter.Schaap 56 views 6 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Termination report for multiple work relationshipsSummary: I need a true termination report for when someone leaves an organization with multiple legal employers, and they have multiple work relationships. I know there …Jessica D 64 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Using filter with ORSummary: We want to add a filter to a fact column to only return Direct Applications, so no Agency Referrals from Source or Internal Candidates from Job Application Basi…Emily Robinson 25 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BIP - Non Catalog Item Report (Learning)Does anyone know how to fetch creation date using BIP? Please see screenshot below:Hazel De Castro 44 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Function to replace accent characters with respective characterSummary: Function to replace accent characters with respective character ex: O'Brian to O Brian, Noël to be Noel I need something like ascii using which it will directly…
-
Unable to resolve " ORA-01427: single-row subquery returns more than one row"Summary: Hi Experts, When I open a BI report, I am getting, "ORA-01427: single-row subquery returns more than one row" Error. I checked each subquery and all subquery re…
-
Address Validation report for USSummary: Hi, Do you have sample address validation report for US? Thanks, Content (required): Version (include the version you are using, if applicable): Code Snippet (a…
-
Worker dropping off report if null value in one columnWe're using the Workerforce Management - Worker Assignment Realtime and Workforce Management - Areas of Responsibility subject areas for the report I've attached below. … -
How to create .txt files using burstingSummary: Requirement is to generate a .txt file with Job Posting description for Job Requisitions meeting certain criteria Content (required): We are having issue in gen…Arathi Devi H 353 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Link to the offer in the personalized notificationSummary: Content (required): Good morning everyone, we are developing a package of custom notifications on rtf templates and excel attachments to be provided to a custom…
-
How can I use parameters that work independently from each other on a single dashboard screen?Hi, I have multiple reports that I use on the dashboard screen and my 2 reports have promts. And from these separate promts there are common ones. I want to use the sepa…Cansel Karasoy 37 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Need to customize a workflow notification but cannot see 'Customize' in the More dropdownSummary: Need to customize a workflow notification but cannot see 'Customize' in the More dropdown. I have a custom BI Admin role. Am I missing a permission to be able t…PrJohns-Oracle 36 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Query to extract the last update author for document record fieldsSummary: Hello experts, please, could you share the query to execute in order to find the author of the last update on document record fields? Thanks in advance for your…Valerio Curzi 19 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Need to fetching displayvalue of payroll time type from time entry layout component.Summary: Hi, We want to fetch the display value of the payroll time type from the time entry layout component. I am not able to find it in any OTL subject area. Has anyo…Piyush Pokharkar-Oracle 42 views 2 comments 0 points Most recent by Piyush Pokharkar-Oracle Reporting and Analytics for HCM
-
Skills OTBI reportSummary: Dear Experts, Please could anyone help how to extract the OTBI report to find how many employees updated the Skills in the Oracle? Kindly help with the subject …Rajeshkumar_Sekar06 36 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to show only the MAX response attempt for a questionniare response in OTBI analysisSummary: We have an OTBI Analysis that returns information based on a checklist questionnaire. Employee can be asked to review and revise this content. We then want to p…Amy Wilson 37 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Costing of Positions subject area in OTBI?Summary: We get requests from all of our customers in Academics and Healthcare for reports/ analysis that show position costing but we have to use BI Publisher since we …Darren Nelson 309 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How to write filter for custom logic?Summary: I have a parameter Diverse, it has values ALL and Diverse. if user selects Diverse it should display the counts of diverse employee, if ALL selected all employe…Raghavendra M 95 views 14 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
I am working on one of the change only extract but I am not getting OLD values for few recordsSummary: I am working on one of the change only extract but I am not getting OLD values for few records Content (required): I am working on one of the change only with p…
-
In need of a report that returns associates who had a change in their direct managerSummary: Have a need for a report that returns associates who have changed their direct manager Content (required): We have a need for a report (BIP or OTBI) that will i… -
Link external data inside BIP reportSummary: Hi! I have an external data that is in excel file, is there a way to import this data into BIP and access it inside the data model? If yes, kindly share a docum…RenzelkeithCoquia 93 views 6 comments 0 points Most recent by makarandamondikar Reporting and Analytics for HCM
-
Inquiring logic used in one field of OTBI reportSummary: Need to know the logic used to calculate the field 'Years of service' Subject Area: Workforce Management - Work Relationship Real TIme Measurement Name: Years o…Jithin Mathews 46 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on Assessment in LearningSummary: Hi Reporting Experts, Is it possible to build a report on assessment for OLC in which we can determine who has changed assessment questions and date and time of…Saurabh Pratap Singh 58 views 2 comments 0 points Most recent by Saurabh Pratap Singh Reporting and Analytics for HCM -
Can we have any job process to run HDL(.dat) file which output of BI reportSummary: Can we have any job process to run HDL(.dat) file which is output of BI report Content (required): Can we have any job process to run HDL(.dat) file which is ou…
-
Looking for HDL to upload Calc Cards for bulk employee movements from PT to FTSummary: Looking for HDL to upload Calc Cards for bulk employee movements from PT to FT Content (required): Version (include the version you are using, if applicable): C…
-
Getting line break and error while extracting the report.Summary: I have created one BI report using e-text template while extracting it , giving me error and line break refer the attached image. What could be the possible rea…Rajib_Samanta 48 views 3 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM -
Report to Audit Approval Rules ChangesSummary: Just trimmed back access to Transaction Console, but would like to see who made the most recent Approval Rules changes to workflows, and when the changes were m…Jessica D 550 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Can you use wildcards in a CASE statement?Summary: I have an analysis where if the Job Name is like 'abc%', '%hpr%', then I want to display certain text. Note that there are multiple wildcards, some only before,…