BI Publisher
Discussion List
-
Absences ReportSummary get the working dates between start_date and end_dateContent we have requiremnet to generate absences report, need help on sql query, If any empployee having abs… -
BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a singlSummary BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a single email idContent Hi, In BI Publisher bursting, we usually bu…User_MC37Q 106 views 6 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Link BIP Report to InfoletSummary Can we Link BIP Report to InfoletContent Hi All, Can we Create BIpublisher Report and link to Infolet, and how we can give access to particular user these infole…
-
Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesSummary Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesContent Hello! We are a team of OTBI and BI Publisher users, new to Oracle HCM. I… -
OBIEE 11.1.1.9.0 Archiving: Difference between 'Keep Timestamps' and 'Keep Permission'Summary OBIEE 11.1.1.9.0 Archiving: Difference between 'Keep Timestamps' and 'Keep Permission'Content Hi, I need to know the difference between 'Keep Timestamps' and 'Ke…User_MC37Q 62 views 2 comments 1 point Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
BI Publisher: Can we FTP the individual bursted emails onto the Web content serverSummary BI Publisher: Can we FTP the individual bursted emails onto the Web content serverContent HI, We are aware that we can FTP or put to Web content server, a BIP re…
-
Sql query is not workinkgContent Hi, trying to excute the following sql via BI publisher per support document: Doc ID 2187087.1 Select * from per_assignment_supervisors_f sup, per_all_people_f p…Gal Shani 69 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to create a report to pick address fields which have invalid charactersSummary How to create a report to pick address fields which have invalid charactersContent Hi I am working on a requirement to create a report which would pick invalid c…User_2025-01-30-21-52-52-008 43 views 9 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Hide Catalog and New based on RoleContent Hi All, Is there a way to hide Catalog and New based on User Role? I have a requirement to share reports with other Oracle HCM cloud users, but i want to restric…User_2025-01-30-00-14-06-021 77 views 3 comments 1 point Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM
-
save a BI Publisher Output pdf or OTBI Output pdf in Documents of recordsSummary save a BI Publisher Output pdf or OTBI Output pdf in Documents of recordsContent Hello, It is a possible to save a BI Publisher Output pdf or OTBI Output pdf in …Giuseppe 1234 32 views 4 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsSummary Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsContent Hi, We need information about how to capture the evalua…User_MC37Q 357 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
CASE WHEN in BI PublisherSummary Using CASE WHEN in BI Publisher SQL and not getting resultsContent Hi all, I have been writing a BI Publisher data model with SQL to bring back employees along w…User_2025-01-29-21-02-12-466 557 views 10 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM
-
Table per_national_identifiers is blank however there are data in the screenSummary per_national_identifiers table no dataContent Hi, I have a problem with person national identifier table is shown no data but the application screen shows data c…
-
OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaSummary OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaContent Hi, We are creating a Dashboard for plotting the average …User_MC37Q 75 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
how to get seniority date of a person from Oracle Fusion HCM tablesSummary how to get seniority date of a person from Oracle Fusion HCM tablesContent Hi, We are creating a BIP report to fetch seniority date of a person onto a Terminatio…User_MC37Q 1K views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Need inputs to fetch PBL batch start time and End timeContent Hi All, Please suggest in which table holds the when the PBL process started and end dated (i.e. completion time). Ex: If we submit PBL batch, we need to know co…
-
Workflow table Fusion HCMSummary Need to extract notification historyContent Hi, Being saas customer do i have option to extract workflow data from Fusion HCM Br Azfar.Azfar.128 100 views 2 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
Need database table name that stores the Performance Goals that are present in subject area ""WorkfoSummary Need database table name that stores the Performance Goals that are present in subject area ""Workforce Goals - Goal Status Overview Real Time" "Content Hi. Need…
-
Personal Payment Methods Processing OrderContent HI All, In the Manage person payment method UI is having processing order as 1,2,3 and corresponding column in DB as “pay_person_pay_methods_f” and “priority”. T…Visu 285 views 11 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Cutting string at a certain character in SQL BI PublisherSummary i want to cut a string at a certain point of a string in BI PublisherContent Hi All, I have a department name however in the middle there is a . (full stop) and …User_2025-01-29-21-02-12-466 47 views 2 comments 0 points Most recent by User_2025-01-29-21-02-12-466 Reporting and Analytics for HCM
-
New Hire Notifications to Manager, Payroll, HR Business Partner, EmployeeSummary Creating Individualized New Hire NotificationsContent Hello, We are currently transitioning to HCM Fusion and we need a New Hire alert that sends out to their Ma…User_2025-01-31-00-25-12-234 143 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Active\Inactive Employees with assigned Line ManagersSummary A requirement for a BIP report to show all employees and their Line ManagersContent Hi All, I have a requirement to create a BIP report to display all Active and…User_2025-01-30-03-54-32-528 451 views 12 comments 0 points Most recent by User_2025-01-30-03-54-32-528 Reporting and Analytics for HCM
-
Identifying if an assignment change was done with a future, retro or current dateSummary Having trouble finding a way to identify if an assignment change was done with a future date or retro date after the fact.Content Hello, My team is in the proces…Mak-Moose 182 views 4 comments 0 points Most recent by User_2025-01-29-21-12-23-173 Reporting and Analytics for HCM
-
Which table stores value set details used in fast formulaContent Hello everyone, Which table stores the information about the value set which is used in fast formula. if anyone knows which tabe defines the relationship between…
-
HCM infolets - include HC measures from records excluded from data role?Summary HCM infolets - can you include HC measures from records excluded from data role?Content We've put together a number of infolets showing basic HCM measures eg hea…User_0HYZ2 228 views 7 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Manager HiearchySummary Manager HiearchyContent Trying to get the Manager Hiearchy using CONNECT BY PRIOR on PER_ASSIGNMENT_SUPERVISORS_F. Noticed that there are flattened manager hiera…VijayaBaskar Ranganathan 104 views 4 comments 0 points Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
Tell us how you use OTBI to inform our future product directionContent https://oraclehcm.influitive.com/challenges/486 Please use the above link to provide us with feedback on OTBI to help us improve our product. The short questionn…Julian Challenger-Oracle 44 views 0 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Report: Need help with Dependent parameter LOVSummary BI Report: Need help with Dependent parameter LOVContent Hi, I have a BI Report where there are 2 parameters: 1) Review Period: 2) Period_Month_Or_Week 1) Review…User_MC37Q 60 views 15 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Issue in "Workforce Performance - Performance Rating Real Time" Post Rel 13Summary Post Release 13 IssueContent Hi All, Attaching a report for performance tracking created on the "Workforce Performance - Performance Rating Real Time"(subject ar…User_2025-01-30-00-14-06-021 81 views 6 comments 0 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM
-
report show "no results" for specific roleSummary cant see results for person profile reportsContent hi, we created 2 reports from subject area "Workforce profiles: person profile real time" both report are work…User_2025-01-30-04-14-21-127 70 views 5 comments 1 point Most recent by User_2025-01-22-19-43-38-766 Reporting and Analytics for HCM