BI Publisher
Discussion List
-
Dashboard Report links to Another ReportSummary Link on Person's Name Opens Separate ReportContent On a dashboard report, is there a way to add a hyper-link to a person’s name or number and have a report open …Shelly Feyerherm 67 views 11 comments 0 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
Department to User Login report helpSummary Adding department to data modelContent Can anyone help add department to this user last login report please? It was built with a data model and I don't know sql.…User_2025-02-05-07-51-01-504 20 views 8 comments 0 points Most recent by User_2025-02-05-07-51-01-504 Reporting and Analytics for HCM -
Oracle Fusion Cloud Audit Reports - Changes in Static Data (Before and After Values)Summary Audit Reports - Additional Functionality (Before and After Values)Content Hi, My client wishes to have a more detailed Audit Report functionality Currently the A…Stuart Hackney 55 views 2 comments 0 points Most recent by Stuart Hackney Reporting and Analytics for SCM -
Do we have any report or sql that will provide us the permission list details of the given report inSummary Do we have any report or sql that will provide us the permission list details of the given report in BI Publisher?Content Is there any report available that will…GTS Narayanen 51 views 4 comments 0 points Most recent by Karthik K-Oracle Reporting and Analytics for HCM
-
What is the significance of the fields "Assigned to User" and "Assigned to Username" in the subjectSummary What is the significance of the fields "Assigned to User" and "Assigned to Username" in the subject area "Transaction Administration Real Time" ?Content The pend…Sreedharan-Oracle 22 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to fetch the time card exceptions using OTBI/BIP report?Summary How to fetch the time card exceptions using OTBI/BIP report?Content Hello Team, We are trying to build a report where we need to show the details of person and t…Harish Kumar Kovi 67 views 2 comments 1 point Most recent by Sai1654 Reporting and Analytics for HCM
-
BIP report on Reverse terminationContent I have a requirement to build BIP report on Reverse Termination. Please let me know if someone has already built this report. Thanks in advance.User_2025-02-06-14-37-05-233 42 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Performance issue while fetching details from data_cache columnSummary I am facing performance issue while fetching details from data_cache column.Content Hi Team, I am using below query for fetching all kind of approval transaction… -
Looking for Quadrant view of dashboard for BSCContent Hi, I have a requirement to build Quadrant view of dashboard for BSC. Please let me know if anyone can help me on this. Thanks. JyotiUser_2025-02-06-14-37-05-233 22 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Looking for Transfer Compensation Change ReportContent Hi, I am in need of Transfer Compensation and Location Change report. Please help. Thanks, JyotiUser_2025-02-06-14-37-05-233 15 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Remove merged cells from report in reports & analyticsSummary Remove merged cells from report in reports & analyticsContent Hello, Please note that we have a report : Scott Marketing report which has merged columns B & C AN…User_2025-02-05-12-20-44-163 274 views 7 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Manager_type = Timecard_Approver in OTBISummary Manager_type = Timecard_Approver in OTBIContent Hi ALL, In OTBI when I see "Manager Type" ( "Workforce Management - Worker Assignment Real Time"."Worker"."Manage…User_2025-02-07-19-03-14-525 36 views 7 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Rename Column HeaderSummary BI Publisher Report Column HeaderContent Hi, The attached BI Publisher report has a typo in the column header where Annual is misspelt as Annaul. I have tried ed…User_2025-02-05-22-44-35-842 29 views 3 comments 2 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Salary reportSummary Salary reportContent I need a report which pulls current salary and previous salary details. Can any one have SQL to pull the data. PERSON_NUMBER OLD_SALARY_STAR…Reddykrishna Chidella-Oracle 202 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Remove Pending Workers from BI Publisher ReportSummary Pending WorkersContent Hi, I have a BI Publisher report that is incorrectly including System Person Type: Pending Worker in the Headcount figures. Can someone te…User_2025-02-05-22-44-35-842 54 views 8 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI Matrix Manager ReportSummary OTBI Matrix Manager ReportContent Hi Team, We are working on a OTBI report where client want to add all matrix managers and should extract all manager in single …User_2025-02-01-03-43-13-079 126 views 2 comments 2 points Most recent by User_2025-02-01-03-43-13-079 Reporting and Analytics for HCM
-
How Extract flexfield attributes of departmentContent Hello Guys, I need to extract the flex-field attributes of department, but by using this query I don't find any things. Moreover, I have a lot of duplicate rows …Giuseppe Iacono 33 views 2 comments 1 point Most recent by Seiichiro Yasui Reporting and Analytics for HCM -
Role related issue while running a BIP report via HR Dashboard in HCM CloudSummary Role related issue while running a BIP report via HR Dashboard in HCM CloudContent Hi, I have a BIP report developed which is working fine as is when checking da… -
fields to use for employee bank account reportSummary what fields to use for employee bank account report?Content hi what are the correct fields and subject to use for getting a report of current employee bank accou…User_2025-01-29-02-09-34-137 139 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Report for All Products in Staging with Order NumbersSummary Report for All Products in Staging with Order NumbersContent Hello, Can you please advise from which subject area we can download a report with all products in s…User_2025-02-05-12-20-44-163 29 views 2 comments 2 points Most recent by User_2025-02-05-12-20-44-163 Reporting and Analytics for SCM
-
UCM Document Retention Rates, Storage Limits, Access Privileges and Automatic PurgingContent We have a requirement where a Custom BIP Report uses bursting to send the report documents to UCM (Unified Content Management Portal). The documents sent to UCM …Shivakumar Ayyanagowdar-Oracle 628 views 2 comments 1 point Most recent by Shivakumar Ayyanagowdar-Oracle Reporting & Analytics for Sales -
SQL for report columnsSummary SQL for report columnsContent I want to be able to query an analysis and get a list of columns that are used in that analysis.Chris Campbell 37 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Is it possible to have email recipient in Agent based on Area of Responsibility?Summary I am creating an email notification for New Hires with benefits enrollment details using Subject Areas and I would like to have the email recipients based on the…Dana Resultay 52 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to I achieve DD-MON-RRRR in output of BI publisher report for a dateSummary How to I achieve DD-MON-RRRR in output of BI publisher report for a dateContent Hi, I transform my date column in the required format using TO_CHAR(effective_sta…