BI Publisher
Discussion List
-
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 43 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 18 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 432 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 67 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…
-
Need to restrict Public output of a report to a group of peopleSummary: Currently report output generated using "Make output Public" is visible to everybody but we want to restrict this Public output of the report to a particular gr…Tarun_chaudhary 12 views 2 comments 0 points Most recent by Tarun_chaudhary Reporting and Analytics for HCM
-
Location Report - No ResultSummary: Content (required): Attempted to run a seeded BI Publisher report but there are no results. Shared Folders/Human Capital Management/Data Exchange/Location Repor…
-
BI Publisher SQL helpHello Team, i have written below sql to fetch count of time entries. select REC.RESOURCE_ID, count(distinct(to_char(start_time ,'yyyy-MM-dd'))) as Counter from HWM_TM_RE…minati_behera-Oracle 31 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Add "Business Object Type" and "Attribute" columns to the Delete Audit ReportSummary: We had a custom report called 'Delete Audit Report' and the client wants to add columns on it for 'Business Object Type' and 'Attribute' same on what we see on …Maria Cristina L. San Jose 31 views 1 comment 0 points Most recent by Maria Cristina L. San Jose Reporting and Analytics for HCM
-
Can we access SOA MDS schema in fusion OBI reportsSummary: How to access SOA MDS schema in fusion OBI reports Content (required): We want to fetch business rules information in Cloud HCM through an OBI report. Is SOA MD…Hitachi ServiceDesk 21 views 0 comments 0 points Started by Hitachi ServiceDesk Reporting and Analytics for HCM
-
DATE_ADD function ErrorSummary: Hi Everyone! I am try to add specific year to the hire date using Date_add function, but it is throwing "Missing right parenthesis error". Could any one help me…
-
Fusion BI Report Output file name along with current date and timeSummary: Fusion BI Report Output file name along with current date and time Content (required): Hi Team Can someone help me how to add date and time in the custom BI rep…[Deleted User] 2.2K views 4 comments 2 points Most recent by Kavitha Balaiah Reporting and Analytics for HCM
-
Oracle BIP Report Issue with RTF templateSummary: Seeking a solution to fix the corrupted RTP template. Content (required): Enhancing the existing rtf template to add a new field. However, the new field value d… -
Costing table link with gl tables in hcm fusionSummary: I am looking for the below tables Whether its linked with gl tables pay_costs pay_cost_allocations_f pay_cost_allocations_keyflex GL_JE_BATCHES, GL_JE_HEADERS G…
-
Resignation/Termination Approval- Current/Pending Approver DetailsSummary: Resignation/Termination - Pending Approver Details Content (required): Hi All, There is a report requirement to show Resignation/ Termination approval -> curren…
-
Table to pull the ESS Scheduled Job definition details.Summary Required table which stores the ESS scheduled job defiinition details.Content Hi Experts, I would like to know from which table we can pull the ESS Job definitio…Charan Kollipara 109 views 3 comments 1 point Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for HCM
-
Report on Employee's Time in Current RoleSummary: Content (required): We're looking to build a report that show us how long an employee has been in their current. Do anyone have recommendations or samples? Vers…Ratha Sun 42 views 1 comment 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM
-
How to take Resignation Submission date?Summary: How to take Resignation Submission date? Content (required): Hi All, Report requirement to show employee's Resignation Submission Date. From which table we can …Venkatesan 31 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
State tax details in hcm fusionSummary: I am looking for the below details in the state tax setup level state tax type state Minimimum wage state of the tax defined Please guide me to refer the table …
-
Column order in BIP ReportSummary: Column order in BIP Report Content (required): Hi, We are trying to have specific order of columns in our BIP report (CSV output). Earlier it was word layout wh…
-
Help getting interview date - BI report for ORC.Summary: Hello experts, Need input for getting interview date for an ORC report i am working on. This is my first time working on ORC related tables. I can see this tabl…Jithin Mathews 81 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
User_2025-10-10-00-14-09-209 41 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
I'm looking below columns in otbi or any reference reportSummary: Hi , I'm looking below columns in otbi or any reference report ,any help me on below columns. Thanks, Ajay Content (required): Opening EL leave balance /DOJ (Da…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need to edit Subject in Enterprise Onboarding mail- ChecklistWelcomeReportSummary: Wanted to customize the Enterprise Onboarding email subject being sent. Content (required): We want to display the first name in place of full name in the Enter…Gourabh Choudhary 52 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM