BI Publisher
Discussion List
-
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 41 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 31 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 61 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 41 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 431 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 132 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 161 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 41 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Is it possible to report on time worked?Summary: Is it possible to create a report that list the hours worked for an employee? Content (required): We are trying to create a report to show if an employee is eli…Brandon Roberts 311 views 13 comments 0 points Most recent by Scott Pisani Reporting and Analytics for HCM -
SQL Query to extract Skill and Qualification Attachment URL?Summary: Content (required): Hello experts, please, could you provide the SQL Query to extract the attachment URL loaded in Skill and Qualification page? Is it possible …Valerio Curzi 134 views 3 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
SQL query to extract Candidates ResumeSummary: Content (required): Hello experts, we need to recover candidates resume URL. Is it possible to retrieve this information? Which table store resume URLs. Is ther…Valerio Curzi 491 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 71 views 2 comments 4 points Most recent by Tom Strudley Reporting and Analytics for HCM -
Position details with transaction summarySummary: Hello Everyone, I have a requirement to create a position report with a real-time transactional summary. Columns are: I could fetch all the above eleven columns…Saher 61 views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Upgraded from Version 1 to 3. PER_SENIORITY_DATES_F - How is it Populated?Summary: New table PER_SENIORITY_DATES_F created as part of upgrade to version 3. Can any one share the details of the data migration to this table? Content (required): …ChicagoConsultant 12 views 1 comment 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Payslip Reprinting Report flow does not Produce Output and cannot be opened because it has no pagesSummary: Payslip Reprinting Report flow is completed successfully and does not Produce Output and cannot be opened because it has no PDF (Blank) pages ####[2023-07-11T16…Janardhan ACS-Oracle 41 views 3 comments 0 points Most recent by Janardhan ACS-Oracle Reporting and Analytics for HCM -
Timeout while using ESS to manage BI submissionSummary: Our ESS job keeps failing with an odd error but if we manually submit the BI it succeeds Content (required): We have a long-running BI query which has been gran…Scott Paulin 352 views 2 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM -
Hierarchy not availble in BIWe have created an Organzaiotn Hierachy as per 1th of january 2023. The tree version is active, but noy (yet) avaliable in BI. Same for a Department Hierarchy. Is there …Wouter.Schaap 21 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Custom Performance Management Audit BI ReportSummary: Build a custom BI report that contains audit for performance document Content (required): Would like to know if there's an oracle hcm table to capture the previ… -
Standard OTBI report displaySummary: Content (required): Hello everyone, We are experiencing problems with the visualization of a standard OTBI made available by Oracle that allows the 'department …Gerardo Peluso 41 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Oracle HCM: How to change existing Host Key Fingerprint in BI AdministrationHi Team, We have a requirement to change the Host Key Fingerprint because of change in SFTP hostkey due to recent changes within SFTP application. Are we able to change …Chaitra Lakshmi Krishna 422 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Is there a seeded skills and qualifications report?Summary: Content (required): Is there a standard qualifications report? Version (include the version you are using, if applicable): 23A Code Snippet (add any code snippe…Stella Kaszab 93 views 3 comments 1 point Most recent by Stella Kaszab Reporting and Analytics for HCM -
Form output created in BI PublisherI prepared a absence form using BI Publisher, when I add the relevant fields, it does not change according to the person, the only date is fixed. What could be the cause…Cansel Karasoy 61 views 15 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
California Meal Break ReportCalifornia Meal Break Report Could you please help us getting a meal break report for the California Employees? Thanks Mansur -
Executing seeded data model to display report - TalentProfileDMSummary: How can I run the seeded data model, TalentProfileDM, to review the data that I have input into the talent profile? Content (required): This is a massive data m…User_2025-02-05-22-55-58-511 32 views 1 comment 0 points Most recent by Welsey Reporting and Analytics for HCM -
Table for security console audit?Summary: We have auditing enabled. Specifically, the "Oracle platform security services" option. We need the table names where audit tracking takes place with respect to…Shant Sarkissian_NES 51 views 5 comments 1 point Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM