Category 81
Discussion List
-
Absence Record Not showing after Global Transfer Or TerminationSummary: Hi Guys, I’m unable to view the absence records after an employee is terminated or globally transferred. Could anyone please help me understand what might be ca…Dharani Dhar Gupta 13 views 3 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
If Position or Department attributes getting changes how to extract all the employees assignedSummary: If Position or Department attributes getting changes how to extract all the employees assigned to that position/department in fusion hcm Content (please ensure …Samapti 14 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Which table stores Career sites details in Recruiting?Summary: Which table stores Career sites details in Recruiting? Content (please ensure you mask any confidential information): Version (include the version you are using…Pritha 14 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
BI/OTBI Report to identify list of all users who have access to a specific employeeSummary: We have a requirement to fetch all users who have access to view/modify employment data for a given user. We explored options and we can see such information is…Vinayak Hegde 9 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
List of users using HCM Mobile app reportSummary: We need a list of users who are using HCM Mobile app as a report with BI or OTBI . where this information is stored in SaaS? Content (please ensure you mask any…Akshitha Vyas 7 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
How to identify Specific Column used Reports in BIPSummary: Hello Everyone, Is there any query we to fetch all BIP reports which are using specific column? Eg: Person_Number (Per_all_people_f) Can we pull all BIP Reports…Ganesh G 58 views 5 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
From which tables can I get the Workflow details of transactions archived in transaction console.Summary: Tables to get the Workflow task details of transactions archived in the transaction console. Content (please ensure you mask any confidential information): Vers…JSAHOO1988 15 views 3 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
How to get shift name start time, end time for certain date, from the work schedule caledarSummary: In oracle Fusion, We need a query to identify the shift name , shift start time and shift end time as the following parameters shall be passed Emp number Date C…MHanif 20 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
SQL Query to get HRBP assigned to an employee (when AOR uses organization hierarchy)Summary: We need a query to find HRBP assigned to an employee when Organization hierarchy has been used to assign the AOR(area of responsibility). It doesn't include any…Aloka Bhattacharya 1.6K views 7 comments 1 point Most recent by User_R6F1A Reporting and Analytics for HCM -
[Sharing_BIP Report]: Redwood Profile Option Code listSummary: Extract list of Redwood Profile OptionCodes with value Content (please ensure you mask any confidential information): Some customers ask if there is any report …Sandy Suo-Oracle 249 views 7 comments 6 points Most recent by EmilyVB Reporting and Analytics for HCM -
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl…Julian Challenger-Oracle 41.5K views 95 comments 118 points Most recent by Dave Chudzik Reporting and Analytics for HCM -
Person real time and Assignment real time securityWe have an OTBI analysis for passport and visa details. It combines the Person Real Time and Assignment Real Time subject areas. One employee has a current assignment in…Stephen Jones 13 views 4 comments 0 points Most recent by Stephen Jones Reporting and Analytics for HCM
-
How to get shift name start time, end time for certain date after manually change the workSummary: I need to retrieve the shift name, start time, and end time for a specific date after manually updating the work schedule calendar. How can I get these updated …Sanduni Pathirathne 9 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to get the XML data for TimecardApprovalNotificationReport seeded reportSummary: Hi Experts, we have a requirement to get the XML data out of the TimecardApprovalNotificationReport to troubleshoot how data is displayed in the report, does an…
-
How to report on previous person name in OTBI?Summary: I want to create a report in OTBI, that will show changes of person name - current name and previous name. Content (required): I tried Person Names/Person Names…Maciej Kozakiewicz 184 views 4 comments 0 points Most recent by MJ Surel Reporting and Analytics for HCM
-
BIP Report is taking more time while Using Bursting, Without Bursting it completes in 10 minSummary: Custom BIP Report is running for more than an hours and it is not bursting output to FTP(secure) while using bursting query. But when we are running the same re…
-
Accurate Headcount Reporting in OTBI even after department changeMy goal is to accurately reflect the headcount by department, ensuring that the count includes only active employees, even if they have changed departments. Currently, w…Nithin Reddy 14 views 2 comments 0 points Most recent by Nithin Reddy Reporting and Analytics for HCM
-
What is the SA to use for Goals' Published Flag ?Summary: Hello, We need to display in an OTBI report the Performance Goals along with their Shared and Published flags. We are using Workforce Goals - Goal Status Overvi…MariaStanciu 9 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Dashboard passing prompts with url link.Hi, I am creating a OTBI dashboard and i want to generate a link with an url which would be passed through tthe prompt directly. i tried this link but it did not work…MYassikaya 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Query to fetch data entered by employee in an ICP requestI am looking to build a query on the ICP request raised by an employee. This should include submitted and approved transactions. However, there are certain fields for wh…SHRUTI PRIYA 4 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to Query Reported Time for Specific Payroll Time Types Based on Time CategorySummary: I'm trying to query reported time entries for specific Payroll Time Types that belong to a particular Time Category — in my case, the category is called "**** T…Raghavendra M 9 views 1 comment 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
OTBI: HR HelpDesk Request Real Time - Line ManagerSummary: We are creating an analysis report using HR HelpDesk Request Real Time Subject Area with the ff goals: 1. If the Line Manager runs the report, the report should…Garry Parta 3 views 2 comments 0 points Most recent by Vishal Purohit Reporting & Analytics for Fusion Service
-
Future dated benefit groupsSummary: I am trying to create an OTBI report that shows the effective start date and end date of Benefit Groups. The only subject area that I can find that has the bene…
-
OTBI Custom Subject Areas using Application ComposerSummary: Can Customer create custom Subject Areas for OTBI in Fusion HCM using Application Composer? Content (please ensure you mask any confidential information): Highe…AVorster-Oracle 18 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to identify hires as Internal or ExternalSummary: Using OTBI, I would appreciate recommendations on how to identify hires as either an Internal or an External hire. Thanks! Content (please ensure you mask any c…
-
How to change the date format in OTBI promptSummary: How to change the date format in OTBI prompt. currently we are trying to change the accounting date column to mm-dd-yyyy format but we are getting syntax issue.…User_U4A6A 55 views 4 comments 1 point Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM
-
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 295 views 6 comments 0 points Most recent by Aditya Jadhav Reporting and Analytics for HCM
-
Join multiple subject areas in AnalyticsSummary: Join multiple subject areas to have an outer joint result. Content (required): My users want a dashboard to show the percentage of the employees who set up annu… -
Need Help Identifying Tables for Custom Oracle Audit Report with Product, Business Object TypeSummary: Hello Oracle Community, I'm trying to build a custom audit report similar to Oracle's standard audit output with the following columns: User Product Event Type …Vishal Purohit 12 views 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM
-
Question on where to fetch seniority dates in OTBI (v1 vs v3)Summary: with the v3 seniority dates in play, we are a bit confused as to where to fetch the seniority date data in otbi. Before we migrated to v3, we leveraged 2 fields…