BI Publisher
Discussion List
-
Query for courses available for a Global Access Group using logged in employee recordSummary: Hi All, We have a requirement to display a report for all employees under Me with the list of available courses. We have restricted the courses country wise, ba… -
Audit Trail for OTBI ActivitySummary We would like to see an audit trail of who has made changes to a specific folder of OTBI reports and also who has generated specific reports.Content We have a nu…User_2025-02-06-10-48-34-019 104 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
AUTOMATICALLY INCREMENT THE DATE PARAMETER FOR COST TRANSFERS TO COST MANAGEMENT SCHEDULE RUNSSummary: Hi Content (required): Currently, my team is testing the 21D release update. The aforementioned feature (AUTOMATICALLY INCREMENT THE DATE PARAMETER FOR COST TRA…Sheneli98 191 views 3 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management -
SQL to get application url dynamicallySummary SQL to get application url dynamicallyContent Hi, Please can some one advise how to get application URL of a fusion instance using SQL? Similar to EBS, where we …Muhammad-Rizwan 408 views 3 comments 0 points Most recent by Deshin Pillay-Oracle Receivables & Collections -
Is it possible to add Department Parameter in Seeded Gross To Net Payroll Report?Summary: I have a requirement to add a Department Parament in GTN Seeded Report Content (required): Version (include the version you are using, if applicable): 22B (11.1… -
NewHireReport not getting triggeredSummary: Content (required): We have set the value as "true" for all the below profile options: BIP_EMAIL_NOTIFICATION_HCM BIP_EMAIL_NOTIFICATION_HCM_IRC BIP_EMAIL_NOTIF…Vinay Gharge 21 views 1 comment 0 points Most recent by Vinay Gharge Reporting and Analytics for HCM -
Where is 'Expedite Payroll' flag stored?Hi All, Summary: I'm trying to find what table is the 'Expedite Payroll' flag on timecards stored? Content (required): this is what it looks like in front-end Thanks!notautomni9 31 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to Schedule a CUSTOM BI Publisher Report with Dynamic Date ValuesSummary: Content (required): I want to schedule a custom BIP report with dynamic date and run time should be Daily. Date parameter should pick current system date every …Rahul Kumar Gupta.-Oracle 274 views 1 comment 0 points Most recent by Madhu Chalamalasetty Reporting and Analytics for ERP -
Structural Change in the HCM Extract XML OutputSummary: Hi Team, Does UE (User Entity) change in an already existing HCM extract changes the structure of the XML output? We have change the UE for the child data group… -
BI Template Sum Function Not Working ProperlySummary: The Sum function in the BI template not working as expected. Content (required): We have a custom report where we used the sum function on specific field but it…Ahmed Maher Kadeh 71 views 3 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Ledger Amount Field in the Payment in Case of Foreign PaymentSummary: Needs to know the table and the field holding the payment ledger amount. Content (required): We have a requirement to fetch the information for the Ledger Amoun…Ahmed Maher Kadeh 11 views 3 comments 0 points Most recent by Ahmed Maher Kadeh Payables, Payments & Cash Management -
When we apply filter below for particular process not working on pending transactions reportSummary: Hi Team, we have developed pending transactions report in that all process are coming like change manger,'Resignation', location, and etc but we need only Resig…AjayKumar Maddipati 31 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Date is not appearing after transaction madeSummary: Custom report is not reflecting date immediately after transaction is made in system. Content (required): We have created custom reprot which is based on absenc… -
Performance Issue caused after 22B upgrade for CF Activity ReportSummary: Hi Team, We have performance issue in our report after 22B update. Regards Nidhi... Content (required): Version (include the version you are using, if applicabl…Nidhi Chhajed 21 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
How to establish a connection from Oracle Cloud to Local printerHow to establish a connection from Oracle Cloud to Local printer to print cheques Hi all, We are trying to establish a connection between Oracle Cloud and a local printe…Daniel Ackland 81 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
What tables store the representatives that are assigned to each employee?Summary: I have been tasked with creating either an OTBI analysis or BI Publisher report to pull all employees and the representatives that have been assigned/linked to …BeachDreamer 251 views 6 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
User Last Login Details Using OTBI ReportSummary: OTBI reports to pull out last login user Details Content (required): Hi, We have requirement to pull out last login user details using OTBI report. Is it possib…Vasanthakumar Ravi 1.5K views 5 comments 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How do you join WLF_ATTACHED_DOCUMENTS with other learn tables of coure? For example WLF_LEARNING_ITSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Bhasha Desai 11 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
how to create BIP export into UCM without creating new filesSummary: BIP export to UCM Content (required): Hi All, I schedule a BIP report to export data into UCM location on daily basis. Every day when the file is created to UCM…Adam Liu 31 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Sales -
Leave Balance showing incorrect IN Custom BIP reportSummary: Hi Team, Some of emplyoees showing incorrect leave balance that zero and some of have showing corret value . Could you please assit on ? Thanks AJAY Content (re…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Table for Public Info (Me-> Directory-> My Public Info)Summary: We need to fetch the representatives information for an employee. I have tried with PER_ASG_RESPONSIBILITIES but unable to find the information. Please guide me… -
How to find the PTD, YTD and LTD for budget and actual for PPM BIP report?Summary: I want to fetch : 1) Period Name 2) From Project Number 3) To Project Number 4) FERC Code 5) Major Capital Category 6) Minor Capital Category 7) Project Owning …Anshul Varshney 422 views 0 comments 0 points Started by Anshul Varshney Reporting and Analytics for ERP -
Adding a BI Publisher Report to a Flow - parameter questionSummary: Hi, I have a BI Publisher report that I want to add to a flow. I have followed the steps described under https://docs.oracle.com/en/cloud/saas/human-resources/2… -
Deep Link for Employee detailsSummary: Content (required): We have a use-case to send workflow notification BIP Report to the HR Team/Head in case of Termination or Re-hire. Oracle provides the stand…Vinay Gharge 21 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Report integration on a pageDear all I integrated a dashboard on a custom page. There are two open points fr which I can't find an answer at the moment: 1. The report is not fully shown. There is a…Annelies Van Erom 11 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM