BI Publisher
Discussion List
-
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 31 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 41 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 793 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 357 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 884 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 1 view 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 1 view 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 233 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 31 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 62 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 241 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 332 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 22 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 125 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 21 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
-
Signature in the reportSummary We need to store Digital signatures in the Fusion cloud and need to display same signatures in the reports.Content Hi All, Can we store Signatures in the Fusion …
-
RTF holding on the empty space if the condition is not satisfiedHi, I facing an issue with rtf template where if the condition is not fulfilled it shows blank space and then the next text in the report like below picture Is there som…chpriyanka 271 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM