BI Publisher
Discussion List
-
Chetana Pawar 104 views 4 comments 0 points Most recent by Chetana Pawar Reporting and Analytics for HCM -
Query to extract second manager level (under top manager) for all employeesSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve for each employee the second level manager …Valerio Curzi 266 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query/ table to find the new joiners detailsSummary: Hi team, Please help to find the Query/ table to find the new joiners details in Oracle Fusion HCM such as: Current Job Title Last Title (Designation from previ…Hitha Harikumar 22 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Employee Dates History ReportSummary: I have been asked to build a report showing an employees employment dates history; showing hire date, rehire date (if applicable), term date, and 2nd or 3rd ter… -
How do I re-enable download functionality of BI Publisher output when using Firefox?Summary: After Firefox updated to version 123 yesterday, Feb 20, 2024, we can no longer download BI Publisher output anymore. Content (please ensure you mask any confide…BeachDreamer 12 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
Workflow Transactions Detail BI ReportContent Hi All, We have a requirement to create a report to fetch all the details of all workflow transactions going through approval. Is there a way to create a single …User_Z7BKU 271 views 4 comments 0 points Most recent by Neysan Mohajer Reporting and Analytics for HCM
-
query to get the vendor email id by vender id in publish report..?Summary: query to get the vendor email id by vender id in publish report..? Content (please ensure you mask any confidential information): Version (include the version y…
-
RTF Template creates incorrect word wrapping in output to PDFSummary: We have a company policy document that needs employees signature. We have an RTF template that contains all the verbiage and signature sections. When we output …Brian W 37 views 2 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
How do I exclude two question codes from the following query?Summary: Unfortunately I do not know SQL and am struggling with what I would think is a simple ask. I am trying to exclude two question codes from a query that I have. C…Tammy Hemmingson 24 views 2 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
Count Time Cards Approved by WorkerSummary: Trying to determine how many timecards there are for a worker that make up the Processed Time Cards.Processed Hours from the Workforce Management - Processed Ti…Jason Snipes 27 views 4 comments 0 points Most recent by Jason Snipes Reporting and Analytics for HCM -
Talent Pool Report in Oracle BIPSummary: This report is required by the business to report on the grades of talent pool candidates while they are actively part of the talent pool and later, in future y…Pradnya_Pampatwar 33 views 9 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Unable to access BI report using REST serviceHi, When I try to access BI report from postman it returns as 400 Bad Request Thanks -
Query to check filled and vacant positionsHi All, I need a Query to fetch Vacant and filled positions with headcount. if anyone has please share. Thanks, SowmyaSowmyaSk18 740 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue with converting UTC time to BRT timeSummary: When I run below SQL to convert time from UTC to BRT (America/Sao_Paulo), output is not correct. There is a difference of 1 hour in the output. I read somewhere… -
Multiple Values to a parameter in OTBI/BIP ReportContent Hi All, We have a report requirement where we need to have a prompt which takes as good as 1000 values for Person Number at a time to run the report. we are work…Vibha Pandey - Oracle 340 views 4 comments 2 points Most recent by Saadiq Reporting and Analytics for HCM
-
Table(s) contain POD Version and Last Refreshed DateContent Hi... I am looking for a SQL query to derive the last refresh date for a POD and latest patch level (ie 12A, 12C, etc). Thanks in advance for any tips. JRJoe Roberts-Oracle 867 views 15 comments 1 point Most recent by DhirajRathi Reporting and Analytics for HCM
-
Suppress a field in BIP reportSummary: We are looking to group a field and suppress it in a BIP report. Content (please ensure you mask any confidential information): As shown in the snippet, we are …Tammy Hemmingson 11 views 1 comment 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM
-
Can we call external application from BIP ReportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagendra Chitra-Oracle 3 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
{ELE_NAME} in FND_MESSAGES_TLWe have a requirement to display Message Name and Message Text in Payroll Message Report. We are getting these values from FND_MESSAGES_TL table. Now our client wants th…
-
BIP password change all extracts are failing - Need Solution or workaroundSummary: BIP reports password change all extracts are failing - Need Solution or workaround please Content (please ensure you mask any confidential information): Version…Ankusham Rakesh 22 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Oracle Fusion Payroll Balance QuerySummary:Performance Issue with my BI Publisher report Payroll Balance Query Content (required): My current payroll balance query is using pay_balance_view_pkg.get_balanc…
-
Strange OTBI Error:[nQSError: 27046] Inaccessible columnSummary: Strange Behavior, getting the below error however respective Job Role/ Duty roles are assigned to the user but still users are getting the below error (Screensh…
-
How to get approved by for Job Requisition ?Summary: I want a query to get approved by in transaction console for job requisitionMartin_Melek 2 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Eligibility tables for data modelSummary Eligibility tables for data modelContent I am having some difficulty creating a data model that i need for the report bursting. I want to create a report that wi…User_2025-01-22-19-28-29-985 98 views 6 comments 0 points Most recent by RJH.CC.gov.uk Reporting and Analytics for HCM -
How to add multiple IF function in the Field Browser using Microsoft Word - BI Publisher?In my RTF template, I'd like to put a message for employees who are not belong to a specific department: However, in our case, some employees under 'ABC Expert' departme…
-
Can we able to send data from Oracle cloud to GCP directlyGot a requirment to send file from Oracle to GCP. Can we able to send the file directly? Need suggestions. Thanks, Keerthana.KeerthanaBaskaran 1 view 0 comments 0 points Started by KeerthanaBaskaran BI Publisher Learning Center
-
Table that stores BIP error detailsSummary: Which table stores BIP error details text? Content (required): We are trying to build a custom BIP report to summarize all BIP job errors into a notification em…Abhishek Potnuru 229 views 8 comments 1 point Most recent by Sneha Sao Reporting and Analytics for HCM
-
Unable to fetch Resignation Transaction approval rules data in the reportWe have a requirement to fetch the approval rules data in the BI report. But we are not able to get the full approval flow from the tables.KeerthanaBaskaran 32 views 9 comments 0 points Most recent by KeerthanaBaskaran Reporting and Analytics for HCM
-
Unable to Upload PGP key Post 24A UpgradeI'm Unable to Upload PGP key Post 24A Upgrade in BI Publisher using Administrator. It is giving 'Generating BI Publisher kaypair failed: reason = gpg --gen-key command f…SushantAnand 131 views 2 comments 0 points Most recent by SushantAnand Reporting and Analytics for HCM
-
report to show timecards that aren't approved (when the last editor was not the worker him/herself)Summary: Just sharing BI SQL. We have a need to output instances onto a report to show which worker did not re-approve a timecard that was edited by a member of our time…Shant_Sarkissian_WJG 60 views 2 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM