BI Publisher
Discussion List
-
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 36 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 21 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 23 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 31 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 696 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 345 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 855 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 21 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 97 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 2 views 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 225 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 33 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 130 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 54 views 2 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
Privileges/Roles to access the Reports and Analytics Work areaSummary: Content (please ensure you mask any confidential information): Hi experts, I'm working with a custom job role that should be able to access the Reports and Anal…Elena_Panniello98 225 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM
-
Candidate Risk of Loss and Candidate Impact of Loss field table namesContent HI All, We have a requirement to fetch the succession plan, Candidate Impact Loss and Candidate Risk of Loss details through BIP . I find the "HRM_PLANS " and "H…
-
BI Publisher Bursting with Multiple Templates , Multiple Data setsSummary BI Publisher Bursting with Multiple Templates , Multiple Data setsContent Hi Friends We have a requirement where we need to burst BIP reports. Now i have 2 diffe…Mansur Khalil 322 views 4 comments 0 points Most recent by Alon Hadar Tamir Reporting and Analytics for HCM -
User-Defined tables name in Oracle HCM BISummary: Content (please ensure you mask any confidential information): Hello experts, do you know the BI table to extract user-defined tables? Thanks in advance for you…Valerio Curzi 19 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Unable to see output on scheduled report jobSummary We have users, not all, that are unable to see the output file from a scheduled report job.Content Does anyone know what may be causing some users to be able to …Ellen Manthei 113 views 5 comments 0 points Most recent by Erika Szewczyk_UCSD Reporting and Analytics for HCM -
How to link transaction adminstration Real time with worker assigenment Subject area ?Summary: HI Team, We have need to track the all transactions in hcm of : Change Location, Change Manager, DeleteAssignment Promotions ResignationTransfers. with worker d…AjayKumar Maddipati 13 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to: Translate BI Publisher Report Parameters at 24ASummary: How to: Translate BI Publisher Report Parameters at 24A Content (please ensure you mask any confidential information): Version (include the version you are usin…Ishtiaque AHmed 41 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM