Category 81
Discussion List
-
Fast Formula making difference between date fieldsSummary: Content (required): Hello experts, do you have an example of fast formula making the difference between dates? For example we need to create a fast formula maki… -
Choosing Position PVO from BICC - PositionPVO vs PositionPVOViewAllSummary: We are implementing a data warehouse and establishing BICC data extraction pipelines. In reviewing the available PVOs for HCM Position data, there are two relev…Josh Vincent 131 views 1 comment 1 point Most recent by Aaron Leggett Reporting and Analytics for HCM -
Is there a report/subject area/table/view that pulls all role/data access auto-provisioning rules?Summary: I am in search of a way to pull in all of the active auto-provisioning role/data access rules (rule name, conditions, assignments (associated roles, associated … -
Candidate Report with Sensitive DataSummary: Can we get a Candidate Report (Recruiting - Recruiting Real Time) that provides the DOB & last 4 of the National Identifier/Social Security Number for those tha…SUSAN SANDIFER 71 views 4 comments 0 points Most recent by SUSAN SANDIFER Reporting and Analytics for HCM -
OTBI Data.Summary: Hi Team, We are not getting any data in worker assignments realtime. Do we need to run any process? In front-end I can see all employees. and this happens our i…
-
Can we restrict otbi reports such that only manager can be able to see direct reportees?Summary: Manager should be able to see complete details of an employee who is reportee to him/her? Can we use any restrictions in otbi reports such that only manager can…Kurva Paramesh 11 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
New Hired employee details with Requisition Details (Req Number, Hiring Manager, Recruiter Name etc)Summary: Sql Query to get New Hired employee details with Requisition Details (Req Number, Hiring Manager, Recruiter Name etc) Content (required): Version (include the v…Awadhendra Tripathi 2.9K views 4 comments 0 points Most recent by Gamidi Venkat Rambabu Reporting and Analytics for HCM
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.1K views 6 comments 0 points Most recent by User_CTDSJ Reporting and Analytics for HCM
-
Folder permission in OTBI "Resetting?" - "Enterprise Scheduler Job Application Identity for HCM"Summary: Good Day, We have a number of Custom Folders within Shared Folders - Custom where for some reason the "Accounts" "Permission" on specific user on each folder ke… -
Query bursting combined with Union AllI prepared a report using more than one UNION ALL and I want to send it as a notification, for this I prepared bursting and used it from the FROM condition of the first …Cansel Karasoy 172 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
BIP - Organization HierarchySummary: Hello, Does anyone tried creating report in BIP with organization hierarchy details? For example: Enterprise Division Business Unit Department Level 1 Departmen…
-
Query to get time card approver name and approved dateSummary: I need query to get time card approver name. Content (required): I need query to get time card approver name. Version (include the version you are using, if app…Swati U 1.9K views 4 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM
-
Can we restrict learning course details from backend for reporting ?Summary: We would like to give restricted access to the technical person to on the basis of specific course or offering details in oracle learning cloud . We would like …
-
New hires are not showing in SQL reportSummary: New hires are not showing in SQL report. We created report by using Data model. When we export the report, there are not some new hires in it. Content (required…
-
OTBI AgentsWe have OTBI reports with more than 25000 rows (Approx 250000). To transfer data, we need to split them up into 10 to 15 agents by employee's name character or Person nu…Ashok Kumar Sharma 21 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Report for Equal Pay Registration Certificate in IllinoisSummary: Has anyone built a report for the Equal Pay Registration Certificate now required in Illinois? Attached is the template we were provided, which is missing quite…MGettman 11 views 1 comment 0 points Most recent by Jeremy Miller-Oracle Payroll and Global Payroll Interface (GPI)
-
Custom report to see who is listed as Read Only AccessSummary: Hi, Our Audit team would like a security report that lists everyone we have setup for READ ONLY access under Manage Administrator Profile Options Content (requi…Darrin N 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
The scheduled BIP report is not received to gmail accountsSummary: Content (required): We've scheduled the report to be received by the users with specific roles. It is successfully delivered for some of the accounts but we hav…Evgeniya Repnina 31 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Core HR Seeded report.Summary: Hi Expert, Does anyone one have core hr seeded report path, where I can see all seeded report. If possible, please share the document. Thank you! Content (requi…Mohammad Afghan 51 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Learning item access group -BIP table to fetch Person Number List details for Learning access groupSummary: I am working on one BIP report where I am fetching one column to learning access group members using Person Number List options. In which table the person numbe…Kamini Kaushik-Oracle 31 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
catalog managerSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Wayne Smith 11 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Ability to scan all reports for specific fieldsSummary: Hi - We recently introduced a second Organization tree where we have only had 1 tree since our initial go-live in 2018. With the addition of this new tree, anyw…
-
Change of Owner in Catalog FoldersSummary: What are all the actions that trigger the change of ownership for folder, sub folder and reports under it? Please explain in what all cases "System Account" is …
-
Count of employees by Business Unit, Location and DepartmentWe need count of employees by Business Unit, Location and Department using OTBI. When we use count function, it shows same count for all business units instead of showin…Ashok Kumar Sharma 234 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
Count not coming correctAny idea why below XML is showing Column "Count as 2 " value = 2 for all business units. Column "Count1 using assignment " value = 0 for all business units.Ashok Kumar Sharma 11 views 2 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
How can I get "And" instead of "Or" to work with the same column filter?Summary: I have a sales team member column. Each team member respresents a different function on the team. Example: Primary and Overlay. I want to create a report that s…
-
How to query Location changesIs there an audit trail for Location changes that provides meaningful information? Someone made a change to a location and we're trying to determine who made the change.… -
I want to use hth.xml_data_cache.getClobVal() to get the Promotion details like new Position, etcSummary: I want to use the hth.xml_data_cache.getClobVal() function to display the Promotion details like new Position, new Manager, new Salary in separate columns. How …Consultant Ian 21 views 0 comments 0 points Started by Consultant Ian Reporting and Analytics for HCM -
OTBI Analysis for Benefit Dependents over 21Summary: I need an OTBI analysis get information for dependents who are 21 years of age in every year. Content (required): I created an analysis based on Benefit Enrollm…Ayesha Iroshani 51 views 4 comments 0 points Most recent by User_FG152 Reporting and Analytics for HCM
-
Find and Replace PROD path reference in extractsSummary: Find and Replace PROD path reference in extracts Content (required): Hi Team, Greetings! We have multiple extracts with reference to Production path on SFTP or …