Global HR
Discussion List
-
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 11 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
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 41 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 -
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 47 views 1 comment 0 points Most recent by Julian Challenger-Oracle 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? -
SQL count of vacant positions in each department for the last three monthsSummary count of vacant positions for each department group by the last three monthsContent Hi, I am trying to write a sql in BIP to get the count of active vacant posit…
-
Scheduling OTBI report with a conditionSummary: I'd like to be able to schedule an OTBI report but restrict the data that is sent to the recipient using a condition. Content (required): Our OTBI employee stru…
-
How to hide or unhide dashboard pages & report links which are embedded in each dashboard pages?Summary: How to hide or unhide dashboard pages & report links which are embedded in each dashboard pages based on logged user. Content (required): We have a Dashboard; i…Ravindr-Oracle 104 views 5 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Number of days an employee works in the departmentHi, In our setup, an employee can work in different departments. For this, I need a SQL query that returns information on how many hours an employee works in a departmen…Cansel Karasoy 21 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
descriptive flexfield in job to be retrieved in query and joined with personSummary: descriptive flexfield in job to be retrieved in query and joined with person. Not able to join with person. Please share some references ffvs.flex_value_set_nam…Ganesh Purnima 21 views 4 comments 0 points Most recent by Ganesh Purnima Reporting and Analytics for HCM
-
BIP Job History Retention PeriodSummary: BIP Job History Retention Period Content (required): I'm trying to give clear guidance to our customer, and I'm unable to find a consistent answer on this topic…CodySisson 134 views 3 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
SQL to derive the Department names for all the personSummary: Hello we have a requirement where we need to bring the data of the department on the custom attributes created via application composer, however could not be ab…Krupesh Joshi 101 views 7 comments 0 points Most recent by Krupesh Joshi Reporting and Analytics for HCM
-
United States Job Information Extensible Flexible Attribute not BI EnabledSummary: 2 of the attributes in United States Job Information Extensible Flexible are not BI Enabled. The flexfield is protected hence no changes can be made. Please see…
-
DOR Workflow Notification CustomizationSummary: DOR Workflow Notification Customization Content (required): Hi All, We get a requirement like, whenever employee added their bank details in DOR, one approval n…
-
which table can store the bip report permissions detailsHi All, Could you please let me know ,which table can store the bip report permissions details. Thanks For Your Help!! RavindraRavindr-Oracle 43 views 3 comments 0 points Most recent by Gayathri K M-Oracle Reporting and Analytics for HCM
-
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi…Vasanthakumar Ravi 101 views 7 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
UNable to query fusion_mds.mds_pathsSummary: UNable to query fusion_mds.mds_paths Content (required): Hi Team, There is insufficient privilege error received when we try to run query against table fusion_m…Parag Hiremath 34 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Transaction Console BIP ReportSummary: For the Transaction Status: In Progress we are not able to fetch the Assigned To data in the table FA_FUSION_SOAINFRA.WFTASK Also we checked FND_BPM_TASK_VL as …Kshitiz Sinha 21 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
User person Type is not capturedContent Hi all I have created an ORBI report with Subject Area > Workforce Management - Worker Assignment Event Real Time to capture user Person type detail of the user.…Dhajani Perera 52 views 5 comments 0 points Most recent by Erica Williams Reporting and Analytics for HCM
-
Delegate Access - InfoletsHi all, I was just wondering if anyone know if it was possible for those who have delegate access to run infolets on front end and see the same results as the manager wh…MikeW 121 views 34 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Active Organization Name for PromptSummary: Hi - I have a BI report that we're using for a dashboard along with some prompts for filtering the report. We have a Business Area (Division) filter but I wante…
-
How to prevent those writing BI Publisher Data Models from who have ERP access to use HCM tablesSummary: We are trying to prevent those writing BI Publisher Data Models from who have ERP access from being able to use HCM tables and vice versa. Need to implement the…
-
Duplicate person number in OTBI report.Summary: Hi Team, I am using the subject area " Worforce Management - worker Assignment Event Real Time" with below clolum and without any filter . Legislation CodeLegal…
-
How to get outcome, where we can know how many users are set English/German as Language PreferencesSummary: We wanted to know how many users use English/German as a Language Preference set under set Preferences. Content (required): Example, We have 1,000 users, we wan…Deepak9 21 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
BPM Worklist Notification CustomizationHi , I want to edit the title information of the Absence Approval notification in the BPM Worklist. But is it possible and how is it possible to change the title only fo…Cansel Karasoy 231 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
pivot table sorting dataSummary: How to sort data in pivot table view Content (required): I created a report using a pivot table, but the data in pivot can be sorted in ascendent or discendent …
-
Report for failed attempted login with error messageSummary: Need to create a report for audit all the failed attempted logins with the error message. Content (required): Person number, name, date/time of login, error mes…Kumar, Nitin 13 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Registration Information OTBI columnSummary: Content (required): Hello experts, do you know the OTBI column name and subject area where finding the Legal Entity Registration Information fields? Please, fin…Valerio Curzi 11 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to fetch details from Worker Assignment Real Time Subject area as of (current_date - 7)Summary: Hi All, In an OTBI Analysis, I'm trying to fetch all the employees who has their Assignment Category changed to "Leader" in the past week. But I don't see a sub…Akhila 51 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM