BI Publisher
Discussion List
-
How do I query Administrator Profile Options?We often find that there are Administrator Profile Options that are enabled or disabled during upgrades that we are unaware of and are not part of the release notes. Bec… -
We looking employees Names in arabic language like LANGUAGE = 'AR'Summary: Hi Team, We looking employees Names in arabic language. for department name we used Transalation table HR_ALL_ORGANIZATION_UNITS_TL ,,and dept_arabic.LANGUAGE =…AjayKumar Maddipati 171 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
SQL needed to find parent department in department tree for any given department nameSummary: SQL needed to find parent department in department tree for any given department name Content (required): Hi All, Please share SQL to find parent department in …C.R.Balaji 3.3K views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to fetch content ID generated after running the Mass Create Printable Page Performance DocumentsWe are migrating the performance documents form an old fusion environment to a new one since we cannot load the item level ratings we are planning to load print of the e… -
Scheduled Report taking the extract in UTCSummary: Hello, The query is that if we are scheduling a custom report in IST time zone like 2.45 AM IST BUT the scheduled report is extracting the data from form 9.15 P…Awadhendra Tripathi 11 views 1 comment 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten…Kauan_Bohn 41 views 16 comments 0 points Most recent by mathew060581 Reporting and Analytics for ERP -
OrganizationAM.OrganizationUnitPVO field OrganizationUnitTranslationPEOTitleSummary: HcmTopModelAnalyticsGlobalAM.OrganizationAM.OrganizationUnitPVO field OrganizationUnitTranslationPEOTitle showing NULL VALUES Content (please ensure you mask an…
-
View Formatted HTML Text in BI Report Excel TemplateSummary: We are trying to fetch a formatted CLOB Data in an Excel template. However, the report is fetching HTML tags in the Excel cell . We tried the solution given in …Tanu Shri Patel 91 views 3 comments 1 point Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
DM for an Emergency Contact ReportHi Sorry if this has been asked before and I see a number of reports in OTBI but I am looking to see if someone has a data model for an Emergency Contact report. I am lo… -
Extract XML or output from ESS jobSummary: Is there a way to extract XML or output from ESS job through SOAP webservice, or REST to outside of Oracle fusion Content (please ensure you mask any confidenti…Sunil Pradhan 81 views 4 comments 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
Unable to view the Output in ESS JobHI Team, When invoice import is done the ESS job(Import Payables Invoices Report) is being executed and the report is not generating at ESS Job level as showed in attach…Sarath Lakshman 91 views 2 comments 0 points Most recent by Sarath Lakshman Payables, Payments & Cash Management
-
How to pass/refer Date From Parameter to another Date Parameter in BIP Report?Summary: How to pass/refer Date From Parameter to another Date Parameter in BIP Report? In below example Enroll Start Date is 01-01-2025 and Enrollment End Date max rang…
-
How to duplicate a page in the dashboard?Summary: Hello, how to duplicate a page in the dashboard? I want to copy a page in existing dashboard so I could have the same layout. Thanks! Content (please ensure you…
-
what is the deep link for manage customers details?Summary: We need the deep link of manage customers page Content (please ensure you mask any confidential information): we made a dashboard with customers and we want to …
-
Table names to get reported time and calculated time on time card for reportingHi, We need a timecard report comparing the reported time vs the calculated time. Can anyone please share table names to get reported time and calculated time on time ca…
-
Table to find instance name/Environment NameHi Team, Could you please share a table or SQL to find the instance name, when values would be DEV1, DEV2, or PROD. I have already checked the ASK_DEPLOYED_DOMAINS table…Swapnil Kashid 554 views 6 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Installments Associated with Collection Documents Listing Report for Brazil not worksSummary: There is a Report available in the Scheduled Process: "Installments Associated with Collection Documents Listing Report for Brazil" I tried to run in many diffe…
-
AR print commercial documents burstingSummary: There is a bursting query in print commercial documents process. We have understood that emails can't be send through this process, wanted to check if FTP or an…
-
actual vs budget bi publisher based on COASummary: Hi, is there a BIP report where we can extract initial budget and adjusted amount for chart of accounts 1-3. Content (please ensure you mask any confidential in…
-
How to fetch CURRENT and PREVIOUS Salary using BIP?I need columns to compare the CURRENT and the PREVIOUS salary of employees in 1 row only. How to construct the BIP report using SQL?Welsey 765 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
can we have different Font style for e-sign on offer letter templateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…YOGESH SAMPANGI 1 view 0 comments 0 points Started by YOGESH SAMPANGI Reporting and Analytics for HCM
-
Need a Bell notification when a course is assigned to the employee by their managerSummary Need to create a custom alert when the manager has assigned a course to his employeesContent Hi Experts, We have a requirement to enable a custom bell notificati… -
BIP or OBTI Auditing Users making changes to their own HCM/Payroll DataSummary: Does anyone have or know of any current reports that will give details on Oracle HCM users who have made data changes to their own Global HR/Global payroll info…
-
There is requirement on BIP for learningSummary: when the learner course is due date past 7 days email notification should go to manager 's manager. How can we write BIP report to generate notification Content…
-
How to fetch Resignation details, which include Resignation reason,,Summary: This is the resignation page in Me tab. How to fetch all These details using SQL?Aryan Yadav 42 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM -
Position Request Status ReportHello, I am looking for a report that will give me all the positions requested for New Position, Backfill/Replacement, and Promotion by leader. Ideally the report captur…
-
How to fetch comments and attachments from hcm extract and bip report?Summary: I want to know, how to fetch comments and attachments from HCM extract and BIPreport? Content (required): Version (include the version you are using, if applica…
-
Show original transaction's Remit To address on Credit MemoSummary: We'd like to have the Remit To address shown of the original transaction on all credit memos. We have one single remit-to address for each country set up, but i… -
PVO and Oracle Base Table for Fixed Assets approvalsWe have approval hierarchies enabled for Fixed Assets, for that to reflect in BI report we need related PVO & Base table which I am not able to find it anywhere. Please …