BI Publisher
Discussion List
-
Audit Report using BIPSummary Looking for a custom BIP report query for Audit purpose. #AuditContent Hi, We enabled the Audit for multiple products using the task 'Manage Audit Policies' and …MadhuVitta 245 views 2 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
Mandatory Parameters in BI PublisherSummary Mandatory Parameters in BI PublisherContent Hi, How can we make the parameters as mandatory/required in a BI Publisher report ? Thanks, NitinNitin Gupta HCM 59 views 6 comments 0 points Most recent by User_1B10X Reporting and Analytics for HCM -
Drill back using SQL query from GL_JE_LINES to PAY_COSTS tableContent We are building a report to get the related Pay Cost data from the GL Journals that gets created after transferred to GL. We have few documents for EBS which men…Satish Kumar-21650 58 views 0 comments 0 points Most recent by Satish Kumar-21650 Reporting and Analytics for HCM -
REPORT EMAIL DID NOT RECEIVEDSummary REPORT OUTPUT DID NOT RECEIVED VIA EMAILContent Hello, We have existing BIP report job which runs and deliver report output via email. And today few customers re… -
Bargaining Unit (Name) - Table and Column ?Content Hello Everyone, I'm trying to build a BI Publisher Report (complex requirement therefore cannot utilize OTBI) and I am requiring Bargaining Unit field, or to be … -
How to add "Year" ,"Start Date" and "End Date" as prompt parameter in BI analysisSummary How to add "Year" ,"Start Date" and "End Date" as prompt parameterContent Hi. I am having one requirement in absence management where need to fetch the absence t…Rahul Mishra-19235 130 views 4 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM -
Adding Subject Areas - errorSummary Using the 'Create Analysis' option and selecting 2 Subject AreasContent Hello, I am new to reporting and trying to use some of the out of the box features. The s…Denise Rae 34 views 5 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Probation Confirmation letter Automation in Oracle fusion HCMSummary Probation Confirmation letter Automation in Oracle fusion HCMContent Hi Team, I have to create the bursting report, in which whenever probation status for an emp…nitin Sharma 75 views 5 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Increasing Export Limit into Excel, CSV, XML, etc.Summary Is there a way to increase the row limit when exporting to Excel, CSV, XML, etc.?Content Is there a way to increase the number of rows that can be exported out o…User_2025-01-31-02-48-58-054 247 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Using Max function for bank account highest process orderSummary Issue with using MAX for selecting highest processing order (Priority) within PAY_PERSON_PAY_METHODS_FContent Hi, We are setting up an extract of bank accounts w…User_2025-01-30-03-54-32-528 52 views 7 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 24 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 90 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 135 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 82 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 25 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 71 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 59 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 57 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 38 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 255 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 146 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 41 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 197 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 101 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM