BI Publisher
Discussion List
-
OTBI Anaylsis to retrieve Security roles by usersHello, How can I create an OTBI Analysis to pull users along with their Security Roles or by able search the Role to see all the users using that role? Any help is appre…Gail Wilmoth 41 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Just like for each that populate several rows in Excel Template, can we do the same for columns?Summary: Hello, For the Recruiting module, our client wants to have a report that dynamically populates the Questions found in Questionnaires of Job Requisitions based o… -
Oracle BI Publiser for fusion . Applying parameters for excel dataset on element by expression.Summary: Content (required): Hi Gurus, I'm using an excel dataset with 'Element by expression' as explained on the image image . The question is: is it possible filterni…Enzo Venturini 32 views 2 comments 0 points Most recent by Enzo Venturini Reporting and Analytics for HCM -
Need a report that shows assignment numbers that DO NOT have a tax card associationSummary: I'm looking for help on developing a query that will fetch Employee Name, Person Number, Assignment Number, and Assignment Effective Start Date for any assignme…
-
How to hide Mark as read and Mark as unread links based on condition in workflow notificationSummary: How to hide Mark as read and Mark as unread links based on condition in workflow notification(Checklist task) Content (required): Hi All, We got a requirement t…
-
how to call fast formula from SQLSummary: how to call fast formula from SQL Content (required): Hi All, Is it possible to call Fast formula from SQL to verify the FF results? Thanks, Venkatesan R Versio…Venkatesan 724 views 4 comments 1 point Most recent by Ketan Prajapati Reporting and Analytics for HCM
-
How to pull data from Human Capital Management and Workforce Management subject areas?Summary: How can data from the Human Capital Management Approval Notification and Archive Real Time and Workforce Management Person Real Time subject areas be effectivel…Basti 41 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BIP Report for batch monitoring of Scheduled HCM ExtractsSummary: Feasibility of BI Report for batch monitoring of Scheduled HCM Extracts. Content (required): Would like to know if it's possible to pull Scheduled HCM extracts …Kate Calderon 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Bursting body and pdf attachmentHello, I want the message body of an e-mail I prepared with bursting to appear as follows, and I also want to add a pdf to this e-mail. How can I do that?
-
Impossible to get report output for only some usersSummary: Impossible to get report output for only some users when launching them Content (required): Hello experts, we have been having problems since November 2022 for …Oriana L. 132 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How can I have a data model for Line Managers with Inactive - Payroll Eligible status?Summary: The organization decided to just use one BU. In so doing, there are expense reports generate and managers have not assigned to the new BU. Content (required): W…
-
Benefit Certifications tableSummary: We have a requirement to fetch "Certifications" tab related data in the BIP report. May I know in which tables holds the information on certification? Content (…Satyabrata Nanda 52 views 5 comments 2 points Most recent by Viral Abotiyawala-Oracle Reporting and Analytics for HCM -
OTBI if Grade is Null those employees are not fetching in the report.Summary: We are adding version 3 seniority dates in OTBI existing report, added new subject area "Workforce Management - Person Seniority Real Time" when using filter co…challa praveen 72 views 8 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
How to display the value to be in line using BI Publisher (rtf)Summary: We want to display value in line from the RTF Template. However it displays as per below. Content (required): Please find attached RTF Template and XML Version …Aries 345 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
How to Prevent merging columns in excel using RTF template in Fusion BIP ReportsSummary How to Prevent merging columns in excel using RTF template in Fusion BIP ReportsContent Hi Experts, How to Prevent merging columns in excel output using RTF temp…Bala Kasineedi 1.2K views 6 comments 0 points Most recent by User_67JNL Reporting and Analytics for HCM
-
Need a Query to Exclude the Terminated Record after 7 daysSummary: First 7 days , The Record should show with Status= Inactive Status and after 7 days The Record should not be shown in the Report. Content (required): Version (i…MilanMohanty 91 views 10 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Which tables do these search results belong to?Summary: When I search Subject Areas the result contains duplicates. Content (required): How do I know to which presentation tables the search results belong, and how ca…Maboagamo 31 views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How can I combine multiple templates in a publisher?I have a report that returns the absence records of the people I prepared from SQL and it will work according to the absence type parameter. The report will be prepared …Cansel Karasoy 42 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM -
Cross subject area analysis - ErrorSummary: Content (required): Hello everyone, We are trying to create a cross analysis in OTBI using the following subject areas: Workforce Management - Person Real Time …Agapi 91 views 6 comments 0 points Most recent by Nilanjan Biswas-Oracle Reporting and Analytics for HCM -
How to fetch Arrear balance details for terminated EmployeesSummary: Content (required): Hello, Our requirement is to fetch the arrears details for the terminated employees, adjust them accordingly. Deduction report has a section… -
Looking for Report with Absence Type and it's corresponding Display Name on a TimecardSummary: Howdy, I'm looking for a report that will list the absence management type and corresponding display name by Timecard. See screenshot below. Content (required):…David Rabalais 46 views 1 comment 0 points Most recent by David Rabalais Reporting and Analytics for HCM -
Infolet / Reporting Issue - USER.ID matching to Manager Email AddressHi all, I'm currently working on some infolets for displaying learning information for the managers to use when they load up PeopleCloud and I appear to have run into a …
-
Shared folder report are not recived by users and when only through my folder recived by usersSummary: HI Team, when i scheduled through shared folder BI report are not recived by recipients and when scheduled through my folder only recived by recipients. May I k…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Equate a node from Root Data Group and a child Data Group on EText for HCM ExtractHello Experts, Have you tried anything like this in etext template & HCM Extract combination? I have a node in my Root Data Group "Emp_DG' that I want to equate with a c…Aloka Bhattacharya 15 views 0 comments 0 points Started by Aloka Bhattacharya Reporting and Analytics for HCM -
regexp_replace not working in etext templateSummary: regexp_replace not working in etext template Content (required): We have a requirement to remove extra semicolon from the string. Using regexp_replace, we are a…Meenakshi K 417 views 2 comments 0 points Most recent by Meenakshi K Reporting and Analytics for HCM
-
Fetching Workforce Structure from Job Profile Type in BI queryContent Hi Team, I have a requirement of fetching "Workforce Structure" from Job Profile using BI query.Please help me with the query. Thanks Sandip KarmakarSandip Karmakar 66 views 3 comments 1 point Most recent by Jen Troeger Reporting and Analytics for HCM -
Original Candidate sourceSummary: Content (required): Is it possible to capture candidate’s original source via reporting? Currently the system only tracks application source and we lose key dat…
-
How to take Length of service(in years), Service category and transfer detailsSummary: How to take Length of service(in years), Service category and transfer details? Content (required): Hi All, We got a BI report requirement to show employee's Le…
-
How can I pass the current date to a job that runs a BI publisher report with a text parameter?Summary: I have a report that takes a date in TZ format (ex: '2023-03-10T00:00:00.000+05:00'), through a text parameter. I need to create a scheduled job for this report…