Global HR
Discussion List
-
csv output giving multiple date format while using etext templateSummary: I have built a report to display a date column in dd-mm-yyyy format using etext template. the report output is displayed in text or csv. In both the cases when …Nisha_Hegde 91 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to filter the column values by another column?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to filter employees which have these Response A…
-
Facing issue with top manager type in OTBIWe have created otbi report using top manager type. Multiple managers are visible in OTBI, but in system only 1 manager is tagged. Is there any way we can pick the activ…Pranay_Soma 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle 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 38 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
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 32 views 2 comments 0 points Most recent by Jatin_Maru_1 Reporting and Analytics for HCM -
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 16 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 50 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 32 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 53 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 121 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 25 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 27 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 155 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 116 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 49 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 110 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 47 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 26 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 56 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 126 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 27 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM