BI Publisher
Discussion List
-
How to query user details if person_id and party_id are null and no data in per_ldap_users?Summary: Customer has requested a report to display all the usernames along with their first name, last name, email etc. I have encountered a username for whom person_id…Abhi_19 402 views 2 comments 0 points Most recent by Adrian Nae-Oracle Reporting and Analytics for HCM -
Need a SQL query to get the value for Parent Position for the employee's Assignment Position.Summary Need a SQL query to get the value for Parent Position for the employee's Assignment Position.Content Need a SQL query to get the value for Parent Position for th…JP Chandran 2.4K views 6 comments 0 points Most recent by user3929728 Reporting and Analytics for HCM -
Can Employer Comment under Termination Details be on a report?Summary Is there a way to add the Employer Comment informaiton to a reportContent We list the company that an employee leaves us for in the Employer Comments box on the …Denise Jo Crangle 82 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to query Content server objects?Summary: I would like to query a list of specific Content ID's from object in the content server (https://.fa.em2.oraclecloud.com/cs). Is it possible to find the content…Mia Tøttrup 97 views 3 comments 0 points Most recent by Mia Tøttrup Fusion Applications Administration -
Fast Formula ReportSummary Fast Formula ReportContent Hi Experts, Is it possible to download a report of all fast formula details along with code? Regards, Nivya Version 18CNivya Mathire 135 views 4 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Data not appearing on all tabs of an Excel report when run as a payroll FlowSummary: We have an HDL Error report that is based on a Data Model and creates an Excel spreadsheet with 3 tabs of data. The first tab is the Summary, the second lists a…Al Darabaris 11 views 3 comments 0 points Most recent by Al Darabaris Reporting and Analytics for HCM
-
Custom Expense Approval Notification (Preferred Name)Overall Question: How can I use a custom Report/DM for expense report notifications instead of the delivered one? Context: We have a requirement that our Expense Report …Alex Cardenas 53 views 9 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM -
How can we get a list of all Scheduled BIP Reports in Oracle HCM CloudSummary: We are looking for a SQL using which we can get a list of all Scheduled BIP Reports and their recent status Content (please ensure you mask any confidential inf…Mridula Mitra Pal 58 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Solved:I cannot find DOC ID 2478863.1 How to Download and Use the Microsoft Word BI Publisher PluginSummary: Solved by using firefox and using How to Install BI Publisher Desktop Template Builder Add-In - Microsoft Office - Office 365 (Doc ID 2591350.1) ===============…RichardFoxFoxTaskForceNatureScot 276 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
LAG Function not able to pull previous job of an employee.Hello Experts, I am creating a report to pull the previous job of an employee, I am using LAG function to fetch the previous job, but i turns out to fetch the same data …Joliver Caangay 11 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Address change report to capture old and new valuesSummary: I have not been able to build or find a report that captures address change data. We have been looking for something and was wondering if the community would be…Tammy Hemmingson 285 views 5 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM -
Query to fetch manager hierarchy based on Functional Reports-toSummary: Need help in fetching manager hierarchy based on most recently assigned Functional Reports-to manager. Content (please ensure you mask any confidential informat…Dinky Dudeja 413 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Line manager dashboard through My Team > My DashboardSummary: We found the line manager Dashboard that was available through My Team > My Dashboard is no longer accessible for line managers. The function (tile) is no linge…
-
Excel template missing row header infoSummary: I have converted an Excel template to display in rows rather than columns. I have updated the Name Manager and the results display as expected however the param…Viviane Beaudoin 1 view 1 comment 0 points Most recent by Viviane Beaudoin Reporting and Analytics for HCM -
Position Incumbent History reportContent Hi, Can someone help me with Position Incumbent History report ? We wanted to know how long the position was vacant at any point of time after creation and who a…Nivya Mathire 140 views 13 comments 1 point Most recent by Ian Figueroa Schulte-Oracle Reporting and Analytics for HCM
-
Run report that will show users that have run BIP or OTBI reports over timeframeSummary: Good afternoon. Any suggestions around how to produce an audit report (we don't have auditing enabled) to produce a list of users that have run Human Capital Mg…Rich R 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Whenever bursting job ran where can we find the details whom all the trigger is sentHi , We have letters like tenure/grade change we need the detail to whom the trigger is sent. Where will the details stored. Can i get the tables. Please help Regards, S…
-
CMP_ASG_SALARY_V we need these fields zone_name,ZONE_TYPE_NAME,ZONE_TYPE_ID,ZONE_ID related querySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Surya Prakash Chetla 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
SCROM ReportSummary: Has anyone had any success with creating a SCORM report in OTBI or BI? Would really appreciate help with this. We are trying to create a report to take out the …Teja Arepalle 32 views 2 comments 0 points Most recent by Teja Arepalle Reporting and Analytics for HCM
-
Custom folder structureSummary: My client wants to change the Custom folder structure. My client does not want path to be Shared Folders > Custom > Human Capital Management. My client wants to…Consultant Ian 12 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Terminated Employee QuerySummary: Can anybody Please share a query where the Terminated Employee should be Pulled in the query on the Day of Termination as Active Record. Content (please ensure …MilanMohanty 1.1K views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How to report on days in state/phase through BIPSummary: We would need to create a datamodel showing when a submission entered a certain phase/state to calculate the times in phase/state. You can see similar informati…
-
New fields not showing any data in rtf template for document of recordsHello, I have one Document of record which is working fine but requirement is to add 3 new columns in that , For example Notice period/Hours and contract so i added all … -
Exclude Data Models in BI Search ResultsWe don't want end users to see data models in BI. We have followed the typical approach of saving data models in a Data Models folder where the permissions on the folder… -
What is the alternative of EXTRACTVALUE function and how to use it?Summary: Hi All, As EXTRACTVALUE function is no longer supported in Oracle SQL, the Data Models designed using EXTRACTVALUE is throwing error. The alternative is suggest…Robinson Ng 99 views 3 comments 0 points Most recent by Jordan Ritchie Reporting and Analytics for HCM
-
sql statement to get the performance document current taskSummary: sql statement to get the performance document current task Content (please ensure you mask any confidential information): Hi Team, I need these below two column…Malak 870 views 3 comments 0 points Most recent by Himavarsha Sathpadi Reporting and Analytics for HCM
-
Need assistance on Bursting report for Visa and Passport expirationSummary: Hi, Our requirement: The alert should trigger Worker and AOR on Worker passport expires. The Notification should be sent before 30days. Currently Alert composer…RamkumarKadhiravan 2 views 0 comments 0 points Started by RamkumarKadhiravan Reporting and Analytics for HCM -
How to return the max value based on a column?Summary: Content (please ensure you mask any confidential information): I've created a report using Workforce Learning - Learning Records Real Time subject area. The fol…Giuseppe Cannova 69 views 2 comments 0 points Most recent by Sai Darbha-Oracle Reporting and Analytics for HCM -
Error message: ORA-01898: too many precision specifiersSummary: Error message: ORA-01898: too many precision specifiers Content (please ensure you mask any confidential information): Hi, we have run the SQL query I attached,…Barile Alberto 295 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for HCM
-
Ability to report out who joins talent community but does not apply to a job postingWe went live a few months ago with ORC, and in our setup we enabled the talent community and have it showing on the job search results page with a general application be…Rob Stahly 12 views 1 comment 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM