BI Publisher
Discussion List
-
Fetching Data from the Legal Entity DFFSummary: Content (required): Hello experts, We've run into a bit of an odd issue, and was looking out for any advice. We've written a snippet of code to fetch the ATTRIB… -
Leave Balance Calculation date showing different than UI in BIP reportSummary: Hi Team, Leave Balance Caluclation date showing diffrent than UI in BIP report Content (required): Version (include the version you are using, if applicable): C…AjayKumar Maddipati 51 views 16 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
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…Karthikeyan Dhanasekaran 201 views 6 comments 0 points Most recent by Karthikeyan Dhanasekaran Learning
-
Select Max (Last Update Date) from "FUSION"."IRC_JA_EXTRA_INFO"Summary: Calling all SQL Experts: Trying to select the most current record (based upon last_updated_date field) from table "FUSION"."IRC_JA_EXTRA_INFO" in a data model. …Denise Izzi 191 views 7 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM -
ESS Job Report Output File NameSummary: Content (required): We used Bursting to set the file name of the report. It is displayed correctly on the ESS Job screen but when we click on the file to downlo…Vinay Gharge 566 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
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 398 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 272 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 252 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