BI Publisher
Discussion List
-
SQL query to get offering start date and end date in learn module in fusion HCMContent Hi All, I am working in a requirement where I need the following details: Offering Name, Offering start date, Course Name, Person number enrolled in the offering…Mani Venkataraman 1K views 1 comment 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM -
Dependents not enrolled in Benefits SQL HelpSummary Dependents not enrolled in Benefits SQL HelpContent Hi All, I have a query that I use in a BIP report that is supposed to be determining if a dependent is going …User_2025-02-04-08-51-08-912 110 views 1 comment 0 points Most recent by Nagaraj Hunur-Oracle Reporting and Analytics for HCM -
Custom Performance Document TemplateSummary Changing the fonts in Performance Document templateContent Hi, Has anyone successfully customized the RTF in template in: Path: /Human Capital Management/Career/…Janine Dorongon 23 views 2 comments 0 points Most recent by Janine Dorongon Reporting and Analytics for HCM
-
Change Font of Delivered Performance Management ReportSummary Change Font of delivered - Performance Document Worker And Manager Ratings ReportContent Hello Experts, I am planning to change font (to Arial) for the delivered…Anil Pillaresetty 34 views 9 comments 0 points Most recent by Janine Dorongon Reporting and Analytics for HCM -
Oracle SQL - Display rows as columns - Many to Many RelationshipSummary Oracle SQL - Display rows as columns - Many to Many RelationshipContent Good day! I need some guidance if I want to do is actually possible in Oracle SQL. I have…Raymund Jerome 38 views 2 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
"Insufficient Privileges" in Fusion CloudContent Hi All, We have a requirement to find the approver name of a particular transaction. I did some research and found that may be we can get relevant data in hcm_fu…
-
Role Change Reflect to AnalyticsSummary When you change roles in Fusion, does it also get changed at the same time in Analytics?Content We encounter scenarios where we cannot see a report and then we a…Pernel Dela Pena 27 views 6 comments 0 points Most recent by Matt Nease Reporting and Analytics for HCM
-
How to report on "lineouts" and "ergonomic injuries" within OTBI / OSHASummary How to report on "lineouts" and "ergonomic injuries" within OTBI / OSHAContent How to report on "lineouts" and "ergonomic injuries" within OTBI I think this data…Andrew_Schmitz 30 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Need SQL Query/ table names to get Source System ID for person's areas of responsibilitySummary Need SQL Query/ table names to get Source System ID for person's areas of responsibilityContent Hi All, What I need is to get Source System ID for person's areas…Dhanuka Chamal 3K views 6 comments 2 points Most recent by Dhanuka Chamal Reporting and Analytics for HCM -
How can we pass a table prompt selected in the main report to the table prompt in the drilldown repContent We have a dashboard with a drill down to a detailed report. The main dashboard has a report that shows the rollup counts of documents by task status. When you cl…Tom_Giarratano12 30 views 3 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Looking for the Table for assignee Details from Service RequestSummary Table for the Assignee Details to whom the SR is assign to in the Helpdesk.Content Table for the Assignee Details to whom the SR is assign to in the Helpdesk. Ve…Preethi nair 16 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Cannot Find Category Name in Service RequestsSummary Looking for Category Name in the CRM Service ModuleContent Hey everyone, We recently installed HCM and we use the service model to act as our HR Help desk. I hav…
-
Organization Chart Custom ReportContent Hi All, I customized the DirectoryPrintReport report in /xmlpserver. I have kept only Custom as Default and Active. But the system is still printing the delivere…Mohit-Sinha 41 views 2 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Custom report for goals displays HTML tags and splits the Success Criteria Text CLOB data into multiContent Sample text in Success Criteria Field. - -This is a sample for success criteria textoralife 47 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dashboard prompt returned error (Failed to load (Odbc driver returned an error SQLExecDirectW).)Content Hello All, Currently I am using SQL Results option to populate value of a dashboard prompt called "Module Name".I am using below SQL code for this : actual colum…Janardhana K 27 views 6 comments 0 points Most recent by Janardhana K Reporting and Analytics for HCM -
deep link to reportSummary deep link to reportContent Hi, We are trying to deep link to report in OBI report. below is the link we copied from the browser address bar:…Nizar Kassam 201 views 5 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Upload a RTF Layout in new Layout is freeze shows message "Uploading please wait"Summary Upload a RTF Layout in new Layout is freeze shows message "Uploading please wait"Content Upload a RTF Layout in new Layout is freeze shows message "Uploading ple…Prabhu Krishnamoorthy 32 views 2 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
BI Publisher - Layout IssueSummary Unable to upload a new Excel templateContent Hi, I want to upload a new template for a BIP report but when it gets to processing then it just freezes on Uploadin…Jo Black 31 views 5 comments 0 points Most recent by Prabhu Krishnamoorthy Reporting and Analytics for HCM -
Password Protect xls output in Cloud HCMContent Hi Team, We have a requirement where we need to password protect the xls output produced in Fusion HCM. Can you please let me know on how to achieve this? Thanks…MandeepGupta 35 views 2 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
how to extract sql query in data modelSummary how to extract sql query in data modelContent Hi, I wonder if there is any way to extract SQL Query in Data Model using table/web service/etc. Regards, Suyoung V…Suyoung 39 views 3 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
OTBI Report showing multiple Parent Position Codes for a recordSummary Display the current parent position code in the OTBI analysisContent I have an OTBI analysis that is using Workforce Management - Worker Assignment Real Time and…User_2025-02-04-08-51-08-912 37 views 8 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Benefit Eligibility CriteriaContent Hi All, When we click on the Eligibility profile able to see View hierarchy and Eligibility criteria. Can you please share inputs in which Table/OTBi subjetc are…
-
Conditional format image - The file type is invalid, only .png .jpeg .jpg .gif and .bmp files are suContent I am trying to add a image if a condition holds true but I am getting this error message trying to upload an image. I confirmed the image format I am trying to u…User_2025-02-10-08-27-16-805 10 views 6 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
HDL - Element Entry IDContent Hello, I'm trying to update recurring element entries but am not sure where to find the ElementEntryID so that we can refer the HDL to a specific element entry. …
-
How to Embed a BIP Report with Prompts on a DashboardSummary How to Embed a BIP Report with Prompts on a DashboardContent Hi All, I have an existing custom Missing Time Cards report which is built using a custom SQL refere…Vinay Soni 200 views 4 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
how to default the date parameter in BIP report with sysdate-1 hourSummary how to default the date parameter in BIP report with sysdate-1 hourContent Hi All, Could any one help me in defaulting the date parameter in BIP report with an h…User_2025-02-06-09-41-56-955 359 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Data Model for HR Service RequestsSummary looking to report on HR Service Request dataContent Hi, we've recently started using the 'HR Service Request' facility. Was wondering if anyone had built a data …David McLellan 43 views 4 comments 0 points Most recent by David McLellan Reporting and Analytics for HCM
-
Eligibility Profile Validation Report for BenefitsSummary A lot of time customer requests to validate Or have the Benefits Eligibility Matrix handy as to query for each plan and combinations using UI is a cumbersome pro… -
Vertical display of text in titleContent We built a 9-Box using performance tiles and would like to display labels against the Performance boxes. Is that feasible? Thank you!User_2025-02-10-08-27-16-805 22 views 9 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Issue passing the date parameter to the date parameter while creating a link to the other BIP reportSummary I have been tryingng to create a link for a custom BIP report in my existing report for which I am passing 3 string parameters which worked fin, while passign th…User_2025-02-07-18-15-37-534 97 views 2 comments 0 points Most recent by User_2025-02-07-18-15-37-534 Reporting and Analytics for HCM