BI Publisher
Discussion List
-
How to know recipients of bursting report that is not job history?Hi, we have many scheduled BI Publisher reports leveraging Bursting functionality to send emails to many recipients. Our client has the requirement to report on those pe…Fabio_Testa 114 views 9 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How to send attachments from BI publisher?Summary: How to send attachments from BI publisher? Content (required): Hi All, We got a requirement to send a onboarding notifications for the new hired employees with …Venkatesan 22 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
How to force repeat on rows in pivot tableSummary Trying to build a pivot table using the report editor with repeating valuesContent Has anyone been able to force a repeat on a row value in a pivot table? The ex… -
Serial numbering in the reportHello, In a notification I prepared, I would like to give a serial number to the document that will be sent to the people in that month. For example, document no;01 docu…Sinem Kara 21 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
We need basic details of time card submission details in BI or OTBISummary: HI Team, We need basic details of time card submission details in BI or OTBI. person details. time card submission details, project name, etc. Thanks, Ajay Cont…AjayKumar Maddipati 22 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
Get rid of white space at the top of a tabular reportSummary: Has anyone experienced a large white space at the top of a tabular report. Please see attached screenshot. Content (required): Has anyone experienced a large wh…
-
Consolidated List of OTBI and BI Publisher Reports Posted (10 February 2015)Content The following is the list of published OTBI and BI Publisher reports between 10 December 2014 and 10 February 2015: * Bradford Factor * Extract Manager Hierarchy…Julian Challenger-Oracle 320 views 8 comments 5 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need SQL Query to fetch the Advanced Mode Absence Duration in Absence RecordsHi Experts, Could you please help me on SQL Query to fetch the Advanced Mode Absence Duration in Absence Records. Thanks, Nagaraju.Naga raju Ibba 314 views 4 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Is there a way to pull comments section off Requisitions and Offers into reports?Summary: Pull the Comments field from Job Requisitions and Offers into reports Content (required): Looking to be able to pull the Comments field from Job Requisitions an…
-
BI Publisher Bursting Email from Company Domain IDSummary: Hello Experts, We have a requirement to trigger emails from our company domain ID (@companyname.com) while triggering emails from BI Bursting. We don't want the…Gourabh Choudhary 138 views 3 comments 0 points Most recent by Gourabh Choudhary Reporting and Analytics for HCM
-
Primary Email in Oracle TablesSummary: Hello. Could you please advise which table contains Primary Email? I'm building a BIP data model using query below. There are email type and email address inclu… -
Passing parameters from a UI page to html opening BIP Report doesn't work anymoreSummary: Passing parameters from a UI page to html opening BIP Report doesn't work anymore Content (required): Hello Experts, I'm facing an issue when passing a paramete…Dario_DiFranceschi 51 views 4 comments 0 points Most recent by Dario_DiFranceschi Reporting and Analytics for HCM
-
Email-Bursting Without Split-ByWe have a requirement to send an email with details. The email body should have the details with table format. The query has more than one record and it should be printe…
-
Need table name to fetch 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen.Summary: Dear Experts, Which table stores the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached Screenshot for your reference. Than…
-
How to determine timing delay how long does it take for data to be committed to the audit tables?Summary: We receive ad hoc tasks from business every time there's a compensation refresh happening. This process contains updates in the Assignment and Salary Section of…
-
Interview Feedback Report - BIPSummary: I need to create a feedback report , where we need to fetch responses Content (required): These are some of the fields that I am trying to fetch in the report. …Sushant Srivastava 74 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Control Infolet visibility on HCM Home page based on person GenderSummary: Control Infolet visibility on HCM Home page based on person Gender Content (required): how to control Infolet visibility on HCM Home page based on logged in per…Nirmal Ignatius 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Way to restrict the options in Output Tab during BI Report SchedulingSummary: Content (required): Hi All, Is there a way to restrict the options in Output tab not to be modified during BIP Scheduling? Example - if bursting is enabled in r…Ramanathan Sockalingam 42 views 5 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Restrict Security Groups available under Content Server DestinationsSummary: When running an HCM report through BIPublisher, you can send the output to the Content Server. We would like to remove the ability to pick these options from th…Terri Woodard-TI 27 views 2 comments 0 points Most recent by Terri Woodard-TI Reporting and Analytics for HCM
-
Why am I unable to report on the ratings given within a completed performance document?I need to be able to report on the ratings given by the manager for a pre-assigned performance document. I am using the Workforce Management - Performance Rating Real ti…Helen Tilling 62 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Are Deduction Code; Deduction Amount and Deduction Factor available in OTBI or Oracle HCM BI tables?Summary: Content (required): Hello experts, are Deduction Code; Deduction Amount and Deduction Factor available in OTBI or Oracle HCM BI tables? If so, could you share t…Valerio Curzi 45 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Document Record Deep Link in SQL Query - use parameter regarding uploaded document record IDSummary: There is a requirement for BI report to have direct / deep link to a document record for persons Content (required): I found the Deep Link URL and several of it…Shant Sarkissian_NES 418 views 3 comments 1 point Most recent by Balaji Vijayakumaran Reporting and Analytics for HCM
-
BI Report or OTBI report - create Bell Icon Notification via BI Publisher scheduler or AgentSummary: How can one trigger the creation of a notification in the Bell Icon, so a BI Publisher BI report or OTBI appear there? Content (required): Want BI to be able to…Shant_Sarkissian_WJG 125 views 3 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
Audit on Termination DataSummary: Audit on Termination Data Content (required): Hi All, Greetings! Is there any report available based on audit for termination data for the employees? We'd need …Parag Hiremath 122 views 4 comments 0 points Most recent by Daniel McMillian Reporting and Analytics for HCM -
How to get a data secured Job Requisition report in ORC?Summary: We need an Oracle Recruiting Job Requisition report with Job Offer status/progressing information if the Requisition started the offer process, which will publi…
-
Audit ability for OTBI fields and BIPSummary: Is there any ability to audit on who has created and run a BIP report or OTBI analysis that include specific folders/fields such as from Workforce Management - … -
I can't see absence approvers in transaction tableHello, I am preparing a report to see who approved or denied the absences for the absence records in the transaction console. However, I cannot access the approver infor…
-
Query to extract Candidate Attachments URLSummary: Content (required): Hello experts, please, could you provide the SQL Query to extract Candidate Attachments URL? Our customer should retrieve Candidate Curricul…Valerio Curzi 147 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Can somebody assist. on how to get the "Seniority Date" calculation date in OTBI subject report?Summary: How to include Seniority Date calculation date in OTBI subject area report (Please refer the screenshot 1 for reference)? How to include Seniority Date transact…
-
Time zone in BIP .xpt templateSummary: How can we add the user preferred time zone along with Date and time in the BIP .XPT template? I am aware of the tags for RTF template but the requirement is to…Debkanya 43 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM