BI Publisher
Discussion List
-
Significance of default Data Source 'AuditDB' in BI PublisherContent Hello What is the Significance of default Data Source 'AuditDB' in BI Publisher while creating the new data set. My Oracle Cloud Application is: 19A (11.13.19.01…Janardhana Kondaveeti 21 views 6 comments 1 point Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
Row disappearing in the output of RTF when the XML group tag is not thereContent Hi All, I have built one RTF template and have 5 fixed absence plans. If any of the plans is not there then the row is not appearing in the output file. My requi… -
Display Number as Number in Excel output of BI publisher reportContent I have a report which displays employee ids as part of the report. Now when I export that excel output it shows as Number stored as text and it comes with that y… -
Help with BI Publisher Report and ParametersSummary Help with BI Publisher Report and ParametersContent Hi - We are having an issue with a BI Publisher Report to on dashboard. When we have these reports on the das…Matthew DeCilio 86 views 6 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM -
Report on Performance document attachmentSummary Report on Performance document attachmentContent Hi, how to get a report for which all performance document has attachments? Got the below document but no luck w…Nivya Mathire 132 views 2 comments 4 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Duplicate Rows in a ReportContent Hi All, Hoping someone can assist me - I'm getting duplicate rows in a report and it seems to be tied to FLSA status as I have one row with a value and one row w… -
FTE based on Processed HoursContent Hi All, I'm trying to get an FTE number for each department based on actual hours entered in processed time cards. It works fine for my nonexempt population who … -
Pass Parameters from OTBI to BI DatamodelSummary Pass Parameters/Prompts from OTBI to BI DatamodelContent I have created a OTBI Report with a presentation variable. I would need a pipe delimiter file. So I adde…User_2025-01-22-19-45-49-284 76 views 3 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM -
Sales Incentive FlagSummary BIP and OTBI reportContent Hi Everyone, Does anyone know which Table/Subject Area is stored the Sales Incentive Flag available in Assignment Details / Job Detail…Alvaro Couto 23 views 5 comments 1 point Most recent by Alvaro Couto Reporting and Analytics for HCM -
Layout in OTBIContent I have a requirement to build a report on Absence in OTBI based on the absence types. Just wanted to check if the following layout is possible. Can anyone please…Amrit 68 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Combining cost allocation and FTESummary Combining cost allocation and FTEContent Hello does anyone has experience merging * FTE coming from Workforce Management - Worker Assignment Real Time and * Cost…User_2025-01-30-22-29-59-990 55 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Custom flow patternSummary Effective Date parameter is not working with data type as Calendar date in Custom flow patternContent Hi Team, I have created custom flow pattern to attach BI Re…User_2025-02-04-07-00-18-658 52 views 8 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM -
Custom flow migrationSummary How to migrate custom flow pattern from one instance to another instanceContent Hi Team, Is there a way to migrate Custom flow pattern from one instance to anoth…User_2025-02-04-07-00-18-658 35 views 3 comments 1 point Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM -
Performance Document each task statusContent Hi All, We need to display Task Status in each level of the Performance Document in BIP (BI Publisher). For ex: We have different task flows like Worker Self-eva…Visu 252 views 8 comments 0 points Most recent by User_2025-01-30-23-22-56-745 Reporting and Analytics for HCM -
BI Report - Performance Management, Task Name for Employee/Manager RoleSummary BI Report - Performance Management, Task Name for Employee/Manager RoleContent Hi, I'm currently developing BI Report using SQL query in HCM Cloud. User requeste…Suyoung 140 views 6 comments 1 point Most recent by User_2025-01-30-23-22-56-745 Reporting and Analytics for HCM -
Schedule Report to Service Cloud WebDavSummary Schedule Report to Service Cloud WebDavContent Hi, Quite simply, I am trying to schedule/run a report so it goes to Service Cloud WebDav As yet, zero success. I … -
Report to Extract Leave Deductions from Plan BucketsSummary BIP or OTBI Report to extract the leave deductions from Plan BucketsContent We need to extract leave deductions from the Plan buckets in the system. Suppose, an …Aahiri_Sarma 36 views 1 comment 0 points Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
Limits on Rows Retrieved/Exported to Excel for OTBI and BI Publisher?Summary Limits on Rows Retrieved/Exported to Excel for OTBI and BI Publisher?Content Are there limits inherent with OTBI and BI Publisher as to the number of rows report…User_2025-01-25-02-53-28-953 194 views 5 comments 0 points Most recent by kmanda Reporting and Analytics for HCM -
Ned inputs to display reports(BIP/OTBI) to specific users/based on the rolesContent Hi All, We developed custom BIP reports as per our requirements and all the reports we placed in custom-->Human Capital Management-->Reports.Now we have a requir… -
BPM Transaction Report (R13) StruggleSummary Making use of the SOAINFRA tables to replace HRC_TXN_HEADER_archive and HRC_TXN_data_archiveContent Greetings Everyone, Hope you are all well :) Since we are upg…User_2025-01-30-02-36-54-478 98 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
UK Court Order details - 'Issuing Authority'Summary Need to find details of 'Issuing Authority'Content Within the Calculation Componet Details field for an 'Attachment of Earnings Priority' deduction, there is a f…User_2025-02-04-16-50-19-277 38 views 5 comments 0 points Most recent by User_2025-02-04-16-50-19-277 Reporting and Analytics for HCM -
BI report to get changes made in both update and correct mode in HCMSummary Hi all, i just want to know is it possible to build changes report in BI that can pull both corrected and updated values.User_2025-02-04-16-34-56-920 63 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to sort Payslip reprinting report?Summary Need to know how to add a sort order to a RTF templateContent It is suggested in the following Oracle support note to customize the payslip template to achieve a…Matt_Peters 72 views 1 comment 2 points Most recent by Yan Li-144606 Reporting and Analytics for HCM -
Adding a new items on a Profile Skills and Qualifications Print ReportSummary Adding a new items on a Profile ReportContent Dear all, I am looking to add some new items to the report of the print page of the skills and qualifications; we f…Pablo Martinez de Villa De las Heras 84 views 3 comments 0 points Most recent by Pablo Martinez de Villa De las Heras Reporting and Analytics for HCM
-
Create OTBI report to fetch the 2 recent most records for a person's legal employer changeSummary Create OTBI report to fetch the 2 recent most records for a person's legal employer changeContent Hi Experts, I need to create an OTBI report that shows the curr…Aloka Bhattacharya 101 views 4 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Reporting on employee's contacts' phone numbersSummary User unable to report on employee's contacts' phone numbers, even though they have access to the fieldContent Hello Experts! One of our HR reps is unable to repo…User_2025-01-29-23-59-58-976 146 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Publisher Report Name with Date and TimeSummary Include the Date and Time in the Output Report Name of Scheduled ReportContent Hello All, I have a report that will run as a BI scheduled report. Is there any wa…Daniel McMillian 102 views 2 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
BI Report fails with custom security roleSummary User can't run report as he is assigned to security roleContent Hi Team, BI report runs for Admin but does not run for the user. Narrowing down the roles we foun…Alvaro Couto 42 views 4 comments 1 point Most recent by Alvaro Couto Reporting and Analytics for HCM -
Parameterised Dates in OTBISummary Need to get Tax year start and end dates relative to current dateContent I need to get the UK tax year start date (April 6th) applicable to current date, the rep…User_2025-02-04-16-50-19-277 79 views 5 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
Add Column to Reflect whether Measurement is Present in an Employee's GoalSummary There needs to be 1 column added to a Goal report namely "SUCCESS_MEASURE_EXISTS" which will reflect any of the following values: Complete, Incomplete, PartiaCon…Aahiri_Sarma 44 views 2 comments 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM